(Excel) Get Individual Photo Info

Assuming we have the ID of a Photo, this example demonstrates how to retrieve the photo information and parse the JSON.

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.

' This example assumes a previously obtained an access token
Dim oauth2 As Chilkat.OAuth2
Set oauth2 = Chilkat.NewOAuth2
oauth2.AccessToken = "FACEBOOK-ACCESS-TOKEN"

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to Facebook...

success = rest.Connect("graph.facebook.com",443,True,True)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Provide the authentication credentials (i.e. the access key)
success = rest.SetAuthOAuth2(oauth2)

' Assumes we've already obtained a Photo ID.

photoId = "10210199026347451"

Dim sbPath As Chilkat.StringBuilder
Set sbPath = Chilkat.NewStringBuilder
success = sbPath.Append("/v2.7/")
success = sbPath.Append(photoId)

' Select the fields we want.
' This example will select many of the possible fields.
' See https://developers.facebook.com/docs/graph-api/reference/photo/
success = rest.AddQueryParam("fields","id,album,can_delete,can_tag,from,height,width,images,link,name,name_tags,picture,place,target")


responseJson = rest.FullRequestNoBody("GET",sbPath.GetAsString())
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
success = json.Load(responseJson)

' Show the JSON in human-readable format.
Debug.Print json.Emit()

' A sample response is shown below.
' Demonstrate how to parse values from the JSON.
Debug.Print "Album name: "; json.StringOf("album.name")

canDelete = json.BoolOf("can_delete")
Debug.Print "Can Delete: "; canDelete
Debug.Print "From Name: "; json.StringOf("from.name")

height = json.IntOf("height")

width = json.IntOf("width")
Debug.Print "Dimensions: "; width; "x"; height
Debug.Print "First Image Source: "; json.StringOf("images[0].source")

' A sample JSON response is shown here.  
' { 
'   "id": "10210199026347451",
'   "album": { 
'     "created_time": "2009-10-19T00:06:46+0000",
'     "name": "Timeline Photos",
'     "id": "1237223526054"
'   },
'   "can_delete": true,
'   "can_tag": true,
'   "from": { 
'     "name": "Matt Smith",
'     "id": "10224048320139890"
'   },
'   "height": 120,
'   "width": 120,
'   "images": [
'     { 
'       "height": 120,
'       "source": "https:\/\/scontent.xx.fbcdn.net\/v\/t1.0-9\/14462791_10210199026347451_7830642117574407060_n.jpg?oh=a7f9ed10cf9cd81a82adeb541c60e2e2&oe=58ABB195",
'       "width": 120
'     }
'   ],
'   "link": "https:\/\/www.facebook.com\/photo.php?fbid=10210199026347451&set=a.1237223526054.2038240.1093202869&type=3",
'   "name": "Ignore my posts -- I'm doing some testing for Facebook related programming...",
'   "picture": "https:\/\/scontent.xx.fbcdn.net\/v\/t1.0-9\/14462791_10210199026347451_7830642117574407060_n.jpg?oh=a7f9ed10cf9cd81a82adeb541c60e2e2&oe=58ABB195"
' }
'