How to find out the Object Type in a Salesforce Polymorphic relationship when using the Salesforce Query component

Matillion ETL
1

Occasionally Salesforce Object have polymorphic relationships with other Salesforce Objects. In a polymorphic relationship, the referenced object of the relationship can be one of several different types of object. These polymorphic relationships are defined using polymorphic fields contained in a Salesforce Object. A polymorphic field is one where the related object might be one of several different types of objects. For example, the Who relationship field of a Task Object can be a Contact or a Lead. Similarly the What relationship field of a Task can be any non-Person Object in Salesforce.

 

When using the Salesforce Query component in Matillion how do I find out the Object Type of a Object ID in Polymorphic field?

2

Hey @saqib​

Thank you for posting your question, If you would like me to raise a support case for you with your solution architects, I would be more than happy to, just let me know 😀

Thanks Joe

3

All done @saqib​

You should hear off a member of our team soon, thank you for sharing your experiences with us here on the community, I look forward to hearing about the resolution and the continuation of your amazing work!

Thanks, Joe

4

Hi @JoeCommunityManager​ . Yes, please. That would be awesome. Thanks again.