azure data factory 2 – How to dynamically use toLabel function with SOQL query to SalesForce API within ADF?

My objective is to stage data from SalesForce to Azure SQL Database using ADF. In the past we used queries written in SOQL to load the data. However, when the SalesForce consultants introduce new columns, the query has to be adapted manually to reflect this change.

We used the toLabel() function to obtain the translation for certain columns. These fields are stored in English, our front-end language is different. We would like to load these translated values instead of the default values, and get the changes from the SalesForce would rewriting the SOQL query.

My first thought would be to create a dynamic query and add the toLabel() function to certain columns if they match the input from a control table. How would you tackle this?

Read more here: Source link