Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID's

bsim1130

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?

Genevieve P.

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

Genevieve P.

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

bsim1130

I believe this was the problem. The search was taking place shortly after the new rows were created.

Joan Smith

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?

Genevieve P.

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