Actions7
- Script Actions
- Record Actions
- Metadata Actions
Metadata → Get Value List Items
AI-generatedOverview
The node "FileMaker OttoFMS" is designed to interact with the FileMaker OttoFMS DataAPI Proxy. Specifically, for the Metadata resource and the Get Value List Items operation, it retrieves items from a specified value list within a FileMaker database. This functionality is useful when you need to dynamically fetch predefined lists of values (value lists) that are used in FileMaker fields, enabling workflows that depend on these lists for validation, selection, or further processing.
Practical examples include:
- Fetching a list of product categories stored as a value list to populate dropdown menus in other applications.
- Retrieving status options defined in FileMaker to ensure consistent data entry across integrated systems.
- Using value list items to validate incoming data against allowed values before inserting or updating records.
Properties
| Name | Meaning |
|---|---|
| Value List Name | The name of the value list to retrieve items from. This must match an existing value list defined in the FileMaker database. |
Output
The node outputs JSON data containing the items retrieved from the specified value list. The structure typically includes an array of values representing each item in the value list. This output can be used directly in subsequent workflow steps for filtering, mapping, or decision-making.
If the node supports binary data output (not indicated here), it would represent any file or media content returned by the API, but for this operation, the focus is on JSON data representing value list items.
Dependencies
- Requires connection to a FileMaker OttoFMS DataAPI Proxy instance.
- Needs an API key credential configured in n8n to authenticate requests to the FileMaker OttoFMS service.
- The FileMaker database must have the relevant value lists defined and accessible via the API.
Troubleshooting
Common issues:
- Incorrect or misspelled value list name will result in no data or an error response.
- Authentication failures if the API key credential is missing or invalid.
- Network connectivity problems between n8n and the FileMaker OttoFMS proxy.
Error messages:
- Errors indicating "value list not found" suggest verifying the exact name of the value list in FileMaker.
- Authentication errors require checking the API key configuration.
- Timeout or connection errors may need network troubleshooting or proxy availability checks.
Links and References
- FileMaker OttoFMS DataAPI Proxy documentation (refer to official FileMaker or OttoFMS resources).
- n8n documentation on creating and using API credentials.
- FileMaker value list concepts and management guides.