I have a Swagger Defined REST Web Service that returns something in the format of the following:
{ "Id": "86790819-21b1-4881-9af2-86297f586021", "Status": "OK", "ProviderName": "MyApp", "DateTimeUTC": "/Date(1508339098344)/", "Invoices": [ { "Type": "ACCPAY", "InvoiceID": "20ff01b8-c2d8-49bb-8abf-a9486c9ea665", "InvoiceNumber": "RPT644-1", "Reference": "", }, { "Type": "ACCPAY", "InvoiceID": "20aaa1b8-c2a8-49ab-8abf-a9a86caeaaa6a", "InvoiceNumber": "RPT644-2", "Reference": "", } ] }
I want to cycle through all of the Invoices and grab the InvoiceId to then use in a later flow call, but I can't figure out the proper way to reference the properties of a JSON.
Since this structure is all defined in Swagger, I thought it would be as easy as doing an Apply To Each on the Invoices; but that is not identified as a parameter since its an object that has a property that has an array.
Based on my searches, it sounds like I should be able to use Compose somehow, but I'm not sure how to reference the property.
e.g. In concept, I feel like I should be able to put the following as the source of a Apply To Each:
Solved! Go to Solution.
As soon as I posted this, I found more actions I hadn't seen before.
1) Search for "Compose" within Actions.
2) Choose "Parse JSON"
- I gave an example payload for parsing.
3) Choose Apply To Each and use the Array as Input
Wallah, I'm good to go.
As soon as I posted this, I found more actions I hadn't seen before.
1) Search for "Compose" within Actions.
2) Choose "Parse JSON"
- I gave an example payload for parsing.
3) Choose Apply To Each and use the Array as Input
Wallah, I'm good to go.
Hi @DougL for point 3 3) Choose Apply To Each and use the Array as Input, what is the array you compose?
I have the same problem.
Kind regard
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
29 | |
29 | |
21 | |
11 |