Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Unicode C) QuickBooks - Query EmployeesDemonstrates how to query the QuickBooks employee data. For more information, see https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/employee#query-an-employee
#include <C_CkJsonObjectW.h> #include <C_CkRestW.h> #include <C_CkStringBuilderW.h> #include <C_CkDateTimeW.h> #include <C_CkDtObjW.h> #include <C_CkStringTableW.h> void ChilkatSample(void) { HCkJsonObjectW jsonToken; BOOL success; HCkRestW rest; BOOL bAutoReconnect; HCkStringBuilderW sbAuth; const wchar_t *query; const wchar_t *responseBody; HCkJsonObjectW json; HCkDateTimeW dtime; BOOL bLocalTime; HCkDtObjW dt; int numRecords; int i; HCkStringTableW sTab; const wchar_t *year; const wchar_t *month; const wchar_t *day; // This example assumes the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. // Get our previously obtained OAuth2 access token, which should contain JSON like this: // { // "expires_in": 3600, // "x_refresh_token_expires_in": 8726400, // "refresh_token": "L011546037639r ... 3vR2DrbOmg0Sdagw", // "access_token": "eyJlbmMiOiJBMTI4Q0 ... oETJEMbeggg", // "token_type": "bearer" // } jsonToken = CkJsonObjectW_Create(); success = CkJsonObjectW_LoadFile(jsonToken,L"qa_data/tokens/qb-access-token.json"); rest = CkRestW_Create(); // Connect using TLS. // A single REST object, once connected, can be used for many Quickbooks REST API calls. // The auto-reconnect indicates that if the already-established HTTPS connection is closed, // then it will be automatically re-established as needed. bAutoReconnect = TRUE; success = CkRestW_Connect(rest,L"sandbox-quickbooks.api.intuit.com",443,TRUE,bAutoReconnect); if (success != TRUE) { wprintf(L"%s\n",CkRestW_lastErrorText(rest)); CkJsonObjectW_Dispose(jsonToken); CkRestW_Dispose(rest); return; } sbAuth = CkStringBuilderW_Create(); CkStringBuilderW_Append(sbAuth,L"Bearer "); CkStringBuilderW_Append(sbAuth,CkJsonObjectW_stringOf(jsonToken,L"access_token")); CkRestW_putAuthorization(rest,CkStringBuilderW_getAsString(sbAuth)); CkRestW_AddHeader(rest,L"Accept",L"application/json"); CkRestW_putAllowHeaderFolding(rest,FALSE); query = L"select * from Employee"; CkRestW_AddQueryParam(rest,L"query",query); CkRestW_AddQueryParam(rest,L"minorversion",L"45"); // The company ID is 123146096291789 responseBody = CkRestW_fullRequestNoBody(rest,L"GET",L"/v3/company/123146096291789/query"); if (CkRestW_getLastMethodSuccess(rest) != TRUE) { wprintf(L"%s\n",CkRestW_lastErrorText(rest)); CkJsonObjectW_Dispose(jsonToken); CkRestW_Dispose(rest); CkStringBuilderW_Dispose(sbAuth); return; } // We should expect a 200 response if successful. if (CkRestW_getResponseStatusCode(rest) != 200) { wprintf(L"Request Header: \n"); wprintf(L"%s\n",CkRestW_lastRequestHeader(rest)); wprintf(L"----\n"); wprintf(L"Response StatusCode = %d\n",CkRestW_getResponseStatusCode(rest)); wprintf(L"Response StatusLine: %s\n",CkRestW_responseStatusText(rest)); wprintf(L"Response Header:\n"); wprintf(L"%s\n",CkRestW_responseHeader(rest)); wprintf(L"%s\n",responseBody); CkJsonObjectW_Dispose(jsonToken); CkRestW_Dispose(rest); CkStringBuilderW_Dispose(sbAuth); return; } // Load the JSON response into a JSON object for parsing. // A sample JSON response is shown below. json = CkJsonObjectW_Create(); CkJsonObjectW_Load(json,responseBody); // Show the full JSON response. CkJsonObjectW_putEmitCompact(json,FALSE); wprintf(L"%s\n",CkJsonObjectW_emit(json)); // Use this online tool to generate parsing code from sample JSON: // Generate Parsing Code from JSON // These will be used for parsing date/time strings.. dtime = CkDateTimeW_Create(); bLocalTime = TRUE; // Iterate over each account returned. numRecords = CkJsonObjectW_SizeOfArray(json,L"QueryResponse.Employee"); i = 0; while (i < numRecords) { CkJsonObjectW_putI(json,i); wprintf(L"DisplayName: %s\n",CkJsonObjectW_stringOf(json,L"QueryResponse.Employee[i].DisplayName")); wprintf(L"Id: %s\n",CkJsonObjectW_stringOf(json,L"QueryResponse.Employee[i].Id")); wprintf(L"Active: %d\n",CkJsonObjectW_BoolOf(json,L"QueryResponse.Employee[i].Active")); // Load the CreateTime into a CkDateTime... CkDateTimeW_SetFromTimestamp(dtime,CkJsonObjectW_stringOf(json,L"QueryResponse.Employee[i].MetaData.CreateTime")); dt = CkDateTimeW_GetDtObj(dtime,bLocalTime); wprintf(L"%d/%d/%d %d:%d\n",CkDtObjW_getMonth(dt),CkDtObjW_getDay(dt),CkDtObjW_getYear(dt),CkDtObjW_getHour(dt),CkDtObjW_getMinute(dt)); CkDtObjW_Dispose(dt); // The the birth year, month, and day, if it exists. // The BirthDate contains something like this: "1985-09-11" if (CkJsonObjectW_HasMember(json,L"QueryResponse.Employee[i].BirthDate") == TRUE) { sTab = CkStringTableW_Create(); CkStringTableW_SplitAndAppend(sTab,CkJsonObjectW_stringOf(json,L"QueryResponse.Employee[i].BirthDate"),L"-",TRUE,TRUE); year = CkStringTableW_stringAt(sTab,0); month = CkStringTableW_stringAt(sTab,1); day = CkStringTableW_stringAt(sTab,2); wprintf(L"BirthDate: %s/%s/%s\n",month,day,year); } wprintf(L"----\n"); i = i + 1; } wprintf(L"Success.\n"); // ------------------------------------------------------ // The JSON response looks like this: // { // "QueryResponse": { // "Employee": [ // { // "BillableTime": false, // "domain": "QBO", // "sparse": false, // "Id": "55", // "SyncToken": "0", // "MetaData": { // "CreateTime": "2016-09-15T11:21:48-07:00", // "LastUpdatedTime": "2016-09-15T11:21:48-07:00" // }, // "GivenName": "Emily", // "FamilyName": "Platt", // "DisplayName": "Emily Platt", // "PrintOnCheckName": "Emily Platt", // "Active": true // }, // { // "BillableTime": false, // "BirthDate": "1985-09-11", // "HiredDate": "2016-08-17", // "domain": "QBO", // "sparse": false, // "Id": "54", // "SyncToken": "1", // "MetaData": { // "CreateTime": "2016-09-15T11:21:28-07:00", // "LastUpdatedTime": "2016-09-15T11:46:26-07:00" // }, // "GivenName": "John", // "FamilyName": "Johnson", // "DisplayName": "John Johnson", // "PrintOnCheckName": "John Johnson", // "Active": true, // "PrimaryPhone": { // "FreeFormNumber": "(540) 555-9645" // } // }, // { // "SSN": "XXX-XX-XXXX", // "PrimaryAddr": { // "Id": "98", // "Line1": "45 N. Elm Street", // "City": "Middlefield", // "CountrySubDivisionCode": "CA", // "PostalCode": "93242" // }, // "BillableTime": false, // "domain": "QBO", // "sparse": false, // "Id": "60", // "SyncToken": "0", // "MetaData": { // "CreateTime": "2016-10-25T14:08:18-07:00", // "LastUpdatedTime": "2016-10-25T14:08:18-07:00" // }, // "GivenName": "John", // "FamilyName": "Meuller", // "DisplayName": "John Meuller", // "PrintOnCheckName": "John Meuller", // "Active": true, // "PrimaryPhone": { // "FreeFormNumber": "408-525-1234" // } // } // ], // "startPosition": 1, // "maxResults": 3 // }, // "time": "2016-10-25T14:18:38.487-07:00" // CkJsonObjectW_Dispose(jsonToken); CkRestW_Dispose(rest); CkStringBuilderW_Dispose(sbAuth); CkJsonObjectW_Dispose(json); CkDateTimeW_Dispose(dtime); CkStringTableW_Dispose(sTab); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.