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 TIMESTAMP 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 TIMESTAMP 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