Salesforce reports data lookup using ADF not fetching all columns

Question

Salesforce reports data lookup using ADF not fetching all columns

Devarchetti, Saivenkatesh (Contractor) 0

Hi Team,

I am using ADF lookup activity to fetch records of a salesforce report and seeing one issue. There are two columns with name "Call Type" and "Call type" in salesforce, but ADF lookup activity is fetching "Call Type" column with "Call type" column values. I have checked and these are direct columns from base tables and there are no conditions as well. I have attached the screenshot for reference. Please let me know if anything is missing.

User's image

Thanks & Regards,

D. Sai Venkatesh.

1 answer

Your answer

Answer 1

Amira Bedhiafi 33,071 Volunteer Moderator

It might be worth it to see if you can rename one of the columns temporarily to something different, then run your ADF pipeline and see if the issue still persists. If it doesn't, then rename it back.

Check for views, custom fields, or other configurations in Salesforce that might cause the data to be treated in this manner.

Some platforms treat column names as case-sensitive, while others do not. If ADF is pulling Salesforce data in a case-sensitive manner, but Salesforce is storing it in a case-insensitive manner, this could cause conflicts. Make sure to account for case discrepancies.

Instead of using Lookup directly on the Salesforce data, you can create a Data Flow. In the Data Flow, you can rename columns, handle transformations, and even manage case issues. Once the columns are properly renamed or managed in the Data Flow, use the Lookup on this corrected dataset.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-09-08T22:35:07.86+00:00

Thank you, Amira Bedhiafi

Devarchetti, Saivenkatesh (Contractor) ,

I am checking to see if you got a chance to look into the above answer from Amira. Please let us know if you have any further questions.

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
Devarchetti, Saivenkatesh (Contractor) 0 Reputation points

2023-09-11T10:07:44.33+00:00

HI @Bhargava-MSFT and @Amira Bedhiafi

Thanks for the quick response. Unfortunately, I cannot modify the reports at salesforce end as that is being used by multiple users. I have tried with test reports and it worked the way you mentioned.

I am facing one other issue where only 2000 records are getting fetched through ADF though reports have more than 50K records. Could you help with this?
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2023-09-12T13:42:58.8633333+00:00

Can you please validate the answer ? Otherwise you can open a new question

Share via

Salesforce reports data lookup using ADF not fetching all columns

1 answer

Your answer