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?
below main script:
FROM JSON (wrap off) "export";
LOAD [created_at] AS [created_at],
[url] AS [url]
DROP TABLE RestConnectorMasterTable;
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.