Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Andruasi
Contributor
Contributor

Consume REST API with nested output

Hey folks - 

New here, looking for some help !!

Working on calling REST API which has JSON output. The output I see is in nested format and I am looking for some guidance on how to append select statement to read all the data. 

API connection worked fine but it gives data preview as single array of record as below,

Andruasi_1-1610581187788.png

Here's sample screenshot of output,

Andruasi_0-1610580947827.png

Here's the default system generated SQL statement,

Andruasi_2-1610581268824.png

 

Any guidance would be really appreciated !!

Thanks in advance.

Labels (5)
2 Replies
QFabian
Specialist II
Specialist II

Hi @Andruasi ,  maybe you can check the WITH CONNECTION clause, that can be added to your load from the API.  i used it within a for next cycle, changing parameters to get all the records. 

QFabian
Andruasi
Contributor
Contributor
Author

Thanks @QFabian for your suggestion. Issue I am facing is not with query parameters or getting not all records. I am able to get the output but output is showing as one single array of record. I am looking forward to split all the fields rather just like below,

Andruasi_0-1610586398367.png

Was wondering if SQL Select needs to be enhanced to handle nested JSON output but not sure how.

Appreciate all the help !