DataFlex

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.

DataFlex

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Handle hoHttp
Token    Handle hoJsonToken
    String sStrResponse
    Handle hoJson
    Integer i
    Integer iCount_i
    String sCreatedByUserId
    String sPlanId
    String sBucketId
    String sTitle
    String sOrderHint
    String sAssigneePriority
    String sCreatedDateTime
    String sAssignments_odataType
    String sAssignmentsAssignedByUserId
    String sAssignmentsAssignedDateTime
    String sAssignmentsOrderHint
    String sId
A    Handle hoJsonA
UserA    Handle hoJsonUserA
    String sUserId
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    Move False To iSuccess

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    // 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.

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonToken
    If (Not(IsComObjectCreated(hoJsonToken))) Begin
        Send CreateComObject of hoJsonToken
    End
    Get ComLoadFile Of hoJsonToken "qa_data/tokens/msGraphGroup.json" To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoJsonToken To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComStringOf Of hoJsonToken "access_token" To sTemp1
    Set ComAuthToken Of hoHttp To sTemp1

    // Send a GET request to https://graph.microsoft.com/v1.0/me/planner/tasks
    Get ComQuickGetStr Of hoHttp "https://graph.microsoft.com/v1.0/me/planner/tasks" To sStrResponse
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get Create (RefClass(cComChilkatJsonObject)) To hoJson
    If (Not(IsComObjectCreated(hoJson))) Begin
        Send CreateComObject of hoJson
    End
    Get ComLoad Of hoJson sStrResponse To iSuccess
    Set ComEmitCompact Of hoJson To False

    Get ComLastStatus Of hoHttp To iTemp1
    If (iTemp1 <> 200) Begin
        Get ComEmit Of hoJson To sTemp1
        Showln sTemp1
        Get ComLastStatus Of hoHttp To iTemp1
        Showln "Failed, response status code = " iTemp1
        Procedure_Return
    End

    Get ComEmit Of hoJson To sTemp1
    Showln sTemp1

    // 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"
    //     }
    //   ]
    // }

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonA
    If (Not(IsComObjectCreated(hoJsonA))) Begin
        Send CreateComObject of hoJsonA
    End
    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonUserA
    If (Not(IsComObjectCreated(hoJsonUserA))) Begin
        Send CreateComObject of hoJsonUserA
    End

    Move 0 To i
    Get ComSizeOfArray Of hoJson "value" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJson To i
        Get ComStringOf Of hoJson "value[i].createdBy.user.id" To sCreatedByUserId
        Get ComStringOf Of hoJson "value[i].planId" To sPlanId
        Get ComStringOf Of hoJson "value[i].bucketId" To sBucketId
        Get ComStringOf Of hoJson "value[i].title" To sTitle
        Get ComStringOf Of hoJson "value[i].orderHint" To sOrderHint
        Get ComStringOf Of hoJson "value[i].assigneePriority" To sAssigneePriority
        Get ComStringOf Of hoJson "value[i].createdDateTime" To sCreatedDateTime

        Get pvComObject of hoJsonA to vJsonA
        Get ComObjectOf2 Of hoJson "value[i].assignments" vJsonA To iSuccess

        Get ComNameAt Of hoJsonA 0 To sUserId

        Get pvComObject of hoJsonUserA to vJsonUserA
        Get ComObjectOf2 Of hoJsonA sUserId vJsonUserA To iSuccess

        Get ComStringOf Of hoJsonUserA '"@odata.type"' To sAssignments_odataType
        Get ComStringOf Of hoJsonUserA "assignedBy.user.id" To sAssignmentsAssignedByUserId
        Get ComStringOf Of hoJsonUserA "assignedDateTime" To sAssignmentsAssignedDateTime
        Get ComStringOf Of hoJsonUserA "orderHint" To sAssignmentsOrderHint

        Get ComStringOf Of hoJson "value[i].id" To sId
        Move (i + 1) To i
    Loop

    Showln "Success."


End_Procedure