Search for customer in Quickbooks

[Baruch_Pappo]

Hi folks,

I’m trying to do a search in QuickBooks for a customer based on phone number (Unfortunately the search by field doesn’t have a phone search option), so I used a user defined query:

However, I’m getting the following error, wondering what’s wrong in the query?

Thank you!

[Wemakefuture]

Hi. Maybe you have issues with special characters “(” and “)” in your query. Try a test removing it to be sure. Probaly the field type has specific requeriments in QBO.

---

Thanks, Helio!
Wemakefuture
If you have questions reach out

[alex.newpath]

It looks like the QBO query engine is not allowing the ( and ) characters around your WHERE clause. Have you tried removing them? They are not really necessary in your particular situation.

[Baruch_Pappo]

I was using OR not AND. I changed the query to its simplest form and still getting an error

[alex.newpath]

The Mobile_FreeFormNumber field is not in the table Customer. Confirm the name of the field please.

[Baruch_Pappo]

It should be in the table

and this is from a previous step:

[alex.newpath]

Try selecting all the fields from Customer without any where clause to see what the actual field is. The array aggregator shows that the FreeFormNumber field is inside a collection called Mobile, and that is not the native name of the field in the QBO database, I don’t think.

[Baruch_Pappo]

So here I’m doing a field search ‘Email’ and this is the result from QB:

[Baruch_Pappo]

…and here I did a search using Skyvia

[alex.newpath]

I am stumped then. That query looks identical to what you already tried and got an error. Maybe open a ticket with Make support?

[Baruch_Pappo]

Thank you Alex, I’ll contact support.

[Baruch_Pappo]

Do you know how long does it take them to respond…They never got back to me.

[Baruch_Pappo]

Wow, so this was Make support response.