I've run into a bit of trouble that I think is being called by dashes in Row IDs (which appsheet is handling). Here's my setup:
I have a table of People, all of whom have a related table of Subscriptions.
A call, via appsheet api, to find a record of People works -- I can do so by either having the Row ID, or I can search myself by making a call and using something like: "Selector": "Filter(People, [Email]=blah@blah.com)",
What I've noticed, though, is that when these People records get returned, sometimes data is missing. Like name phone email will all be there but sometimes the "Related [Name of Table]" field is empty, including for my Subscriptions table.
This only seems to be the case if the column you're using to search of the subscription, in the Subscriptions table, happens to have a dash in it. Without dashes return properly.
Additionally, an API call to the Subscriptions table, with a selector like this:
"Selector": "Filter(Subscriptions, [Person]=r-m-TNixN34IEoUFJNBSLa)",
[note: I can see from appsheet, the database, or a 'show data' look, that r-m-TN... IS in fact the proper entry in the column]
runs successfully but returns empty.
The identical API call
"Selector": "Filter(Subscriptions, [Person]=i_eViD_cLF4Qa20QK5P0f4)",
returns properly the record.
Is there something going on with dashes? Something obvious I'm missing? It seems to be why sometimes when I make calls I get empty results "for no reason"
LinkedIn
Twitter
