How to get the elements from a JSON object

Like (0) Share

Report

Posted on 23 Sep 2022 15:25:26 by Dhiran

143

Hi All,

I am trying to get a string value from within a JSON object that I receive. I would like to have have a string after the ParseJSON step which shows the product names - "Product Name A;Product Name B;Product Name C;Product Name D"

[
 {
 "CustomerName": "Customer A",
 "DocumentType": "Word",
 "Product": [
 {
 "Value": "Product Name A"
 },
 {
 "Value": "Product Name B"
 },
 {
 "Value": "Product Name C"
 },
 {
 "Value": "Product Name D"
 }
 ]
 }
]

All responses (3)

Answers (0)

Ellis Karim 10,957 Super User 2025 Season 1 on 24 Sep 2022 at 17:18:36

Like (1)

Report

Re: How to get the elements from a JSON object

The demo flow I posted does not need the Parse JSON action. It uses an expression to "grab" the Product array.

Place your data in to the varJSON variable:

However, if you still need to use the Parse JSON function, then modify the expression in the Select action to:
body('Parse_JSON')?[0]?['Product']

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Dhiran 143 on 24 Sep 2022 at 15:16:18

Like (0)

Report
Re: How to get the elements from a JSON object

Hi @ekarim2020

Thank you for your answer and I tried your steps but had no success 😞

I also look at the raw output of my ParseJSON step and it also had the word body at the head of of the object. I assumed I could just reference the using this expression "outputs('ParseJSON')?['body']?['Product'] but that also failed.

{ "body": [ { "CustomerName": "Customer Name", "DocumentType": "Word" "Product": [ { "Value": "Product A" }, { "Value": "Product B" }, { "Value": "Product C" }, { "Value": "Product D" } ] } ] }
Ellis Karim 10,957 Super User 2025 Season 1 on 23 Sep 2022 at 19:23:21

Like (0)

Report
Re: How to get the elements from a JSON object

Hi @Dhiran ,

We can use the Select and Join actions to create the string.

(2) We can use the Select action Product property. We use the Select action to select the first item (0) of the varJSON array variable, and then specify the Product property - which is also an array. The expressions are shown below:

The output of the Select action is an array of product names:

[ "Product Name A", "Product Name B", "Product Name C", "Product Name D" ]

(3) Finally, we can join all the product names together using the Join action

The output of the Join action is:

Product Name A;Product Name B;Product Name C;Product Name D

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.