Best way to accomplish calling secondary api

Self Hosted Retool
1

I have table1, which is populated by api 1. There is a primary key field Id. Lets assume 3 fields are returned: id, name, date.

I need to run another query, api2, with the id field from table1 as the key and get a final fourth field, callid. I need to run this api2 for every row returned in table1.

I either want to show all columns, including callid, in table1, ......option 2) have table2 show a one to one row results based on the number of rows in table1. So, I would like to run an api2 for each row in table1 and add these records to table2.

I know i am not explaining this the greatest. showing some screen shots.

1 Like
2

Hi @claycurtis44,

You can call both APIs and use a transformer or JS query to merge the data from both APIs. Alternatively, you could create a workflow to handle this and return the merged data.

Another option is to run the second API on the table’s selected row action if you'd like to display callid in a separate table.

2 Likes
3

Great options, @ZeroCodez!

@claycurtis44 let us know if you have follow up questions or want to share an example

1 Like