2

I created a Google Spreadsheet and created a bound Google Script (Tools > Script Editor) and then published as a Web App.

The docs (https://developers.google.com/apps-script/guides/web) say that I can add parameters to my script url however they don't work and just display a Google error page. The only parameter that works is prefix

Example of a parameter(error): https://script.google.com/macros/s/AKfycbxCTsVDtE89J4FzV_mx-svHkGtRof7L3qg9iKtQgpGgcn6cbbI/exec?pid=1

Example of using prefix(works): https://script.google.com/macros/s/AKfycbxCTsVDtE89J4FzV_mx-svHkGtRof7L3qg9iKtQgpGgcn6cbbI/exec?prefix=testFunction

Example of a parameter with and the prefix parameter(error): https://script.google.com/macros/s/AKfycbxCTsVDtE89J4FzV_mx-svHkGtRof7L3qg9iKtQgpGgcn6cbbI/exec?pid=1&prefix=testFunction

Improve this question
3
  • 2
    Parameters work just fine.. you just find one that can't be used: "pid". Try any other. Commented Sep 4, 2015 at 13:52
  • @HenriqueAbreu ah wow! good pick up. This should be in the docs. Commented Sep 4, 2015 at 15:18
  • Yes, I agree. There's probably others in that "blacklist" too. Commented Sep 4, 2015 at 16:21

2 Answers 2

Reset to default
2

It seems that there are reserved parameters and Google has stated they will not fix this. I can't find a list but I know these do not work:

  • c
  • sid
  • pid
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

file also seems to be reserved

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.