Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I'm not sure if I am asking this question correctly, but I am trying to pull a list of Events from a web API. That list of events contains an event ID that can be passed into another URL to retrieve a list of instances/dates. Is there a way I can pass through the Event IDs that are retrieved into the instances URL?
Displays List of Events: https://system.company.com/clientname/api/v3/events
Displays List of Instances: https://system.company.com/clientname/api/v3/events/{id}/instances
Thanks for any assistance!
You can JSON parse the return payload of the initial Web.Contents call and then access the individual parameters (and re-use them for subsequent Web.Contents calls.) Beware of the Formula Firewall.
| User | Count |
|---|---|
| 54 | |
| 37 | |
| 26 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 69 | |
| 56 | |
| 38 | |
| 21 | |
| 21 |