PowerBuilder Requires Chilkat v11.0.0+

Get Tasks for User

See more Microsoft Tasks and Plans Examples

Demonstrates how to retrieve a list of plannertask objects assigned to a User.

See https://docs.microsoft.com/en-us/graph/api/planneruser-list-tasks?view=graph-rest-1.0 for more information.

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Http
oleobject loo_JsonToken
string ls_StrResponse
oleobject loo_Json
integer i
integer li_Count_i
string ls_CreatedByUserId
string ls_PlanId
string ls_BucketId
string ls_Title
string ls_OrderHint
string ls_AssigneePriority
string ls_CreatedDateTime
string ls_Assignments_odataType
string ls_AssignmentsAssignedByUserId
string ls_AssignmentsAssignedDateTime
string ls_AssignmentsOrderHint
string ls_Id
oleobject loo_JsonA
oleobject loo_JsonUserA
string ls_UserId

li_Success = 0

//  This example requires the Chilkat API to have been previously unlocked.
//  See Global Unlock Sample for sample code.

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

//  The Microsoft Planner REST API requires an OAuth2 token with the Group.ReadWrite.All scope.
//  Use your previously obtained access token as shown here:
//     Get Microsoft Graph OAuth2 Access Token with Group.ReadWrite.All scope.

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

li_Success = loo_JsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
if li_Success = 0 then
    Write-Debug loo_JsonToken.LastErrorText
    destroy loo_Http
    destroy loo_JsonToken
    return
end if

loo_Http.AuthToken = loo_JsonToken.StringOf("access_token")

//  Send a GET request to https://graph.microsoft.com/v1.0/me/planner/tasks
ls_StrResponse = loo_Http.QuickGetStr("https://graph.microsoft.com/v1.0/me/planner/tasks")
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_JsonToken
    return
end if

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

loo_Json.Load(ls_StrResponse)
loo_Json.EmitCompact = 0

if loo_Http.LastStatus <> 200 then
    Write-Debug loo_Json.Emit()
    Write-Debug "Failed, response status code = " + string(loo_Http.LastStatus)
    destroy loo_Http
    destroy loo_JsonToken
    destroy loo_Json
    return
end if

Write-Debug loo_Json.Emit()

//  Sample output:
//  (See parsing code below..)

//  {
//    "value": [
//      {
//        "createdBy": {
//          "user": {
//            "id": "6463a5ce-2119-4198-9f2a-628761df4a62"
//          }
//        },
//        "planId": "xqQg5FS2LkCp935s-FIFm2QAFkHM",
//        "bucketId": "gcrYAaAkgU2EQUvpkNNXLGQAGTtu",
//        "title": "title-value",
//        "orderHint": "9223370609546166567W",
//        "assigneePriority": "90057581\"",
//        "createdDateTime": "2015-03-25T18:36:49.2407981Z",
//        "assignments": {
//          "fbab97d0-4932-4511-b675-204639209557": {
//            "@odata.type": "#microsoft.graph.plannerAssignment",
//            "assignedBy": {
//              "user": {
//                "id": "1e9955d2-6acd-45bf-86d3-b546fdc795eb"
//              }
//            },
//            "assignedDateTime": "2015-03-25T18:38:21.956Z",
//            "orderHint": "RWk1"
//           }
//        },
//        "id":"01gzSlKkIUSUl6DF_EilrmQAKDhh"
//      }
//    ]
//  }

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

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

i = 0
li_Count_i = loo_Json.SizeOfArray("value")
do while i < li_Count_i
    loo_Json.I = i
    ls_CreatedByUserId = loo_Json.StringOf("value[i].createdBy.user.id")
    ls_PlanId = loo_Json.StringOf("value[i].planId")
    ls_BucketId = loo_Json.StringOf("value[i].bucketId")
    ls_Title = loo_Json.StringOf("value[i].title")
    ls_OrderHint = loo_Json.StringOf("value[i].orderHint")
    ls_AssigneePriority = loo_Json.StringOf("value[i].assigneePriority")
    ls_CreatedDateTime = loo_Json.StringOf("value[i].createdDateTime")

    loo_Json.ObjectOf2("value[i].assignments",loo_JsonA)

    ls_UserId = loo_JsonA.NameAt(0)

    loo_JsonA.ObjectOf2(ls_UserId,loo_JsonUserA)

    ls_Assignments_odataType = loo_JsonUserA.StringOf("~"@odata.type~"")
    ls_AssignmentsAssignedByUserId = loo_JsonUserA.StringOf("assignedBy.user.id")
    ls_AssignmentsAssignedDateTime = loo_JsonUserA.StringOf("assignedDateTime")
    ls_AssignmentsOrderHint = loo_JsonUserA.StringOf("orderHint")

    ls_Id = loo_Json.StringOf("value[i].id")
    i = i + 1
loop

Write-Debug "Success."


destroy loo_Http
destroy loo_JsonToken
destroy loo_Json
destroy loo_JsonA
destroy loo_JsonUserA