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
Create a spreadsheet in Google Sheets, and populate it with a few rows of data
Create a Google Sheets connection in Workato
Create a Workato recipe which uses the Google Sheets "New row in sheet" trigger
Add a Google Sheets "Update a row' action to the recipe
Map the Row ID from the trigger to the Row ID in the action
Test the recipe. The job will fail with the error described above.
Marty Chang (R7)
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