{ "connection": "userAuth", "url": "https://XXXXXXXXX/odata/v2/User?$expand=manager,empInfo/jobInfoNav&$select=empId,userId,status,city,location,jobTitle,businessPhone,department,addressLine1,defaultFullName,custom01,custom04,custom09,email,firstName,lastName,custom05,custom03,hireDate,companyExitDate,empInfo/jobInfoNav/countryOfCompany,manager/empId,empInfo/jobInfoNav/company&$filter=status+in+'f','t','T','F'&$format=json", "httpMethod": "GET", "httpHeaders": { "Authorization": "${access_token}", "Accept": "application/json" }, "statusConfig":{ "active":"t", "inactive":"f" }, "userResponsePath": "d.results", "colsToPropsMap": { "username":"empId~#~char", "statuskey":"status~#~char", "city":"city~#~char", "location":"location~#~char", "title":"jobTitle~#~char", "phonenumber":"businessPhone~#~char", "departmentname":"department~#~char", "street":"addressLine1~#~char", "displayname":"defaultFullName~#~char", "customproperty25":"custom01~#~char", "customproperty26":"custom04~#~char", "employeeid":"empId~#~char", "customproperty20":"userId~#~char", "firstname":"firstName~#~char", "lastname":"lastName~#~char", "CompanyName":"custom05~#~", "JobDescription":"custom03~#~", "employeeType":"custom09~#~", "startdate":"hireDate~#~char", "enddate" : "companyExitDate~#~char", "country":"empInfo.jobInfoNav.results[0].countryOfCompany~#~char", "customproperty24":"empInfo.jobInfoNav.results[0].company~#~char", "manager":"manager.empId~#~char", "customproperty30":"#CONST#SAPSF~#~char" }, "pagination": { "nextUrl": { "nextUrlPath": "${response?.completeResponseMap?.d?.__next == null ?null : response?.completeResponseMap?.d?.__next}" } } }