Arguments

SQL Call

exec BSC.WhipAround.ListDrivers
select * from BSC.WhipAround.Drivers

Http Call

/bsc/whiparound/listdrivers

Output Columns

Int64 id
String first_name
String last_name
String username
String bio
String division
String employee_number
String position
String hourly_rate
String work_phone
String home_phone
String mobile_phone
String email
DateTime dob
Boolean on_hold
String licence
String licence_number
String licence_class_id
String health
String notes
String photo
DateTime created_at
String device_platform
String device_model
String device_version
String app_version
String deleted_username
String team_name
DateTime last_inspection
String phone_e164
String phone_countrycode
Int64 business_id
String profile_image
String team__name
String team__photo
String team__business__name
String team__business__industry
Int64 team__business__subscription_plan_id
String team__business__timezone
Int64 team__business__vehicles_limit
DateTime team__business__created_at
DateTime team__business__updated_at
String team__business__logo
Boolean team__business__last_report_signature_required
DateTime team__business__user_last_login_to_dashboard
Int64 team__business__stat_onboarding_stage
Int64 team__business__stat_vehicles_count
Int64 team__business__stat_recently_inspected_vehicles_count
Int64 team__business__stat_user_count
Int64 team__business__stat_driver_count
Int64 team__business__stat_inspection_count
DateTime team__business__stat_last_inspection_date
Int64 team__business__stat_fault_count
Int64 team__business__stat_recent_faults_count_new
Int64 team__business__stat_recent_faults_count_wip
Int64 team__business__stat_recent_faults_count_done
Int64 team__business__stat_driver_app_installed_count
Int64 team__business__stat_recently_inspected_drivers_count
Int64 team__business__currency_id
Boolean team__business__group_repeated_faults
String team__business__sub_status
String team__business__sub_cancellation_date
String team__business__is_verizon_activated
Int64 team__business__stat_pc_vehicles_inspected_7_days
Int64 team__business__stat_pc_vehicles_inspected_30_days
Boolean team__business__is_trial
Boolean team__business__is_self_subscribed
Int64 team__business__stat_forms_count
Int64 team__business__stat_missed_inspection_upcoming_reminders_count
Int64 team__business__stat_missed_inspection_completed_reminders_count
Int64 team__business__stat_inspection_upcoming_reminders_count
Int64 team__business__stat_inspection_completed_reminders_count
Int64 team__business__stat_manager_upcoming_reminders_count
Int64 team__business__stat_manager_completed_reminders_count
DateTime team__business__free_trial_start_date
DateTime team__business__free_trial_end_date
String team__business__subscription_type
String team__business__sale_type
String team__business__salesforce_account_id
String team__business__signed_up_through
String team__business__signed_up_through_mobile_platform
String team__business__salesforce_lead_id
String team__business__salesforce_opportunity_id
String team__business__salesforce_app_cdp_id
String team__business__units_of_length
String team__business__sign_up_stage
Boolean team__business__is_rta_activated
String raw

Arguments

SQL Call

exec bsc.WhipAround.ListForms
select * from WhipAround.Forms

Http Call

/bsc/whiparound/listforms

Output Columns

Int32 id
Int32 parent_form_id
String name
Int32 sort_order
Int32 total_cards
String created_by
DateTime last_inspection
Boolean drivers_signature
Boolean mechanics_signature
DateTime business_odometer_converted_at
Int32 categories__id
String categories__name
Int32 categories__sort_order
Int32 categories__form_id
String categories__icon
Int32 categories__category_type_id
Int32 categories__old_id
String categories__icon_url
Int32 categories__items_count
Int32 categories__items__id
String categories__items__name
Int32 categories__items__sort_order
Boolean categories__items__alert
Boolean categories__items__compulsory
Boolean categories__items__allow_photo_lib_access
String categories__type__name
Int32 categories__type__sort_order
String raw

Arguments

Name	Description	Default
fromDate	Starting date. Default is yesterday.
toDate	Ending date. Default is @fromDate.

SQL Call

exec bsc.WhipAround.ListReports '2019-11-19'
select * from WhipAround.Reports where fromDate = '2019-11-19'

Http Call

/bsc/whiparound/listreports

Output Columns

Int32 id
String first_name
String last_name
Int32 completion
String plate
DateTime created_datetime
String ruid
Decimal start_latitude
Decimal start_longitude
Decimal end_latitude
Decimal end_longitude
DateTime created_at
DateTime updated_at
DateTime created_utc
DateTime report_started_on_device
DateTime report_ended_on_device
Int32 report_duration_sec
String report_timezone_offset
String vehicle_name
String team_name
String form_name
Int32 team_id
DateTime pdf_generated_at
String report_url
Int32 driver__id
Int32 vehicle__id
Int32 form__id
Int32 items_count
Int32 signatures__id
String signatures__photo
String signatures__photo_url
String raw

Arguments

Name	Description	Default
fromDate	Starting date. Default is yesterday.
toDate	Ending date. Default is @fromDate.

SQL Call

exec bsc.WhipAround.ListReportsItems '2019-11-19'
select * from WhipAround.ReportsItems where fromDate = '2019-11-19'

Http Call

/bsc/whiparound/listreportsitems

Output Columns

Int32 id
DateTime created_datetime
String first_name
String last_name
Int32 completion
String plate
String vehicle_name
String team_name
String form_name
Int32 team_id
Int32 driver__id
Int32 vehicle__id
Int32 form__id
Int32 items__id
Int32 items__item_id
Int32 items__report_id
Int32 items__fault_id
Boolean items__passed
String items__comment
String items__photo
String items__data_entry_value
Decimal items__start_latitude
Decimal items__start_longitude
Decimal items__end_latitude
Decimal items__end_longitude
Boolean items__is_valid_odo_submitted
String items__fault_photo
Int32 items__item__id
String items__item__name
Int32 items__item__sort_order
Boolean items__item__alert
Boolean items__item__compulsory
Boolean items__item__allow_photo_lib_access
String items__fault
String raw

Arguments

SQL Call

exec bsc.WhipAround.ListVehicles
select * from WhipAround.Vehicles

Http Call

/bsc/whiparound/listvehicles

Output Columns

Int64 id
String name
String plate
String bio
String make
String model
Int64 year
String licence_plate
String colour
String vehicle_subtype
String estimated_value
String photo
String on_hold
String ownership
DateTime created_at
DateTime updated_at
Int64 business_id
DateTime last_inspection
String team_name
String verizon_vehicle_number
Boolean is_test_vehicle
Decimal latitude
Decimal longitude
Int32 odometer
Boolean is_valid_odo_submitted
DateTime odometer_updated_at
Int32 ui_number
String ui_number_text
Int32 last_service_odometer
DateTime last_service_date
String vehicle_type
String currency
String team__name
String team__photo
String team__business__name
String team__business__industry
Int32 team__business__subscription_plan_id
String team__business__timezone
Int32 team__business__vehicles_limit
DateTime team__business__created_at
DateTime team__business__updated_at
String team__business__logo
Boolean team__business__last_report_signature_required
DateTime team__business__user_last_login_to_dashboard
Int32 team__business__stat_onboarding_stage
Int32 team__business__stat_vehicles_count
Int32 team__business__stat_recently_inspected_vehicles_count
Int32 team__business__stat_user_count
Int32 team__business__stat_driver_count
Int32 team__business__stat_inspection_count
DateTime team__business__stat_last_inspection_date
Int32 team__business__stat_fault_count
Int32 team__business__stat_recent_faults_count_new
Int32 team__business__stat_recent_faults_count_wip
Int32 team__business__stat_recent_faults_count_done
Int32 team__business__stat_driver_app_installed_count
Int32 team__business__stat_recently_inspected_drivers_count
Int32 team__business__currency_id
Boolean team__business__group_repeated_faults
String team__business__sub_status
DateTime team__business__sub_cancellation_date
Boolean team__business__is_verizon_activated
Int32 team__business__stat_pc_vehicles_inspected_7_days
Int32 team__business__stat_pc_vehicles_inspected_30_days
Boolean team__business__is_trial
Boolean team__business__is_self_subscribed
Int32 team__business__stat_forms_count
Int32 team__business__stat_missed_inspection_upcoming_reminders_count
Int32 team__business__stat_missed_inspection_completed_reminders_count
Int32 team__business__stat_inspection_upcoming_reminders_count
Int32 team__business__stat_inspection_completed_reminders_count
Int32 team__business__stat_manager_upcoming_reminders_count
Int32 team__business__stat_manager_completed_reminders_count
DateTime team__business__free_trial_start_date
DateTime team__business__free_trial_end_date
String team__business__subscription_type
String team__business__sale_type
String team__business__salesforce_account_id
String team__business__signed_up_through
String team__business__signed_up_through_mobile_platform
String team__business__salesforce_lead_id
String team__business__salesforce_opportunity_id
String team__business__salesforce_app_cdp_id
String team__business__units_of_length
String team__business__sign_up_stage
Boolean team__business__is_rta_activated
Int32 max_allowed_odometer_value
String units_of_length
String raw