Visual FoxPro

Microsoft Graph -- List Users

See more Microsoft Graph Examples

Retrieve a list of Microsoft Graph user objects. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loReq
LOCAL lcUrl
LOCAL loResp
LOCAL lnStatusCode
LOCAL loJson
LOCAL loSbResponse
LOCAL lcOdata_id
LOCAL lcDisplayName
LOCAL lcGivenName
LOCAL lcJobTitle
LOCAL lcMail
LOCAL lcMobilePhone
LOCAL lcOfficeLocation
LOCAL lcPreferredLanguage
LOCAL lcSurname
LOCAL lcUserPrincipalName
LOCAL lcId
LOCAL j
LOCAL lnCount_j
LOCAL lcOdata_context
LOCAL i
LOCAL lnCount_i

lnSuccess = 0

* ------------------------------------------------------------------------------------------------------
* See an easier way to do OAuth2 client credentials:
* Example using Automatic OAuth2 Client Credentials
* ------------------------------------------------------------------------------------------------------

* Get an access token with the required scope using client credentials...
* See How to Create Microsoft Graph App (in Azure Portal) for Client Credentials Authentication
loHttp = CreateObject('Chilkat.Http')
loReq = CreateObject('Chilkat.HttpRequest')
loReq.AddParam("client_secret","CLIENT_SECRET")
loReq.AddParam("client_id","CLIENT_ID")
loReq.AddParam("scope","https://graph.microsoft.com/.default")
loReq.AddParam("grant_type","client_credentials")

* Use your own tenant ID, for example 4d8fdd66-66d1-43b0-ae5c-e31b4b7de5cd
lcUrl = "https://login.microsoftonline.com/TENANT_ID/oauth2/v2.0/token"

loReq.HttpVerb = "POST"
loReq.ContentType = "application/x-www-form-urlencoded"

loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpReq(lcUrl,loReq,loResp)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loReq
    RELEASE loResp
    CANCEL
ENDIF

lnStatusCode = loResp.StatusCode
? "Response status code = " + STR(lnStatusCode)

loJson = CreateObject('Chilkat.JsonObject')
loJson.Load(loResp.BodyStr)

* -----------------------------------------------------
* Use the access token obtained from above.
* Note: We don't need to re-fetch a new access token every time.  An access token is valid 
* for some amount of time, typically an hour (3600 seconds)

* Use your previously obtained access token here:
loHttp.AuthToken = loJson.StringOf("access_token")

? "access token: " + loHttp.AuthToken

loSbResponse = CreateObject('Chilkat.StringBuilder')

lnSuccess = loHttp.QuickGetSb("https://graph.microsoft.com/v1.0/users",loSbResponse)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loReq
    RELEASE loResp
    RELEASE loJson
    RELEASE loSbResponse
    CANCEL
ENDIF

loJson.LoadSb(loSbResponse)
loJson.EmitCompact = 0

? "Status code = " + STR(loHttp.LastStatus)
IF (loHttp.LastStatus <> 200) THEN
    ? loJson.Emit()
    ? "Failed."
ENDIF

? loJson.Emit()

* Sample output
* {
*   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users",
*   "value": [
*     {
*       "@odata.id": "https://graph.microsoft.com/v2/6d8ddd66-68d1-43b0-af5c-e31b4b7dd5cd/directoryObjects/fca490d8-5918-4201-8079-c5dcbeafcdc9/Microsoft.DirectoryServices.User",
*       "businessPhones": [
*       ],
*       "displayName": "Joe Sample",
*       "givenName": "Joe",
*       "jobTitle": null,
*       "mail": null,
*       "mobilePhone": null,
*       "officeLocation": null,
*       "preferredLanguage": null,
*       "surname": "Sample",
*       "userPrincipalName": "admin_chilkatsoft.com#EXT#@adminchilkatsoft.onmicrosoft.com",
*       "id": "fca490d8-5918-4201-8079-c5dcbeafcdc9"
*     }
*   ]
* }

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

lcOdata_context = loJson.StringOf('"@odata.context"')
i = 0
lnCount_i = loJson.SizeOfArray("value")
DO WHILE i < lnCount_i
    loJson.I = i
    lcOdata_id = loJson.StringOf('value[i]."@odata.id"')
    lcDisplayName = loJson.StringOf("value[i].displayName")
    lcGivenName = loJson.StringOf("value[i].givenName")
    lcJobTitle = loJson.StringOf("value[i].jobTitle")
    lcMail = loJson.StringOf("value[i].mail")
    lcMobilePhone = loJson.StringOf("value[i].mobilePhone")
    lcOfficeLocation = loJson.StringOf("value[i].officeLocation")
    lcPreferredLanguage = loJson.StringOf("value[i].preferredLanguage")
    lcSurname = loJson.StringOf("value[i].surname")
    lcUserPrincipalName = loJson.StringOf("value[i].userPrincipalName")
    lcId = loJson.StringOf("value[i].id")
    j = 0
    lnCount_j = loJson.SizeOfArray("value[i].businessPhones")
    DO WHILE j < lnCount_j
        loJson.J = j
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loReq
RELEASE loResp
RELEASE loJson
RELEASE loSbResponse