Custom Column value by calling an API request

App Building
1

  • Goal: To be able to retrieve value via API call for custom column by using id of the row

  • Details: I have a API that accepts input in header to fetch value. I need to use this API to get value for a custom column which is not returned from original table API.

So as shown in screenshot I want to be able to pass this header for each row and get value and show in the table as column value for each row. I have searched a lot but I dont know how to pass current row ID to this query and use that in the header to get value for the column.

I have spent hours figuring out this, if anyone knows please help

image
image563×683 35.9 KB

2

Hi @Meet,

You can iterate over your table data using a javascript and pass them using additionalScope. Check out the following example:
https://docs.retool.com/docs/scripting-retool#trigger-a-query-for-each-item-in-an-array

1 Like
3

Hi @Meet,

Let us know if you have any trouble with additional scope :slightly_smiling_face: