cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

multiple API retuning XML with inconsistent data types for same column

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:

Reece_EC_0-1652938230704.png

 

Sample output (this is also happening to a number of other columns):

Reece_EC_1-1652938288578.png

 

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.

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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

 

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,180)