Multiple REST API calls on button click

I have google sheets as the attached resource

I want to trigger an API call for all rows of the table on a button click. I am unable to figure out how to call this Rest API query multiple times

I have generally connected to gSheets using the gSheets connection they provided. However,

you could add the the desired query multiple times in the 'Events' / Event Handler section
image

is this what you mean?

1 Like

Hey aniket, thanks for reaching out! You could do as DavidD has suggested, adding multiple onClick events to the button. Or you could trigger a JS query that would loop through your desired data and invoke the REST API on each iteration. I've attached a link to the docs that talk about this and a screenshot of an example. Hope this helps!
https://docs.retool.com/docs/scripting-retool



2 Likes