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

02/21/21
Accepted

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?

Popular Tags:

Best Answer

  • Genevieve PGenevieve P admin
    Accepted 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

  • Genevieve PGenevieve P admin
    Accepted 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

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

Sign In or Register to comment.