Dear Thunkables,
I’m pretty new to this forum and tried to find an answer to the following problem, but did not find any. So if this was discussed in another post, please let me know.
I successfully managed to build a WebAPI connection to the Online Database QuintaDB.com. In fact I can access a table via GET, a record within this table and read the single fields of the record to display them in my Thunkable app.
My problem is to write back (=update) data in this record. The QuintaDB doc tells me to send a json like this:
{“rest_api_key”:“API_KEY”, “values” => {“aNW4nkW5bdUjldO8oKuSku” : 3, “aMW4HKWR9bnOoGWQbpWQS4” : “b”, “cMW6pcTSjbWOFdTCkBtmkN” : “c”}}
As I cannot send a body using PUT, the only way is to transport the values via the URL. So I build a block as seen here:
(I have to adress the field not via its name but via ‘bCBSov…’)
This does not work right. The ‘?values=’ seems ok because the record is updated. But in the field ‘bCBSov…’ is not ‘Erwin’ as I would like to have but ‘bCBSov…’ as well?! So the name of the field is also written in(!) the field value. I have also tried:
?“values”=>{“bCBSovW6LdNOkaW7iTiCof” : “Erwin”}
?values=>{“bCBSovW6LdNOkaW7iTiCof” : “Erwin”}
?values={“bCBSovW6LdNOkaW7iTiCof” : “Erwin”}
?values=>{“bCBSovW6LdNOkaW7iTiCof”=“Erwin”}
The result is always the same.
I guess I have to find the correct syntax to transmit this json structure. Or is there another way to deal with the ‘generate json from object’? Each suggestion is welcome …