Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
NoNameFound
Contributor III
Contributor III

Load JSON as text through REST Connector (Qlik Sense Enterprise for Windows)

Hey everybody,

does anyone know wether it is possible to retreive the raw response of an API call (typically JSON) through the REST Connector as a text blob in order to use the JSONGet() function on it?
I'd like to use the JSONGet() function but I don't know how to use it on the REST Connector or if it's even possible when loading JSON through the connector.
When reading from a file or Inline Loading JSON I have more possibilities to parse out what I need.

So far I managed setting up the connector, but the automatically generated code that tries to pluck my response apart is kinda meh due to the structure of my response being sub-optimal. I also would like to avoid external scripts, so my ETL stays within Qlik Sense.

Any ideas?

2 Replies
henrikalmen
Specialist II
Specialist II

One idea could be to take a look att QSEoW version May 2025 that was released today, apparently there's now native json support in Qlik Sense: https://community.qlik.com/t5/Release-Notes/Sense-Enterprise-on-Windows-release-notes-May-2025-Initi... 

NoNameFound
Contributor III
Contributor III
Author

Amazing timing, I'll look into it. Thanks!