I have an issue with the copy data activity. Scenario input is xml to db sproc tabletype sink.
I noticed it works fine as long as we have 0 or 2+ elements, if we have exactly one child element in the source Xml it is not mapped and send to the DB.
it looks like internally in the ADF the xml is converted into Json, but if the xml has only one child it dose not convert it to an array, but the mapping requires it to be a collection.
Mapping is like
element
item -> [] array Collection reference is checked
this dose not work if item is 1, it will not throw an error , but will not map the item.
Can we somehow adjust the mapping, to allow a collection or a single element both?
Can we influence the internal conversion from xml to json to force it to use an array?