WorkRamp Connector Reference
6 metrics36 dimensions
The WorkRamp connector exposes 42 fields (6 metrics, 36 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
WorkRamp Fields
WorkRamp awarded_certifications fields
The awarded_certifications report of the WorkRamp connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| awarded_certifications__awarded_at | NUMERIC | awarded_certifications.awarded_at | awarded_certifications.awarded_at |
| awarded_certifications__description | TEXT | awarded_certifications.description | awarded_certifications.description |
| awarded_certifications__id | TEXT | awarded_certifications.id | awarded_certifications.id |
| awarded_certifications__name | TEXT | awarded_certifications.name | awarded_certifications.name |
| awarded_certifications__user_email | TEXT | awarded_certifications.user_email | awarded_certifications.user_email |
| awarded_certifications__user_id | TEXT | awarded_certifications.user_id | awarded_certifications.user_id |
| awarded_certifications__user_name | TEXT | awarded_certifications.user_name | awarded_certifications.user_name |
WorkRamp certifications fields
The certifications report of the WorkRamp connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| certifications__awarded_by_name | TEXT | certifications.awarded_by_name | certifications.awarded_by_name |
| certifications__awarded_by_title | TEXT | certifications.awarded_by_title | certifications.awarded_by_title |
| certifications__created_at | TEXT | certifications.created_at | certifications.created_at |
| certifications__description | TEXT | certifications.description | certifications.description |
| certifications__id | TEXT | certifications.id | certifications.id |
| certifications__name | TEXT | certifications.name | certifications.name |
WorkRamp registrations fields
The registrations report of the WorkRamp connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| registrations__completed_at | NUMERIC | registrations.completed_at | registrations.completed_at |
| registrations__completion_percentage | NUMERIC | registrations.completion_percentage | registrations.completion_percentage |
| registrations__content | OBJECT | registrations.content | registrations.content |
| registrations__created_at | NUMERIC | registrations.created_at | registrations.created_at |
| registrations__due_at | TEXT | registrations.due_at | registrations.due_at |
| registrations__due_date | TEXT | registrations.due_date | registrations.due_date |
| registrations__id | TEXT | registrations.id | registrations.id |
| registrations__is_completed | BOOLEAN | registrations.is_completed | registrations.is_completed |
| registrations__pass_status | TEXT | registrations.pass_status | registrations.pass_status |
| registrations__score | NUMERIC | registrations.score | registrations.score |
| registrations__user | OBJECT | registrations.user | registrations.user |
WorkRamp trainings fields
The trainings report of the WorkRamp connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trainings__created_at | NUMERIC | trainings.created_at | trainings.created_at |
| trainings__id | TEXT | trainings.id | trainings.id |
| trainings__name | TEXT | trainings.name | trainings.name |
| trainings__type | TEXT | trainings.type | trainings.type |
WorkRamp users fields
The users report of the WorkRamp connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| users__created_at | TEXT | users.created_at | users.created_at |
| users__custom_registration_field_values | OBJECT | users.custom_registration_field_values | users.custom_registration_field_values |
| users__display_name | TEXT | users.display_name | users.display_name |
| users__email | TEXT | users.email | users.email |
| users__first_name | TEXT | users.first_name | users.first_name |
| users__id | TEXT | users.id | users.id |
| users__last_name | TEXT | users.last_name | users.last_name |
| users__segments | OBJECT | users.segments | users.segments |
WorkRamp other fields
The WorkRamp connector has 6 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| paths_users__id | TEXT | paths_users.id | paths_users.id | paths_users |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |
