Type mapping between Apps Script and AppSheet: Object to Table Ref

[ThibaultM]

Hi peers,

The documentation here states that if my AppScript returns an object I can store it as a "Table Ref with columns for each type".

I cannot find examples of how to set this up.

Here is how I tried to set it up:

Say my object is:

{
a:1234567,
b:something,
config:{
   alpha:123456,
   beta:something,
   gamma:[
      {i:12345, j: Mon Nov 06 00:00:00 GMT-08:00 2023},
      {j:12345, j: Mon Nov 06 00:00:00 GMT-08:00 2023}
      ]
   }
}

I created two tables in my App to act as reference (app sheet dbs), the first being to host the first level object {a: ,b:, config:  } and a second one to host the underlying config object.

I also mapped the return values to Refs to the corresponding table but upon saving, this returned variable (the only object) is never written in the DB although the rest of returned variables are (not objects). 

If anyone has already set up something similar I would gladly get some advice/examples.

[TeeSee1]

I have not worked with this much myself but maybe your object (nested objects) is not yet supported..