Failed to invoke procedure `apoc.load.jsonParams`

[martin_ebert]

What do I want to achieve?
I am calling an API with Bearer Token.

What doesn't work?
In Neo4j Desktop the import runs without problems. As soon as I want to roll out the same coding for my instance on EC2 (with Docker), I get an error message.

Error Message:

Cypher Statement
CALL apoc.load.jsonParams("https:/.../api/...",{Authorization:"Bearer token"},null) yield value
return value limit 1

Left neo instance on EC2, right local test instance

My guess is that I don't have the necessary certificates in Neo4j yet to address the https address.

Config:

#*****************************************************************
# Neo4j configuration
#
# For more details and a complete list of settings, please see
# https://neo4j.com/docs/operations-manual/current/reference/configuration-settings/
#*****************************************************************
# This setting constrains all `LOAD CSV` import files to be under the `import` directory. Remove or comment it out to
# allow files to be loaded from anywhere in the filesystem; this introduces possible security problems. See the
# `LOAD CSV` section of the manual for details.
dbms.directories.import=import


#********************************************************************
# Wrapper Windows NT/2000/XP Service Properties
#********************************************************************
# WARNING - Do not modify any of these properties when an application
#  using this configuration file has been installed as a service.
#  Please uninstall the service before modifying this section.  The
#  service can then be reinstalled.

# Name of the service
dbms.windows_service_name=neo4j

#********************************************************************
# Other Neo4j system properties
#********************************************************************

dbms.connector.https.listen_address=0.0.0.0:7473

dbms.connectors.default_listen_address=0.0.0.0

dbms.connector.http.listen_address=0.0.0.0:7474

dbms.connector.bolt.listen_address=0.0.0.0:7687

wrapper.java.additional=-Dneo4j.ext.udc.source=docker
dbms.tx_log.rotation.retention_policy=100M size
dbms.security.procedures.unrestricted=apoc.\*,algo.\*
dbms.security.allow_csv_import_from_file_urls=true
dbms.memory.pagecache.size=6G
dbms.memory.heap.initial_size=6g
dbms.jvm.additional=-Dunsupported.dbms.udc.source=docker
dbms.directories.logs=/logs
apoc.import.file.use_neo4j_config=true
apoc.import.file.enabled=true
apoc.export.file.enabled=true
HOME=/var/lib/neo4j
EDITION=community

[dana_canzano]

From your EC2 instance can you curl to the url and get a response back?

[martin_ebert]

[dana_canzano · Accepted solution]

if curl cant resolve the host I very much doubt if Neo4j and APOC will resolve the host. Can you simply ping the host and get a response. Either way, presuming this is the same statement on your other instance and is working, then this looks like some type of networking issue