Xbase++

Microsoft Graph -- List Users

See more Microsoft Graph Examples

Retrieve a list of Microsoft Graph user objects. Xbase++

LOCAL nSuccess
LOCAL oHttp
LOCAL oReq
LOCAL cUrl
LOCAL oResp
LOCAL nStatusCode
LOCAL oJson
LOCAL oSbResponse
LOCAL cOdata_id
LOCAL cDisplayName
LOCAL cGivenName
LOCAL cJobTitle
LOCAL cMail
LOCAL cMobilePhone
LOCAL cOfficeLocation
LOCAL cPreferredLanguage
LOCAL cSurname
LOCAL cUserPrincipalName
LOCAL cId
LOCAL j
LOCAL nCount_j
LOCAL cOdata_context
LOCAL i
LOCAL nCount_i

nSuccess := 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
oHttp := CreateObject("Chilkat.Http")
oReq := CreateObject("Chilkat.HttpRequest")
oReq:AddParam("client_secret", "CLIENT_SECRET")
oReq:AddParam("client_id", "CLIENT_ID")
oReq:AddParam("scope", "https://graph.microsoft.com/.default")
oReq:AddParam("grant_type", "client_credentials")

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

oReq:HttpVerb := "POST"
oReq:ContentType := "application/x-www-form-urlencoded"

oResp := CreateObject("Chilkat.HttpResponse")
nSuccess := oHttp:HttpReq(cUrl, oReq, oResp)
IF (nSuccess == 0)
    ? oHttp:LastErrorText
    oHttp:destroy()
    oReq:destroy()
    oResp:destroy()
    RETURN
ENDIF

nStatusCode := oResp:StatusCode
? "Response status code = " + Str(nStatusCode)

oJson := CreateObject("Chilkat.JsonObject")
oJson:Load(oResp: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:
oHttp:AuthToken := oJson:StringOf("access_token")

? "access token: " + oHttp:AuthToken

oSbResponse := CreateObject("Chilkat.StringBuilder")

nSuccess := oHttp:QuickGetSb("https://graph.microsoft.com/v1.0/users", oSbResponse)
IF (nSuccess == 0)
    ? oHttp:LastErrorText
    oHttp:destroy()
    oReq:destroy()
    oResp:destroy()
    oJson:destroy()
    oSbResponse:destroy()
    RETURN
ENDIF

oJson:LoadSb(oSbResponse)
oJson:EmitCompact := 0

? "Status code = " + Str(oHttp:LastStatus)
IF (oHttp:LastStatus != 200)
    ? oJson:Emit()
    ? "Failed."
ENDIF

? oJson: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

cOdata_context := oJson:StringOf('"@odata.context"')
i := 0
nCount_i := oJson:SizeOfArray("value")
DO WHILE i < nCount_i
    oJson:I := i
    cOdata_id := oJson:StringOf('value[i]."@odata.id"')
    cDisplayName := oJson:StringOf("value[i].displayName")
    cGivenName := oJson:StringOf("value[i].givenName")
    cJobTitle := oJson:StringOf("value[i].jobTitle")
    cMail := oJson:StringOf("value[i].mail")
    cMobilePhone := oJson:StringOf("value[i].mobilePhone")
    cOfficeLocation := oJson:StringOf("value[i].officeLocation")
    cPreferredLanguage := oJson:StringOf("value[i].preferredLanguage")
    cSurname := oJson:StringOf("value[i].surname")
    cUserPrincipalName := oJson:StringOf("value[i].userPrincipalName")
    cId := oJson:StringOf("value[i].id")
    j := 0
    nCount_j := oJson:SizeOfArray("value[i].businessPhones")
    DO WHILE j < nCount_j
        oJson:J := j
        j := j + 1
    ENDDO
    i := i + 1
ENDDO

oHttp:destroy()
oReq:destroy()
oResp:destroy()
oJson:destroy()
oSbResponse:destroy()