(Excel) Read a Single Facebook Post

Demonstrates how to read the contents of a single Facebook post. A post is an individual entry in a profile's feed. The profile could be a user, page, app, or group.

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)

' This example assumes a post id was already retrieved.
' For example, it could've been retrieved by reading the user's feed:
' See Parsing the Facebook User Feed for code showing how to parse the JSON feed content.


postId = "10224048320139890_10210156138515282"

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

' Select the fields we want.
' This example will select almost all the possible fields.
' See https://developers.facebook.com/docs/graph-api/reference/post/
success = rest.AddQueryParam("fields","id,message,created_time,caption,description,from,link,name,object_id,picture,place,privacy,properties,shares,source,status_type,story,targeting,to,type,updated_time,with_tags")


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 JSON response is shown here.  
' { 
'   "id": "12345678901234567_12345678900000004",
'   "message": "Ignore my posts -- I'm doing some testing for Facebook related programming...",
'   "created_time": "2016-09-29T20:46:18+0000",
'   "from": { 
'     "name": "John Doe",
'     "id": "12345678901234567"
'   },
'   "link": "https:\/\/www.facebook.com\/photo.php?fbid=10210199026247451&set=a.1237223526054.2038240.1094202869&type=3",
'   "object_id": "10210139026347451",
'   "picture": "https:\/\/scontent.xx.fbcdn.net\/v\/t1.0-9\/14462791_10210199026647451_7830642117574407060_n.jpg?oh=a7f9ed10ce9cd81a82adeb541c60e2e2&oe=58ABB195",
'   "privacy": { 
'     "allow": "",
'     "deny": "",
'     "description": "Public",
'     "friends": "",
'     "value": "EVERYONE"
'   },
'   "status_type": "added_photos",
'   "type": "photo",
'   "updated_time": "2016-09-29T20:46:18+0000"
' }

' This is the code to parse some fields in the JSON response.
Debug.Print "type: "; json.StringOf("type")
Debug.Print "message: "; json.StringOf("message")
Debug.Print "id: "; json.StringOf("id")
Debug.Print "link: "; json.StringOf("link")
Debug.Print "privacy descripton: "; json.StringOf("privacy.description")

Dim dtime As Chilkat.CkDateTime
Set dtime = Chilkat.NewCkDateTime

bLocalTime = True
success = dtime.SetFromTimestamp(json.StringOf("created_time"))

Set dt = dtime.GetDtObj(bLocalTime)
Debug.Print dt.Month; "/"; dt.Day; "/"; dt.Year; "  "; dt.Hour; ":"; dt.Minute