Background:
I am connecting to an API that returns XML. I was hoping for JSON but I was not that lucky.
The result of my ask is a structured .xml file or even better an Excel file so i can use PowreApps Dataflow for import to CDS.
Why, because i can't figure out how to import the XML response to with xPath in a "for each" setting.
<?xml version="1.0" encoding="utf-8"?> <Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Body> <GetProjectListResponse xmlns="http://24sevenOffice.com/webservices"> <GetProjectListResult> <Project> <Id> 2100009531 </Id> <Name> Yolo </Name> <RawName> Yolo </RawName> <NameDisplay> Plain </NameDisplay> <DepartmentId> -2147483648 </DepartmentId> <TimeReg> WorkType </TimeReg> <Version> 1 </Version> </Project> </GetProjectListResult> </GetProjectListResponse> </Body> </Envelope>
Hi @crmkeeper ,
Could you please explain more details about your requirement?
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |