Data Manipulation

Function Description
ftos.data.insert Adds a new record to an entity.
ftos.data.update Updates attribute values for a specific record.
ftos.data.delete Deletes a specific record from an entity based on its ID.
ftos.data.getById Returns a record's data based on its ID and parent entity.
ftos.data.getByQuery Returns a fetch result set.

ftos.data.getByQueryAndCache

Returns a fetch result set from cache.

ftos.data.updateBusinessUnit Updates a record's associated business unit.
ftos.data.executeDbTask Executes a database stored procedure that has been registered as a DB task in FintechOS Studio.
ftos.data.importFile Imports entity data from an Excel file (based on a data import template).