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?

1 Answer 1

1

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.

4
  • I believe it's SentEvent.SendID = Send.ID May 20, 2020 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, 2020 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. May 26, 2020 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, 2020 at 20:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .