Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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?