I have a JSON response from an API call that returns a userset like below:
I'd like to convert that somehow into an array of users that I can then loop through.
I've tried just replacing the second layer of {} to [] but the ID and the ":" cause issues. I don't quite know how to replace those since they can be various numbers and there could be hundreds of them. I was looking for some kind of regex or wildcard replace but the only one I found required another subscription plan that I'd prefer to avoid.
Thanks in advance.
-Aaron
Solved! Go to Solution.
I was able to create an SQL stored procedure that fixed the JSON to what I wanted.
I used flow to send the JSON to SQL as a string then took the response and could edit it down to what I need it to be.
for example I would need it to look like this:
I was able to create an SQL stored procedure that fixed the JSON to what I wanted.
I used flow to send the JSON to SQL as a string then took the response and could edit it down to what I need it to be.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
13 | |
11 | |
11 | |
7 | |
6 |
User | Count |
---|---|
20 | |
16 | |
14 | |
10 | |
9 |