• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Recipe Error Troubleshooting
S

Saul Macht

started a topic almost 6 years ago
Answered

Salesforce: More than 1 record matched the given creteria and could not be updated. Make sure the condition matches exactly one record

Hi, i'm having difficulty with a recipe between Google Sheets and Salesforce where a new sheet row in Google Sheets creates or updates a Campaign Member on Salesforce.


image


Error message: More than 1 record matched the given criteria and could not be updated. Make sure the condition matches exactly one record


However, I am using the Contact ID ... so its not possible that it matches more than one record?



Best Answer
P
Patricia Guevarra said almost 6 years ago

Hi Saul,


This error might be due to the fact that you have one contact in multiple campaigns. This causes an error because the recipe becomes unsure which one it should be updating -- should it be the contact under Campaign A, or the contact under Campaign B? The best way to go about this is to to do a search for the campaign member populating both the Contact ID field and Campaign ID field. This means that it will look for the contact that fulfills both conditions. From there, you can do two conditional actions -- if the Campaign Member is present then update it, if not present then create it. Do let me know if anything is unclear!

Answer

Patricia Guevarra

said almost 6 years ago

Hi Saul,


This error might be due to the fact that you have one contact in multiple campaigns. This causes an error because the recipe becomes unsure which one it should be updating -- should it be the contact under Campaign A, or the contact under Campaign B? The best way to go about this is to to do a search for the campaign member populating both the Contact ID field and Campaign ID field. This means that it will look for the contact that fulfills both conditions. From there, you can do two conditional actions -- if the Campaign Member is present then update it, if not present then create it. Do let me know if anything is unclear!

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