select FaceId,FingerPrint from UsersFP where EmployeeCodeInDevice='19' and DeviceId in (6,7,8,9,10,11,12,13,14,15,16,17,18) and BIoType='Face'Bigbasket API to update/insert Employee Details
\nBelow is the mapping between Payload and SmartOffice API
\nthis api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"http","port":"86","path":["","api","WebAPI","UpdateUser_BB"],"host":["207","148","121","63"],"query":[{"description":{"content":"This is the unique api key to authorize the user
\n","type":"text/plain"},"key":"APIKey","value":"572818042423"},{"description":{"content":"This is Employee Code
\n","type":"text/plain"},"key":"EmployeeCode","value":"333448"},{"description":{"content":"This is Employee Name
\n","type":"text/plain"},"key":"EmployeeName","value":"jain ajay"},{"description":{"content":"This is the company
\n","type":"text/plain"},"key":"Region","value":"BANGALORE-REGION"},{"description":{"content":"EBranch
\n","type":"text/plain"},"key":"Ebranch","value":"GURGAON-DC"},{"description":{"content":"Eunit
\n","type":"text/plain"},"key":"Eunit","value":"CHANDU"},{"description":{"content":"Designation
\n","type":"text/plain"},"key":"Designation","value":"CUT VEG - SUPERVISOR"},{"description":{"content":"Employment Type
\n","type":"text/plain"},"key":"EmployementType","value":"Offroll"},{"description":{"content":"Department
\n","type":"text/plain"},"key":"Department","value":"Software"},{"description":{"content":"Date of joining, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOJ","value":"2020-01-01"},{"description":{"content":"Date of Birth, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOB","value":"1987-01-01"},{"description":{"content":"Gender possible values are Male, Female
\n","type":"text/plain"},"key":"Gender","value":"Male"},{"key":"BloodGroup","value":""},{"description":{"content":"Optional(possible value Rented House,Own House,PG)
\n","type":"text/plain"},"key":"AccomodationType","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"StayingWith","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Relation","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Relation","value":""}],"variable":[]}},"response":[],"_postman_id":"35e4fa0f-514c-4471-abf0-1eb1c5b47e76"},{"name":"Update User V2","id":"22b43369-4d25-48cf-9981-96e8991e5229","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"APIKey\": \"572818042423\",\r\n \"EmployeeCode\": \"1114478\",\r\n \"EmployeeName\": \"jain ajay\",\r\n \"Region\": \"BANGALORE-REGION\",\r\n \"Ebranch\": \"GURGAON-DC\",\r\n \"Eunit\": \"CHANDU\",\r\n \"Designation\": \"CUT VEG - SUPERVISOR\",\r\n \"EmployementType\": \"Offroll\",\r\n \"Department\": \"Software\",\r\n \"DOJ\": \"2020-01-01\",\r\n \"DOB\": \"1987-01-01\",\r\n \"Gender\": \"Male\",\r\n \"BloodGroup\": \"\",\r\n \"AccomodationType\": \"\",\r\n \"StayingWith\": \"\",\r\n \"EmergencyContact1Name\": \"\",\r\n \"EmergencyContact1Number\": \"\",\r\n \"EmergencyContact1Relation\": \"\",\r\n \"EmergencyContact2Name\": \"\",\r\n \"EmergencyContact2Number\": \"\",\r\n \"EmergencyContact2Relation\": \"\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://207.148.121.63:86//api/WebAPI/UpdateUser_BB","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"http","port":"86","path":["","api","WebAPI","UpdateUser_BB"],"host":["207","148","121","63"],"query":[],"variable":[]}},"response":[],"_postman_id":"22b43369-4d25-48cf-9981-96e8991e5229"},{"name":"Update User Sgspl","id":"77ad4d01-905d-48df-8049-6e72b27aa311","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"url":"http://so365.in/sgspl//api/WebAPI/UpdateUser_BB?APIKey=084610092116&EmployeeCode=1114478&EmployeeName=jain ajay&Region=ffff&Ebranch=GURGAON-DC&Eunit=CHANDU&Designation=CUT VEG - SUPERVISOR&EmployementType=Offroll&Department=Software&DOJ=2020-01-01&DOB=1987-01-01&Gender=Male&BloodGroup=&AccomodationType=&StayingWith=&EmergencyContact1Name=&EmergencyContact1Number=&EmergencyContact1Relation=&EmergencyContact2Name=&EmergencyContact2Number=&EmergencyContact2Relation=","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"http","path":["sgspl","","api","WebAPI","UpdateUser_BB"],"host":["so365","in"],"query":[{"description":{"content":"This is the unique api key to authorize the user
\n","type":"text/plain"},"key":"APIKey","value":"084610092116"},{"description":{"content":"This is Employee Code
\n","type":"text/plain"},"key":"EmployeeCode","value":"1114478"},{"description":{"content":"This is Employee Name
\n","type":"text/plain"},"key":"EmployeeName","value":"jain ajay"},{"description":{"content":"This is the company
\n","type":"text/plain"},"key":"Region","value":"ffff"},{"description":{"content":"EBranch
\n","type":"text/plain"},"key":"Ebranch","value":"GURGAON-DC"},{"description":{"content":"Eunit
\n","type":"text/plain"},"key":"Eunit","value":"CHANDU"},{"description":{"content":"Designation
\n","type":"text/plain"},"key":"Designation","value":"CUT VEG - SUPERVISOR"},{"description":{"content":"Employment Type
\n","type":"text/plain"},"key":"EmployementType","value":"Offroll"},{"description":{"content":"Department
\n","type":"text/plain"},"key":"Department","value":"Software"},{"description":{"content":"Date of joining, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOJ","value":"2020-01-01"},{"description":{"content":"Date of Birth, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOB","value":"1987-01-01"},{"description":{"content":"Gender possible values are Male, Female
\n","type":"text/plain"},"key":"Gender","value":"Male"},{"key":"BloodGroup","value":""},{"description":{"content":"Optional(possible value Rented House,Own House,PG)
\n","type":"text/plain"},"key":"AccomodationType","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"StayingWith","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Relation","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Relation","value":""}],"variable":[]}},"response":[],"_postman_id":"77ad4d01-905d-48df-8049-6e72b27aa311"},{"name":"Update User Sgspl V2","id":"cb140f5f-62fc-4d49-8c4a-5a486c787d90","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"APIKey\": \"084610092116\",\r\n \"EmployeeCode\": \"1114478\",\r\n \"EmployeeName\": \"jain ajay\",\r\n \"Region\": \"BANGALORE-REGION\",\r\n \"Ebranch\": \"GURGAON-DC\",\r\n \"Eunit\": \"CHANDU\",\r\n \"Designation\": \"CUT VEG - SUPERVISOR\",\r\n \"EmployementType\": \"Offroll\",\r\n \"Department\": \"WAREHOUSE\",\r\n \"DOJ\": \"2020-01-01\",\r\n \"DOB\": \"1987-01-01\",\r\n \"Gender\": \"Male\",\r\n \"BloodGroup\": \"\",\r\n \"AccomodationType\": \"\",\r\n \"StayingWith\": \"\",\r\n \"EmergencyContact1Name\": \"\",\r\n \"EmergencyContact1Number\": \"\",\r\n \"EmergencyContact1Relation\": \"\",\r\n \"EmergencyContact2Name\": \"\",\r\n \"EmergencyContact2Number\": \"\",\r\n \"EmergencyContact2Relation\": \"\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://so365.in/sgspl//api/WebAPI/UpdateUser_BB","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"http","path":["sgspl","","api","WebAPI","UpdateUser_BB"],"host":["so365","in"],"query":[],"variable":[]}},"response":[],"_postman_id":"cb140f5f-62fc-4d49-8c4a-5a486c787d90"},{"name":"Update User ircpl","id":"91ad67ea-92dd-4777-b1cd-1ee69e02e6cb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"url":"https://so365.in/ircpl//api/WebAPI/UpdateUser_BB?APIKey=514610092116&EmployeeCode=1114478&EmployeeName=jain ajay&Region=&Ebranch=GURGAON-DC&Eunit=CHANDU&Designation=CUT VEG - SUPERVISOR&EmployementType=Offroll&Department=Software&DOJ=2020-01-01&DOB=1987-01-01&Gender=Male&BloodGroup=&AccomodationType=&StayingWith=&EmergencyContact1Name=&EmergencyContact1Number=&EmergencyContact1Relation=&EmergencyContact2Name=&EmergencyContact2Number=&EmergencyContact2Relation=","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"https","path":["ircpl","","api","WebAPI","UpdateUser_BB"],"host":["so365","in"],"query":[{"description":{"content":"This is the unique api key to authorize the user
\n","type":"text/plain"},"key":"APIKey","value":"514610092116"},{"description":{"content":"This is Employee Code
\n","type":"text/plain"},"key":"EmployeeCode","value":"1114478"},{"description":{"content":"This is Employee Name
\n","type":"text/plain"},"key":"EmployeeName","value":"jain ajay"},{"description":{"content":"This is the company
\n","type":"text/plain"},"key":"Region","value":""},{"description":{"content":"EBranch
\n","type":"text/plain"},"key":"Ebranch","value":"GURGAON-DC"},{"description":{"content":"Eunit
\n","type":"text/plain"},"key":"Eunit","value":"CHANDU"},{"description":{"content":"Designation
\n","type":"text/plain"},"key":"Designation","value":"CUT VEG - SUPERVISOR"},{"description":{"content":"Employment Type
\n","type":"text/plain"},"key":"EmployementType","value":"Offroll"},{"description":{"content":"Department
\n","type":"text/plain"},"key":"Department","value":"Software"},{"description":{"content":"Date of joining, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOJ","value":"2020-01-01"},{"description":{"content":"Date of Birth, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOB","value":"1987-01-01"},{"description":{"content":"Gender possible values are Male, Female
\n","type":"text/plain"},"key":"Gender","value":"Male"},{"key":"BloodGroup","value":""},{"description":{"content":"Optional(possible value Rented House,Own House,PG)
\n","type":"text/plain"},"key":"AccomodationType","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"StayingWith","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Relation","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Relation","value":""}],"variable":[]}},"response":[],"_postman_id":"91ad67ea-92dd-4777-b1cd-1ee69e02e6cb"},{"name":"Update User ircpl V2","id":"e5a55448-7a3a-47da-b0b1-6523c602c8f1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"APIKey\": \"514610092116\",\r\n \"EmployeeCode\": \"1114478\",\r\n \"EmployeeName\": \"jain ajay\",\r\n \"Region\": \"BANGALORE-REGION\",\r\n \"Ebranch\": \"GURGAON-DC\",\r\n \"Eunit\": \"CHANDU\",\r\n \"Designation\": \"CUT VEG - SUPERVISOR\",\r\n \"EmployementType\": \"Offroll\",\r\n \"Department\": \"WAREHOUSE\",\r\n \"DOJ\": \"2020-01-01\",\r\n \"DOB\": \"1987-01-01\",\r\n \"Gender\": \"Male\",\r\n \"BloodGroup\": \"\",\r\n \"AccomodationType\": \"\",\r\n \"StayingWith\": \"\",\r\n \"EmergencyContact1Name\": \"\",\r\n \"EmergencyContact1Number\": \"\",\r\n \"EmergencyContact1Relation\": \"\",\r\n \"EmergencyContact2Name\": \"\",\r\n \"EmergencyContact2Number\": \"\",\r\n \"EmergencyContact2Relation\": \"\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://so365.in/ircpl//api/WebAPI/UpdateUser_BB","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"https","path":["ircpl","","api","WebAPI","UpdateUser_BB"],"host":["so365","in"],"query":[],"variable":[]}},"response":[],"_postman_id":"e5a55448-7a3a-47da-b0b1-6523c602c8f1"},{"name":"Update User Localhost","id":"f0e73bca-d878-462b-952c-94afc2106ffd","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"url":"http://localhost:92/api/WebAPI/UpdateUser_BB?APIKey=520216082402&EmployeeCode=1114478&EmployeeName=jain ajay&Region=BANGALORE-REGION&Ebranch=GURGAON-DC&Eunit=CHANDU&Designation=CUT VEG - SUPERVISOR&EmployementType=Offroll&Department=Software&DOJ=2020-01-01&DOB=1987-01-01&Gender=Male&BloodGroup=&AccomodationType=&StayingWith=&EmergencyContact1Name=&EmergencyContact1Number=&EmergencyContact1Relation=&EmergencyContact2Name=&EmergencyContact2Number=&EmergencyContact2Relation=","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"http","port":"92","path":["","api","WebAPI","UpdateUser_BB"],"host":["localhost"],"query":[{"description":{"content":"This is the unique api key to authorize the user
\n","type":"text/plain"},"key":"APIKey","value":"520216082402"},{"description":{"content":"This is Employee Code
\n","type":"text/plain"},"key":"EmployeeCode","value":"1114478"},{"description":{"content":"This is Employee Name
\n","type":"text/plain"},"key":"EmployeeName","value":"jain ajay"},{"description":{"content":"This is the company
\n","type":"text/plain"},"key":"Region","value":"BANGALORE-REGION"},{"description":{"content":"EBranch
\n","type":"text/plain"},"key":"Ebranch","value":"GURGAON-DC"},{"description":{"content":"Eunit
\n","type":"text/plain"},"key":"Eunit","value":"CHANDU"},{"description":{"content":"Designation
\n","type":"text/plain"},"key":"Designation","value":"CUT VEG - SUPERVISOR"},{"description":{"content":"Employment Type
\n","type":"text/plain"},"key":"EmployementType","value":"Offroll"},{"description":{"content":"Department
\n","type":"text/plain"},"key":"Department","value":"Software"},{"description":{"content":"Date of joining, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOJ","value":"2020-01-01"},{"description":{"content":"Date of Birth, should be in yyyy-MM-dd format
\n","type":"text/plain"},"key":"DOB","value":"1987-01-01"},{"description":{"content":"Gender possible values are Male, Female
\n","type":"text/plain"},"key":"Gender","value":"Male"},{"key":"BloodGroup","value":""},{"description":{"content":"Optional(possible value Rented House,Own House,PG)
\n","type":"text/plain"},"key":"AccomodationType","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"StayingWith","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact1Relation","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Name","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Number","value":""},{"description":{"content":"Optional
\n","type":"text/plain"},"key":"EmergencyContact2Relation","value":""}],"variable":[]}},"response":[],"_postman_id":"f0e73bca-d878-462b-952c-94afc2106ffd"},{"name":"Update User Localhost V2","id":"8c0f608b-56ac-4cff-97c8-0058425f9177","protocolProfileBehavior":{"disableBodyPruning":true,"disabledSystemHeaders":{}},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"APIKey\": \"5202160824021\",\r\n \"EmployeeCode\": \"1114478\",\r\n \"EmployeeName\": \"jain ajay\",\r\n \"Region\": \"BANGALORE-REGION\",\r\n \"Ebranch\": \"GURGAON-DC\",\r\n \"Eunit\": \"CHANDU\",\r\n \"Designation\": \"CUT VEG - SUPERVISOR\",\r\n \"EmployementType\": \"Offroll\",\r\n \"Department\": \"Software\",\r\n \"DOJ\": \"2020-01-01\",\r\n \"DOB\": \"1987-01-01\",\r\n \"Gender\": \"Male\",\r\n \"BloodGroup\": \"\",\r\n \"AccomodationType\": \"\",\r\n \"StayingWith\": \"\",\r\n \"EmergencyContact1Name\": \"\",\r\n \"EmergencyContact1Number\": \"\",\r\n \"EmergencyContact1Relation\": \"\",\r\n \"EmergencyContact2Name\": \"\",\r\n \"EmergencyContact2Number\": \"\",\r\n \"EmergencyContact2Relation\": \"\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:92//api/WebAPI/UpdateUser_BB","description":"this api is ued for update the Employee profile details or create a new employee profile
\n","urlObject":{"protocol":"http","port":"92","path":["","api","WebAPI","UpdateUser_BB"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"8c0f608b-56ac-4cff-97c8-0058425f9177"}],"event":[{"listen":"prerequest","script":{"id":"c5dd434f-7230-4dc3-9c5d-f63892f698b2","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"d70aff72-bc02-417c-935d-83fbd5a76a31","type":"text/javascript","exec":[""]}}]}