How to loop through query and set values one by one

Workflows
1

Hi Team,

I am creating a workflow to send notifications based on location id.

I have a table which contains location id, module and a message which needs to be sent using an API.

This is my table:

image
image1920×1080 275 KB

This is my API form body

image
image1920×1080 234 KB

I want the api to run for the number of times the total records exist in my table. Can you please help me iterate through table data one by one and send it in the API?

2

Hi there! You'll want to create a loop block that runs after getting all records & triggers the API call for each one: https://docs.retool.com/docs/retool-workflows-blocks#loop-blocks

Let us know what questions come up!

1 Like