JSON Objects to Array

[Shegs]

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

[Shegs]

for example I would need it to look like this:

[Shegs · Accepted 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.