I am using the QuickBooks Online “Find Purchase (Expense)” step in Zapier, and the test fails whenever I search using an amount. The error is: QueryParserError: Encountered "<FLOAT> "9.05 "" ... Was expecting "false" or "true"
Perhaps a potential mapping error?
+6Hey
Try adding a Formatter → Numbers → Format Number action before mapping the amount in Find Purchase action.
This should fix it probably. Otherwise post screenshots of whole Data In, Data Out as well as how each Zap step is configured for us to have more context.
Hope it helps!
+14Hi
For us to have more info about the error, post screenshots showing how your Zap step 11 is configured in the CONFIGURE tab.
Hi Troy, currently i’m only searching by amount, please find the attached picture:
+14
TIP: Click field labels to see tooltips with more info about expected field values and formats.
This might be a bug with how the Zap step is configured.
You can try reporting it via a ticket to Zapier Support: https://zapier.com/app/get-help
You can try other approaches:
+6Hey
Did you try formatting the number as I suggested before? Please try that to see if it fixes your issue.
If the action is not working as expected, you probably have to query the Quickbooks API directly using API request action. Here is a helpful article about API request action in Zapier- https://help.zapier.com/hc/en-us/articles/12899607716493-Create-an-API-Request-action
I know it can get a bit more technical and complex but if it’s important for you, you can give this approach a try. Hope it helps!
PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
