ParseJson - Help

Like (0) Share

Report

Posted on 14 Mar 2024 16:06:05 by jbronzo

Hello,

Am trying to parse a json string coming from rest api. The end goal is to set variable to pass as context for generative answers. I am stuck on how to parse the json when there is nested array. In this example, I am wondering how to extract properties like city from the nested address array in results?

Categories:

General

I have the same question (0)

All responses (1)

Answers (0)

jbronzo 7 on 14 Mar 2024 at 21:26:11

Like (0)

Report

Re: ParseJson - Help

I am able to extract properties like the number field using:
ForAll(Topic.varNPIJsonData.results, number)

However, I am not able to merge all of the address properties to a single table with the number field. I have tried syntax like the following can't seem to figure out the correct method.

ForAll(ParseJSON(Topic.varNPIJsonData.results).addresses, {city: Text(ThisRecord.city) })

References used:

1) ParseJSON function - Power Platform | Microsoft Learn
2) Power Apps ParseJSON (youtube.com)
3) How to parse JSON with Copilot Studio (youtube.com)

JsonExample: npiregistry.cms.hhs.gov/api/?city=Dudley&state=MA&limit=1&skip=&pretty=&version=2.1

Was this reply helpful? Yes No