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

[NoNameFound]

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?

[henrikalmen]

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]

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

[KHSDM]

Hi, were you able to get it working? I'm facing a similar issue. Our JSON response is dynamic, and I can't load it without the script editor generating the script beforehand. I’d like to download the raw response first and then transform it in the subsequent script logic.

[henrikalmen]

You can do for example LOAD * from xyz.json (json); - see https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/working-with-JSON.htm

[NoNameFound]

Hey @KHSDM, 

I wasn't able to get it to work using Qlik alone, but resorted to Python instead. 
The issue here is, that you cannot parse out what you don't explicitly know when using the REST Connector.
I've had the issue, that my top-level-elements were all random integers, so not iterable and therefore very not cool.

Yet @henrikalmen has a good point here. If you can manage to place your JSON data as a file on a file server, you can load it as @henrikalmen described here just like you would do with a regular Excel sheet for example.

Qlik is way more powerful with JSON, when it does not come from a REST Connector endpoint, but rather as a file from a file server or your local hard drive or whatever may be the case.

[henrikalmen]

Perhaps you could use the generic web connector, and specify the format as json. This principle works for me, but it might depend on where the data is fetched from:

jsontable: load * from [lib://My Generic Web Connector] (url is "https://api....com/data", json);