Hi All, I have got the Below result from a service using a!httpquery:

rishub356 over 8 years ago

Hi All,

I have got the Below result from a service using a!httpquery:
{"Info":{"Flag":"Y","abc":"2","def":"1","ghi":"1"},"result":"Success"}

I was trying to get data of fields by using using following expression:
I saved the result in local!data & the used following expression to get value of abc
index(local!data, "abc",{})

But this did not work. Can you please guide me with correct expression to get data?

Discussion posts and replies are publicly visible

0 Stefan Helzle
A Score Level 3
over 8 years ago

Try this:

=with(
local!jsn: a!fromJson("{""Info"":{""Flag"":""Y"",""abc"":""2"",""def"":""1"",""ghi"":""1""},""result"":""Success""}"),
local!jsn.Info.abc
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub356 over 8 years ago

Thanks stefanh. It worked. :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

Good news. The fromJson() call is important to convert from JSON to Appian dictionary.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel