If doOutput=false - call setDoOutput(true)

Neo4j Graph Platform Procedures & APOC
1

I have tried to execute the following on the current Neo4j Community Edition server:

CALL apoc.load.jsonParams ("https://api.box.com/2.0/search?query=A&type=folder&fields=id&limit=200&offset=200",{method:"GET",Authorization:"Bearer {actual token here}"},null)

The response was:

Failed to invoke procedure apoc.load.jsonParams: Caused by: java.net.ProtocolException: cannot write to a URLConnection if doOutput=false - call setDoOutput(true)

I have searched in vain for a solution. Can you help on this?

2

What happens when you call the URL in postman?

3

It generated a JSON response from Box just as expected

4

I was able to get it to work by removing the "method" header

CALL apoc.load.jsonParams ("https://api.box.com/2.0/search?query=A&type=folder&fields=id&limit=200&offset=200", {Authorization: "Bearer XXXXXXXX"},null) yield value
return value

I redacted my token before the screenshots:

Screenshot 2024-09-27 at 9.52.09 AM
Screenshot 2024-09-27 at 9.52.09 AM2344×772 69.5 KB

5

Thanks so much! Then one more issue perhaps. I went back to Postman after well over 24 hours and the token seemed to stil work without being refreshed. However that same token does not seem to work in the neo4j call. Is there some kind of persistence in the Postman call? The error I get after following your spacing is now "Failed to invoke procedure apoc.load.jsonParams: Caused by: org.neo4j.graphdb.security.URLAccessValidationError: Unable to verify access to api.box.com. Cause: api.box.com."

6

Thanks so much! After correcting to match your content and spacing my error message is now "Failed to invoke procedure apoc.load.jsonParams: Caused by: org.neo4j.graphdb.security.URLAccessValidationError: Unable to verify access to [box api URL]. [box api URL]" I copied a token that is currently still working in Postman but still get this resuilt. (I substituted within the brackets because of an error on this site.)

7

Sorry...I am not seeing that behavior. The token is working in both platforms.

8

BTW- Adding method GET does work, but the key is case sensitive. It should be "Method", not "method". It does not have to be added because GET is used by default.

CALL apoc.load.jsonParams ("https://api.box.com/2.0/search?query=A&type=folder&fields=id&limit=200&offset=200", {Method: "GET", Authorization: "Bearer XXXXXXXX"},null) yield value
return value
9

Thanks, I will continue to explore the token issue. But if I import the Box JSON from a file I get "set apoc.import.file.enabled=true." But on the community edition I do not find an apoc.conf file and if I add that line to neo4j.conf it does not seem to make a difference. I also created apoc.conf and added that line but no change.

10

Create the apoc.conf file in the same location as the neo4j.conf file

11

I did that and added the line "apoc.import.file.enabled=true" to the apoc.conf file I created and restarted the server. No change.

12

Are you getting an error?

13

Yes, the same error - set apoc.import.file.enabled=true.

14

Thanks! I got past everything except the token and will continue to work on that.

1 Like