Solved

Salesforce Query Contact Record in NWC - Receiving failure on Query

  • 5 March 2020
  • 1 reply
  • 10 views
S

I'm building a NWC workflow that populates information in Salesforce. I'm stuck on query contact look-up fields. I'm receiving the same failure notification when I try and query the contact records in Salesforce. 

 

Here's the use case: 

Submit a form to create an opportunity with "Architecture Contact". This is a look-up field in Salesforce. I submitted a form request with the name "Sammie Gibson", which is an existing contact in Salesforce. I'm trying to query the results, if the results return 1 record, then I'm updating the opportunity with the Architecture name submitted. However, the workflow is failing on query a record and returning the error message attached.

 

I've attached a picture of the my configuration as well.

 

Any ideas on what I'm doing wrong here? 

 

 

 

icon

Best answer by butlerj 6 March 2020, 15:23

View original
2 Attachments

1 reply

butlerj
Userlevel 5
Badge +19

@Sgibson20 it looks like what you actually want for that query is the ID of the contact in SFDC (not sure how familiar you are with SFDC, but this will be the string in the URL after your TLD: https://company.my.salesforce.com/0062v00001Hz1DZ). Right now your action is configured to query for the ID and when it looks for a record with ID "Sammie Gibson" (https://company.my.salesforce.com/Sammie Gibson) it can't find that record and fails. 


 


There are two ways that you could potentially go about this:


 



  1. If you know the contact ID then you can just enter that in the form and the workflow should work as is.

  2. If you don't know the contact ID by memory then you should be able to query by their name: 

  3. And then you will most likely want to extract the ID of your contact from that collection so you can use it elsewhere in your workflow:



 


Hope that helps!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings