• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Applications Questions
T

Trevor Perraton

started a topic almost 6 years ago
Answered

[QuickBooks Online] - Search QuickBooks by ID to avoid duplicates

Would like to see the ability to search Quickbooks by ID (not just display/company name or email) so duplicate records are not created.


If I create an account with a company name of "ABC Ltd." in salesforce and the workato process creates the related account in QB with a company name of "ABC Ltd." they both match and all is fine and both have the UID of, for example, "3". If i change the company name in salesforce or QB to "ABC Inc." or the organization goes through a name change to "XYZ Newco LLC" I now am in a position where Workato can't match my records any longer. However, if the UID is used to search QB records all is fine and no duplicate records are created.


Thanks.

Trevor


Best Answer
C
CJ Wee said almost 6 years ago

Hi Trevor,


If you want to search for a customer by ID, you can use the action "Get customer details".


image


"Search" and "Get" are almost identical in function. 


The only difference is that "Search" can return 1 or more results which meet the search criteria (i.e multiple users with the same Display name or same email address).


"Get" on the other hand, returns 1 unique result which makes sense since the Customer ID is a unique identifier for a record in Quickbooks.


Hope this helps!


Answer

CJ Wee

said almost 6 years ago

Hi Trevor,


If you want to search for a customer by ID, you can use the action "Get customer details".


image


"Search" and "Get" are almost identical in function. 


The only difference is that "Search" can return 1 or more results which meet the search criteria (i.e multiple users with the same Display name or same email address).


"Get" on the other hand, returns 1 unique result which makes sense since the Customer ID is a unique identifier for a record in Quickbooks.


Hope this helps!


Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count