Concatenating a varying REST structure

[lachlanwwells]

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

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

Thanks!