Salesforce Azure Data Factory Source Connector getting less or more columns from salesforce

Satya Praveen Velicheti 6

Hi,

I'm using ADF to get data from Salesforce to SQL Server (Copy Activity). I see everything is working except that Salesforce connector is getting less columns for one Salesforce object and also getting more columns (Than what we see in actual salesforce object) for one other object. Trying to find if i'm missing anything in here or is that an expected behavior.

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2023-05-11T22:31:02.9766667+00:00

Hi @Satya Praveen Velicheti ,

Thanks for using Microsoft Q&A forum and posting your query.

As per my understanding, ADF Salesforce connector is getting less columns for one Salesforce object and more columns for another Salesforce object. Please correct me if I'm wrong.

To verify if this is an issue with ADF or an issue with your specific objects, could you please try in POSTMAN using Salesforce API and see if you notice the same behavior or not? Let us know how it goes.

For the object where you are getting more columns, could you please confirm if the additional columns are custom fields or standard fields?

Thanks
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2023-05-12T23:05:02.5766667+00:00

@Satya Praveen Velicheti Checking to see if you have a got a chance to test the scenario mentioned in my previous response.

Please do let us know how it goes.

Thanks

2 answers

Satya Praveen Velicheti 6 Reputation points

2023-05-15T11:47:05.27+00:00

Hi @KranthiPakala-MSFT , For less columns found it's due to a setting at salesforce level. There is a column level setting in Salesforce which needs to be set in order for a column to be visible to respective user/Application. https://developer.salesforce.com/forums/?id=906F0000000AhcPIAS. Following that I was able to see rest of the columns in ADF now. I will try the Post Man today to test more columns piece.
Please sign in to rate this answer.
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2023-05-15T14:28:02.85+00:00

Thanks for the update @Satya Praveen Velicheti ! Please keep this posted on how the testing goes.
Sign in to comment
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more