Posting to facebook from json on google apps script

Question

i have de following .gs code

function updateStatus(){
var myId="100006898720726";
var myAppAccess_token="APP-ID|APP-SECRET";
var graphUrl="https://graph.facebook.com/"+myId+"/feed";
var theDate=new Date().toString();
UrlFetchApp.fetch(graphUrl,{method:"post",payload:{
message:"foo\n"+theDate,
access_token:myAppAccess_token
}});
}

AND y have a JSON URL http://pipes.yahoo.com/pipes/pipe.run?_id=a6c5eeff220e55a4fe9607065384817a&_render=json

i want to publish to facebook every new item with description and link

i've tried several ways but the google console always shows something wrong

thanks in advance

Answer 1

The biggest problem is that you are adding the payload to the options, and the message to be posted to Facebook must be part of the Facebook URL. I updated your code at the bottom of the answer.

Here is what I use:

function fncPostSecurly_(argToPost) { //argToPost is the message to post to Facebook that is passed to this function.
  Logger.log("fncPostSecurly ran: " + argToPost);

  var sttsUpdate = argToPost + "your text to post here" + argToPost;
  var fromLogInTkn = cache.get('fbTkn'); // Get facebook token that was stored in cache

  Logger.log("cache FB token: " + fromLogInTkn);

  //This is added security https://developers.facebook.com/docs/graph-api/securing-requests/
  var appsecret_sig = Utilities.computeHmacSha256Signature(fromLogInTkn, "YourAppSecret");
  var optnPostFB = {"method" : "post"};  //
  var PostToFB_URL = "https://graph.facebook.com/FacebookPageOrGroupID/feed?message=" + sttsUpdate + "&access_token=" 
    + fromLogInTkn;


    //Make a post to the Page
    var whatHappened = UrlFetchApp.fetch(PostToFB_URL, optnPostFB );

    //The return from facebook is an object.  Has to be converted to a string.
    var strFrmFbObj = whatHappened.getContentText();
    Logger.log("Return value of Post: " + strFrmFbObj);

    //When a post is successfully made to Facebook, a return object is passed back with an id value.

    var rtrnVerify = strFrmFbObj.indexOf('{\"id\":\"');
    Logger.log("rtrnVerify: " + rtrnVerify);

    if (rtrnVerify != -1) {
      return true;
    } else {
      return false;
    };
 };

I think you need a question mark after /feed, like this:

var graphUrl="https://graph.facebook.com/"+myId+"/feed?";

Also, the content to get posted to Facebook is part of the URL. You are adding the content to be posted to the payload. That's the wrong place to put it.

Fetch takes two parameters. The second parameter can only be: {"method" : "post"}

You've got:

{method:"post",payload:{
  message:"foo\n"+theDate,
  access_token:myAppAccess_token
}}

Again, you can't add the payload to the options. The payload must be part of the URL. That's how Facebook processes the info using the API.

Updated code:

function updateStatus(){
  var myId="100006898720726";

  var myAppAccess_token="APP-ID|APP-SECRET";
  var graphUrl=  "https://graph.facebook.com/" + myId+ "/feed?message=" + "foo\n" + theDate + "&access_token=" 
    + myAppAccess_token;

  var theDate=new Date().toString();

  var optnPostFB = {"method" : "post"};
  UrlFetchApp.fetch(graphUrl, optnPostFB);

}

Answer 2

• Never post any Access Token. the App Secret is called Secret for a reason. I have edited and removed the App Secret, not sure if it´s in any change history though.
• You can´t post anything with an App Access Token, you need a User Token with the publish_actions permission to post to a User profile
• publish_actions initially only works for Users with a role in the App (Admin, Developer, Tester). If you want to go public, you have to go through a review process first.
• The message always must be 100% User generated and you are not allowed to "autopost". Every single post has to be approved by the User. See the platform policy for more information.

Information about Facebook Login: https://developers.facebook.com/docs/facebook-login

Here´s a solution that is actually allowed on Facebook and does not even required User authorization: https://developers.facebook.com/docs/sharing/reference/share-dialog