Google Sheets webscript: How to set a response code

Question

I've seen many links of how to GET a response code, but is there a way, within the webscript of the Google Sheet, to SET a response code if a condition fails? e.g.

if(webscriptSharedToken != AUTH_TOKEN) {
    return setStatusCode(401); 
}

The idea would be to use this returned error code to prevent certain functions within the application I'm creating.

ziganotschka · Accepted Answer · 2020-03-18 09:51:27Z

1

If you are making a request to a Google API, that is you call a server side method - you will obtain a HTTP Response coming from the server side - you cannot manipulate this response on the client side.

answered Mar 18, 2020 at 9:51

ziganotschka

26.9k2 gold badges18 silver badges34 bronze badges

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

4 Comments

Michael T Over a year ago

Would there be any way to return something similar? A string or something.

ziganotschka Over a year ago

What exactly do you want to do, which language are you using and to where do you want to return a response? To the browser window?

Michael T Over a year ago

I am creating a Flutter app (therefore Dart language), and using the Google Sheet webscript to read/write data to/from the Google sheet. I want to return SOMETHING (string/response/true/false) back to the Flutter app in order to allow or deny certain app functions.

ziganotschka Over a year ago

I assume you are calling a function within which data is read / written. You can implement a return value into your function. You can assign the response code you obtain from your request to a variable and use it as your return value.

Collectives™ on Stack Overflow

Google Sheets webscript: How to set a response code

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related