I have 5 data sources due REST API pagination and I would like to put all them together in one unique data source.
How do I do that please?
I have 5 data sources due REST API pagination and I would like to put all them together in one unique data source.
How do I do that please?
Hi Marcelo,
The pages of data produced by pagination cannot be combined into a single datasource, but can be combined into 1 set of data to work with in a klip formula. Please read the Datasources with Multiple Pages article for a description of how to create a dynamic datasource that will create an instance for each page and how to use the multiple pages in klip formulas.
Thank you,
Janice
Hi Janice, thank you for your help.
I am nearly getting there, I created the dynamic data source but when trying to get all data in a table, the MAP function is returning only the first id of each page.
Why?
Thank you
Hi Marcelo,
The MAP function returns only the first item from each page. If the field referenced returns more than one item, use the MAPFLAT function instead of the MAP function.
Thanks,
Janice
Thank you