cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Connect and get data from xml api

I have a data source that is stored in an XML api and I would like to get it and convert it to JSON so I can iterate through each entry but I don't know how to bring that data into Flow in the first place as I am not familiar with XML.

 

Here is an example

XML

https://www.w3schools.com/xml/plant_catalog.xml

 

How would I connect and convert that to JSON so I can read each of the entries to get <PRICE> of each entry

 

Sorry in advance for the probably simple question, I looked through the forum but couldn't seem to find anything

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Re: Connect and get data from xml api

Howdy @JmeBrey ,

 

I have a blog series in which I create custom connector to invoke an On-Premise SOAP service.

 

In the third blog, I explain on how you can Parse XML responses: https://clavinfernandes.wordpress.com/2019/11/12/create-a-flow-using-the-soap-connector/

 

Perhaps you can use the same idea to connect and get data from your XML API. 

 

 

 

 

 

 

View solution in original post

1 REPLY 1
Highlighted
Memorable Member
Memorable Member

Re: Connect and get data from xml api

Howdy @JmeBrey ,

 

I have a blog series in which I create custom connector to invoke an On-Premise SOAP service.

 

In the third blog, I explain on how you can Parse XML responses: https://clavinfernandes.wordpress.com/2019/11/12/create-a-flow-using-the-soap-connector/

 

Perhaps you can use the same idea to connect and get data from your XML API. 

 

 

 

 

 

 

View solution in original post

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (3,930)