Visual Basic 6.0
Visual Basic 6.0
List Groups
See more Microsoft Group Examples
List all the groups available in an organization, including but not limited to Office 365 Groups.See https://docs.microsoft.com/en-us/graph/api/group-list?view=graph-rest-1.0 for more information.
Chilkat Visual Basic 6.0 Downloads
Dim success As Long
success = 0
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New ChilkatHttp
' Use your previously obtained access token as shown here:
' Get Microsoft Graph OAuth2 Access Token with Group.ReadWrite.All scope.
Dim jsonToken As New ChilkatJsonObject
success = jsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
If (success = 0) Then
Debug.Print jsonToken.LastErrorText
Exit Sub
End If
http.AuthToken = jsonToken.StringOf("access_token")
' Send a GET request to https://graph.microsoft.com/v1.0/groups?$orderby=displayName
Dim strResponse As String
strResponse = http.QuickGetStr("https://graph.microsoft.com/v1.0/groups?$orderby=displayName")
If (http.LastMethodSuccess = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim json As New ChilkatJsonObject
success = json.Load(strResponse)
json.EmitCompact = 0
If (http.LastStatus <> 200) Then
Debug.Print json.Emit()
Debug.Print "Failed, response status code = " & http.LastStatus
Exit Sub
End If
Debug.Print json.Emit()
' Sample output:
' (See parsing code below..)
' {
' "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#groups",
' "value": [
' {
' "id": "45b7d2e7-b882-4a80-ba97-10b7a63b8fa4",
' "deletedDateTime": null,
' "classification": null,
' "createdDateTime": "2018-12-22T02:21:05Z",
' "creationOptions": [],
' "description": "Self help community for golf",
' "displayName": "Golf Assist",
' "groupTypes": [
' "Unified"
' ],
' "mail": "golfassist@contoso.com",
' "mailEnabled": true,
' "mailNickname": "golfassist",
' "onPremisesLastSyncDateTime": null,
' "onPremisesSecurityIdentifier": null,
' "onPremisesSyncEnabled": null,
' "preferredDataLocation": "CAN",
' "proxyAddresses": [
' "smtp:golfassist@contoso.onmicrosoft.com",
' "SMTP:golfassist@contoso.com"
' ],
' "renewedDateTime": "2018-12-22T02:21:05Z",
' "resourceBehaviorOptions": [],
' "resourceProvisioningOptions": [],
' "securityEnabled": false,
' "visibility": "Public",
' "onPremisesProvisioningErrors": []
' },
' {
' "id": "d7797254-3084-44d0-99c9-a3b5ab149538",
' "deletedDateTime": null,
' "classification": null,
' "createdDateTime": "2018-11-19T20:29:40Z",
' "creationOptions": [],
' "description": "Talk about golf",
' "displayName": "Golf Discussion",
' "groupTypes": [],
' "mail": "golftalk@contoso.com",
' "mailEnabled": true,
' "mailNickname": "golftalk",
' "onPremisesLastSyncDateTime": null,
' "onPremisesSecurityIdentifier": null,
' "onPremisesSyncEnabled": null,
' "preferredDataLocation": "CAN",
' "proxyAddresses": [
' "smtp:golftalk@contoso.onmicrosoft.com",
' "SMTP:golftalk@contoso.com"
' ],
' "renewedDateTime": "2018-11-19T20:29:40Z",
' "resourceBehaviorOptions": [],
' "resourceProvisioningOptions": [],
' "securityEnabled": false,
' "visibility": null,
' "onPremisesProvisioningErrors": []
' }
' ]
' }
'
' Use this online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON
Dim odataContext As String
Dim i As Long
Dim count_i As Long
Dim id As String
Dim deletedDateTime As String
Dim classification As String
Dim createdDateTime As String
Dim description As String
Dim displayName As String
Dim mail As String
Dim mailEnabled As Long
Dim mailNickname As String
Dim onPremisesLastSyncDateTime As String
Dim onPremisesSecurityIdentifier As String
Dim onPremisesSyncEnabled As String
Dim preferredDataLocation As String
Dim renewedDateTime As String
Dim securityEnabled As Long
Dim visibility As String
Dim j As Long
Dim count_j As Long
Dim strVal As String
odataContext = json.StringOf("""@odata.context""")
i = 0
count_i = json.SizeOfArray("value")
Do While i < count_i
json.I = i
id = json.StringOf("value[i].id")
deletedDateTime = json.StringOf("value[i].deletedDateTime")
classification = json.StringOf("value[i].classification")
createdDateTime = json.StringOf("value[i].createdDateTime")
description = json.StringOf("value[i].description")
displayName = json.StringOf("value[i].displayName")
mail = json.StringOf("value[i].mail")
mailEnabled = json.BoolOf("value[i].mailEnabled")
mailNickname = json.StringOf("value[i].mailNickname")
onPremisesLastSyncDateTime = json.StringOf("value[i].onPremisesLastSyncDateTime")
onPremisesSecurityIdentifier = json.StringOf("value[i].onPremisesSecurityIdentifier")
onPremisesSyncEnabled = json.StringOf("value[i].onPremisesSyncEnabled")
preferredDataLocation = json.StringOf("value[i].preferredDataLocation")
renewedDateTime = json.StringOf("value[i].renewedDateTime")
securityEnabled = json.BoolOf("value[i].securityEnabled")
visibility = json.StringOf("value[i].visibility")
j = 0
count_j = json.SizeOfArray("value[i].creationOptions")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].groupTypes")
Do While j < count_j
json.J = j
strVal = json.StringOf("value[i].groupTypes[j]")
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].proxyAddresses")
Do While j < count_j
json.J = j
strVal = json.StringOf("value[i].proxyAddresses[j]")
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].resourceBehaviorOptions")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].resourceProvisioningOptions")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].onPremisesProvisioningErrors")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
i = i + 1
Loop
Debug.Print "Success."