Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID's
I'm attempting to have a flow in Microsoft Power Automate/Flow create rows in a Smartsheet sheet and update a field once an approval outcome is present. The first part works with no problem - rows are created with a value in one column to help identify (e.g., SR001) - but after they're created, querying the sheet for all rows that match the criteria (e.g., https://api.smartsheet.com/2.0/search/sheets/....6548/?query=SR001), data returns with row object ID's that can't be found. This makes the subsequent update to each newly created row break.
Am I doing something wrong here? What can I present to make the intention and issue clearer?
Best Answer
-
Hi @bsim1130
How soon after the row creation are you implementing the search? Newly created or recently updated data may not be immediately discoverable via search. (See the API documentation, here: https://smartsheet-platform.github.io/api-docs/#search). Try querying the sheet 5 - 10 minutes after the initial update, does that return the correct result?
Cheers,
Genevieve
Answers
-
Hi @bsim1130
How soon after the row creation are you implementing the search? Newly created or recently updated data may not be immediately discoverable via search. (See the API documentation, here: https://smartsheet-platform.github.io/api-docs/#search). Try querying the sheet 5 - 10 minutes after the initial update, does that return the correct result?
Cheers,
Genevieve
-
I believe this was the problem. The search was taking place shortly after the new rows were created.
-
Hello @Genevieve P
Do you know if smartsheet are planning to change this so that newly created rows will be available to search, ie to avoid the 5min wait?
-
Hi @Joan Smith
I don't know if there is a plan to update this in the future, but please let the Product team know about your use-case and request by filling in this form, here!
Thanks,
Genevieve
