Error while invoking rest API

varshaw over 8 years ago

Hi,

We are calling rest API in one rule which returns JSON response as {"message":,"isSuccess":,"data":{"employee":[{},{},{}]}
we want to display employee data on SAIL form in gridfield, but employee is list of variant , which we are unable to display in grid with paginginfo as we can not pass it to todatasubset().Passing this employee list to todatasubset gives
error like given value is not of type complex.

Any pointer to display this list of variant to grid with paging.

Discussion posts and replies are publicly visible

0 mohammedz
A Score Level 2
over 8 years ago

Create a expression rule inside which

emplyee:ri!employee

and make it in a apply and store the results in a local variable. Now you can put this local variable into todatasubset(local!variable,local!pagingInfo)

By doing so we can get employee data in local!datasubse
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohammedz
A Score Level 2
over 8 years ago

By doing so we can get employee data in local!datasubset.data will holds value of employee
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 varshaw over 8 years ago

Thanks Mohammed, I will try this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JANARDHNA KETHA over 8 years ago

I hope you need to use a!fromJson(xxx.data) to map the json response to Appian complex data type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sonalk over 8 years ago

Hi Varsha,
Added to the comment above, store the response in a local variable say local!response and then convert the data into the complex data type, you can use the code mentioned below :-
cast(
'type!{urn:com:appian:xxxx}CDT_Name?list',
a!fromJson(
local!response.result.body
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 varshaw over 8 years ago

I don't want to use custom data type here and I am using a!fromJson() to convert JSON to Appian type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 varshaw over 8 years ago

Issue is resolved...

We have used a!fromJson(jsonText:readJson(json:readjson(json: httpquery().result.body,key:"data"),key:"employee"))

now we can pass output of this rule directly to dataSubset() and display data in grid
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel