Creating a Campaign Member record in SFDC and from the error message it seems like the Campaign Member ID is getting cut off? Any tips here?
Happening sporadically here as well
Hi Alex, thank you for reaching out.Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732130100&signature=b5320d5c842214c2a629c6d21dc6d698fce7d9ae106d66d52d34c55d55712ad5&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn9BZcX2BKsam%2FhVPsumQ%3D%3D%0A
The error you're encountering occurs because either the Member ID or the Campaign ID is missing or invalid in your request to add a Campaign Member in Salesforce. Specifically, the error message indicates that the Member ID is null, and there may be an issue with the Campaign ID being truncated or incorrectly formatted. Salesforce requires both fields to be populated for the operation to succeed. To resolve this, ensure that the Member ID is correctly passed and not null, and verify that the Campaign ID is correct and fully intact. Once both fields are correctly populated, the request should be processed successfully.
Thanks Stefano but this is a create record, there wouldn’t be a member ID
In the "Create Record" column, where we see the error, the issue is that there is no ID to provide to Salesforce. The column is currently using the ContactId returned from the "contact-lookup" column. Many rows do not have a value in that column. So Salesforce cannot create a membership because it does not know who it is for. ContactID is required, so you'll need to be sure the "Create Record" has one to provide. https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_campaignmember.htm (Both 15- and 18-character Salesforce IDs are valid, they're just different versions for case sensitivity. So I wouldn't worry too much about that. cf. https://help.salesforce.com/s/articleView?id=000383751&type=1) As a test, I re-ran the "contact-lookup" for row 4, saw a record returned, and then "Create Record" worked as a result.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.