(Tcl) GeoOp - Export Clients to CSV

Export client data to a CSV.

Chilkat Tcl Extension Downloads Chilkat Tcl Extension Downloads

load ./chilkat.dll

# 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}
set jsonToken [new_CkJsonObject]

set success [CkJsonObject_LoadFile $jsonToken "qa_data/tokens/geoop.json"]

# This example assumes we previously obtained an access token
set oauth2 [new_CkOAuth2]

CkOAuth2_put_AccessToken $oauth2 [CkJsonObject_stringOf $jsonToken "access_token"]

set rest [new_CkRest]

# Connect to GeoOp and send the following GET request:

# GET /users HTTP/1.1
# Host: api.geoop.com
set bAutoReconnect 1
set success [CkRest_Connect $rest "api.geoop.com" 443 1 $bAutoReconnect]
if {$success != 1} then {
    puts [CkRest_lastErrorText $rest]
    delete_CkJsonObject $jsonToken
    delete_CkOAuth2 $oauth2
    delete_CkRest $rest
    exit
}

# Provide the authentication credentials (i.e. the access token)
CkRest_SetAuthOAuth2 $rest $oauth2

# Set the X-Version header.
CkRest_AddHeader $rest "X-Version" "1.0"

set responseBody [CkRest_fullRequestNoBody $rest "GET" "/clients"]
if {[CkRest_get_LastMethodSuccess $rest] != 1} then {
    puts [CkRest_lastErrorText $rest]
    delete_CkJsonObject $jsonToken
    delete_CkOAuth2 $oauth2
    delete_CkRest $rest
    exit
}

set json [new_CkJsonObject]

CkJsonObject_put_EmitCompact $json 0

# If the response status code did not indicate success, then see what happened..
if {[CkRest_get_ResponseStatusCode $rest] != 200} then {
    puts "Request Header: "
    puts [CkRest_lastRequestHeader $rest]
    puts "----"
    puts "Response StatusCode = [CkRest_get_ResponseStatusCode $rest]"
    puts "Response StatusLine: [CkRest_responseStatusText $rest]"
    puts "Response Header:"
    puts [CkRest_responseHeader $rest]
    CkJsonObject_Load $json $responseBody
    puts [CkJsonObject_emit $json]
    delete_CkJsonObject $jsonToken
    delete_CkOAuth2 $oauth2
    delete_CkRest $rest
    delete_CkJsonObject $json
    exit
}

CkJsonObject_Load $json $responseBody
# Show the full JSON response.. (see below)
puts [CkJsonObject_emit $json]
puts "---"

set csv [new_CkCsv]

CkCsv_put_HasColumnNames $csv 1
CkCsv_SetColumnName $csv 0 "id"
CkCsv_SetColumnName $csv 1 "companyName"
CkCsv_SetColumnName $csv 2 "businessType"
CkCsv_SetColumnName $csv 3 "account_id"
CkCsv_SetColumnName $csv 4 "address_line1"
CkCsv_SetColumnName $csv 5 "address_city"
CkCsv_SetColumnName $csv 6 "address_postcode"

# Iterate over each client and populate the CSV...
set numRecords [CkJsonObject_SizeOfArray $json "clients"]
set i 0
while {$i < $numRecords} {

    CkJsonObject_put_I $json $i
    CkCsv_SetCellByName $csv $i "id" [CkJsonObject_stringOf $json "clients[i].id"]
    CkCsv_SetCellByName $csv $i "companyName" [CkJsonObject_stringOf $json "clients[i].companyName"]
    CkCsv_SetCellByName $csv $i "businessType" [CkJsonObject_stringOf $json "clients[i].businessType"]
    CkCsv_SetCellByName $csv $i "account_id" [CkJsonObject_stringOf $json "clients[i].account.id"]
    CkCsv_SetCellByName $csv $i "address_line1" [CkJsonObject_stringOf $json "clients[i].address.line1"]
    CkCsv_SetCellByName $csv $i "address_city" [CkJsonObject_stringOf $json "clients[i].address.city"]
    CkCsv_SetCellByName $csv $i "address_postcode" [CkJsonObject_stringOf $json "clients[i].address.postcode"]
    set i [expr $i + 1]
}

# Show the CSV.
puts [CkCsv_saveToString $csv]

# Save the CSV.
CkCsv_SaveFile $csv "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
# 	  }
# 	}
# 

delete_CkJsonObject $jsonToken
delete_CkOAuth2 $oauth2
delete_CkRest $rest
delete_CkJsonObject $json
delete_CkCsv $csv