Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Concatenating a varying REST structure

Hi there,

We are attempting a connection to an API which returns a JSON structure, however the 'table' names vary through each request.

We loop through the endpoints using WITH CONNECTION as normal, but as the table & field names change, automatic concatenation does not occur (the primary and foreign keys which are generated have different names)

Hoping to get some thoughts on how to concatenate this within the loop?

Please see below 

Screenshot showing non-concatenated tables

111.jpg

Screenshot showing loop (using variables and varying PK/FK field names)

222.jpg

Thanks!

Tags (2)
Labels (1)