How do I take an api response in a loop and add it in a new row in a table?

Queries and Resources
1

I am passing certain ids like 1,2,3,4 etc. to an API using the script method: Scripting Retool
For every id, the API is triggered and sends me a response like this:
Chapter Name: ABC
Item Type: Ball
Item Desc: Rubber Ball
Price: 12.34

The response is in JSON format. I want to store this response for each id in a table with column names as mentioned above (chapter name, item type etc.) and each row for the id. How do I do that?

2

@IshanBizongo
Welcome to the forum - is it possible for you to post the response you get back along with screenshot of the query result and also what you are adding in the Default Value field in the Inspect panel for the table you want to populate?