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 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
is this what you mean?
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