Hello,
Apologies i can not post the xaml as it has sensitive connection details. Basically, i am trying to get the manager first name, last name, userid and email details.
The json response from success factor is below:
Request:
https://api4preview.sapsf.com/odata/v2/User?$select=firstName,lastName,loginMethod,username,status,businessPhone,email,hireDate,teamMembersSize,country,manager/firstName, manager/lastName,manager/userId&$filter=userId eq ‘30147’&$format=JSON&$expand=manager
response:
{
“d”: {
“results”: [
{
“__metadata”: {
“uri”: “https://api4preview.sapsf.com:443/odata/v2/User(‘xxx’)”,
“type”: “SFOData.User”
},
“firstName”: “xxxx”,
“lastName”: “xxx”,
“country”: “xxxx”,
“hireDate”: “xxxxx”,
“teamMembersSize”: xx,
“loginMethod”: “xxx”,
“businessPhone”: null,
“email”: “xx@sap.com”,
“username”: “xx@xxx.com”,
“status”: “t”,
“manager”: {
“__metadata”: {
“uri”: “https://api4preview.sapsf.com:443/odata/v2/User(‘xxxx’)”,
“type”: “SFOData.User”
},
“userId”: “xxx”,
“firstName”: “xx”,
“lastName”: “xx”
}
}
]
}
}
Configuration done in Select user in Uipath to get the manager first name, last name.
Select value:{“firstName”,“lastName”,“loginMethod”,“username”,“status”,“businessPhone”,“email”,“hireDate”,“teamMembersSize”,“country”,“manager/firstName”, “manager/lastName”,“manager/userId”}
Expand: Manager
I am writing the output of above in datatable. However manager firstname, lastname and userid does not appear in separate columns. Only one column appear as manager instead 3 different columns. Similarly issue appears while retrieving email address, email type.
Secondly, while using the update activity how can i update the email id, username without nullifying other field. Currently, if i pass four fields - userid,username,emailid and status only for update using Update Record, all other fields like firstname,lastname, rid are getting updated as blank in success factor. Ideally, the update record activity should only update the fields which are getting passed in the input.
