• 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

Quickbooks to Google Sheets - error 400

Status
Not open for further replies.

furhan

Member
I am trying to extract invoices, payments from one customer to send to Google Sheets.
I have connected both and mapped the fields.

When I do Save and Send Test Request I get an error 400, Error Message: Invalid values, Error Status: INVALID_ARGUMENT.

The problem appears to be the Description field that I want to import, it has several values from Quickbooks - pic attached.
If I delete this date, QB and Sheets works fine but I need the line item description to be exported to sheets.

I am a bit stuck here so I need some help please.
 

Attachments

  • pabbly qbo error.png
    pabbly qbo error.png
    40 KB · Views: 13

ArshilAhmad

Moderator
Staff member
Hi @furhan,

We have added a JSON Extractor to your workflow to extract the Description and mapped that Description to the Google Sheets action step. This seems to have fixed your issue.
1718129628692.png
 
Status
Not open for further replies.
Top