PowerBuilder

GeoOp - Get a list of all users

See more GeoOp Examples

Gets a list of all GeoOp users. PowerBuilder

integer li_rc
long li_Success
oleobject loo_JsonToken
oleobject loo_Oauth2
oleobject loo_Rest
long li_BAutoReconnect
string ls_ResponseBody
oleobject loo_Json
oleobject loo_Dtime
long li_BLocalTime
oleobject loo_Dt
long li_NumRecords
long 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