I have some calls in AppScript to find records with the AppSheet API, but there's one that has been "Failing" lately. It doesn't return an error, but an empty array. Data source is Google Sheets
{
"Action":"Find",
"Properties":{
"Selector":"Filter('Products', [UniqueId]='7a9a4175')"
},
"Rows":[]
}
It is weird because it has always (several months) been working great, and now time to time fail with some records. Ids are generated with UNIQUEID(). It works with most of the records, but sometimes it fails with no apparent reason.
Sometimes it got fix after manually changing the Id, like adding an extra character and if doesn't work, I have to change the entire Id, but that isn't a great solution. It also mess up sync with external resources because didn't find anything even though id is correct and existing.
LinkedIn
Twitter
