Claris FileMaker

Run script - Runs a script

Execution behavior - choose how to execute the script

Script parameter - Enter a script parameter. JSON will be stringified if provided

Script - Script name

Find records - Searches for records

Layout - Layout name

Filter - Fields and Find criteria in the following query schema: [ { "<fieldName>": "<fieldValue>", "omit" : "true" ... }, ...]

Limit - The maximum number of records that should be returned. If not specified, the default value is 100.

Skip - The record number of the first record in the range of records

Sort - The sort field specification. Example: [ { "fieldName": "LastName", "sortOrder": "ascend" }, { "fieldName": "FirstName", "sortOrder": "ascend" } ]

Advanced: find records - Searches for records

Table - Select a table

Filter

Select

Sort

Limit - The maximum number of records that should be returned. If not specified, the default value is 100.

Skip - The record number of the first record in the range of records

Advanced: Create record - Creates a new record. Allows you to specify table fields and data to create the record with using JSON.

Table - Select a table

Fields - The fields in the record to specify values for. Fields must already exist in the chosen table. Format as a JSON object.

Advanced: Update record - Updates a record by ID. Allows you specify table fields and data to update the record with using JSON.

Table - Select a table

ID - The ID or External ID of the record to update

Fields - The fields in the record to specify values for. Fields must already exist in the chosen table. Format as a JSON object.

Create table - Creates a table

Fields - The fields of the table

[{ "name": "Company ID", "type": "int", "primary": true }]

Name - The name for the table

Add table fields - Adds fields to a table

Table - Select a table

Fields - The fields of the table

Upload to container - Upload a file to a container field on a layout

Container name - Container field name

Layout - Layout name

Record ID - The ID of the record to edit

File URL - The URL of the file. Content should be less than 100mb

Remove table field - Removes a field from a table

Table - Select a table

Field - The field to remove

Create record - Creates a record

Table - Select a table

Delete record - Deletes a record by ID

Table - Select a table

ID - The ID or External ID of the record to delete

Delete table - Deletes a table by name

Table - Select a table

Get container link - Returns a link to download content in a container field

Layout - Layout name

ID - The ID or External ID of the record to retrieve

Container name - The name of the container field

Get records - Returns a list of records

Table - Select a table

Limit - The number of results to return. Default value: 50.

Example: 50

Skip - The number of results to skip. Default value: 0.

Example: 50

Get tables - Returns a list of tables

Get record - Returns a record by ID

Table - Select a table

ID - The ID or External ID of the record to retrieve

Get table - Returns a table by name

Table - Select a table

Update record - Updates a record by ID

Table - Select a table