• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home Recipe 101 General Best Practices

Best Practices: Dealing With Searches With Partial Matches

Modified on: Mon, Jun 26, 2017 at 10:19 AM

Many connectors in Workato support a search object function, but certain applications, such as Freshdesk are only able to search using a partial match. For example, if you search for a company "ABC Inc.", it will give you all the companies that contain the words "ABC" and "Inc.", meaning you could potentially get multiple matches, and even the first result may not be what you're looking for. In order to circumvent this issue, you can run the following logic: When a new object is created, search for the object in another app. For each object that is obtained in the search, check if there is an exact match. If yes, do something. If no, do nothing. 


Lets take a look at an example using Salesforce Account and Freshdesk Companies. 


What this recipe does is when a new Account is created in Salesforce:

  1. It runs a search for Companies in Freshdesk using the account name from Salesforce
  2. For each item in the list of search results from step 1,
  3. If the company name in Freshdesk matches the account name in Freshdesk,
  4. Perform your desired action. 


With this set of logic, you can be sure that you will receive an exact match for your searches.


NOTE: For certain apps like Freshdesk, the search result has a limit to the number of results it can show, which means if your desired result is past the limit, you will not be able to perform the action, even though it exists in your apps.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

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