Execute Data API - Stateless CRUD
Continuing from a previous video that introduced the Execute FileMaker Data API script step, this video explores the remaining CRUD operations added in FileMaker 21+.
With the create, update, duplicate, and delete actions, we can now leverage more stateless data operations thanks to direct write access to tables.
This video walks through the new write capabilities of the Execute FileMaker Data API script step. Along the way, we’ll also share tips and tricks for writing Custom Functions and explore how to take advantage of CRUD options using plug-ins, such as the popular MBS plug-in.
Comments
Stateless CRUD speed
Hi, how does the speed compare to import ?
Import will be faster
In most cases, if your data is already within a file like csv or tab, then an import will be much faster.
Using the Data API step is more for your UI work than raw data manipulation. If you don't have a complex transaction touching multiple tables, and just need to create or update records, then is is a wonderful method for doing so easily without having to write a script which navigates from the current context.
If the process is working across many records and dealing with many different fields, then it would be a toss up as to which method I would use for updating.
There are just so many different ways to manipulate the data within FileMaker, it always comes down to use case.
-- Matt Petrowsky - ISO FileMaker Magazine Editor