Need some help. I'm trying to figure out how to transform this JSON response into the desired table format.
{
"ESS-auth-profiles-svc.temp": {
"flagVersion": 4,
"trackEvents": false,
"value": false,
"variation": 1,
"version": 1091
},
"PROCESS_EVENT_IDR": {
"flagVersion": 20,
"trackEvents": false,
"value": false,
"variation": 1,
"version": 1091
},
"acl-svc.api-only.temp": {
"flagVersion": 6,
"trackEvents": false,
"value": true,
"variation": 0,
"version": 1091
},
"acl-svc.domain-active-check.temp": {
"flagVersion": 6,
"trackEvents": false,
"value": true,
"variation": 0,
"version": 1091
}
}
Each of the bolded items i want to be the rows. and flagVersion, trackEvents, value, variation, version be the column headings.
So want it to look like this.
| FlagName |
flagVersion |
trackEvents |
value |
variation |
version |
| ESS-auth-profiles-svc.temp |
4 |
false |
false |
1 |
1091 |
| PROCESS_EVENT_IDR |
20 |
false |
false |
1 |
1091 |
| acl-svc.api-only.temp |
6 |
false |
true |
0 |
1091 |
| acl-svc.domain-active-check.temp |
6 |
false |
true |
0 |
1091 |
| …..there will be 1000's of these in array |
|
|
|
|
|
I'm getting the data via API call with REST connector.
Any help would be appreciated. Been trying to figure this out for hours with no luck.
