0

I have data that I am retrieving using SentEvent (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/sentevent.htm) and Send (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/send.htm) objects using SOAP API. I'd like to figure out of these two object have a common property/data point in common so I can match/combine the data in a single view...ideally a batchID/jobID (ID to identify the email/asset that is sent). Is there a way to accomplish this whether its directly through SOAP API retrieval or through comparing the two data sets?

0

Updating my anwser per Adam’s comment below:

SentEvent.SendID = Send.ID


If I am not mistaken, it should be SentEvent.SendID = Send.ObjectID.

I like to use the Describe method to get information about the metadata associated with an object, as the documentation isn’t always accurate. You can easily run it on a CloudPage using WSProxy to get all the info you need: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/ssjs_WSProxy_describe.htm

Depending on what kind of data you are trying to get, there might be easier ways to accomplish this than SOAP API, eg. you can pull 6 months of tracking data from Data Views.

| improve this answer | |
  • I believe it's SentEvent.SendID = Send.ID – Adam Spriggs May 20 at 16:17
  • Thanks @AdamSpriggs, that’s true - I just checked and for the Send object, ID actually is retrievable, while ObjectID is not retrievable. – zuzannamj May 20 at 16:27
  • Thanks for the info. Do you have a 'Send' retrieve example using ssjs or know where I can find an example? I haven't been able to find this in documentation. – esgreenberg May 26 at 20:47
  • See WSProxy retrieve request: developer.salesforce.com/docs/… or my blog post about retrieving tracking data: sfmarketing.cloud/2019/11/09/… – zuzannamj May 26 at 20:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.