Bad Value When Trying To Execute Google Apps Script

I am trying to execute a simple Apps script to retrieve data from my google sheet. However, I get the error: Bad value (line 2, file 'Code', project 'Untitled project') when I past

Solution 1:

From your question, it seems that you have changed the code but you have not republished it with latest version, so when you "test web app for your latest code", it works fine but when you use your publishing link, it crashes.

go to : publish > deploy as webapp > select project version to new and update the project.