First of all: I'm able to access my sheet this way - just tried it in the browser. Many thanks!
To tell my little horror story from tonight: Since I've never used that API before I had no idea which way to add that cell range. But I remembered the line of your former posting:
$sheetsURL = "https://sheets.googleapis.com/v4/spreadsheets/1bH6LmIsDQQdd1Beiq1s9fI-SuYRoGYmBc-_IYrpux_g/basic/A1%3AB40?key=key";
basic/A1%3AB40 didn't work - returning a 404 error. So I tried it without range, and in fact I received JSON this time, returning some nice general information about my sheet, but no data. :(
Okay, wrong approach I thought - time to study the API docs. And unfortunately I landed on https://developers.google.com/sheets/api/guides/concepts. Actually, doing it like that returned my data for the first time
"stringValue": "Lips, Botox"
Yeah, and JSON decoding this baby gives a nested array you wouldn't want to process. And that's where I gave up.
I'd really appreciate if you could tell me the link to the Google page
where stuff like
/values/ is documented.
Aside from that (having a look into your form):
It's not necessary (and just eating up memory) to create a new object more than once. See http://php.net/manual/en/language.types.object.php
It's sufficient to do a
$component = new OssnComponents;
$settings = $component->getSettings('COMPONENT');
one time in the beginning, as
$settings will be valid til the end of your code, and you can just do a
$settings->setting1 ... $settings->setting2 .... $settings->settingN later inside of your html