0

How do I append data in one unique data source?

Marcelo Ribeiro

January 30, 2020 18:42

None

Follow

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?

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Janice Janczyn January 30, 2020 20:23

  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

• 0
  
  Marcelo Ribeiro January 31, 2020 16:03

  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

  

• 0
  
  Janice Janczyn February 03, 2020 13:38

  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

• 0
  
  Marcelo Ribeiro February 03, 2020 13:39

  Thank you