SentEvent and Send properties in SOAP API

Question

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?

Answer 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.