Skip to main content
Community site session details

Community site session details

Session Id : kbARPFd2+KIfk1YzyK9MBk
Copilot Studio - General
Unanswered

ParseJson - Help

Like (0) ShareShare
ReportReport
Posted on 14 Mar 2024 16:06:05 by 7

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?

jbronzo_0-1710432276509.png

 

Categories:
  • jbronzo Profile Picture
    7 on 14 Mar 2024 at 21:26:11
    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:
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 468 Super User 2025 Season 2

#2
stampcoin Profile Picture

stampcoin 52 Super User 2025 Season 2

#3
trice602 Profile Picture

trice602 46 Super User 2025 Season 2