cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

JSON Objects to Array

I have a JSON response from an API call that returns a userset like below:

2018-09-27_11-28-12.jpg

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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.

View solution in original post

2 REPLIES 2
Highlighted
Advocate II
Advocate II

for example I would need it to look like this:

2018-09-27_13-14-58.jpg

Highlighted

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Kudoed Authors
Users online (9,221)