Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    Couchbase
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/whiparound




Whiparound


This adapter allows you to access the Whiparound API.


Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String Url Web service URL
String apiVersion Pressero API version
String ClientId ClientId used for authentication
String ClientSecret Secret used for authentication
String UserTokenEmail Email used for obtaining a User Token
String UserTokenPassword Password used for obtaining a User Token
String DriverTokenEmail Email used for obtaining a Driver Token
String DriverTokenPassword Password used for obtaining a Driver Token

Handlers



ListDrivers
Drivers
Get a list of drivers details 

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
ListForms
Forms
Get a list of forms details 

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
ListReports
Reports
Get a list of Reports details 

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
ListReportsItems
ReportsItems
Get a list of Reports and their detail items details 

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
ListVehicles
Vehicles
Get a list of vehicles details 

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