Unanswered

How to read a value from array object by name?

(0) Share

Report

Posted on by sathishsam

I have a output from HTTP as an array like below

[
{
"country": "USA",
"kpi": "Sales",
"value": "4444",
"indicator": "same"
},
{
"country": "USA",
"kpi": "Revenue",
"value": "5555",
"indicator": "same"
},
{
"country": "China",
"kpi": "Sales",
"value": "3333",
"indicator": "same"
},
{
"country": "China",
"kpi": "Revenue",
"value": "3444",
"indicator": "same"
}
]

Now i want to read Sales value for say USA, how do i achieve this using expressions so that i can form a HTML body out of this

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sathishsam

I have made a test for your reference:

1.

2.

Best Regards,

Levi

Was this reply helpful? Yes No
sathishsam 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks Levi.
However, in my case this will not work as i have too many items in the array and i have write filter for each expression. For example if i want to find a value of Revenue of China, how do i find it using an expression?

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sathishsam

Are you trying to perform a filter per country?

Best Regards,

Levi

Was this reply helpful? Yes No
sathishsam 10 on at

Like (0)

Report
Copy link

Link copied!

I have next action to send email with some custom formats and have to render each KPI in the email

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sathishsam

Could you please show me an example?

Best Regards,

Levi

Was this reply helpful? Yes No
sathishsam 10 on at

Like (0)

Report
Copy link

Link copied!

Something similar as shown in above example

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sathishsam

So you want to get sales and revenue for each country?

You can use the second method I provided.

Best Regards,

Levi

Was this reply helpful? Yes No
sathishsam 10 on at

Like (0)

Report
Copy link

Link copied!

you mean to build the html table dynamically under apply for each and then concatenate ?

Was this reply helpful? Yes No
sathishsam 10 on at

Like (0)

Report
Copy link

Link copied!

Is there no easy way to directly query the JSON and append the values in my HTML tempelate
<table>
<tr><td>INDIA <br> json['India']['Sales'].value <td><tr>
......

Was this reply helpful? Yes No