How to avoid redirection in google-sheet app script

Question

I have created a Google Sheet App Script and published as web app. https://script.google.com/macros/s/AKfycbyqUxINw93wmWPouXb7nOjt2886FBj6HBKg9sMF1B4rMN0I1xFG/exec

While i tried to POST data to this url, it's redirect to another URL. How i can avoid this redirection.?

Eldhose Elias · Accepted Answer · 2020-11-26 09:06:33Z

4

Don't use ContentService. if you are using ContentService for returning JSON data. it will redirect to another URL. That's why your are getting 302 response.

return ContentService.createTextOutput(JSON.stringify(result)) .setMimeType(ContentService.MimeType.JSON);

https://developers.google.com/apps-script/guides/content#redirects

edited Nov 26, 2020 at 9:06

answered Nov 26, 2020 at 8:56

Eldhose Elias

4492 gold badges8 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Aerials Over a year ago

did you write a doPost(e) method?

Eldhose Elias Over a year ago

@Aerials Yes.. I'm using doPost(e) function

Dimitris Tsarouhas Over a year ago

Is there another alternative/work around ? if someone doesn't need to use redirection?

newbie Over a year ago

@DimitrisTsarouhas you can use HTMLService

Dan Cancro Over a year ago

@newbie, I tried that and got a bunch of html and javascript and not the content I entered into HtmlService.createHtmlOutput()

|

Collectives™ on Stack Overflow

How to avoid redirection in google-sheet app script

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related