FileMaker is a cross-platform relational database application from Claris International.
This component extracts layout data from FileMaker relational databases using the FileMaker Data API.
Create a new configuration of the FileMaker data source connector.
Fill in the required authorization parameters:
base_url
, required) – The FileMaker server host URL.username
, required) – The username for authentication.#password
, required) – The corresponding password.ssl_verify
, optional) – Set to false
to disable SSL (https) certificate verification. Use with caution.Save the configuration and click Add Row to create a new row configuration.
Define the object type to extract and configure storage syncing options.
Download schemas of selected layouts. Provide a list of Database and Layout names to retrieve metadata.
Note: Leave the list empty to retrieve metadata for all available objects.
Download data from a specific layout with a specified query.
Parameters:
database
, optional) – The name of the FileMaker database.layout_name
, optional) – The name of the layout.query
, optional) – Groups of filter criteria.
incremental
) – Defines how the result is stored in Keboola Storage:
pkey
) – List of primary key columns, if available. Required for incremental load.incremental_fetch
) – If true
, only records with values >= to the last incremental field value will be retrieved in consecutive runs.incremental_fields
) – List of columns used for incremental fetching. If multiple specified, an AND relation is applied.page_size
, optional) – The number of records retrieved per API call. Note: A large page size may impact performance on the destination database.Note: Columns prefixed with _
are stored in Keboola Storage with the hsh
prefix in the resulting table. This is because Keboola Storage does not allow columns to begin with an underscore. For example, the column _Timestamp
will be stored as hsh_Timestamp
in the resulting table.
layouts
Columns: [table
, layout_name
, parent_layout_name
]
layout_fields_metadata
columns: [ displayType
,
repetitionEnd
,
numeric
,
maxCharacters
,
maxRepeat
,
fourDigitYear
,
layout_name
,
database_name
,
type
,
repetitionStart
,
autoEnter
,
name
,
global
,
result
,
notEmpty
,
timeOfDay
]
Layout data is extracted based on the query definition provided.