'Azure Data Factory "Copy data" activity not working for ODATA source with forward slash ("/") in the endpoint's column list
I am trying to do a simple Copy Data activity in Azure Data Factory.
My source dataset is an ODATA EndPoint, which has a $select filter (to specify columns):
All columns are loaded just fine in my destination (SQL server), only I am missing the column "specialField/Custom:81". When I click "preview data", or simply run the Copy Data activity, I get all fields except this one.
It seems clear that it is because the field name contains special characters. How do I fix this? I can easily retrieve data from this field in Postman, so it is a Data Factory issue.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|