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 · Answer 1 · 2020-11-26T09:06:33.840

3

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 '20 at 09:06

answered Nov 26 '20 at 08:56

Eldhose Elias

389
1
6
22

did you write a doPost(e) method? – Aerials Nov 26 '20 at 09:02
@Aerials Yes.. I'm using doPost(e) function – Eldhose Elias Nov 26 '20 at 09:04
1

Is there another alternative/work around ? if someone doesn't need to use redirection? – Dimitris Tsarouhas Jan 05 '23 at 16:54
@DimitrisTsarouhas you can use HTMLService – newbie Jun 16 '23 at 11:11

How to avoid redirection in google-sheet app script

1 Answers1

Linked