CODEWITHSUNDEEP
postgoogle-apps-scripthttp-postgoogle-sheets
Vin
Vin

Reputation: 2155

Google Apps Script make HTTP POST

I would like to make an HTTP POST using google apps script. I have found very little documentation on this, maybe someone could kindly help?

The HTTP POST will be to a service called 'Twilio':

https://www.twilio.com/docs/api/rest/sending-sms

The page says I only need three parameters in my POST:

I am hoping that the HTTP Post will invoke Twilio to send an sms.

In the end I want to get these parameters from a google spreadsheet. I can do that myself as I'm fairly comfortable with Apps Script but I've never done an HTTP POST, so for now (and for the sake of simplicity) I'll just type these parameters into the code myself.

If anyone knows how to do this, or make any sort of HTTP POST with Apps Script, please let me know - I've spent hours trying to figure this one out!

Upvotes: 27

Views: 64306

Answers (4)

Vin
Vin

Reputation: 2155

i managed to do it, here's the code:

var url = "https://api.twilio.com/2010-04-01/Accounts/ ...account.SID... /SMS/Messages.json";
var options = {
    "method": "post",
    "headers": {
        "Authorization": "Basic " + Utilities.base64Encode(" ...account.SID... : ...auth.token... ")
    },
    "payload": {
        "From": "+12025551212",
        "To": "+14155551212",
        "Body": "Test from Google Apps Script"
    }
};
var response = UrlFetchApp.fetch(url, options);

Upvotes: 65

Rafael De Alemar Vidal
Rafael De Alemar Vidal

Reputation: 173

I had difficulties using Google App Script HtmlService in the beginning as well. Check for the fully functional basic example that I made on how to use Htmlservice. In this example you can post a form, display the posted information on a second page, and navigate between pages.

https://script.google.com/macros/s/AKfycby-tsWP8GiVj9KxdZa2KtIcEIh9zfaCaG_iCtayydhg-6G-rsc/exec

if you want to see the code just access the link bellow. Make a copy to yourself and don't forget to change the link to your script on line 50 (Codigo.gs)

https://script.google.com/macros/d/MWH5NC4RbgzryH_Ut-1zVe3Ow4ZzbpCe7/edit

Upvotes: 1

Waqar Ahmad
Waqar Ahmad

Reputation: 3732

I think, you are missing the authorization part. Look at these two links, this might be helpful to you. https://www.youtube.com/watch?feature=player_embedded&v=j0wjM1Ds3lc https://github.com/entaq/GoogleAppsScript/tree/master/Twilio

Upvotes: 1

Sebastian Kreft
Sebastian Kreft

Reputation: 8189

Take a look at the UrlFetchApp class. Also you probably need to pass some sort of authentication parameters to the API.

Upvotes: 2

Related Questions