Unanswered

Copilot Studio Parsed Json request

(1) Share

Report

Posted on by EudesBarbosa

Hello everyone, I'm a beginner with Copilot Studio and I could use some advice. I'm making an API request and storing the response in the 'SampleJSON' variable. After that, I attempt to access the property 'Topic.SampleJSON.result[0].number' to display this value in the chat. However, I encounter an error stating that it's not possible. How can I correctly reach the last level of this JSON property that looks like this:

{

"result": [

{

"number": "string",

"short_description": "string",

"close_notes": "string"

}

]

}

Categories:

Publish & channel management

I have the same question (0)

All responses (4)

Answers (0)

adilei Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Use the PowerFX Index function to access a specific row:

Index(Topic.resultTable.result,1).close_notes

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @adilei,

Does the Index function actually work with a record data type? Like @EudesBarbosa mentioned the return data is not a table, but a record.

Was this reply helpful? Yes No
adilei Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Thanks for bringing this to my attention!

OP's payload is an array nested within an object, or in PowerFX, a table nested within a record:

{ "result": [ { "number": "string", "short_description": "string", "close_notes": "string" } ] }

To access a property on the first record of a table nested within a record, you can use the following pattern:

Index(Topic.myRecord.result,1).close_notes

Was this reply helpful? Yes No
Leo_Blue 7 on at

Like (3)

Report
Copy link

Link copied!
Not sure if this code worked for you. It threw an error when I used this code.

Index(Topic.resultTable.result,1).close_notes

It worked fine when I tried this way:

Index(ParseJSON(Topic.resultTable.result),1).close_notes

Was this reply helpful? Yes No