Hi All, I'm using a custom record (CusRec) as a table for field mapping. Each record in CusRec will have 1 field from Record A and 1 corresponding field from Record B. Is there a way to load all records in CusRec so I can loop through using SuiteScript to get the mapping? Record.load & search.lookupfields all need id param but I want to load all the records in that CusRec.

You could use SuiteQL for that.

const sql = `SELECT * FROM CustRec WHERE isInactive = 'F'`;
                            const resultSet = query.runSuiteQL({query: sql});
                            const sqlResults = resultSet.asMappedResults();

thank you!