• 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 Find a customer

Metro

Member
Your Task History ID
Zelle Payments Notifications api in my account.
I am trying to run a solution to email parsar a name and find a QuickBooks customer with something other than the email. looking over the quickbooks api info i see i can use
"GivenName":
"FamilyName":
"FullyQualifiedName":
"DisplayName"
I would like to run a filter that finds a customer using a name using the contains function with these above data sets.
I tried running the api get function in the endpoint url using
https://quickbooks.api.intuit.com/v3/company/913XXXXXXXXXXX/query?query=select_*_from_Customer_Where_FullyQualifiedName_>_'Megan'&minorversion=70

in the data set but i'm getting a validation error.

Quickbooks request
GET /v3/company/913xxxxxxxxxxxxx/query?query=select * from Customer Where FullyQualifiedName > 'Megan'&minorversion=70

Content type:text/plain
Production Base URL:https://quickbooks.api.intuit.com
Sandbox Base URL:https://sandbox-quickbooks.api.intuit.com

seems to be working on their end.

is there something i am missing?
 

Supreme

Well-known member
Staff member
Hey @Metro

Could you kindly provide the URL for the workflow and grant permission to search for the customer within your QuickBooks inside your workflow?
 

Supreme

Well-known member
Staff member
Hey @Metro

Kindly check the following screenshot setting up the query to get the customer details.

image (1).png
 
Top