Visual FoxPro

Outlook List Contacts

See more Outlook Contact Examples

List Outlook Contacts Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loJsonToken
LOCAL loSbJson
LOCAL lnStatusCode
LOCAL loJResp
LOCAL lcOdata_etag
LOCAL lcId
LOCAL lcCreatedDateTime
LOCAL lcLastModifiedDateTime
LOCAL lcChangeKey
LOCAL lcParentFolderId
LOCAL lcBirthday
LOCAL lcFileAs
LOCAL lcDisplayName
LOCAL lcGivenName
LOCAL lcInitials
LOCAL lcMiddleName
LOCAL lcNickName
LOCAL lcSurname
LOCAL lcTitle
LOCAL lcYomiGivenName
LOCAL lcYomiSurname
LOCAL lcYomiCompanyName
LOCAL lcGeneration
LOCAL lcJobTitle
LOCAL lcCompanyName
LOCAL lcDepartment
LOCAL lcOfficeLocation
LOCAL lcProfession
LOCAL lcBusinessHomePage
LOCAL lcAssistantName
LOCAL lcManager
LOCAL lcMobilePhone
LOCAL lcSpouseName
LOCAL lcPersonalNotes
LOCAL j
LOCAL lnCount_j
LOCAL lcStrVal
LOCAL lcName
LOCAL lcAddress
LOCAL lcOdata_context
LOCAL i
LOCAL lnCount_i

lnSuccess = 0

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

loHttp = CreateObject('Chilkat.Http')

* Use your previously obtained access token here: Get Outlook Contacts OAuth2 Access Token (Azure AD v2.0 Endpoint).

loJsonToken = CreateObject('Chilkat.JsonObject')
lnSuccess = loJsonToken.LoadFile("qa_data/tokens/outlookContacts.json")
IF (lnSuccess = 0) THEN
    ? loJsonToken.LastErrorText
    RELEASE loHttp
    RELEASE loJsonToken
    CANCEL
ENDIF

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

* Send the following GET:

* GET https://graph.microsoft.com/v1.0/me/contacts
loSbJson = CreateObject('Chilkat.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://graph.microsoft.com/v1.0/me/contacts",loSbJson)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJsonToken
    RELEASE loSbJson
    CANCEL
ENDIF

lnStatusCode = loHttp.LastStatus
? "Response status code = " + STR(lnStatusCode)

IF (lnStatusCode <> 200) THEN
    ? loSbJson.GetAsString()
    ? "Failed."
    RELEASE loHttp
    RELEASE loJsonToken
    RELEASE loSbJson
    CANCEL
ENDIF

loJResp = CreateObject('Chilkat.JsonObject')
loJResp.LoadSb(loSbJson)
loJResp.EmitCompact = 0
? loJResp.Emit()

* Sample output:

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

* {
*   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('4ee732c3-322e-4a6b-b729-2fd1eb5c6004')/contacts",
*   "value": [
*     {
*       "@odata.etag": "W/\"EQAAABYAAABUcG0qWqkmQYqWLHQataQxAAD0iYfT\"",
*       "id": "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQBGAAAAAAAu7cUXL5YOTrdsUIw7-v8FBwBUcG0qWqkmQYqWLHQataQxAAAAAAEOAABUcG0qWqkmQYqWLHQataQxAAD0sxexAAA=",
*       "createdDateTime": "2021-06-29T16:32:05Z",
*       "lastModifiedDateTime": "2021-06-29T16:32:06Z",
*       "changeKey": "EQAAABYAAABUcG0qWqkmQYqWLHQataQxAAD0iYfT",
*       "categories": [
*       ],
*       "parentFolderId": "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQAuAAAAAAAu7cUXL5YOTrdsUIw7-v8FAQBUcG0qWqkmQYqWLHQataQxAAAAAAEOAAA=",
*       "birthday": null,
*       "fileAs": "",
*       "displayName": "Pavel Bansky",
*       "givenName": "Pavel",
*       "initials": null,
*       "middleName": null,
*       "nickName": null,
*       "surname": "Bansky",
*       "title": null,
*       "yomiGivenName": null,
*       "yomiSurname": null,
*       "yomiCompanyName": null,
*       "generation": null,
*       "imAddresses": [
*       ],
*       "jobTitle": null,
*       "companyName": null,
*       "department": null,
*       "officeLocation": null,
*       "profession": null,
*       "businessHomePage": null,
*       "assistantName": null,
*       "manager": null,
*       "homePhones": [
*       ],
*       "mobilePhone": null,
*       "businessPhones": [
*         "+1 732 555 0102"
*       ],
*       "spouseName": null,
*       "personalNotes": "",
*       "children": [
*       ],
*       "emailAddresses": [
*         {
*           "name": "Pavel Bansky",
*           "address": "pavelb@fabrikam.onmicrosoft.com"
*         }
*       ],
*       "homeAddress": {},
*       "businessAddress": {},
*       "otherAddress": {}
*     },
* ...
*   ]
* }

lcOdata_context = loJResp.StringOf('"@odata.context"')
i = 0
lnCount_i = loJResp.SizeOfArray("value")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcOdata_etag = loJResp.StringOf('value[i]."@odata.etag"')
    lcId = loJResp.StringOf("value[i].id")
    lcCreatedDateTime = loJResp.StringOf("value[i].createdDateTime")
    lcLastModifiedDateTime = loJResp.StringOf("value[i].lastModifiedDateTime")
    lcChangeKey = loJResp.StringOf("value[i].changeKey")
    lcParentFolderId = loJResp.StringOf("value[i].parentFolderId")
    lcBirthday = loJResp.StringOf("value[i].birthday")
    lcFileAs = loJResp.StringOf("value[i].fileAs")
    lcDisplayName = loJResp.StringOf("value[i].displayName")
    lcGivenName = loJResp.StringOf("value[i].givenName")
    lcInitials = loJResp.StringOf("value[i].initials")
    lcMiddleName = loJResp.StringOf("value[i].middleName")
    lcNickName = loJResp.StringOf("value[i].nickName")
    lcSurname = loJResp.StringOf("value[i].surname")
    lcTitle = loJResp.StringOf("value[i].title")
    lcYomiGivenName = loJResp.StringOf("value[i].yomiGivenName")
    lcYomiSurname = loJResp.StringOf("value[i].yomiSurname")
    lcYomiCompanyName = loJResp.StringOf("value[i].yomiCompanyName")
    lcGeneration = loJResp.StringOf("value[i].generation")
    lcJobTitle = loJResp.StringOf("value[i].jobTitle")
    lcCompanyName = loJResp.StringOf("value[i].companyName")
    lcDepartment = loJResp.StringOf("value[i].department")
    lcOfficeLocation = loJResp.StringOf("value[i].officeLocation")
    lcProfession = loJResp.StringOf("value[i].profession")
    lcBusinessHomePage = loJResp.StringOf("value[i].businessHomePage")
    lcAssistantName = loJResp.StringOf("value[i].assistantName")
    lcManager = loJResp.StringOf("value[i].manager")
    lcMobilePhone = loJResp.StringOf("value[i].mobilePhone")
    lcSpouseName = loJResp.StringOf("value[i].spouseName")
    lcPersonalNotes = loJResp.StringOf("value[i].personalNotes")
    j = 0
    lnCount_j = loJResp.SizeOfArray("value[i].categories")
    DO WHILE j < lnCount_j
        loJResp.J = j
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("value[i].imAddresses")
    DO WHILE j < lnCount_j
        loJResp.J = j
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("value[i].homePhones")
    DO WHILE j < lnCount_j
        loJResp.J = j
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("value[i].businessPhones")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcStrVal = loJResp.StringOf("value[i].businessPhones[j]")
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("value[i].children")
    DO WHILE j < lnCount_j
        loJResp.J = j
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("value[i].emailAddresses")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcName = loJResp.StringOf("value[i].emailAddresses[j].name")
        lcAddress = loJResp.StringOf("value[i].emailAddresses[j].address")
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loJsonToken
RELEASE loSbJson
RELEASE loJResp