topic Re: Help with REST connector set up in Connectivity & Data Prep

Help with REST connector set up

shruthibk — Wed, 12 Jul 2023 04:47:08 GMT

Hi All,

I am trying to connect to NEO4j data base using qliksense through REST API connection but i am unable to understand how to get the api end point and pass the cyper query . Could anybody please guide me or share the poc if you have.

Thanks in advance

Re: Help with REST connector set up

Jay_Brown — Mon, 31 Jul 2023 18:09:49 GMT

It appears that the Neo4j REST API has been deprecated.
https://neo4j.com/docs/rest-docs/current/

You may want to reach out to the Neo4j team for more information for that particular connection method.

Otherwise I suggest you check out the ODBC documentation such as that from Simba:
https://insightsoftware.com/drivers/neo4j-odbc-jdbc/
And use the ODBC connection method within Qlik:
https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/DataSource/ODBC.htm?_ga=2.232690015.1150673625.1690820840-1869923486.1687802502

Re: Help with REST connector set up

Henriette — Mon, 16 Oct 2023 16:53:32 GMT

Hi Jay

Similar situ - I have connected successfully through Postman so I have confirmed that the BLS API
https://api.bls.gov/publicAPI/v2/timeseries/data/
is working. I actually get a Successful COnnection from Qlik (see Screenshot) But 4 the life of me I cannot understand why it will not allow me to select the data - Here is the error message

Here is the payload body:
{"seriesid":["JTU620000000000000HIL","JTU620000000000000LDL", "JTU620000000000000QUL", "JTU620000000000000TSL"[,
"startyear":"2013", "endyear":"2023", "catalog":false,
"calculations":true, "annualaverage":true, "aspects":true,
"registrationkey":"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" }

ANy help would be soooooooo appreciated !