https://community.qlik.com/t5/Connectivity-Data-Prep/Concatenating-a-varying-REST-structure/m-p/1672467#M4919 <P>Hi there,</P><P>We are attempting a connection to an API which returns a JSON structure, however the 'table' names vary through each request.</P><P>We loop through the endpoints using WITH CONNECTION as normal, but as the table &amp; field names change, automatic concatenation does not occur (the primary and foreign keys which are generated have different names)</P><P>Hoping to get some thoughts on how to concatenate this within the loop?</P><P>Please see below&nbsp;</P><P>Screenshot showing non-concatenated tables</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="111.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27982iBF32FC7DF3651209/image-size/large?v=v2&amp;px=999" role="button" title="111.jpg" alt="111.jpg" /></span></P><P>Screenshot showing loop (using variables and varying PK/FK field names)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="222.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27983i55890AC672DC9BD5/image-size/large?v=v2&amp;px=999" role="button" title="222.jpg" alt="222.jpg" /></span></P><P>Thanks!</P> Fri, 10 Dec 2021 20:29:42 GMT lachlanwcast 2021-12-10T20:29:42Z https://community.qlik.com/t5/Connectivity-Data-Prep/Concatenating-a-varying-REST-structure/m-p/1672467#M4919 <P>Hi there,</P><P>We are attempting a connection to an API which returns a JSON structure, however the 'table' names vary through each request.</P><P>We loop through the endpoints using WITH CONNECTION as normal, but as the table &amp; field names change, automatic concatenation does not occur (the primary and foreign keys which are generated have different names)</P><P>Hoping to get some thoughts on how to concatenate this within the loop?</P><P>Please see below&nbsp;</P><P>Screenshot showing non-concatenated tables</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="111.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27982iBF32FC7DF3651209/image-size/large?v=v2&amp;px=999" role="button" title="111.jpg" alt="111.jpg" /></span></P><P>Screenshot showing loop (using variables and varying PK/FK field names)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="222.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27983i55890AC672DC9BD5/image-size/large?v=v2&amp;px=999" role="button" title="222.jpg" alt="222.jpg" /></span></P><P>Thanks!</P> Fri, 10 Dec 2021 20:29:42 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Concatenating-a-varying-REST-structure/m-p/1672467#M4919 lachlanwcast 2021-12-10T20:29:42Z