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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
FelipeGarvin1
Contributor
Contributor

Qlik REST Connector Not Recognizing JSON Array as Root

Hi everyone,

I'm facing an issue while trying to load data from a REST API into Qlik Sense. The connection is successfully created, but when I try to select data, no tables appear in the data preview.

I've tested the same API in Postman, using the same headers and parameters, and it works perfectly, returning the expected JSON response. However, in Qlik, the response seems empty, and I can't generate the script automatically.

One suspicion I have is that the API returns a JSON array at the root level, like this:

FelipeGarvin1_1-1743686794291.png

Since Qlik REST Connector usually expects an object as the root, I believe this might be causing the issue.

Additionally, since no tables appear in the Select Data option, I can't even generate the table script automatically to try adjusting it manually.

I've tried some approaches using WITH CONNECTION and different parameters to force the data to be read, but since Qlik doesn't generate the table script automatically, it's difficult to manipulate the structure correctly.

Maybe if there were an option in the connector to ignore the square brackets [ ] and treat the array as an object, Qlik could recognize it as a valid JSON and load the data correctly. Manually specifying fields in the script returns 0 rows.

FelipeGarvin1_2-1743686951978.png

Labels (4)
0 Replies