Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
10106 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
JSON Key Lookup
kdimitrov
over 7 years ago
Hi there,
Curious if anyone has any good suggestions on the below problem. We are trying to get the keys from a JSON array object. The keys unfortunately are dates and are dynamic. For example, the below works fine, but it's hard-coding "09/03/2017". Any way to get all the keys from the object properly? Worth noting that index(local!list, 1) does not work in the below case.
=with(
local!json: "{
""09/03/2017"": {
""total"": 5
},
""10/03/2017"": {
""total"": 5
}
}",
local!list: a!fromJson(local!json),
index(local!list, "09/03/2017")
)
OriginalPostID-268859
Discussion posts and replies are publicly visible
Parents
0
Josh
Certified Lead Developer
over 7 years ago
Here is an Appian implementation for your data model. Note that it could probably be cleaned up and it may not work for other data models! Also, you want the "values" here, the "keys" are the dates in your dictionary.
with(
local!json: "{
""09/03/2017"": {
""total"": 5
},
""10/03/2017"": {
""total"": 5
}
}",
local!dictionary: a!fromJson(local!json),
local!objects: split(tostring(local!dictionary), ","),
local!keysRaw: apply(
mid(_, 1, 11),
local!objects
),
local!keysStripped: apply(stripwith(_, "[]:"), local!keysRaw),
apply(index(local!dictionary, _, {}), local!keysStripped)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Josh
Certified Lead Developer
over 7 years ago
Here is an Appian implementation for your data model. Note that it could probably be cleaned up and it may not work for other data models! Also, you want the "values" here, the "keys" are the dates in your dictionary.
with(
local!json: "{
""09/03/2017"": {
""total"": 5
},
""10/03/2017"": {
""total"": 5
}
}",
local!dictionary: a!fromJson(local!json),
local!objects: split(tostring(local!dictionary), ","),
local!keysRaw: apply(
mid(_, 1, 11),
local!objects
),
local!keysStripped: apply(stripwith(_, "[]:"), local!keysRaw),
apply(index(local!dictionary, _, {}), local!keysStripped)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data