How to create a doPost(e) to receive data from an external service?

Question

I'm trying to create a Script that receives data from a POST that I make from Postman, but every time I get the error code 301. I followed different tutorials (Google Web App and Stack Overflow posts) with not good results. I only need to receive the data from this POST call and send them to a SpreadSheet for their storage.

Thanks for your help, I really appreciate it.

Yes, it is public. I do not know if I need to configure something else :/ — Ricardo Aguilar, Apr 10 '18 at 13:44

score 1 · Answer 1 · answered Apr 10 '18 at 02:15

1

You need to make sure you're following redirects. In Postman, go to your preferences, and make sure you've enabled "Automatically follow redirects".

Alternatively, you can use Hurl.it, which has the redirects option very clearly visible.

answered Apr 10 '18 at 02:15

Diego

9,261
2
19
33

Hi, thanks for your response. I did what you said but I still get the same error. This is the Script URL https://script.google.com/macros/s/AKfycbzuXLBu9Rsq9R51xboIlTkTEqUTKyfJisRboeYkPKAUmp_OUw/exec – Ricardo Aguilar Apr 10 '18 at 13:39
That image isn't viewable – Diego Apr 10 '18 at 13:41
Sorry, here you can see the result I get https://drive.google.com/open?id=1erQmFTkedAuOsAaL8kvrdDZtsvHtm4de – Ricardo Aguilar Apr 10 '18 at 14:06
That's not the same error. It's a 401 unauthorized error. I just visited the link and your app is not public. – Diego Apr 10 '18 at 14:17
Yes, Sorry my bad. Thanks for your help. – Ricardo Aguilar Apr 10 '18 at 14:39

score 0 · Answer 2 · edited Apr 11 '18 at 01:06

0

This link you have commented in one answer : https://script.google.com/macros/s/AKfycbzuXLBu9Rsq9R51xboIlTkTEqUTKyfJisRboeYkPKAUmp_OUw/exec

When I tried opening, it's asking me to Give permissions.

Which means MAYBE you're not "Executing the app as" yourself [me(your email)]. Rather you have selected something else like "User who is accessing"

So if you want to access it via Postman then you need to implement proper authentication or Execute it on your behalf.

Hope this helps you.

enter image description here

edited Apr 11 '18 at 01:06

tehhowch

9,645
4
24
42

answered Apr 10 '18 at 14:34

Umair Mohammad

4,489
2
20
34

Yes, you are right. It works now perfectly. Thank you very much for the help. – Ricardo Aguilar Apr 10 '18 at 14:38
Great to know it helped you! https://stackoverflow.com/help/someone-answers – Umair Mohammad Apr 10 '18 at 14:42

How to create a doPost(e) to receive data from an external service?

2 Answers2

Linked