Unanswered

Parse JSON output into a usable string

Like (0) Share

Report

Posted on 24 Jan 2019 20:02:59 by TerryMcCullagh

Hi,

My objective is to retreive and display two fields (webLink and toRecipient:name) from a emails in a shared mailbox to be used in an HTML table. How do I get the value of toRecipients:name - just the name?

Thanks,

Terry

Right now this is what I get:

"to": [
{
"emailAddress": {
"name": "XXXXXXXXX",
"address": "XXX@XXX.com"
}
}

I'm using the graph to retreive the values and this is the schema:

{
 "type": "object",
 "properties": {
 "@@odata.context": {
 "type": "string"
 },
 "@@odata.nextLink": {
 "type": "string"
 },
 "value": {
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "@@odata.etag": {
 "type": "string"
 },
 "id": {
 "type": "string"
 },
 "webLink": {
 "type": "string"
 },
 "toRecipients": {
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "emailAddress": {
 "type": "object",
 "properties": {
 "name": {
 "type": "string"
 },
 "address": {
 "type": "string"
 }
 }
 }
 },
 "required": [
 "emailAddress"
 ]
 }
 }
 }
 }
 }
 }
}

graph.png.jpg

I have the same question (0)

Summarized by AI

All responses (4)

Answers (0)

v-yamao-msft on 28 Jan 2019 at 07:46:29

Like (2)

Report
Re: Parse JSON output into a usable string

Hi @Terry_McCullagh,

You may take the following blog USING JSON IN MICROSOFT FLOW for a reference:

https://sergeluca.wordpress.com/2017/11/23/using-json-in-microsoft-flow-part-1/

I assume that you could configure the code to something like:

Item()?['toRecipients']?['name']

Hope it could be your reference.

Best regards,

Mabel

Was this reply helpful? Yes No
TerryMcCullagh 26 on 29 Jan 2019 at 17:02:27

Like (0)

Report

Re: Parse JSON output into a usable string

Mabel, Thank you for the suggestion.

I tried Item()?['toRecipients']?['name'] and received this error:
ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@Item()?['toRecipients']?['name']' is of type 'Null'. The result must be a valid array.

Can you identify what I'm doing wrong?

Thanks,
Terry

Was this reply helpful? Yes No
DanielaHo 241 on 17 Mar 2022 at 02:28:05

Like (0)

Report

Re: Parse JSON output into a usable string

Hello,
I know it's been a while since this post but I'm having the same problem. The JSON is an object and I'm trying to extract data from it, and nothing works.. curious if you or anyone has a solution. Most solutions found online are extracting from a JSON array not object.

Was this reply helpful? Yes No
ESG 14 on 12 Oct 2023 at 17:10:56

Like (0)

Report

Re: Parse JSON output into a usable string

When you parse the JSON, do you do it immediately after having access to it, or are you trying to parse JSON while nested inside of something that may not really have access to the JSON data?

Was this reply helpful? Yes No