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) GeoOp - Export Clients to CSVExport client data to a CSV.
#include <C_CkJsonObjectW.h> #include <C_CkOAuth2W.h> #include <C_CkRestW.h> #include <C_CkCsvW.h> void ChilkatSample(void) { HCkJsonObjectW jsonToken; BOOL success; HCkOAuth2W oauth2; HCkRestW rest; BOOL bAutoReconnect; const wchar_t *responseBody; HCkJsonObjectW json; HCkCsvW csv; int numRecords; int i; // This example assumes the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. // This example also assumes an OAuth2 access token was previously fetched. // and saved in a JSON file. // First get our previously obtained access token. // {"access_token":"e6dqdG....mzjpT04w==","token_type":"Bearer","expires_in":2592000,"owner_id":999236} jsonToken = CkJsonObjectW_Create(); success = CkJsonObjectW_LoadFile(jsonToken,L"qa_data/tokens/geoop.json"); // This example assumes we previously obtained an access token oauth2 = CkOAuth2W_Create(); CkOAuth2W_putAccessToken(oauth2,CkJsonObjectW_stringOf(jsonToken,L"access_token")); rest = CkRestW_Create(); // Connect to GeoOp and send the following GET request: // GET /users HTTP/1.1 // Host: api.geoop.com bAutoReconnect = TRUE; success = CkRestW_Connect(rest,L"api.geoop.com",443,TRUE,bAutoReconnect); if (success != TRUE) { wprintf(L"%s\n",CkRestW_lastErrorText(rest)); CkJsonObjectW_Dispose(jsonToken); CkOAuth2W_Dispose(oauth2); CkRestW_Dispose(rest); return; } // Provide the authentication credentials (i.e. the access token) CkRestW_SetAuthOAuth2(rest,oauth2); // Set the X-Version header. CkRestW_AddHeader(rest,L"X-Version",L"1.0"); responseBody = CkRestW_fullRequestNoBody(rest,L"GET",L"/clients"); if (CkRestW_getLastMethodSuccess(rest) != TRUE) { wprintf(L"%s\n",CkRestW_lastErrorText(rest)); CkJsonObjectW_Dispose(jsonToken); CkOAuth2W_Dispose(oauth2); CkRestW_Dispose(rest); return; } json = CkJsonObjectW_Create(); CkJsonObjectW_putEmitCompact(json,FALSE); // If the response status code did not indicate success, then see what happened.. 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)); CkJsonObjectW_Load(json,responseBody); wprintf(L"%s\n",CkJsonObjectW_emit(json)); CkJsonObjectW_Dispose(jsonToken); CkOAuth2W_Dispose(oauth2); CkRestW_Dispose(rest); CkJsonObjectW_Dispose(json); return; } CkJsonObjectW_Load(json,responseBody); // Show the full JSON response.. (see below) wprintf(L"%s\n",CkJsonObjectW_emit(json)); wprintf(L"---\n"); csv = CkCsvW_Create(); CkCsvW_putHasColumnNames(csv,TRUE); CkCsvW_SetColumnName(csv,0,L"id"); CkCsvW_SetColumnName(csv,1,L"companyName"); CkCsvW_SetColumnName(csv,2,L"businessType"); CkCsvW_SetColumnName(csv,3,L"account_id"); CkCsvW_SetColumnName(csv,4,L"address_line1"); CkCsvW_SetColumnName(csv,5,L"address_city"); CkCsvW_SetColumnName(csv,6,L"address_postcode"); // Iterate over each client and populate the CSV... numRecords = CkJsonObjectW_SizeOfArray(json,L"clients"); i = 0; while (i < numRecords) { CkJsonObjectW_putI(json,i); CkCsvW_SetCellByName(csv,i,L"id",CkJsonObjectW_stringOf(json,L"clients[i].id")); CkCsvW_SetCellByName(csv,i,L"companyName",CkJsonObjectW_stringOf(json,L"clients[i].companyName")); CkCsvW_SetCellByName(csv,i,L"businessType",CkJsonObjectW_stringOf(json,L"clients[i].businessType")); CkCsvW_SetCellByName(csv,i,L"account_id",CkJsonObjectW_stringOf(json,L"clients[i].account.id")); CkCsvW_SetCellByName(csv,i,L"address_line1",CkJsonObjectW_stringOf(json,L"clients[i].address.line1")); CkCsvW_SetCellByName(csv,i,L"address_city",CkJsonObjectW_stringOf(json,L"clients[i].address.city")); CkCsvW_SetCellByName(csv,i,L"address_postcode",CkJsonObjectW_stringOf(json,L"clients[i].address.postcode")); i = i + 1; } // Show the CSV. wprintf(L"%s\n",CkCsvW_saveToString(csv)); // Save the CSV. CkCsvW_SaveFile(csv,L"qa_output/clients.csv"); // --------------------------------------------------------------------- // The full JSON response containing all client data: // // { // "result": "success", // "clients": [ // { // "id": 9555868, // "firstName": "[ Demo", // "lastName": "Client ]", // "companyName": "Miller Park Cafe", // "businessType": "Licensed Restaurant", // "leadSource": "", // "emailAddress": null, // "phoneNumber": null, // "mobileNumber": null, // "faxNumber": null, // "notes": "", // "deleted": false, // "hasRecentJobs": true, // "created": "2016-10-26T12:05:09+00:00", // "modified": "2016-10-26T12:05:09+00:00", // "billingClient": null, // "account": { // "id": 39409 // }, // "address": { // "line1": "1732 Pennsylvania Avenue NW", // "line2": "", // "city": "Washington", // "postcode": "20006", // "latitude": 38.899037, // "longitude": -77.040207 // }, // "mailingAddress": {} // }, // { // "id": 9571176, // "firstName": "Mildred", // "lastName": "Vanildred", // "companyName": "Ice Cream Industries", // "businessType": "Ice Cream", // "leadSource": null, // "emailAddress": "milli@icecreamindustries.com", // "phoneNumber": "678-555-1012", // "mobileNumber": null, // "faxNumber": null, // "notes": "", // "deleted": false, // "hasRecentJobs": true, // "created": "2016-10-31T12:32:12+00:00", // "modified": "2016-10-31T12:32:13+00:00", // "billingClient": null, // "account": { // "id": 39409 // }, // "address": { // "line1": "2101 West Roosevelt Road", // "line2": null, // "city": "Wheaton", // "postcode": "60187", // "latitude": 41.8581778, // "longitude": -88.1380111 // }, // "mailingAddress": { // "line1": "2101 West Roosevelt Road", // "line2": null, // "city": "Wheaton" // } // }, // { // "id": 9571218, // "firstName": "Joe", // "lastName": "Miller", // "companyName": "Miller Bakery", // "businessType": "Licensed Bakery", // "leadSource": "", // "emailAddress": null, // "phoneNumber": null, // "mobileNumber": null, // "faxNumber": null, // "notes": "", // "deleted": false, // "hasRecentJobs": true, // "created": "2016-10-31T13:02:07+00:00", // "modified": "2016-10-31T13:02:07+00:00", // "billingClient": null, // "account": { // "id": 39409 // }, // "address": { // "line1": "1832 Pennsylvania Avenue NW", // "line2": "", // "city": "Washington", // "postcode": "20006", // "latitude": 0, // "longitude": 0 // }, // "mailingAddress": { // "line1": "", // "line2": "", // "city": "" // } // } // ], // "metadata": { // "page": 1, // "pagesCount": 1, // "recordsPerPage": 20, // "recordsCount": 3 // } // } // CkJsonObjectW_Dispose(jsonToken); CkOAuth2W_Dispose(oauth2); CkRestW_Dispose(rest); CkJsonObjectW_Dispose(json); CkCsvW_Dispose(csv); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.