I’m a newbie so bear with me. I’m working on a pipeline that connects to a CRM system. This CRM system tracks everything by the customer’s contact ID number. However, our web site uses a customer’s email address for all processing. I’m trying to find a way to take an email address input and find the corresponding customer’s contact ID number.
Does anyone out there have any tips on how to do this?
This is the path I’m currently taking but it seems very laborious:
- I use a REST GET to get all contacts. This only gets me high level attribute fields (with one being contact ID).
- I use another REST GET to get the full details of each contact. This gets me a link to find the email addresses but not the actual email addresses.
- I use another REST GET to get all of the email addresses of all of the contacts. This gets me email addresses but errors when a contact doesn’t have an email address (not sure how to skip those null values).
I’m also not sure how to merge all of these attribute values back together into a complete list of results. (ie. I have no idea how to match the email addresses of the last REST GET with the full details found in the previous REST GET. Any ideas?