JSON error when updating row in Google sheet

[Lars]

My workflow at https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzNTA0M2M1MjZmNTUzMzUxMzMi_pc is suddenly returning a JSON error on update of row in Google sheet. The steps:

1. Lookup first available spreadsheet row
2. Update row with values from other sheet

I've checked the mappings, no errors. So I'm at a loss as to what is causing this. Please assist ASAP!

Best,
Lars.

 

[Supreme]

Hey @Lars

The mapped data indicates that even after encoding, the values from your Google Sheets still contain double quotes, leading the API to assume there are additional fields to process.

To resolve this, you could use the 'Update Range Values' action step, ensure there are no double quotes in the values from your Google Sheets, or replace the double quotes with single quotes.

 

[Lars]

Right, perhaps worth testing - and the existing setup has worked well for many months, so I'd like to understand what's suddenly causing the error?

Again, heres the workflow: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzNTA0M2M1MjZmNTUzMzUxMzMi_pc

Best,
Lars.

 

[Supreme]

nd the existing setup has worked well for many months, so I'd like to understand what's suddenly causing the error?

The main issue was that the additional double quotes in the Google Sheets value prevented the defined number of Google Sheets fields from being passed correctly.

 

[Lars]

Hey @Lars

The mapped data indicates that even after encoding, the values from your Google Sheets still contain double quotes, leading the API to assume there are additional fields to process.

View attachment 43277

To resolve this, you could use the 'Update Range Values' action step, ensure there are no double quotes in the values from your Google Sheets, or replace the double quotes with single quotes.

View attachment 43276

Ah, now I see it. Thanks!