Avatar of martmac
martmac
Flag 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.
Visual Basic ClassicFacebookHTTP ProtocolMicrosoft AccessVB Script

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Walter Ritzel

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
martmac

ASKER
Apologies, I have been away from work sick, This was very helpful. Thanks
Martin Liss

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23