Good afternoon, please help me fix the doGet code

[Avito Bot]

Good afternoon, please help me fix the doGet code
https://script.google.com/macros/s/AKfycbzuXtq85SiH69pzNNoyWn-tRSLRGqm2JE5Cy5Bk7bO4gc39K7A3EkrNPvisAPQMvnWu/exec?word=%D0%90%D0%B1%D0%B0%D1%81

Exception: An error occurred when calling the openById method or property for the "SpreadsheetApp" object. (line 3, file code)

function doGet(e) {
  var wordToCheck = e.parameter.word;
  var spreadsheet = SpreadsheetApp.openById('1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI');
  var sheet = spreadsheet.getSheetByName('price');

  var data = sheet.getRange('A:A').getValues();
  for (var i = 0; i < data.length; i++) {
    if (data[i][0] === wordToCheck) {
      return ContentService.createTextOutput('1');
    }
  }

  return ContentService.createTextOutput('0');
}

[Brett Grear]

That usually means the Id doesn't exist or you don't have access to it.

How is the webapp executed? As you or the person using it?

Also, have you set the appscript.json manifest yourself or was it auto created? openById() required the /spreadsheets permission as opposed to the /spreadsheets.currentonly

[Avito Bot]

appscript.json no my

четверг, 2 ноября 2023 г. в 13:54:18 UTC+3, Brett Grear:

[Brett Grear]

?

Kind regards,

Mr Grear

St Vincent's Primary School

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/9j1QzTW0V74/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ea749202-fd9f-42f9-981e-61efe063dc66n%40googlegroups.com.

[Avito Bot]

I didn't create this file appsscript.json

четверг, 2 ноября 2023 г. в 14:08:15 UTC+3, Brett Grear:

[Avito Bot]

I gave access, what else do I need to do?

четверг, 2 ноября 2023 г. в 13:54:18 UTC+3, Brett Grear:

That usually means the Id doesn't exist or you don't have access to it.

[Brett Grear]

The code you provided above is correct but when I opened your script the Id provided in openById() is 'AKfycbzuXtq85SiH69pzNNoyWn-tRSLRGqm2JE5Cy5Bk7bO4gc39K7A3EkrNPvisAPQMvnWu'

Try using as your code pasted originally says

'1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI' as the Id instead

[Avito Bot]

Так?
https://script.google.com/macros/s/1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI/exec?word=%D0%90%D0%B1%D0%B0%D1%81

четверг, 2 ноября 2023 г. в 19:42:29 UTC+3, Brett Grear:

[Avito Bot]

четверг, 2 ноября 2023 г. в 20:14:31 UTC+3, Avito Bot:

[Brett Grear]

I don't understand Russian but that is the id of the webapp. Not the Sheet.  SpreadsheetApp.openById() access a Spreadsheet, not a webapp.

Seeing as you've changed the code, you need to deploy a new version before the exec url will access the new code.

Click the drop down and select new version and give it a description.

[Avito Bot]

I selected a web application and gave access to everyone

четверг, 2 ноября 2023 г. в 20:42:48 UTC+3, Brett Grear:

[Avito Bot]

https://sheets.googleapis.com/v4/spreadsheets/1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI/values/exec?word=Абас?majorDimension=COLUMNS&key=API

{ "error": { "code": 400, "message": "Invalid JSON payload received. Unknown name \"word\": Cannot bind query parameter. Field 'word' could not be found in request message.", "status": "INVALID_ARGUMENT", "details": [ { "@type": "type.googleapis.com/google.rpc.BadRequest", "fieldViolations": [ { "description": "Invalid JSON payload received. Unknown name \"word\": Cannot bind query parameter. Field 'word' could not be found in request message." } ] } ] } }

четверг, 2 ноября 2023 г. в 21:25:02 UTC+3, Avito Bot:

[Avito Bot]

https://sheets.googleapis.com/v4/spreadsheets/1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI/values/price!A:A2?majorDimension=COLUMNS&key=API

{ "range": "price!A2:A40001", "majorDimension": "COLUMNS", "values": [ [ "МетПромИнтекс Екатеринбург", "MGP Metall", "VD.MARKET", "Абас", "АвиаПромСталь", "АНЭП-Металл Екатеринбург", "АО АМК-Групп" ] ] }

четверг, 2 ноября 2023 г. в 21:31:17 UTC+3, Avito Bot:

[Avito Bot]

function doGet(e) {

  var wordToCheck = e.parameter.word;

  var spreadsheet = SpreadsheetApp.openById('1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI');

  var sheet = spreadsheet.getSheetByName('price');

  var data = sheet.getRange('A:A2').getValues();

[Avito Bot]

четверг, 2 ноября 2023 г. в 21:39:30 UTC+3, Avito Bot:

[Brett Grear]

What is it you are trying to do?

The webapp URL is from the deployment page, it starts script.google... and ends /exec?word=ABC

You don't need any other parameters or script properties

[Avito Bot]

But why doesn't it work?

https://script.google.com/macros/s/AKfycbzuXtq85SiH69pzNNoyWn-tRSLRGqm2JE5Cy5Bk7bO4gc39K7A3EkrNPvisAPQMvnWu/exec?word=%D0%90%D0%B1%D0%B0%D1%81

https://docs.google.com/spreadsheets/d/1GPJMQT7NSrtbwdpq1bBj9xJdhb4i5-1nPkSENIsDeMI/edit#gid=0

четверг, 2 ноября 2023 г. в 22:08:03 UTC+3, Brett Grear:

[Brett Grear]

What is the webapp supposed to do?

What does this mean? %D0%90%D0%B1%D0%B0%D1%81

What error are you getting?

That exec url looks correct

[Avito Bot]

When requesting, it should receive 1 in response, since the value ABC is available
And 0 if there is no value

https://script.google.com/macros/s/AKfycbzuXtq85SiH69pzNNoyWn-tRSLRGqm2JE5Cy5Bk7bO4gc39K7A3EkrNPvisAPQMvnWu/exec?word=ABC

But instead I get an error

Exception: An error occurred when calling the openById method or property for the "SpreadsheetApp" object. (line 3, file code)

четверг, 2 ноября 2023 г. в 23:18:08 UTC+3, Brett Grear:

[Avito Bot]

Good morning

четверг, 2 ноября 2023 г. в 23:18:08 UTC+3, Brett Grear:

[Avito Bot]

please help me

пятница, 3 ноября 2023 г. в 11:14:09 UTC+3, Avito Bot:

[Avito Bot]

Good morning

четверг, 2 ноября 2023 г. в 23:18:08 UTC+3, Brett Grear:

[Avito Bot]

good evening

четверг, 2 ноября 2023 г. в 23:18:08 UTC+3, Brett Grear:

[Brett Grear]

What is the final purpose of your web app? What are you trying to achieve?

[Avito Bot]

Send a GET request to Apps Script
/exec?word=Text test1
The script should check if there is a string with the value Text test1
If the written is present, Apps Script will answer 0
If the written is missing, Apps Script will add Text test1 to a new line and answer 1

суббота, 4 ноября 2023 г. в 20:54:32 UTC+3, Brett Grear:

[Brett Grear]

No I mean why are you trying to do it

[Avito Bot]

I want to understand whether Google can accept data through a GET request and respond to me if such data is already available

воскресенье, 5 ноября 2023 г. в 01:42:17 UTC+3, Brett Grear:

[Avito Bot]

Good morning

воскресенье, 5 ноября 2023 г. в 01:42:17 UTC+3, Brett Grear:

No I mean why are you trying to do it

[Andrew Apell]

You do not need to keep posting "Good morning" and "Good evening" every day.

Your post will be seen and answered by those who can.

[Avito Bot]

Good evening OK

But so far no one has helped

понедельник, 6 ноября 2023 г. в 17:29:42 UTC+3, Andrew Apell:

[Avito Bot]

No one could help me for a week
And I found the solution myself
If you are interested, write and I will tell you how it was

Да ладно вот вам решение:

понедельник, 6 ноября 2023 г. в 20:26:23 UTC+3, Avito Bot:

[Andrew Apell]

Welcome to the club!
I have also posted questions here numerous times but ended up getting the answer myself. It is a common occurrence.

[Avito Bot]

Got angry and found a solution through AI

Thank you for pissing me off, otherwise I would have waited another week

понедельник, 6 ноября 2023 г. в 22:12:18 UTC+3, Andrew Apell: