Windsor brings all your Aha! data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQLPower BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Aha! Field Reference
Fields
| iD | Type | Name | Description | Report |
|---|---|---|---|---|
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| features__created_at | TEXT | features.created_at | features.created_at | features |
| features__id | TEXT | features.id | features.id | features |
| features__name | TEXT | features.name | features.name | features |
| features__product_id | TEXT | features.product_id | features.product_id | features |
| features__reference_num | TEXT | features.reference_num | features.reference_num | features |
| features__resource | TEXT | features.resource | features.resource | features |
| features__url | TEXT | features.url | features.url | features |
| goals__comments_count | NUMERIC | goals.comments_count | goals.comments_count | goals |
| goals__created_at | TEXT | goals.created_at | goals.created_at | goals |
| goals__custom_fields | OBJECT | goals.custom_fields | goals.custom_fields | goals |
| goals__description | OBJECT | goals.description | goals.description | goals |
| goals__effort | NUMERIC | goals.effort | goals.effort | goals |
| goals__features | OBJECT | goals.features | goals.features | goals |
| goals__id | TEXT | goals.id | goals.id | goals |
| goals__initiatives | OBJECT | goals.initiatives | goals.initiatives | goals |
| goals__name | TEXT | goals.name | goals.name | goals |
| goals__parent | OBJECT | goals.parent | goals.parent | goals |
| goals__parents | OBJECT | goals.parents | goals.parents | goals |
| goals__position | NUMERIC | goals.position | goals.position | goals |
| goals__product_id | TEXT | goals.product_id | goals.product_id | goals |
| goals__progress | NUMERIC | goals.progress | goals.progress | goals |
| goals__progress_source | TEXT | goals.progress_source | goals.progress_source | goals |
| goals__project | OBJECT | goals.project | goals.project | goals |
| goals__reference_num | TEXT | goals.reference_num | goals.reference_num | goals |
| goals__releases | OBJECT | goals.releases | goals.releases | goals |
| goals__resource | TEXT | goals.resource | goals.resource | goals |
| goals__success_metric | OBJECT | goals.success_metric | goals.success_metric | goals |
| goals__timeframe | OBJECT | goals.timeframe | goals.timeframe | goals |
| goals__updated_at | TEXT | goals.updated_at | goals.updated_at | goals |
| goals__url | TEXT | goals.url | goals.url | goals |
| goals__value | NUMERIC | goals.value | goals.value | goals |
| idea_categories__created_at | TEXT | idea_categories.created_at | idea_categories.created_at | idea_categories |
| idea_categories__id | TEXT | idea_categories.id | idea_categories.id | idea_categories |
| idea_categories__name | TEXT | idea_categories.name | idea_categories.name | idea_categories |
| idea_categories__parent_id | TEXT | idea_categories.parent_id | idea_categories.parent_id | idea_categories |
| idea_comments__attachments | OBJECT | idea_comments.attachments | idea_comments.attachments | idea_comments |
| idea_comments__body | TEXT | idea_comments.body | idea_comments.body | idea_comments |
| idea_comments__created_at | TEXT | idea_comments.created_at | idea_comments.created_at | idea_comments |
| idea_comments__id | TEXT | idea_comments.id | idea_comments.id | idea_comments |
| idea_comments__idea | OBJECT | idea_comments.idea | idea_comments.idea | idea_comments |
| idea_comments__idea_commenter_user | OBJECT | idea_comments.idea_commenter_user | idea_comments.idea_commenter_user | idea_comments |
| idea_comments__idea_id | TEXT | idea_comments.idea_id | idea_comments.idea_id | idea_comments |
| idea_comments__parent_idea_comment_id | TEXT | idea_comments.parent_idea_comment_id | idea_comments.parent_idea_comment_id | idea_comments |
| idea_comments__visibility | TEXT | idea_comments.visibility | idea_comments.visibility | idea_comments |
| idea_endorsements__created_at | TEXT | idea_endorsements.created_at | idea_endorsements.created_at | idea_endorsements |
| idea_endorsements__endorsed_by_idea_organization | OBJECT | idea_endorsements.endorsed_by_idea_organization | idea_endorsements.endorsed_by_idea_organization | idea_endorsements |
| idea_endorsements__endorsed_by_idea_user | OBJECT | idea_endorsements.endorsed_by_idea_user | idea_endorsements.endorsed_by_idea_user | idea_endorsements |
| idea_endorsements__endorsed_by_portal_user | OBJECT | idea_endorsements.endorsed_by_portal_user | idea_endorsements.endorsed_by_portal_user | idea_endorsements |
| idea_endorsements__endorsed_by_user | OBJECT | idea_endorsements.endorsed_by_user | idea_endorsements.endorsed_by_user | idea_endorsements |
| idea_endorsements__id | TEXT | idea_endorsements.id | idea_endorsements.id | idea_endorsements |
| idea_endorsements__idea_id | TEXT | idea_endorsements.idea_id | idea_endorsements.idea_id | idea_endorsements |
| idea_endorsements__link | TEXT | idea_endorsements.link | idea_endorsements.link | idea_endorsements |
| idea_endorsements__updated_at | TEXT | idea_endorsements.updated_at | idea_endorsements.updated_at | idea_endorsements |
| idea_endorsements__value | TEXT | idea_endorsements.value | idea_endorsements.value | idea_endorsements |
| idea_endorsements__weight | NUMERIC | idea_endorsements.weight | idea_endorsements.weight | idea_endorsements |
| ideas__created_at | TEXT | ideas.created_at | ideas.created_at | ideas |
| ideas__description | OBJECT | ideas.description | ideas.description | ideas |
| ideas__id | TEXT | ideas.id | ideas.id | ideas |
| ideas__name | TEXT | ideas.name | ideas.name | ideas |
| ideas__reference_num | TEXT | ideas.reference_num | ideas.reference_num | ideas |
| ideas__resource | TEXT | ideas.resource | ideas.resource | ideas |
| ideas__updated_at | TEXT | ideas.updated_at | ideas.updated_at | ideas |
| ideas__url | TEXT | ideas.url | ideas.url | ideas |
| ideas__workflow_status | OBJECT | ideas.workflow_status | ideas.workflow_status | ideas |
| products__created_at | TEXT | products.created_at | products.created_at | products |
| products__id | TEXT | products.id | products.id | products |
| products__name | TEXT | products.name | products.name | products |
| products__product_line | BOOLEAN | products.product_line | products.product_line | products |
| products__reference_prefix | TEXT | products.reference_prefix | products.reference_prefix | products |
| products__workspace_type | TEXT | products.workspace_type | products.workspace_type | products |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| users__accessed_at | TEXT | users.accessed_at | users.accessed_at | users |
| users__administrator | BOOLEAN | users.administrator | users.administrator | users |
| users__administrator_roles | OBJECT | users.administrator_roles | users.administrator_roles | users |
| users__created_at | TEXT | users.created_at | users.created_at | users |
| users__email | TEXT | users.email | users.email | users |
| users__enabled | BOOLEAN | users.enabled | users.enabled | users |
| users__id | TEXT | users.id | users.id | users |
| users__identity_provider | OBJECT | users.identity_provider | users.identity_provider | users |
| users__name | TEXT | users.name | users.name | users |
| users__paid_seat | BOOLEAN | users.paid_seat | users.paid_seat | users |
| users__product_roles | OBJECT | users.product_roles | users.product_roles | users |
| users__updated_at | TEXT | users.updated_at | users.updated_at | users |