multiple API retuning XML with inconsistent data types for same column

[Syndicate_Admin]

Hi,

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.

Advanced Editor:

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?

Any help is appreciated.

Thanks, Reece.

[Syndicate_Admin]

Hi @Reece_EC ,

Sorry for that the information you have provided is not making the problem clear to me.

Do you want to keep on expanding Table values ? Or just filter out Table values?

Best Regards,
Eyelyn Qin

[Syndicate_Admin]

Hi Eyelyn,

I am wanting the data in the "table" fields shown in the column just list the rest of the data in those columns.