It appears that the internal Appsheet database does not allow setting [Row ID] within lets say Apps Script and using the API. If I add rows without setting the [Row ID] in the payload, the rows get added, however if I set a [Row ID] within the payload then I receive an error.
Could someone clarify the functionality regarding this please. I have a use case that really requires using Apps Script and the API to generate new records and adding single rows then getting the [Row ID] to set a reference column for new records in another table takes too long for the script to execute and results in other unwanted errors. So generating my own keys and then bulk adding with those generated keys does not work either due to some system limitation apparently.
LinkedIn
Twitter
