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 allows you to view details of a specific Query Column in the OpenProject system by providing its unique identifier. It is useful when you want to retrieve metadata or configuration about a particular column used in queries within OpenProject, such as for reporting or data analysis purposes.
A practical example would be fetching the properties of a "priority" query column to understand how it is configured or displayed in reports.
Properties
| Name | Meaning |
|---|---|
| Id | The unique identifier of the Query Column you want to view. For example, "priority". This property is required. |
Output
The node outputs JSON data representing the details of the specified Query Column. This typically includes all relevant metadata and configuration information about that column as returned by the OpenProject API.
No binary data output is expected from this node.
Dependencies
- Requires an API key credential to authenticate with the OpenProject API.
- The node uses the base URL provided in the credentials to connect to the OpenProject instance.
- The OpenProject API must be accessible from the n8n environment.
Troubleshooting
- Invalid or missing Id: If the provided Query Column id does not exist or is incorrect, the node will likely return an error indicating the resource was not found. Verify the id value.
- Authentication errors: Ensure the API key credential is valid and has sufficient permissions to access query columns.
- Network issues: Confirm that the OpenProject instance URL is correct and reachable from n8n.
- API changes: If the OpenProject API changes, the node might fail; check for updates or compatibility.
Links and References
- OpenProject API Documentation
- OpenProject Query Columns (if available)