Unanswered

Parse JSON output into a usable string

(0) Share

Report

Posted on 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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yamao-msft on at

Like (2)

Report
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 at

Like (0)

Report

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 at

Like (0)

Report

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 at

Like (0)

Report

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