I am trying to do a copy job in Azure Data Factory where I want to copy the entire opportunity entity into a azure sql database. The problem is if I use the auto create table to create the recieving table, or creating the recieving table myself I get the accountid attribute over but with all null values.
If I try to xml query the data over I do not even get the accountid attribute over.
I can read the accountid attribute just fine using SSMS.
Does anyone have experience with this sort of problem and/or knows if there are blockers preventing the accountid data from being /released/ from the CRM environment? (In the azure data factory source preview window I see the attribute but no data)
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.