Lua Requires Chilkat v11.0.0+
Lua
Xero Get Payroll Employees
See more Xero Examples
Download Xero employees informationChilkat Lua Downloads
local chilkat = require("chilkat")
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
local http = chilkat.Http.new()
local jsonToken = chilkat.JsonObject.new()
local success = jsonToken:load_file("qa_data/tokens/xero-access-token.json")
if not success then
print(jsonToken.last_error_text)
return
end
http.auth_token = jsonToken:string_of("access_token")
-- Replace the value here with an actual tenant ID obtained from this example:
-- Get Xero Tenant IDs
http:set_request_header("Xero-tenant-id", "83299b9e-5747-4a14-a18a-a6c94f824eb7")
http.accept = "application/json"
local resp = chilkat.HttpResponse.new()
success = http:http_no_body("GET", "https://api.xero.com/payroll.xro/1.0/Employees", resp)
if not success then
print(http.last_error_text)
return
end
print("Response Status Code: " .. resp.status_code)
local json = chilkat.JsonObject.new()
json:load(resp.body_str)
json.emit_compact = false
print(json:emit())
if resp.status_code ~= 200 then
print("Failed.")
return
end
-- Sample response
-- (See the parsing code below..)
--
-- Use the this online tool to generate parsing code from sample JSON:
-- Generate Parsing Code from JSON
-- {
-- "Id": "796cae61-a7c3-425b-a621-372ab1f29460",
-- "Status": "OK",
-- "ProviderName": "Chilkat2222",
-- "DateTimeUTC": "\/Date(1587075322768)\/",
-- "Employees": [
-- {
-- "EmployeeID": "f12e3b0b-4b4c-4523-b8c0-f481a07bfd13",
-- "FirstName": "James",
-- "LastName": "Lebron",
-- "Status": "ACTIVE",
-- "Email": "JL@madeup.email.com",
-- "DateOfBirth": "\/Date(492739200000+0000)\/",
-- "Gender": "M",
-- "Phone": "0400-000-123",
-- "Mobile": " 408-230-9732",
-- "StartDate": "\/Date(1548806400000+0000)\/",
-- "OrdinaryEarningsRateID": "e648f7bf-af43-41bc-98ea-e7ca94c3e3b1",
-- "PayrollCalendarID": "2cf6326a-d48b-41bf-bf36-7a73b42dd71b",
-- "UpdatedDateUTC": "\/Date(1587075120000+0000)\/"
-- },
-- {
-- "EmployeeID": "d9f5979f-1de8-4040-aa1d-f1fdd327f893",
-- "FirstName": "Odette",
-- "LastName": "Garrison",
-- "Status": "ACTIVE",
-- "Email": "ogg@madeup.email.com",
-- "DateOfBirth": "\/Date(390528000000+0000)\/",
-- "Gender": "F",
-- "Phone": "9000 1234",
-- "StartDate": "\/Date(1554422400000+0000)\/",
-- "OrdinaryEarningsRateID": "e648f7bf-af43-41bc-98ea-e7ca94c3e3b1",
-- "PayrollCalendarID": "ec0f2f68-f4d1-4490-af70-78e5d7f5dcbd",
-- "UpdatedDateUTC": "\/Date(1587075120000+0000)\/"
-- },
-- {
-- "EmployeeID": "22879fb4-d13b-46ed-9c07-e43aba25b576",
-- "FirstName": "Oliver",
-- "LastName": "Gray",
-- "Status": "ACTIVE",
-- "Email": "og@madeup.email.com",
-- "DateOfBirth": "\/Date(94176000000+0000)\/",
-- "Gender": "M",
-- "Phone": "0401 123 456",
-- "StartDate": "\/Date(1562112000000+0000)\/",
-- "OrdinaryEarningsRateID": "e648f7bf-af43-41bc-98ea-e7ca94c3e3b1",
-- "PayrollCalendarID": "2cf6326a-d48b-41bf-bf36-7a73b42dd71b",
-- "UpdatedDateUTC": "\/Date(1587075120000+0000)\/"
-- },
-- {
-- "EmployeeID": "c4d82c18-b1a9-4b6c-982c-14b45b95c10a",
-- "FirstName": "Sally ",
-- "LastName": "Martin",
-- "Status": "ACTIVE",
-- "Email": "sm@madeup3993.com",
-- "DateOfBirth": "\/Date(659577600000+0000)\/",
-- "Gender": "F",
-- "Phone": "0400 123 456",
-- "StartDate": "\/Date(1577750400000+0000)\/",
-- "OrdinaryEarningsRateID": "e648f7bf-af43-41bc-98ea-e7ca94c3e3b1",
-- "PayrollCalendarID": "2cf6326a-d48b-41bf-bf36-7a73b42dd71b",
-- "UpdatedDateUTC": "\/Date(1587075120000+0000)\/"
-- },
-- {
-- "EmployeeID": "e1a5eed0-721e-482d-b1f1-0b73506f26fb",
-- "FirstName": "Sonia",
-- "LastName": "Michaels",
-- "Status": "ACTIVE",
-- "Email": "som@madeup3993.com",
-- "DateOfBirth": "\/Date(727660800000+0000)\/",
-- "Gender": "F",
-- "Phone": "02 2345 6789",
-- "Mobile": " ",
-- "UpdatedDateUTC": "\/Date(1587075120000+0000)\/"
-- },
-- {
-- "EmployeeID": "882587ac-1cfe-4f55-9b37-932b0705cd04",
-- "FirstName": "Tracy",
-- "LastName": "Green",
-- "Status": "ACTIVE",
-- "Email": "tg@madeup.email.com",
-- "DateOfBirth": "\/Date(712886400000+0000)\/",
-- "Gender": "F",
-- "Phone": "0402 123 456",
-- "StartDate": "\/Date(1556755200000+0000)\/",
-- "OrdinaryEarningsRateID": "e648f7bf-af43-41bc-98ea-e7ca94c3e3b1",
-- "PayrollCalendarID": "ec0f2f68-f4d1-4490-af70-78e5d7f5dcbd",
-- "UpdatedDateUTC": "\/Date(1587075120000+0000)\/"
-- }
-- ]
-- }
local EmployeeID = ""
local FirstName = ""
local LastName = ""
local v_Email = ""
local DateOfBirth = ""
local Gender = ""
local Phone = ""
local Mobile = ""
local StartDate = ""
local OrdinaryEarningsRateID = ""
local PayrollCalendarID = ""
local UpdatedDateUTC = ""
local Id = json:string_of("Id")
local Status = json:string_of("Status")
local ProviderName = json:string_of("ProviderName")
local DateTimeUTC = json:string_of("DateTimeUTC")
local i = 0
local count_i = json:size_of_array("Employees")
while i < count_i do
json.i = i
EmployeeID = json:string_of("Employees[i].EmployeeID")
FirstName = json:string_of("Employees[i].FirstName")
LastName = json:string_of("Employees[i].LastName")
Status = json:string_of("Employees[i].Status")
v_Email = json:string_of("Employees[i].Email")
DateOfBirth = json:string_of("Employees[i].DateOfBirth")
Gender = json:string_of("Employees[i].Gender")
Phone = json:string_of("Employees[i].Phone")
Mobile = json:string_of("Employees[i].Mobile")
StartDate = json:string_of("Employees[i].StartDate")
OrdinaryEarningsRateID = json:string_of("Employees[i].OrdinaryEarningsRateID")
PayrollCalendarID = json:string_of("Employees[i].PayrollCalendarID")
UpdatedDateUTC = json:string_of("Employees[i].UpdatedDateUTC")
i = i + 1
end