• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Bug Reports Recipe Bugs

Marty Chang (R7)

started a topic about 5 years ago

The requested URL /v4/spreadsheets/2 was not found on this server

When trying to update a row in a Google sheet using the Row ID from a Google Sheets trigger, the developer will encounter an error, "The requested URL /v4/spreadsheets/2 was not found on this server".


ANALYSIS


The Google Sheets app was implemented using different API versions for the Google Sheets trigger and for the Google Sheets actions. This means the Row ID that is returned by the trigger is not compatible with the Row ID input that the Google Sheets "update row" action uses.


STEPS TO REPRODUCE


  1. Create a spreadsheet in Google Sheets, and populate it with a few rows of data
  2. Create a Google Sheets connection in Workato
  3. Create a Workato recipe which uses the Google Sheets "New row in sheet" trigger
  4. Add a Google Sheets "Update a row' action to the recipe
  5. Map the Row ID from the trigger to the Row ID in the action
  6. Test the recipe. The job will fail with the error described above.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count