retrieving selected fields from a user object in a web-api

Hi all,

I am currently writing a web-api that will help integrate an external system with appian.  I want to write a function that returns selected fields from all the user objects in the system.  To that end, I have started writing a web-api that contains this key code:

local!allusers: a!forEach(
items: getdistinctusers(cons!IWMS_ALL_USERS_GROUP),
expression: {
firstName: user(fv!item.username, "firstName"),
lastName: user(fv!item.username, "lastName"),
email: user(fv!item.username, "email"),
phoneNumber: user(fv!item.username, "phoneOffice")
}
)

However, this fails with the error: "Expression evaluation error [evaluation ID = 5RH87KD4] at function a!forEach [line 24]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'user' parameter 2 [line 27]: Invalid index: Cannot index property 'username' of type Text into type User"

If I code it as: 

local!allusers: a!forEach(
items: getdistinctusers(cons!IWMS_ALL_USERS_GROUP),
expression: fv!item
)

I get the json results as: [{ "id" : "LukeLiv" }, { "id" : "JamesLiv" }, { "id" : "EllaLiv" }, { "id" : "AvaFin" }, { "id" : "FredLiv" }]

What do I need to do in the expression to retrieve more fields than simply the id field in the returned json?

thanks heaps,

David

  Discussion posts and replies are publicly visible

Parents Reply Children