• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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: 97

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