Actions6
- Database Actions
- Database Row Actions
Overview
This node integrates with the AppFlowy API to interact with workspaces, databases, and database rows. Specifically for the Database - Get Many operation, it retrieves multiple databases within a specified workspace. This is useful when you want to list or process all databases available in a particular workspace.
Common scenarios include:
- Automating workflows that need to fetch all databases from a workspace to perform batch operations.
- Synchronizing database metadata with other systems.
- Displaying available databases dynamically in user interfaces or reports.
Example: You have a workspace containing several project databases, and you want to retrieve all of them to analyze or export their structure.
Properties
| Name | Meaning |
|---|---|
| Workspace Name or ID | The name or ID of the workspace to use. Choose from a dropdown list loaded dynamically or specify via expression. This identifies which workspace's databases to retrieve. |
Output
The output is an array of JSON objects representing the databases retrieved from the specified workspace. Each object corresponds to one database and contains its details as returned by the AppFlowy API.
The json output field includes all raw data about each database, such as its ID and views (including the first view's name). No binary data is output by this operation.
Dependencies
- Requires an active connection to the AppFlowy API using an API key credential configured in n8n.
- The node uses internal helper functions to make authenticated HTTP requests to AppFlowy endpoints.
- The workspace ID must be valid and accessible by the provided API credentials.
Troubleshooting
- Empty results: If no databases are returned, verify that the workspace ID is correct and that the API key has permission to access that workspace.
- Authentication errors: Ensure the API key credential is correctly set up and has not expired or been revoked.
- Invalid workspace ID: Using an invalid or non-existent workspace ID will cause the request to fail. Use the dynamic dropdown to select a valid workspace or confirm the ID manually.
- API rate limits: Excessive calls may trigger rate limiting; consider adding delays or handling retries.
Links and References
- AppFlowy API Documentation (for detailed API endpoint info)
- n8n Expressions Documentation (for using expressions in property fields)