Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

g_vanderjagt
New Contributor

REST Connector response is URL with JSON file

Dear All,


I am using the Freshdesk API to import data into Qlik Sense.

In Qlik Sense, I have set up a REST Connector with the API link, username and password.

The response from the API is an URL https://Freshdesk.com/reports/scheduled_exports/8675131525/download_file.json

the URL changes every day.


Currently the only thing I see is, the URL in my data, but I would need to load the data from JSON file.

Can someone help me with a script to load the url from the api and import then the JSON file?

thanks!

below main script:

RestConnectorMasterTable:

SQL SELECT

"created_at",

"url"

FROM JSON (wrap off) "export";

[export]:

LOAD [created_at] AS [created_at],

[url] AS [url]

RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

1 Reply
rai-jmcpheeters
New Contributor III

Re: REST Connector response is URL with JSON file

For me the fix was really simple - change "wrap off" to "wrap on". To be honest, I don't know, and can't find documentation as to what this option does.

mto: There is documentation for the rest connector (here), but no mention of what the "wrap" options for JSON actually do. Is there somewhere we can find this?