(PowerBuilder) 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

integer li_rc
oleobject loo_Http
oleobject loo_JsonToken
integer li_Success
string ls_StrResponse
oleobject loo_Json
integer i
integer li_Count_i
string ls_CreatedByApplicationId
string ls_CreatedByUserId
string ls_CreatedDateTime
string ls_Owner
string ls_Title
string ls_Id

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
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
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
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/groups/{group-id}/planner/plans
ls_StrResponse = loo_Http.QuickGetStr("https://graph.microsoft.com/v1.0/groups/{group-id}/planner/plans")
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_JsonToken
    return
end if

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
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": {
//         "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

i = 0
li_Count_i = loo_Json.SizeOfArray("value")
do while i < li_Count_i
    loo_Json.I = i
    ls_CreatedByApplicationId = loo_Json.StringOf("value[i].createdBy.application.id")
    ls_CreatedByUserId = loo_Json.StringOf("value[i].createdBy.user.id")
    ls_CreatedDateTime = loo_Json.StringOf("value[i].createdDateTime")
    ls_Owner = loo_Json.StringOf("value[i].owner")
    ls_Title = loo_Json.StringOf("value[i].title")
    ls_Id = loo_Json.StringOf("value[i].id")
    i = i + 1
loop

Write-Debug "Success."


destroy loo_Http
destroy loo_JsonToken
destroy loo_Json