multiple API retuning XML with inconsistent data types for same column
I have a query that has an API call to a table that returns an XML. Due to limitations on the API, I need to call the API for multiple pages. For some reason some of the columns are being returned as a single Text Value (or Date depending on the column) on one call but a Table Value on another.
Sample output (this is also happening to a number of other columns):
Is there a way to stop having these incorrectly set as a table value?
A way to convent just those that have been incorectly set as a Table Value?