Link to home
Start Free TrialLog in
Avatar of martmac
martmacFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Using http post to post a Facebook update from VBA

Hi,

I have been using http post to interact with a text message service API from within VBA and it works really well. I am aware that Facebook updates can be updated using http post but am struggling to get this to work. It may well be that it is not possible to achieve, hence this post.

From the Graph API this appears to be the http post code

POST graph.facebook.com
  /{user-id}/feed?
    message={message}&
    access_token={access-token}

Open in new window


I have setup an app on Facebook and have all the access tokens etc

Below is a snippet of what I am using to make http post requests to the text service

    Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")
    
    myURL = "https://api.txtlocal.com/send/?"
    postData = "apiKey=" + apiKey + "&message=" + message + "&numbers=" + numbers + "&sender=" + sender
    
    WinHttpReq.Open "POST", myURL, False
    WinHttpReq.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    WinHttpReq.Send (postData)
    
    SendSMS_textlocal = WinHttpReq.responseText

Open in new window


What I am looking to do is if you like, modify what I am using here to use HTTP post to update Facebook.

I am probably barking up the wrong tree and it's not possible, but I thought it worth an ask?  My issue is how to format the request to make the call.

If anyone could help that would be fantastic and much appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Walter Ritzel
Walter Ritzel
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of martmac

ASKER

Apologies, I have been away from work sick, This was very helpful. Thanks
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.