Visual FoxPro
Visual FoxPro
GeoOp - Get all Jobs
See more GeoOp Examples
Gets all information about all jobs.Chilkat Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loJsonToken
LOCAL loOauth2
LOCAL loRest
LOCAL lnBAutoReconnect
LOCAL lcResponseBody
LOCAL loJson
LOCAL loDtime
LOCAL lnBLocalTime
LOCAL loDt
LOCAL lnNumRecords
LOCAL i
lnSuccess = 0
* 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}
loJsonToken = CreateObject('Chilkat.JsonObject')
lnSuccess = loJsonToken.LoadFile("qa_data/tokens/geoop.json")
* This example assumes we previously obtained an access token
loOauth2 = CreateObject('Chilkat.OAuth2')
loOauth2.AccessToken = loJsonToken.StringOf("access_token")
loRest = CreateObject('Chilkat.Rest')
* Connect to GeoOp and send the following GET request:
* GET /users HTTP/1.1
* Host: api.geoop.com
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("api.geoop.com",443,1,lnBAutoReconnect)
IF (lnSuccess = 0) THEN
? loRest.LastErrorText
RELEASE loJsonToken
RELEASE loOauth2
RELEASE loRest
CANCEL
ENDIF
* Provide the authentication credentials (i.e. the access token)
loRest.SetAuthOAuth2(loOauth2)
* Set the X-Version header.
loRest.AddHeader("X-Version","1.0")
lcResponseBody = loRest.FullRequestNoBody("GET","/jobs")
IF (loRest.LastMethodSuccess = 0) THEN
? loRest.LastErrorText
RELEASE loJsonToken
RELEASE loOauth2
RELEASE loRest
CANCEL
ENDIF
loJson = CreateObject('Chilkat.JsonObject')
loJson.EmitCompact = 0
* If the response status code did not indicate success, then see what happened..
IF (loRest.ResponseStatusCode <> 200) THEN
? "Request Header: "
? loRest.LastRequestHeader
? "----"
? "Response StatusCode = " + STR(loRest.ResponseStatusCode)
? "Response StatusLine: " + loRest.ResponseStatusText
? "Response Header:"
? loRest.ResponseHeader
loJson.Load(lcResponseBody)
? loJson.Emit()
RELEASE loJsonToken
RELEASE loOauth2
RELEASE loRest
RELEASE loJson
CANCEL
ENDIF
loJson.Load(lcResponseBody)
* Show the full JSON response.. (see below)
? loJson.Emit()
* These will be used for parsing date/time strings..
loDtime = CreateObject('Chilkat.CkDateTime')
lnBLocalTime = 1
loDt = CreateObject('Chilkat.DtObj')
* Iterate over each job and get information..
lnNumRecords = loJson.SizeOfArray("jobs")
i = 0
DO WHILE i < lnNumRecords
loJson.I = i
? "job id: " + loJson.StringOf("jobs[i].id")
? "client id: " + loJson.StringOf("jobs[i].client.id")
? "account id: " + loJson.StringOf("jobs[i].account.id")
? "address line1: " + loJson.StringOf("jobs[i].address.line1")
loDtime.SetFromTimestamp(loJson.StringOf("jobs[i].startTime"))
loDtime.ToDtObj(lnBLocalTime,loDt)
? "created: " + STR(loDt.Month) + "/" + STR(loDt.Day) + "/" + STR(loDt.Year) + " " + STR(loDt.Hour) + ":" + STR(loDt.Minute)
? "----"
i = i + 1
ENDDO
* A sample jobs listing response:
*
* {
* "result": "success",
* "jobs": [
* {
* "id": 17580761,
* "reference": "1000",
* "startTime": "2016-10-26T02:10:00+00:00",
* "endTime": "2016-10-28T02:40:00+00:00",
* "priority": 2,
* "title": "[ Demo Job ]",
* "description": "",
* "jobNumber": null,
* "deleted": false,
* "type": "demo",
* "created": "2015-09-03T02:11:32+00:00",
* "modified": "2016-10-26T12:05:09+00:00",
* "client": {
* "id": 9555868
* },
* "billingClient": null,
* "status": {
* "id": 675900
* },
* "account": {
* "id": 39409
* },
* "address": {
* "line1": "21462 New York Avenue NW",
* "line2": null,
* "city": "Washington",
* "postcode": "20005",
* "latitude": 38.903959,
* "longitude": -77.02137
* },
* "metadata": {
* "visitsCount": 3,
* "assignedVisitsCount": 3,
* "unassignedVisitsCount": 0,
* "partsCount": 1,
* "chargesCount": 1,
* "timersCount": 0,
* "notesCount": 0,
* "parcelsCount": 0,
* "paymentsCount": 0,
* "documentsCount": 1
* }
* },
* {
* "id": 17639295,
* "reference": "1000",
* "startTime": "2016-10-31T12:00:00+00:00",
* "endTime": "2016-10-31T12:30:00+00:00",
* "priority": 2,
* "title": "Deliver Donuts",
* "description": "Deliver donuts to the cafe.",
* "jobNumber": "21122",
* "deleted": false,
* "type": "normal",
* "created": "2016-10-31T12:07:14+00:00",
* "modified": "2016-10-31T12:07:14+00:00",
* "client": {
* "id": 9555868
* },
* "billingClient": null,
* "status": {
* "id": 675900
* },
* "account": {
* "id": 39409
* },
* "address": {
* "line1": "1732 Pennsylvania Avenue NW",
* "line2": null,
* "city": "Washington",
* "postcode": "20006",
* "latitude": 38.8990534,
* "longitude": -77.0401866
* },
* "metadata": {
* "visitsCount": 1,
* "assignedVisitsCount": 0,
* "unassignedVisitsCount": 1,
* "partsCount": 0,
* "chargesCount": 0,
* "timersCount": 0,
* "notesCount": 0,
* "parcelsCount": 0,
* "paymentsCount": 0,
* "documentsCount": 0
* }
* }
* ],
* "metadata": {
* "page": 1,
* "pagesCount": 1,
* "recordsPerPage": 20,
* "recordsCount": 2
* }
* }
*
RELEASE loJsonToken
RELEASE loOauth2
RELEASE loRest
RELEASE loJson
RELEASE loDtime
RELEASE loDt