(Visual FoxPro) Get Tasks for User

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.

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

LOCAL loHttp
LOCAL loJsonToken
LOCAL lnSuccess
LOCAL lcStrResponse
LOCAL loJson
LOCAL i
LOCAL lnCount_i
LOCAL lcCreatedByUserId
LOCAL lcPlanId
LOCAL lcBucketId
LOCAL lcTitle
LOCAL lcOrderHint
LOCAL lcAssigneePriority
LOCAL lcCreatedDateTime
LOCAL lcAssignments_odataType
LOCAL lcAssignmentsAssignedByUserId
LOCAL lcAssignmentsAssignedDateTime
LOCAL lcAssignmentsOrderHint
LOCAL lcId
LOCAL loJsonA
LOCAL lcUserId
LOCAL loJsonUserA

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonToken = CreateObject('Chilkat.JsonObject')
lnSuccess = loJsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
IF (lnSuccess = 0) THEN
    ? loJsonToken.LastErrorText
    RELEASE loHttp
    RELEASE loJsonToken
    CANCEL
ENDIF

loHttp.AuthToken = loJsonToken.StringOf("access_token")

* Send a GET request to https://graph.microsoft.com/v1.0/me/planner/tasks
lcStrResponse = loHttp.QuickGetStr("https://graph.microsoft.com/v1.0/me/planner/tasks")
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJsonToken
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.Load(lcStrResponse)
loJson.EmitCompact = 0

IF (loHttp.LastStatus <> 200) THEN
    ? loJson.Emit()
    ? "Failed, response status code = " + STR(loHttp.LastStatus)
    RELEASE loHttp
    RELEASE loJsonToken
    RELEASE loJson
    CANCEL
ENDIF

? loJson.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"
*     }
*   ]
* }

i = 0
lnCount_i = loJson.SizeOfArray("value")
DO WHILE i < lnCount_i
    loJson.I = i
    lcCreatedByUserId = loJson.StringOf("value[i].createdBy.user.id")
    lcPlanId = loJson.StringOf("value[i].planId")
    lcBucketId = loJson.StringOf("value[i].bucketId")
    lcTitle = loJson.StringOf("value[i].title")
    lcOrderHint = loJson.StringOf("value[i].orderHint")
    lcAssigneePriority = loJson.StringOf("value[i].assigneePriority")
    lcCreatedDateTime = loJson.StringOf("value[i].createdDateTime")

    loJsonA = loJson.ObjectOf("value[i].assignments")
    lcUserId = loJsonA.NameAt(0)
    loJsonUserA = loJsonA.ObjectOf(lcUserId)
    lcAssignments_odataType = loJsonUserA.StringOf('"@odata.type"')
    lcAssignmentsAssignedByUserId = loJsonUserA.StringOf("assignedBy.user.id")
    lcAssignmentsAssignedDateTime = loJsonUserA.StringOf("assignedDateTime")
    lcAssignmentsOrderHint = loJsonUserA.StringOf("orderHint")
    RELEASE loJsonUserA
    RELEASE loJsonA

    lcId = loJson.StringOf("value[i].id")
    i = i + 1
ENDDO

? "Success."

RELEASE loHttp
RELEASE loJsonToken
RELEASE loJson