It appears that the JSON coming from the API is structured differently now than it was when our team provided that advice. In the screenshot you previously sent us, I can see columns titled ‘headers’ and ‘rows’, each containing JSON data. It now seems like headers and rows are being packaged in ‘contacts’, which should (hopefully) eliminate the need for multiple API import steps to bring in one contact.
Do you mind specifying exactly what your desired end result looks like?
Expand JSON step above, I can see that the JSON has been flattened into 1 row and 2,641 columns. After the
Flip Data step, this should be 2,640 rows and 2 columns. Is this what you were hoping for?
Finally, have you considered using multiple API steps, and bringing in 1 ‘contacts’ object per API pull? Once you pull in, expand, and flip the data (which should be under 5000 rows if you do them one by one), you could then use a
Stack Tables step to combine the data all into one larger sheet.
If you have API documentation that you’re able to pass along, that would also be helpful!