• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

JSON error when updating row in Google sheet

Status
Not open for further replies.

Lars

Member
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.

1718183417085.png
 

Supreme

Well-known member
Staff member
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.

2024-06-12_15h30_22.png


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.

1718186642102.png
 

Supreme

Well-known member
Staff member
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.

1718189016444.png
 

Lars

Member
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! :)
 
Status
Not open for further replies.
Top