Windsor brings all your HubPlanner data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
HubPlanner Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| billing_rates___id | TEXT | billing_rates._id | billing_rates._id | billing_rates |
| billing_rates__createdDate | TEXT | billing_rates.createdDate | billing_rates.createdDate | billing_rates |
| billing_rates__currency | TEXT | billing_rates.currency | billing_rates.currency | billing_rates |
| billing_rates__label | TEXT | billing_rates.label | billing_rates.label | billing_rates |
| billing_rates__metadata | TEXT | billing_rates.metadata | billing_rates.metadata | billing_rates |
| billing_rates__rate | NUMERIC | billing_rates.rate | billing_rates.rate | billing_rates |
| billing_rates__updatedDate | TEXT | billing_rates.updatedDate | billing_rates.updatedDate | billing_rates |
| bookings___id | TEXT | bookings._id | bookings._id | bookings |
| bookings__allDay | BOOLEAN | bookings.allDay | bookings.allDay | bookings |
| bookings__backgroundColor | TEXT | bookings.backgroundColor | bookings.backgroundColor | bookings |
| bookings__billable | BOOLEAN | bookings.billable | bookings.billable | bookings |
| bookings__bookingCreatorId | TEXT | bookings.bookingCreatorId | bookings.bookingCreatorId | bookings |
| bookings__bookingRate | OBJECT | bookings.bookingRate | bookings.bookingRate | bookings |
| bookings__categoryName | TEXT | bookings.categoryName | bookings.categoryName | bookings |
| bookings__categoryTemplateId | TEXT | bookings.categoryTemplateId | bookings.categoryTemplateId | bookings |
| bookings__createdDate | TEXT | bookings.createdDate | bookings.createdDate | bookings |
| bookings__customFields | OBJECT | bookings.customFields | bookings.customFields | bookings |
| bookings__deletedById | TEXT | bookings.deletedById | bookings.deletedById | bookings |
| bookings__details | OBJECT | bookings.details | bookings.details | bookings |
| bookings__end | TEXT | bookings.end | bookings.end | bookings |
| bookings__lastUpdatedById | TEXT | bookings.lastUpdatedById | bookings.lastUpdatedById | bookings |
| bookings__metadata | TEXT | bookings.metadata | bookings.metadata | bookings |
| bookings__note | TEXT | bookings.note | bookings.note | bookings |
| bookings__project | TEXT | bookings.project | bookings.project | bookings |
| bookings__resource | TEXT | bookings.resource | bookings.resource | bookings |
| bookings__scale | TEXT | bookings.scale | bookings.scale | bookings |
| bookings__start | TEXT | bookings.start | bookings.start | bookings |
| bookings__state | TEXT | bookings.state | bookings.state | bookings |
| bookings__stateValue | NUMERIC | bookings.stateValue | bookings.stateValue | bookings |
| bookings__title | TEXT | bookings.title | bookings.title | bookings |
| bookings__type | TEXT | bookings.type | bookings.type | bookings |
| bookings__updatedDate | TEXT | bookings.updatedDate | bookings.updatedDate | bookings |
| clients____v | NUMERIC | clients.__v | clients.__v | clients |
| clients___id | TEXT | clients._id | clients._id | clients |
| clients__company | TEXT | clients.company | clients.company | clients |
| clients__createdDate | TEXT | clients.createdDate | clients.createdDate | clients |
| clients__deleted | BOOLEAN | clients.deleted | clients.deleted | clients |
| clients__name | TEXT | clients.name | clients.name | clients |
| clients__updatedDate | TEXT | clients.updatedDate | clients.updatedDate | clients |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| events___id | TEXT | events._id | events._id | events |
| events__backgroundColor | TEXT | events.backgroundColor | events.backgroundColor | events |
| events__createdDate | TEXT | events.createdDate | events.createdDate | events |
| events__label | TEXT | events.label | events.label | events |
| events__metadata | TEXT | events.metadata | events.metadata | events |
| events__name | TEXT | events.name | events.name | events |
| events__updatedDate | TEXT | events.updatedDate | events.updatedDate | events |
| holidays___id | TEXT | holidays._id | holidays._id | holidays |
| holidays__createdDate | TEXT | holidays.createdDate | holidays.createdDate | holidays |
| holidays__date | TEXT | holidays.date | holidays.date | holidays |
| holidays__metadata | TEXT | holidays.metadata | holidays.metadata | holidays |
| holidays__name | TEXT | holidays.name | holidays.name | holidays |
| holidays__updatedDate | TEXT | holidays.updatedDate | holidays.updatedDate | holidays |
| projects___id | TEXT | projects._id | projects._id | projects |
| projects__backgroundColor | TEXT | projects.backgroundColor | projects.backgroundColor | projects |
| projects__billable | BOOLEAN | projects.billable | projects.billable | projects |
| projects__budget | OBJECT | projects.budget | projects.budget | projects |
| projects__budgetCashAmount | NUMERIC | projects.budgetCashAmount | projects.budgetCashAmount | projects |
| projects__budgetCategories | OBJECT | projects.budgetCategories | projects.budgetCategories | projects |
| projects__budgetCurrency | TEXT | projects.budgetCurrency | projects.budgetCurrency | projects |
| projects__budgetHours | NUMERIC | projects.budgetHours | projects.budgetHours | projects |
| projects__categoryGroups | OBJECT | projects.categoryGroups | projects.categoryGroups | projects |
| projects__companyBillingRateId | TEXT | projects.companyBillingRateId | projects.companyBillingRateId | projects |
| projects__createdDate | TEXT | projects.createdDate | projects.createdDate | projects |
| projects__customFields | OBJECT | projects.customFields | projects.customFields | projects |
| projects__customers | OBJECT | projects.customers | projects.customers | projects |
| projects__defaultCategory | TEXT | projects.defaultCategory | projects.defaultCategory | projects |
| projects__end | TEXT | projects.end | projects.end | projects |
| projects__fixedCosts | OBJECT | projects.fixedCosts | projects.fixedCosts | projects |
| projects__includeBookedTimeGrid | BOOLEAN | projects.includeBookedTimeGrid | projects.includeBookedTimeGrid | projects |
| projects__includeBookedTimeReports | BOOLEAN | projects.includeBookedTimeReports | projects.includeBookedTimeReports | projects |
| projects__links | OBJECT | projects.links | projects.links | projects |
| projects__metadata | TEXT | projects.metadata | projects.metadata | projects |
| projects__name | TEXT | projects.name | projects.name | projects |
| projects__note | TEXT | projects.note | projects.note | projects |
| projects__notes | TEXT | projects.notes | projects.notes | projects |
| projects__private | BOOLEAN | projects.private | projects.private | projects |
| projects__projectCode | TEXT | projects.projectCode | projects.projectCode | projects |
| projects__projectManagers | OBJECT | projects.projectManagers | projects.projectManagers | projects |
| projects__projectRate | OBJECT | projects.projectRate | projects.projectRate | projects |
| projects__resourceRates | OBJECT | projects.resourceRates | projects.resourceRates | projects |
| projects__resources | OBJECT | projects.resources | projects.resources | projects |
| projects__start | TEXT | projects.start | projects.start | projects |
| projects__status | TEXT | projects.status | projects.status | projects |
| projects__tags | OBJECT | projects.tags | projects.tags | projects |
| projects__timeEntryApproval | BOOLEAN | projects.timeEntryApproval | projects.timeEntryApproval | projects |
| projects__timeEntryEnabled | BOOLEAN | projects.timeEntryEnabled | projects.timeEntryEnabled | projects |
| projects__timeEntryLocked | BOOLEAN | projects.timeEntryLocked | projects.timeEntryLocked | projects |
| projects__timeEntryNoteRequired | BOOLEAN | projects.timeEntryNoteRequired | projects.timeEntryNoteRequired | projects |
| projects__updatedDate | TEXT | projects.updatedDate | projects.updatedDate | projects |
| projects__useProjectDays | BOOLEAN | projects.useProjectDays | projects.useProjectDays | projects |
| projects__useProjectDuration | BOOLEAN | projects.useProjectDuration | projects.useProjectDuration | projects |
| projects__useStatusColor | BOOLEAN | projects.useStatusColor | projects.useStatusColor | projects |
| projects__workDays | OBJECT | projects.workDays | projects.workDays | projects |
| resources___id | TEXT | resources._id | resources._id | resources |
| resources__billable | BOOLEAN | resources.billable | resources.billable | resources |
| resources__billing | OBJECT | resources.billing | resources.billing | resources |
| resources__calendarIds | OBJECT | resources.calendarIds | resources.calendarIds | resources |
| resources__createdDate | TEXT | resources.createdDate | resources.createdDate | resources |
| resources__customFields | OBJECT | resources.customFields | resources.customFields | resources |
| resources__email | TEXT | resources.email | resources.email | resources |
| resources__firstName | TEXT | resources.firstName | resources.firstName | resources |
| resources__isApprover | BOOLEAN | resources.isApprover | resources.isApprover | resources |
| resources__isProjectManager | BOOLEAN | resources.isProjectManager | resources.isProjectManager | resources |
| resources__lastName | TEXT | resources.lastName | resources.lastName | resources |
| resources__links | OBJECT | resources.links | resources.links | resources |
| resources__metadata | TEXT | resources.metadata | resources.metadata | resources |
| resources__note | TEXT | resources.note | resources.note | resources |
| resources__resourceRates | OBJECT | resources.resourceRates | resources.resourceRates | resources |
| resources__role | TEXT | resources.role | resources.role | resources |
| resources__status | TEXT | resources.status | resources.status | resources |
| resources__tags | OBJECT | resources.tags | resources.tags | resources |
| resources__updatedDate | TEXT | resources.updatedDate | resources.updatedDate | resources |
| resources__useCustomAvailability | BOOLEAN | resources.useCustomAvailability | resources.useCustomAvailability | resources |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |