PowerBuilder

GeoOp - Get a list of all users

See more GeoOp Examples

Gets a list of all GeoOp users. PowerBuilder

integer li_rc
integer li_Success
oleobject loo_JsonToken
oleobject loo_Oauth2
oleobject loo_Rest
integer li_BAutoReconnect
string ls_ResponseBody
oleobject loo_Json
oleobject loo_Dtime
integer li_BLocalTime
oleobject loo_Dt
integer li_NumRecords
integer i

li_Success = 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}
loo_JsonToken = create oleobject
li_rc = loo_JsonToken.ConnectToNewObject("Chilkat.JsonObject")
if li_rc < 0 then
    destroy loo_JsonToken
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_JsonToken.LoadFile("qa_data/tokens/geoop.json")

// This example assumes we previously obtained an access token
loo_Oauth2 = create oleobject
li_rc = loo_Oauth2.ConnectToNewObject("Chilkat.OAuth2")

loo_Oauth2.AccessToken = loo_JsonToken.StringOf("access_token")

loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat.Rest")

// Connect to GeoOp and send the following GET request:

// GET /users HTTP/1.1
// Host: api.geoop.com
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("api.geoop.com",443,1,li_BAutoReconnect)
if li_Success = 0 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_JsonToken
    destroy loo_Oauth2
    destroy loo_Rest
    return
end if

// Provide the authentication credentials (i.e. the access token)
loo_Rest.SetAuthOAuth2(loo_Oauth2)

// Set the X-Version header.
loo_Rest.AddHeader("X-Version","1.0")

ls_ResponseBody = loo_Rest.FullRequestNoBody("GET","/users")
if loo_Rest.LastMethodSuccess = 0 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_JsonToken
    destroy loo_Oauth2
    destroy loo_Rest
    return
end if

// If the response status code did not indicate success, then see what happened..
if loo_Rest.ResponseStatusCode <> 200 then
    Write-Debug "Request Header: "
    Write-Debug loo_Rest.LastRequestHeader
    Write-Debug "----"
    Write-Debug "Response StatusCode = " + string(loo_Rest.ResponseStatusCode)
    Write-Debug "Response StatusLine: " + loo_Rest.ResponseStatusText
    Write-Debug "Response Header:"
    Write-Debug loo_Rest.ResponseHeader
    Write-Debug ls_ResponseBody
    destroy loo_JsonToken
    destroy loo_Oauth2
    destroy loo_Rest
    return
end if

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.EmitCompact = 0
loo_Json.Load(ls_ResponseBody)
// Show the full JSON response..
Write-Debug loo_Json.Emit()

// These will be used for parsing date/time strings..
loo_Dtime = create oleobject
li_rc = loo_Dtime.ConnectToNewObject("Chilkat.CkDateTime")

li_BLocalTime = 1
loo_Dt = create oleobject
li_rc = loo_Dt.ConnectToNewObject("Chilkat.DtObj")

// Iterate over each user and get information from each.
li_NumRecords = loo_Json.SizeOfArray("users")
i = 0
do while i < li_NumRecords

    loo_Json.I = i
    Write-Debug "id: " + loo_Json.StringOf("users[i].id")
    Write-Debug "firstName: " + loo_Json.StringOf("users[i].firstName")
    Write-Debug "lastName: " + loo_Json.StringOf("users[i].lastName")
    Write-Debug "companyName: " + loo_Json.StringOf("users[i].companyName")
    Write-Debug "active: " + string(loo_Json.IntOf("users[i].active"))
    Write-Debug "isAssignable: " + string(loo_Json.BoolOf("users[i].isAssignable"))
    Write-Debug "account id: " + string(loo_Json.BoolOf("users[i].account.id"))

    loo_Dtime.SetFromTimestamp(loo_Json.StringOf("users[i].created"))
    loo_Dtime.ToDtObj(li_BLocalTime,loo_Dt)

    Write-Debug "created: " + string(loo_Dt.Month) + "/" + string(loo_Dt.Day) + "/" + string(loo_Dt.Year) + "  " + string(loo_Dt.Hour) + ":" + string(loo_Dt.Minute)

    Write-Debug "----"
    i = i + 1
loop

// The responseJson looks like this:
// {
//   "result": "success",
//   "users": [
//     {
//       "id": 984236,
//       "firstName": "Joe",
//       "lastName": "Smith",
//       "companyName": "Chilkat Software, Inc.",
//       "email": "support@chilkatsoft.com",
//       "phone": "",
//       "mobile": "1-630-555-5555",
//       "hourlyRate": 0,
//       "active": 1,
//       "deleted": false,
//       "colour": "#D2BC14",
//       "created": "2016-10-26T12:05:09+00:00",
//       "modified": "2016-10-26T12:05:09+00:00",
//       "isAssignable": true,
//       "avatarUrl": "https:\/\/www.geoop.com\/images\/mobithumb_984236.jpg",
//       "role": {
//         "id": 1
//       },
//       "account": {
//         "id": 39409
//       },
//       "status": {}
//     },
//     {
//       "id": 984237,
//       "firstName": "Demo",
//       "lastName": "Employee",
//       "companyName": "",
//       "email": "",
//       "phone": "",
//       "mobile": "58458458475854758",
//       "hourlyRate": 0,
//       "active": 0,
//       "deleted": true,
//       "colour": "#4C4CFF",
//       "created": "2015-09-03T01:56:17+00:00",
//       "modified": "2016-06-14T20:20:58+00:00",
//       "isAssignable": true,
//       "avatarUrl": "https:\/\/www.geoop.com\/images\/mobithumb_984237.jpg",
//       "role": {
//         "id": 2
//       },
//       "account": {
//         "id": 39409
//       },
//       "status": {
//         "message": null,
//         "timestamp": "2015-09-03T01:57:45+00:00"
//       }
//     }
//   ],
//   "metadata": {
//     "page": 1,
//     "pagesCount": 1,
//     "recordsPerPage": 20,
//     "recordsCount": 2
//   }
// }
// 
// 


destroy loo_JsonToken
destroy loo_Oauth2
destroy loo_Rest
destroy loo_Json
destroy loo_Dtime
destroy loo_Dt