Actions199
- Collections Actions
- Forms Actions
- Actions Capabilities Actions
- Activities Actions
- Attachments Actions
- Budgets Actions
- Categories Actions
- Custom Actions Actions
- Custom Options Actions
- Documents Actions
- File Links Actions
- View File Link
- Delete File Link
- Open File Link
- Download File Link
- List Project Storages
- Get Project Storage
- Open Project Storage
- Create Storage
- Get Storage
- Update Storage
- Delete Storage
- Get Storage Files
- Prepare Storage File Upload
- Create Storage Folder
- Create Storage Oauth Credentials
- Open Storage
- Create Work Package File Link
- List Work Package File Links
- Grids Actions
- Groups Actions
- Help Texts Actions
- Memberships Actions
- Query Filter Instance Schema Actions
- News Actions
- Notifications Actions
- O Auth 2 Actions
- Posts Actions
- Principals Actions
- Priorities Actions
- Query Columns Actions
- Query Filters Actions
- Query Operators Actions
- Query Sort Bys Actions
- Relations Actions
- Previewing Actions
- Revisions Actions
- Roles Actions
- Time Entries Actions
- Time Entry Activities Actions
- Types Actions
- User Preferences Actions
- Wiki Pages Actions
- Work Schedule Actions
- Meetings Actions
- Values Property Actions
- Projects Actions
- Queries Actions
- Users Actions
- Statuses Actions
- Versions Actions
- Work Packages Actions
- Get Project Work Package Collection
- Create Project Work Package
- List Work Package File Links
- Form Create Work Package In Project
- Project Available Assignees
- List Work Packages
- Create Work Package
- Form Create Work Package
- List Work Package Schemas
- View Work Package Schema
- Delete Work Package
- View Work Package
- Update Work Package
- List Work Package Activities
- Comment Work Package
- Work Package Available Assignees
- Available Projects For Work Package
- List Available Relation Candidates
- Available Watchers
- Create Work Package File Link
- Form Edit Work Package
- Revisions
- Reminders
- List Watchers
- Add Watcher
- Remove Watcher
- Views Actions
Overview
This node interacts with the OpenProject API to list queries based on specified filter conditions. It is useful for retrieving saved query configurations from OpenProject, which can represent customized views or reports of project data. Typical use cases include automating the retrieval of project-specific queries for reporting, monitoring updates to queries, or integrating query data into other workflows.
For example, a user might want to fetch all global queries (not assigned to any specific project) or retrieve queries updated after a certain date to synchronize with an external dashboard.
Properties
| Name | Meaning |
|---|---|
| Filters | A JSON string specifying filter conditions to narrow down the list of queries returned. Supported filters include: - project: Filters queries by their assigned project. Using the operator !* returns global queries.- id: Filters queries by their unique identifier.- updated_at: Filters queries based on their last update timestamp. |
Output
The node outputs a JSON array of query objects matching the specified filters. Each object represents a query in OpenProject and typically includes details such as the query's ID, name, associated project, and metadata like the last update time.
No binary data output is produced by this node.
Dependencies
- Requires an API key credential for authenticating with the OpenProject API.
- The base URL of the OpenProject instance must be configured in the node credentials.
- The node depends on the OpenProject REST API being accessible and properly configured to allow query listing.
Troubleshooting
- Invalid Filter JSON: If the
Filtersproperty contains malformed JSON, the node will fail to send the request. Ensure the JSON syntax is correct. - Authentication Errors: If the API key or base URL is incorrect or missing, authentication will fail. Verify that the API credentials are valid and have sufficient permissions.
- Unsupported Filters: Using unsupported filter keys or operators may result in empty results or API errors. Use only the documented filters (
project,id,updated_at) with supported operators. - Network Issues: Connectivity problems to the OpenProject server will cause request failures. Check network access and firewall settings.