topic Re: Get list of fields of Salesforce Data Objects in Pipelines

Get list of fields of Salesforce Data Objects

Anonymous — Fri, 22 Nov 2024 17:27:59 GMT

Background

I'm looking to set up a SOQL query in data factory to Select Fields(All) From ADataObject Where LastModifiedDate > ADateISpecify. Unfortunately my user isn't able to do a Select Fields(All) so I have to manually write in all the fields of a SF data object to get what I need.

What I Want To Do

I'm thinking that I can query the column names from a data object first and then include it as dynamic content in the SOQL query. Has anyone done this before? What is the best practice to get the column names and then plug it into a copy data activity?

Re: Get list of fields of Salesforce Data Objects

lbendlin — Fri, 22 Nov 2024 18:51:04 GMT

You may have to specify the API level. FIELDS(All) only works at 51+

Re: Get list of fields of Salesforce Data Objects

Anonymous — Fri, 22 Nov 2024 19:16:11 GMT

Is it possible to set this in Fabric? In Data Factory I only see a little text box to write SOQL queries

Re: Get list of fields of Salesforce Data Objects

lbendlin — Fri, 22 Nov 2024 20:01:02 GMT

I know it is possible to set the API version in Power Query. I have no expertise in Data Factory and don't know which API version they use there.

Re: Get list of fields of Salesforce Data Objects

Anonymous — Mon, 25 Nov 2024 02:11:45 GMT

Hi Anonymous

Thank you very much lbendlin for your prompt reply.

You can try the following:

Create a data pipeline, add a web activity to call the Salesforce API, and get the field names.

Create a SOQL query using the extracted fields and you can execute the query in the replication activity.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.