(Excel) Outlook Contacts Update (PATCH) a Contact

See more Outlook Contact Examples

Update the properties of an Outlook contact object.

For more information, see https://docs.microsoft.com/en-us/graph/api/contact-update?view=graph-rest-1.0&tabs=http

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

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

Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/outlookContacts.json")
If (success = False) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

http.AuthToken = jsonToken.StringOf("access_token")

' Send the following PATCH:

' PATCH https://graph.microsoft.com/v1.0/me/contacts/{id}
' Content-type: application/json
' Content-length: 1977
' 
' {
'   "homeAddress": {
'     "street": "123 Some street",
'     "city": "Seattle",
'     "state": "WA",
'     "postalCode": "98121"
'   },
'   "birthday": "1974-07-22"
' }

' Build the JSON body of the POST.

' Use this online tool to generate code from sample JSON: 
' Generate Code to Create JSON

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("homeAddress.street","123 Some street")
success = json.UpdateString("homeAddress.city","Seattle")
success = json.UpdateString("homeAddress.state","WA")
success = json.UpdateString("homeAddress.postalCode","98121")
success = json.UpdateString("birthday","1974-07-22")

' We need the ID of the contact to be updated.
' This was available in the response when we created the contact:  Create an Outlook Contact.
' Or you can list contacts to get the ID: List Outlook Contacts).


id = "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQBGAAAAAAAu7cUXL5YOTrdsUIw7-v8FBwBUcG0qWqkmQYqWLHQataQxAAAAAAEOAABUcG0qWqkmQYqWLHQataQxAAD0sxexAAA="
success = http.SetUrlVar("id",id)

' Send the HTTP PATCH

Set resp = http.PText("PATCH","https://graph.microsoft.com/v1.0/me/contacts/{$id}",json.Emit(),"utf-8","application/json",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; resp.StatusCode

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.Load(resp.BodyStr)
jResp.EmitCompact = False
Debug.Print jResp.Emit()

' The send succeeded if the response status code = 201.
If (resp.StatusCode <> 200) Then
    Debug.Print "Failed"
    Exit Sub
End If

' Sample JSON response:

' {
'   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('4ee732c3-322e-4a6b-b729-2fd1eb5c6004')/contacts/$entity",
'   "@odata.etag": "W/\"EQAAABYAAABUcG0qWqkmQYqWLHQataQxAAD0iYu5\"",
'   "id": "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQBGAAAAAAAu7cUXL5YOTrdsUIw7-v8FBwBUcG0qWqkmQYqWLHQataQxAAAAAAEOAABUcG0qWqkmQYqWLHQataQxAAD0sxexAAA=",
'   "createdDateTime": "2021-06-29T16:32:05Z",
'   "lastModifiedDateTime": "2021-06-29T16:57:39Z",
'   "changeKey": "EQAAABYAAABUcG0qWqkmQYqWLHQataQxAAD0iYu5",
'   "categories": [
'   ],
'   "parentFolderId": "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQAuAAAAAAAu7cUXL5YOTrdsUIw7-v8FAQBUcG0qWqkmQYqWLHQataQxAAAAAAEOAAA=",
'   "birthday": "1974-07-22T11:59:00Z",
'   "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": {
'     "street": "123 Some street",
'     "city": "Seattle",
'     "state": "WA",
'     "postalCode": "98121"
'   },
'   "businessAddress": {},
'   "otherAddress": {}
' }

Debug.Print "Contact updated."