salesforce parameters not updating

Carlos Parra 56 Reputation points
2023-06-12T12:11:53.5+00:00

Hello,

The salesforce pipeline keeps failing due to a missing field in the source, supposedly. The parameters for the connection, doesn't have the mapping but upon executing, the mapping shows up. Seems to me like the parameters are cached somewhere and I don't know where. I have redone the salesforce copy task many times and it is the same thing. In the mapping and in the automated parameters created, I don't see the mapping but when executing, it complains about a mapping that doesn't exist?

User's image

User's image

AnnualRevenue, IS NOT anywhere in the parameters but when the pipeline is executed, it always shows up...where is that mapping if not in the parameters that the copy task generates from salesforce? All that process is automated and I have no way of fixing this problem. Please help.

Thank you.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Carlos Parra 56 Reputation points
    2023-06-15T12:49:46.2533333+00:00

    I ended up talking to a Microsoft support engineer. We just decided to recreate the trigger. There is no way to edit the parameters in a trigger so recreating it solved the problem.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.