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
11 replies
Subscribers
9 subscribers
Views
3887 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Anyone knows where I can download the 'extractjsonarray' function. Can f
padmanabhanv
over 10 years ago
Anyone knows where I can download the 'extractjsonarray' function. Can find it anywhere......
OriginalPostID-136349
OriginalPostID-136349
Discussion posts and replies are publicly visible
0
praveenj
over 10 years ago
I assume you are after readjsonarray function. Search for JSON Functions in shared component.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
padmanabhanv
over 10 years ago
There is nothing like that in the shared components
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
praveenj
over 10 years ago
Hmm..you are right. I'm not sure why it was removed. Hopefully an Appian rep can shed some light on it.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 10 years ago
Version 7.7 introduced the a!fromjson() function. Use this on your json string and then you can use standard dot notation to access any array in the dictionary output.
forum.appian.com/.../System_Functions.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
padmanabhanv
over 10 years ago
We are in 7.5, so that won't help. My intent is to parse the output of a 'executeQuery' function.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
padmanabhanv
over 10 years ago
From my original post ...
[{"Name":"Test 1","ROW_ID":"4646"},{"Name":"Test 2","ROW_ID":"4648"}] is the output of a executeQuery() function. Need to display this in a grid - I am not able to parse this with the json functions. We are in 7.5, hence using queryEntity is not an option
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 10 years ago
The JSON Functions are still available through the "Request to Deploy Components to Appian Cloud Site(s)" action - if you're on the Appian cloud that might help, otherwise raise a support ticket and I'm sure someone will be able to make it available.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Cichy
Appian Employee
over 10 years ago
No need to parse since you already have a dictionary. You should be able to use index() to access the different properties, or data type constructor with todatasubset().
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
padmanabhanv
over 10 years ago
This is the output of my test rule - [{"CHOICE_ID":"17","CHOICE_CDD_TYPE":"kya"},{"CHOICE_ID":"17","CHOICE_CDD_TYPE":"kya"},{"CHOICE_ID":"17","CHOICE_CDD_TYPE":"kya"},{"CHOICE_ID":"17","CHOICE_CDD_TYPE":"kya"},{"CHOICE_ID":"17","CHOICE_CDD_TYPE":"kya"}].. I am not able to map this to a CDT. If I do a datasubset on this, the array size is 1 and the whole output is just one string. What am I missing here
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sandram548
over 10 years ago
Hi padmanabhanv, did you get a resolution for this issue as I am facing the same problem? Could you help me here if you found how?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>