0

How do I append data in one unique data source?

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?

4 comments

  • 0
    Avatar
    Janice Janczyn

    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
    Avatar
    Marcelo Ribeiro

    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
    Avatar
    Janice Janczyn

    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
    Avatar
    Marcelo Ribeiro

    Thank you

Please sign in to leave a comment.