Hi, I am wondering how null cell values are structured in query results.
For example, when I iterate over the query results from a selectRecordsAsync() function, e.g. with a .forEach(map(x => {...})) function, when I hit a null value, the script errors. It’s easy enough to skip over these null values by wrapping the functionality in condiional e.g. if (x !== null) {...} but how do the arrays containing the query results represent the null values?
Are the null values empty objects, or empty array indexes?
I tried to emulate the data structure in node:
> let m = [{}, {id: 1}, {id: 2}, {}, {}, {id: 3}] // <-- empty objects
> console.log(m.map(a => a.id))
[ undefined, 1, 2, undefined, undefined, 3 ]
> let p = [, {id: 1}, {id: 2}, , , {id: 3}] // <-- empty indexes
> console.log(p.map(b => b.id))
[ <1 empty item>, 1, 2, <2 empty items>, 3 ]
Is what node reports as <# empty item(s)> a null value, i.e. is the query result returning an array of objects where there exists values, but empty array indexes where there are not? Or, am I misconceiving the data structure for field values?
The following is an example of the code used to produce these null errors:
// Load the Example table object
let table = base.getTable("Example Table");
console.log(table); // <-- the whole table as a single object of id, name, description, url, fields
console.log(Array.isArray(table)); // <-- false
// Query for all the record objects from the table
let query = await table.selectRecordsAsync({
sorts: [
{field: "Created"}
],
fields: [
"Linked Field" // <-- a linked field on the table which allows for multiple record links
]
});
console.log(query); // <-- "{recordIds: Array(#), records: Array(#)}" a single object containing two keys, each with a value which is an array of a) recordID objects {id: "strings"} and b) an array of record objects {id: "string", name: "string"}
console.log(Array.isArray(query)); // <-- false
// Grab the objects in the records array
let exampleTableRecords = query.records;
console.log(exampleTableRecords); // <-- "(#) [Object, Object, Object, ...]" an array of all of the table's record objects {id: "string", name: "string"}
console.log(Array.isArray(exampleTableRecords)); // <-- true
// Iterate over the query results for each record's "Linked Field" values
exampleTableRecords.forEach(q => {
let exampleFieldArray = q.getCellValue("Linked Field");
console.log(exampleFieldArray); // <-- null OR "(#) [Object, Object, Object, ...]"
console.log(JSON.stringify(exampleFieldArray)); // <-- "null" OR "[{"id":"rec...","name":"..."},{"id":"rec...","name":"..."}, ...]"
console.log(Array.isArray(exampleFieldArray)); // <-- false on null values OR true
console.log(exampleFieldArray.map(m => m.id)); // <-- this will error on null values OR "(#) [array of RecordIDs, ..., ...]"
// let fieldArrayIDs = exampleFieldArray.map(r => r.id);
})
Error msg:
TypeError: null is not an object (evaluating 'exampleFieldArray.map')
