Display data from multiple APIs in a single repeating group or table element

vatsal.shah · 2024-07-19T08:46:26.953Z

Hi, I want to display data from multiple APIs into a table or repeating group but I am not able to do it. Even if the APIs return the same type of data still I am not able to get that data as the elements only take 1 type of data content. How can I do what I want?
Thanks in advance.

llloyd · 2024-07-19T12:10:51.802Z

Commenting to follow this thread, cause I’ve also being trying to find an elegant solution for this problem.

Jici · 2024-07-19T12:31:44.974Z

There’s, from my point of view, three options. However, Both could cost a lot of WU

A) Setting RG as “text” for data type and using the ID of returned API Call. In cell, use another call to fetch the data based on the ID. If this come from the same API, this is simple, but if this come from different services, this could be more complicated, mostly if they use the same ID structure.
B) Create a DB thing to store information in a single DB type, but with differents fields for each API (however, one field will be the “origin” of the data so you can set conditions in RG to display data. Don’t forget that you can store the whole API data into a single field of the API data type.
C) Get data from api as “text” (or activate detect header and allow workflow to continue if error to get access to raw body). Use A) settings with RG set as text but push the entire array item to RG and use a JSON plugin to parse the raw body and display data.

codefree · 2024-07-20T09:51:02.730Z

Hey @vatsal.shah

I would do it in the following manner:
Step 1:
Setup all the API in the API connector with use as “Action”

Step 2:
Setup a New API workflow and add all the APIs (from Step 1) actions

Step 3:
Add a “Return data from API” as the last action as shown in the screenshot. You can then merge the results from API actions.

image992×1284 62.4 KB

r

Step 4:
Add the API workflows (from step 3) in the API connector again. Consider this as your merged API datasource. Set it to use as “Data” in order to use it in the RG directly.

Let me know if this works for you. I would be happy to connect if you have any specific use case.

system · 2024-09-27T08:46:53.316Z

This topic was automatically closed after 70 days. New replies are no longer allowed.