Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,535 questions
How to fix issue with salesforce object
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 24%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mayur Patil
5
Reputation points
The 'DatedConversationRate' table in Salesforce contains a 'startdate' column with date values like '0000-12-30'.Previously, salesforce connector in Azure Data Factory successfully fetched data by converting these values to '0001-12-30'. However, the Salesforce connector is no longer performing this conversion, causing pipeline failures. We are unable to read data from salesforce by specifying api object name in copy activity of ADF using salesforce connector due to invalid date values but 2 days back it was working fine.it’s working fine by using SOQL query but facing issue with specifying api object name in ADF.Any suggestions?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth 10,085 Reputation points Microsoft Vendor2024-08-12T13:20:53.7166667+00:00 @Mayur Patil We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.
-
AnnuKumari-MSFT 32,736 Reputation points Microsoft Employee2024-08-13T17:46:52.1966667+00:00 Hi Mayur Patil ,
Could you please share the screenshot of the pipeline configuration and the error message.
Also, kindly validate using lookup activity with ObjectAPI configuration to see if it failing to fetch the result there as well with the same error? Is preview data working fine in the dataset?
-
Mayur Patil 5 Reputation points
2024-08-14T07:13:03.32+00:00 Hi @AnnuKumari-MSFT ,
I can preview data within both copy and lookup activities in my dataset. However, I'm encountering errors during the debug process for both. I've attached a screenshot of the error message for your reference.
-
phemanth 10,085 Reputation points Microsoft Vendor
2024-08-20T12:01:53.83+00:00 @Mayur Patil I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan please let us know here.
-
phemanth 10,085 Reputation points Microsoft Vendor
2024-08-23T12:37:33.29+00:00 @Mayur Patil We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Mayur Patil 5 Reputation points
2024-08-23T13:31:29.9433333+00:00 @phemanth no resolution yet
-
Mayur Patil 5 Reputation points
2024-08-23T13:56:27.5466667+00:00 @phemanth not yet
-
phemanth 10,085 Reputation points Microsoft Vendor
2024-08-27T12:19:18.68+00:00 As I previously suggested, please raise a support ticket for further investigation.
Sign in to comment
Sign in to answer