Hello @Nik Kasala and welcome to Microsoft Q&A.
Data Factory supports two query languages with SalesForce (SOQL , SQL-92). While SOQL does not support aliasing/column renaming, SQL does.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
We are looking to query data in SF using ADF and here is the error I am receiving:
There is a duplicate column names 'Id' in the structure. An item with the same key has already been added. Activity ID: 1ff3c2a6-fae1-4aa0-b728-8fde216082ac
Query :
SELECT IBIS_ID__c, RecordType.Name, Type, Name, Short_Name__c, Legal_Name__c, Country__c, State_Abbr__c,
(SELECT Association_IB_Account__c, Association_IB_Account__r.Name, Association_IB_Account__r.IBIS_ID__c,
Association_IB_Account__r.RecordType.Name from Association_Member__r),
(SELECT Id, Name, MALatitude__c, MALongitude__c, Status__c from Addresses__r ),
(SELECT Id, Account_IBIS_Code__c,
Auth_Certificate_Dispatched__c,
FROM ib_programmes__r)
FROM Account
I am using relational queries and Salesforce does not provide field aliasing. How can I resolve my error in ADF?
Thanks!
Nik
Hello @Nik Kasala and welcome to Microsoft Q&A.
Data Factory supports two query languages with SalesForce (SOQL , SQL-92). While SOQL does not support aliasing/column renaming, SQL does.