APIs can be daunting, espicially as you need to use iterative macros for a lot of them. This additional step makes people generally try to avoid it.
Creating a API-Iterative Macro- Template can save you time and actully make APIs fun to analyse.
Essentially, there are 3 parts to this macro.
1) The download and JSON Parse
This section downloads the API and lists each field in the API.
2) Crosstabbing each field
This section pivots each API field name to a new column and forms the first macro output
3) The iterative Macro-Output
This is the "Loop" that continues to run until all the API rows are returned.
Lastly, remember to confirgure the interface designer to ensure you set the correct iterative macro and max-iterations.