Getting Started
- Deploy Formulize to your website
- Setup a local development environment
- Use Formulize with AI
- See the Roadmap
Professional Services
Help and Documentation
get_entries_from_form
Standard MCP tool.
Retrieve entries from a form with optional filtering, sorting, and pagination. Supports both simple entry ID lookup and complex multi-condition filtering. Returns data in a structured format suitable for analysis or display. It is strongly recommended to use filtering to limit the results you get back, so that it doesn’t return too many entries at once. You can filter by multiple elements at once, and you should when possible, to reduce the size of the dataset amd exclude irrelevant entries. You can filter for non-blank values with the “{BLANK}” search term.
Examples:
- Get specific entry: {“form_id”: 5, “filter”: 526}
- Search by name: {“form_id”: 5, “filter”: [{“element”: “name”, “operator”: “LIKE”, “value”: “John”}]}
- Get all the entries with a non-blank value in the “email” field: {“form_id”: 5, “filter”: [{“element”: “email”, “operator”: “!=”, “value”: “{BLANK}”}], “limitSize”: null}
- Multiple conditions: {“form_id”: 5, “filter”: [{“element”: “age”, “operator”: “>=”, “value”: “18”}, {“element”: “status”, “operator”: “=”, “value”: “active”}], “and_or”: “AND”}
Properties
| Property | Type | Required? | Description |
|---|---|---|---|
| form_id | integer | Required | Required. The ID of the form to query. Use list_forms tool to find form IDs. |
| elements | array of string | Required | Required. An array of element handles to include in results. Get valid handles from the get_form_details tool. Only include the elements you need, to minimize the amount of data returned. You do not need to specify metadata elements, like entry_id and creation_datetime because metadata is always included in the results. Elements from connected forms can be included, if the ‘relationship_id’ property is set to -1. |
| filter | integer or array of object | Optional | |
| and_or | string (one of: AND, OR) | Optional | Logical operator between multiple filter conditions. Default: AND |
| limitSize | integer or null | Optional | |
| limitStart | integer or null | Optional | |
| sortField | string | Optional | Element handle to sort by. Get valid handles from get_form_details tool. |
| sortOrder | string (one of: ASC, DESC) | Optional | Sort direction. Default: ASC (ascending) |
| relationship_id | integer | Optional | Optional. Defaults to 0 which means only data from the requested form is included. Can be set to -1 to include data from the requested form and all forms connected to it, but this is only required if the ‘elements’ property or the ‘filter’ property reference elements from connected forms. |