Extract value from http response

[chandrasekhar.jella]

Hi,

I am working on http call (API) and getting below sample response.
{
“ObjectA”: {
“Name”: “Fruit”,
“Color”: “Red”
},
“contains”: [
{
“FruitName”: “Mango”,
“IsFound”: “Yes”
}
]
}

Now I have to check the Condition if IsFound is Yes, then I have to extract FruitName as Mango.

Any help is greatly appreciated.

Thanks in advance.

[TimK (Tim Kok)]

You need to de-serialize it first then get the element root for ‘contains’ from the xdoc

Xdoc.Root.Descendants(XNameSpace+ “contains”)

then access the IsFound element within that by de-serializing that into a new xdoc:

xdocContains.Root.Descendants(XNameSpace+ “IsFound”).value.tostring

[chandrasekhar.jella]

Hi TimK,

Thanks, but how can I get XnsGCNS?
My requirement is to extract FruitName if IsFound equals to Yes.

[Yoichi]

Hi,

Can you try the following?

1. First, Deserialize your string using Deserialize Json activity in Web Activity Package.
2. Then you can get JObject variable (Let’s say jo).
3. Next you can get JToken variable (say jt) like jt=jo("contains")
4. Finally, you can get each value as jt.First.Item("FruitName") and jt.First.Item("FruitName")

Regards,

[TimK (Tim Kok)]

Sorry XnsGCNS is just an argument name - Xns - is the XNamespace (This is probably isnt required.)

Extraction of Data from a JSON

Hi Aksh1 Thanks for your Feedback. My sequence actually Looks like: HTTP Request (get a id) HTTP Request with the ID ( get the json as string) Deserialize Json (string) as Json object For each Loop Write it to line as string That is working so far (if i filter that everything will be exported). If i Change the filtering to dífferent types i got an error that there are different datatypes in the Array (string, int32 and so on). Think here is the first understanding Problem from me. I tried …

Take a look at this link

[chandrasekhar.jella]

Hi Yoichi,

Thanks. It is very much useful.

If it has multiple nodes with different IsFound, then it is a problem. For example,

{
“ObjectA”: {
“Name”: “Fruit”,
“Color”: “Red”
},
“contains”: [
{
“FruitName”: “Mango”,
“IsFound”: “Yes”
},
{
“FruitName”: “Banana”,
“IsFound”: “No”
},
{
“FruitName”: “Apple”,
“IsFound”: “Yes”
},
{
“FruitName”: “Grapes”,
“IsFound”: “Yes”
}
]
}

In this case, I have to get Mango, Apple and Grapes

Thanks in advance.

[Yoichi]

Hi,

It would be like the following image.

sample20191203.xaml (6.3 KB)

[HareeshMR (Hareesh Madasi)]

Check this @chandrasekhar.jella

jsondata.xaml (6.0 KB)

You can check for the name of the fruit to get the value and get the required value of flag

[chandrasekhar.jella]

Hi Yoichi,

Thanks for sharing logic and it’s working.