1 of 1 people found this helpful
API would be ideal.
If you can export Marketo ID or SFDC ID, you can leverage the API to match on a specific record, which the List Import won't do.
So you could run an Excel sheet match, then push back the exact update via Talend+API.
Takes time, but doable.
2 of 2 people found this helpful
A webhook could do this mighty easily: 'hooks run in the context of a single lead, so duplicates are never a problem. Store the Agency-to-Group mapping in a text file in Design Studio (1000 lines is child's play). Pass the Agency field, read the file to get the Group, pass back the Group. A very familiar pattern!
Thanks Josh and Sanford!
Whoah, I think my mind was just blown a little bit. Sanford, does that mean you can host a .txt file in Design Studio, link to it in a webhook call, and return a value? Could you let me know exactly how this work? That sounds like something that's pretty repeatable, which would be fantastic....otherwise I have to host the Python script for the API calls somewhere, rather than simply triggering Marketo smart campaigns with the webhooks.