Web API - Nested JSON results in grid columns

Dashboard Server
1

I’m hoping someone can help with this.

Is there a way to display ALL of the values under the “rankedImpacts” in the sample JSON below? It seams like I can display one key value pair such as “rankedImpacts” > “entityName:value” but I cannot figure out how to display the other values.

data key path = rankedImpacts
custom template = {{#each value}} {{entityName}} {{/each}}

{
“result”: {
“problems”: [
{
“id”: “-5089970466801314401_1634232960000V2”,
“startTime”: 1634233260000,
“endTime”: -1,
“displayName”: “P-2110963”,
“impactLevel”: “INFRASTRUCTURE”,
“status”: “OPEN”,
“severityLevel”: “RESOURCE_CONTENTION”,
“commentCount”: 2,
“tagsOfAffectedEntities”: [],
“rankedImpacts”: [
{
“entityId”: “PROCESS_GROUP_INSTANCE-99D03F8327F1FD9F”,
“entityName”: “JBoss standalone wildfly”,
“severityLevel”: “RESOURCE_CONTENTION”,
“impactLevel”: “INFRASTRUCTURE”,
“eventType”: “HIGH_GC_ACTIVITY”
}
],
“affectedCounts”: {
“INFRASTRUCTURE”: 1,
“SERVICE”: 0,
“APPLICATION”: 0,
“ENVIRONMENT”: 0
},
“recoveredCounts”: {
“INFRASTRUCTURE”: 0,
“SERVICE”: 0,
“APPLICATION”: 0,
“ENVIRONMENT”: 0
},
“hasRootCause”: true
}
],
“monitored”: {
“INFRASTRUCTURE”: 0,
“SERVICE”: 0,
“APPLICATION”: 0,
“ENVIRONMENT”: 1
}
}
}

sample
sample1261×929 226 KB

2

Hey

This is a bit tricky to do with the WebAPI tile as the objects returned under that field are in an array. When this is the case I usually switch to the Powershell tile instead which is much easier to manipulate.

I think it’s worth checking the support however if they have any tricks to achieve this using some JS magic.

Cheers

1 Like
3

Just saw this again. What happens when you click on “show hidden columns” under the grid columns section? Do the other fields not show up?