(Excel) GeoOp - Create Job

Create a new job.

Download Excel Class Modules Chilkat Excel Class Modules

' 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}
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/geoop.json")

' This example assumes we previously obtained an access token
Dim oauth2 As Chilkat.OAuth2
Set oauth2 = Chilkat.NewOAuth2
oauth2.AccessToken = jsonToken.StringOf("access_token")

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to GeoOp..
' Note: The same REST object, once connected, can be used for many requests.
' The bAutoReconnect argument allows it to automatically reconnect as required for any subsequent request.


bAutoReconnect = True
success = rest.Connect("api.geoop.com",443,True,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Provide the authentication credentials (i.e. the access token)
success = rest.SetAuthOAuth2(oauth2)

' Set the X-Version header.
success = rest.AddHeader("X-Version","1.0")

' To create a new user, we must build and send the following JSON:

' 	{
' 	  "jobs": [
' 	    {
' 	      "priority": 2,
' 	      "title": "Deliver More Donuts",
' 	      "description": "Deliver more donuts to the cafe.",
' 	      "client": {
' 	        "id": 9571218
' 	      },
' 	      "account": {
' 	        "id": 39409
' 	      },
' 	      "status": {
' 	        "id": 675900
' 	      },
' 	      "address": {
' 	        "line1": "1732 Pennsylvania Avenue NW",
' 	        "city": "Washington",
' 	        "postcode": "20006",
' 	      }
' 	    }
' 	  ]
' 	}
' 

Dim jsonJob As Chilkat.JsonObject
Set jsonJob = Chilkat.NewJsonObject
success = jsonJob.UpdateInt("jobs[0].priority",2)
success = jsonJob.UpdateString("jobs[0].title","Deliver More Donuts")
success = jsonJob.UpdateString("jobs[0].description","Deliver more donuts to the cafe.")
success = jsonJob.UpdateInt("jobs[0].client.id",9571218)
success = jsonJob.UpdateInt("jobs[0].account.id",39409)
success = jsonJob.UpdateInt("jobs[0].status.id",675900)
success = jsonJob.UpdateString("jobs[0].address.line1","1732 Pennsylvania Avenue NW")
success = jsonJob.UpdateString("jobs[0].address.city","Washington")
success = jsonJob.UpdateString("jobs[0].address.postcode","20006")

' Examine the JSON we're about to send...
jsonJob.EmitCompact = False
Debug.Print jsonJob.Emit()

success = rest.AddHeader("Content-Type","application/json")

jsonJob.EmitCompact = True

responseBody = rest.FullRequestString("POST","/jobs",jsonJob.Emit())
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

' If the response status code did not indicate success, then see what happened..
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "Request Header: "
    Debug.Print rest.LastRequestHeader
    Debug.Print "----"
    Debug.Print "Response StatusCode = "; rest.ResponseStatusCode
    Debug.Print "Response StatusLine: "; rest.ResponseStatusText
    Debug.Print "Response Header:"
    Debug.Print rest.ResponseHeader
    success = json.Load(responseBody)
    Debug.Print json.Emit()
    Exit Sub
End If

success = json.Load(responseBody)
' Show the full JSON response..
Debug.Print json.Emit()

' The success JSON looks like this:

' 	{
' 	  "result": "success",
' 	  "jobs": [
' 	    {
' 	      "id": 17639811,
' 	      "reference": "1001",
' 	      "startTime": null,
' 	      "endTime": null,
' 	      "priority": 2,
' 	      "title": "Deliver More Donuts",
' 	      "description": "Deliver more donuts to the cafe.",
' 	      "jobNumber": null,
' 	      "deleted": false,
' 	      "type": "normal",
' 	      "created": "2016-10-31T13:36:47+00:00",
' 	      "modified": "2016-10-31T13:36:47+00:00",
' 	      "client": {
' 	        "id": 9571218
' 	      },
' 	      "billingClient": null,
' 	      "status": {
' 	        "id": 675900
' 	      },
' 	      "account": {
' 	        "id": 39409
' 	      },
' 	      "address": {
' 	        "line1": "1732 Pennsylvania Avenue NW",
' 	        "line2": "",
' 	        "city": "Washington",
' 	        "postcode": "20006",
' 	        "latitude": 38.8990534,
' 	        "longitude": -77.0401866
' 	      },
' 	      "metadata": {
' 	        "visitsCount": 0,
' 	        "assignedVisitsCount": 0,
' 	        "unassignedVisitsCount": 0,
' 	        "partsCount": 0,
' 	        "chargesCount": 0,
' 	        "timersCount": 0,
' 	        "notesCount": 0,
' 	        "parcelsCount": 0,
' 	        "paymentsCount": 0,
' 	        "documentsCount": 0
' 	      }
' 	    }
' 	  ],
' 	  "metadata": {
' 	    "receivedItemsCount": 1,
' 	    "validItems": [
' 	      0
' 	    ],
' 	    "invalidItems": [
' 	    ]
' 	  }
' 	}
'