{ "connection": "userAuth", "url": "", "httpMethod": "GET", "httpHeaders": { "Authorization": "${access_token}", "Accept": "application/json" }, "userResponsePath": "d.results", "colsToPropsMap": { "username": "userNav.username~#~char", "employeeid": "userId~#~char", "firstname": "employmentNav.personNav.personalInfoNav.results[0].firstName~#~char", "lastname": "employmentNav.personNav.personalInfoNav.results[0].lastName~#~char", "middlename": "employmentNav.personNav.personalInfoNav.results[0].middleName~#~char", "displayname": "#CONST#${String fn=response.employmentNav.personNav.personalInfoNav.results[0].firstName; String ln=response.employmentNav.personNav.personalInfoNav.results[0].lastName; return fn+\" \"+ln}~#~char", "email": "userNav.email~#~char", "statuskey": "#CONST#${String l = response.emplStatusNav.picklistLabels.results[0].label; if(l.equals('Discarded') || l.equals('Retired') || l.equals('Terminated')){return 'InActive'} else{return 'Active'}}~#~char ", "country": "companyNav.countryOfRegistrationNav.externalName_defaultValue~#~char", "startdate": "hireDate~#~epochdate", "enddate": "employmentNav.endDate~#~epochdate", "city": "locationNav.addressNavDEFLT.city~#~char", "costcenter": "costCenter~#~char", "departmentNumber": "department~#~char", "title": "jobTitle~#~char", "owner": "#CONST#${return (response.managerId!='NO_MANAGER')?('a'+response.managerId):response.managerId}~#~char", "phonenumber": "#CONST#${try{String r; String c=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='MB'}.countryCode; String a=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='MB'}.areaCode; String n=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='MB'}.phoneNumber; r=((c!=null)?c:'')+((a!=null)?a:'')+((n!=null)?n:''); return r}catch(e){return ''}}~#~char", "secondaryPhone": "#CONST#${try{String r; String c=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='B'}.countryCode; String a=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='B'}.areaCode; String n=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='B'}.phoneNumber; r=((c!=null)?c:'')+((a!=null)?a:'')+((n!=null)?n:''); return r}catch(e){return ''}}~#~char", "customproperty1": "#CONST#${String l=response.employeeClassNav.picklistLabels.results[0].label; if(l.equals('Seasonal worker') || l.equals('')){return 'Temporary'} else if(l.equals('External')){return 'Contractor'} else {return l}}~#~char", "customproperty2": "#CONST#${String ec=response.companyNav.externalCode; String n=response.companyNav.name; String ret=''; try{ret='['+ec+'] '+n;} catch(NumberFormatException e){} return ret}~#~char", "customproperty5": "managerId~#~char", "customproperty6": "location~#~char", "customproperty8": "businessUnitNav.name~#~char", "customproperty9": "divisionNav.name~#~char", "customproperty10": "departmentNav.name~#~char", "customproperty11": "customString22Nav.externalName_defaultValue~#~char", "customproperty13": "employmentNav.personNav.customString1Nav.externalCode~#~char", "customproperty14": "#CONST#${String s=\"SuccessFactor\"; return s}~#~char", "customproperty15": "userNav.defaultLocale~#~char", "customproperty16": "#CONST#${return response.userNav.teamMembersSize>0?'1':'0'}~#~char", "customproperty20": "#CONST#${return response.location.substring(0,2)}~#~char", "customproperty21": "#CONST#${try{String r; String c=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='F'}.countryCode; String a=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='F'}.areaCode; String n=response.employmentNav.personNav.phoneNav.results.find{it.phoneTypeNav.externalCode=='F'}.phoneNumber; r=((c!=null)?c:'')+((a!=null)?a:'')+((n!=null)?n:''); return r}catch(e){return ''}}~#~char", "customproperty22": "position~#~char", "customproperty23": "#CONST#${return response.positionNav.employeeClassNav.label_defaultValue}~#~char", "customproperty24": "positionNav.parentPosition.code~#~char", "customproperty25": "locationNav.addressNavDEFLT.city~#~char", "customproperty26": "locationNav.name~#~char", "customproperty27": "locationNav.addressNavDEFLT.address1~#~char", "customproperty28": "locationNav.addressNavDEFLT.address2~#~char", "customproperty29": "locationNav.addressNavDEFLT.city~#~char", "customproperty30": "locationNav.addressNavDEFLT.zipCode~#~char", "customproperty31": "employmentNav.personNav.personalInfoNav.results[0].suffixNav.localeLabel~#~char", "customproperty32": "employmentNav.personNav.personalInfoNav.results[0].salutationNav.localeLabel~#~char", "customproperty33": "businessUnit~#~char", "customproperty34": "division~#~char", "customproperty35": "employmentNav.personNav.personalInfoNav.results[0].customString7Nav.picklistLabels.results[0].label~#~char", "customproperty36": "companyNav.countryOfRegistrationNav.numericCountryCode~#~char", "customproperty37": "customString22Nav.externalCode~#~char", "customproperty38": "customString50Nav.externalCode~#~char", "customproperty39": "customString50Nav.externalName~#~char", "customproperty40": "emplStatusNav.picklistLabels.results[0].label~#~char", "customproperty41": "#CONST#${String l=response.emplStatusNav.picklistLabels.results[0].label; if(l.equals('Discarded')){return 'Contract Terminated'} else if(l.equals('Unpaid Leave')){return 'Maternity'} else if(l.equals('Retired')){return 'Retired'} else if(l.equals('Suspended')){return 'Active'} else if(l.equals('Dormant')){return 'Temporarily Inactive'} else if(l.equals('Furlough')){return 'Leave of Absence'} else if(l.equals('Paid Leave')){return 'Maternity'}else if(l.equals('Terminated')){return 'Left Company'} else if(l.equals('Not in use')){return 'Paternity'} else if(l.equals('Active')){return 'Active'} else {return ''}}~#~char" }, "pagination": { "nextUrl": { "nextUrlPath": "${response?.completeResponseMap.d.__next==null?null:response?.completeResponseMap.d.__next}" } } }