(DataFlex) List Plans for a Group

Demonstrates how to retrieve a list of plannerPlan objects owned by a group object.

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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
Token    Handle hoJsonToken
    Boolean iSuccess
    String sStrResponse
    Handle hoJson
    Integer i
    Integer iCount_i
    String sCreatedByApplicationId
    String sCreatedByUserId
    String sCreatedDateTime
    String sOwner
    String sTitle
    String sId
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    // 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/groups/{group-id}/planner/plans
    Get ComQuickGetStr Of hoHttp "https://graph.microsoft.com/v1.0/groups/{group-id}/planner/plans" 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": {
    //         "application": {
    //           "id": "95e27074-6c4a-447a-aa24-9d718a0b86fa"
    //         },
    //         "user": {
    //           "id": "ebf3b108-5234-4e22-b93d-656d7dae5874"
    //         }
    //       },
    //       "createdDateTime": "2015-03-30T18:36:49.2407981Z",
    //       "owner": "ebf3b108-5234-4e22-b93d-656d7dae5874",
    //       "title": "title-value",
    //       "id": "xqQg5FS2LkCp935s-FIFm2QAFkHM"
    //     }
    //   ]
    // }

    // Use this online tool to generate parsing code from sample JSON: 
    // Generate Parsing Code from JSON

    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.application.id" To sCreatedByApplicationId
        Get ComStringOf Of hoJson "value[i].createdBy.user.id" To sCreatedByUserId
        Get ComStringOf Of hoJson "value[i].createdDateTime" To sCreatedDateTime
        Get ComStringOf Of hoJson "value[i].owner" To sOwner
        Get ComStringOf Of hoJson "value[i].title" To sTitle
        Get ComStringOf Of hoJson "value[i].id" To sId
        Move (i + 1) To i
    Loop

    Showln "Success."


End_Procedure