How to find a customer in QB using ListID

[siroos12]

Hi,

 

I have the customer ListID in FM and wanna make sure that this customer does exist in QB. This is my approach:

PCQB_ZQuery("CustomerQueryRs/*/ListID";"Customer";"<ListID>" & $QBCustomerListID & "</ListID>";"")

Then I use "PatternCount" to search for the target ID.

Can anyone suggest any neater approach?

Edited July 30, 2018 by siroos12

[PCIPal]

Hi Siroos,

Using the native FM Books Connector functions, you can verify if a customer exists by executing the following functions:

 

PCQB_RqNew( "CustomerQuery" )

PCQB_RqAddFieldWithValue( "ListID" ; $QBCustomerListID )

PCQB_RqExecute

 

If the result of PCQB_RqExecute is 0, the customer exists in QuickBooks; otherwise, the customer does not exist. Using these functions ensures you don't need to worry about using a PatternCount to validate the results of the response; the plug-in will report error if the requested ListID is not found (you can further verify this by calling PCQB_SGetStatus immediately after the PCQB_RqExecute function call).

 

Hope this helps!

Chris Turner

[siroos12]

30 minutes ago, PCIPal said:

Hi Siroos,

Using the native FM Books Connector functions, you can verify if a customer exists by executing the following functions:

 

PCQB_RqNew( "CustomerQuery" )

PCQB_RqAddFieldWithValue( "ListID" ; $QBCustomerListID )

PCQB_RqExecute

 

If the result of PCQB_RqExecute is 0, the customer exists in QuickBooks; otherwise, the customer does not exist. Using these functions ensures you don't need to worry about using a PatternCount to validate the results of the response; the plug-in will report error if the requested ListID is not found (you can further verify this by calling PCQB_SGetStatus immediately after the PCQB_RqExecute function call).

 

Hope this helps!

Chris Turner

Awesome, Thank you!