Extracting Nth Value from JSON Array

[Anonymous]

Hi!

I'm wondering how to get the nth value from this array. In my situation, I would need to parse through all three below but not sure how to retrieve these values (effectively). I'm piggy backing from this post I made (same concept).

Thank you!

"ToughnessTemperature": [
  {
    "Key": "DropWeightTearTesting",
    "Value": null
  },
  {
    "Key": "ImpactCharpyTesting",
    "Value": null
  },
  {
    "Key": null,
    "Value": null
  }
]

[Paulie78]

Not this again! 🤮

[Anonymous]

@Paulie78 Yes, unfortunately😕. But, good news, this is the last array I need help with. The rest I can handle (hopefully).

[Paulie78]

I’d do it for you but I’m not near a computer - why not copy the method from the previous post?

[Anonymous]

@Paulie78 Trust me, I've tried. I tweaked and tweaked the expression but I keep getting an error. I tried over 15 different expressions with no luck...hence why I am back😅

[Anonymous]

@Paulie78 I think I got it. It might be:

outputs('JSON')['ToughnessTemperature'][1]['Value']

Tying it out now! 

[Paulie78 · Accepted solution]

From: 

outputs('JSON')['ToughnessTemperature']

Map: 

concat
(
  '"', 
  item()['Key'], 
  '": "',
  item()['Value'],
  '"'
)

The JSON you posted isn't valid and needs to have { and } prepended and appended for these expressions to work. Produces:

{
  "DropWeightTearTesting": "",
  "ImpactCharpyTesting": "",
  "": ""
}

[Paulie78]

The way you are trying it will also work, arguably simpler and easier. Wouldn't have worked for the one you posted yesterday, but this one it should.

[Anonymous]

@Paulie78 Yup, it surely did work! Thank you! Hopefully I won't be back anytime soon lol