(MFC) Xero Get Payroll Employees

Download Xero employees information

For more information, see https://developer.xero.com/documentation/payroll-api/employees

Chilkat C/C++ Library Downloads MS Visual C/C++ Libs

See Also: Using MFC CString in Chilkat

#include <CkHttp.h>
#include <CkJsonObject.h>
#include <CkHttpResponse.h>

void ChilkatSample(void)
    {
    CkString strOut;

    // This example requires the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    CkHttp http;

    CkJsonObject jsonToken;
    bool success = jsonToken.LoadFile("qa_data/tokens/xero-access-token.json");
    if (success == false) {
        strOut.append(jsonToken.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    http.put_AuthToken(jsonToken.stringOf("access_token"));

    // Replace the value here with an actual tenant ID obtained from this example:
    // Get Xero Tenant IDs
    http.SetRequestHeader("Xero-tenant-id","83299b9e-5747-4a14-a18a-a6c94f824eb7");

    http.put_Accept("application/json");

    CkHttpResponse *resp = http.QuickRequest("GET","https://api.xero.com/payroll.xro/1.0/Employees");
    if (http.get_LastMethodSuccess() != true) {
        strOut.append(http.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    strOut.append("Response Status Code: ");
    strOut.appendInt(resp->get_StatusCode());
    strOut.append("\r\n");

    CkJsonObject json;
    json.Load(resp->bodyStr());
    json.put_EmitCompact(false);
    strOut.append(json.emit());
    strOut.append("\r\n");

    if (resp->get_StatusCode() != 200) {
        strOut.append("Failed.");
        strOut.append("\r\n");
        delete resp;
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    delete resp;

    // 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)\/"
    //     }
    //   ]
    // }

    // Chilkat functions returning "const char *" return a pointer to temporary internal memory owned and managed by Chilkat.
    // See this example explaining how this memory should be used: const char * functions.

    const char *EmployeeID = 0;
    const char *FirstName = 0;
    const char *LastName = 0;
    const char *v_Email = 0;
    const char *DateOfBirth = 0;
    const char *Gender = 0;
    const char *Phone = 0;
    const char *Mobile = 0;
    const char *StartDate = 0;
    const char *OrdinaryEarningsRateID = 0;
    const char *PayrollCalendarID = 0;
    const char *UpdatedDateUTC = 0;

    const char *Id = json.stringOf("Id");
    const char *Status = json.stringOf("Status");
    const char *ProviderName = json.stringOf("ProviderName");
    const char *DateTimeUTC = json.stringOf("DateTimeUTC");
    int i = 0;
    int count_i = json.SizeOfArray("Employees");
    while (i < count_i) {
        json.put_I(i);
        EmployeeID = json.stringOf("Employees[i].EmployeeID");
        FirstName = json.stringOf("Employees[i].FirstName");
        LastName = json.stringOf("Employees[i].LastName");
        Status = json.stringOf("Employees[i].Status");
        v_Email = json.stringOf("Employees[i].Email");
        DateOfBirth = json.stringOf("Employees[i].DateOfBirth");
        Gender = json.stringOf("Employees[i].Gender");
        Phone = json.stringOf("Employees[i].Phone");
        Mobile = json.stringOf("Employees[i].Mobile");
        StartDate = json.stringOf("Employees[i].StartDate");
        OrdinaryEarningsRateID = json.stringOf("Employees[i].OrdinaryEarningsRateID");
        PayrollCalendarID = json.stringOf("Employees[i].PayrollCalendarID");
        UpdatedDateUTC = json.stringOf("Employees[i].UpdatedDateUTC");
        i = i + 1;
    }



    SetDlgItemText(IDC_EDIT1,strOut.getUnicode());

    }