The sync of my ODX datasource returns the following error.
The datasource is a REST API endpoint of the form URL/{foreign_ID}
, where foreign_id is a dynamic value that comes from a different endpoint within the same data source. The option "Perform exhaustive meta data scan” is enabled. The error returned is this:
Failed to read metadata from XmlDocument for endpoint X with transformation 'T'
Input string was not in a correct format.
There is no further information.
The sync does work when I replace foreign_ID by a fixed value.
The endpoint contains a field that has a lot of values that look like integers, but some values contain letters. Since the above error message is the most verbose info I’ve got, I assumed that's probably the cause. However this conflicts with my understanding of what an “exhaustive meta data scan” should do.
Any help is appreciated.