Server Side Table API

Retrieve Table

GET <host>/transit_assets/table

Parameters

• fta_asset_class_code: The table code, valid values are bus, rail_car, ferry, other_passenger_vehicle, service_vehicle, capital_equipment, admin_facility, maintenance_facility, passenger_facility, parking_facility
• page_size: (Optional) The number of rows to return.
• page: (Optional) The page number to return.
• columns (Optional A comma separated list of the columns to return. E.g., asset_id,external_id,esl_category,fta_asset_class,cost The full list of available columns for each table is listed below.
• sort_column (Optional)
• sort_order (Optional) ascending or descending

Available Columns

Columns Available to Revenue Vehicles (bus, rail_car, ferry, other_passenger_vehicle)

  vehicle_length: "Length"
  vehicle_length_unit: "Length Unit"
  esl_category:  "ESL Category"`
  seating_capacity:  "Seating Capcity (Ambulatory)"
  fta_funding_type: "Funding Type"
  fta_ownership_type: "Ownership Type"
  vin: "VIN"
  service_status: "Service Status"
  chassis: "Chassis"
  fuel_type: "Fuel Type"
  license_plate: "Plate #"
  primary_mode: "Primary Mode"
  mileage: "Odometer Reading"
  asset_id: "Asset ID"
  org_name: "Organization"
  manufacturer: "Manufacturer"
  model: "Model"
  year: "Year"
  type: "Type"
  subtype:  "Subtype"
  last_life_cycle_action: "Last Life Cycle Action"
  life_cycle_action_date: "Life Cycle Action Date"
  fta_asset_class:  "Class"
  external_id: "External ID"
  purchase_cost:="Cost (Purchase)"
  in_service_date:  "In Service Date"      `
  operator: "Operator"
  direct_capital_responsibility:  "Direct Capital Responsibility"
  pcnt_capital_responsibility: "Capital Responsibility %"
  term_condition: "TERM Condition"
  term_rating: "TERM Condition"
  location: "Location"
  description: "Description"
  quantity: "Quantity"
  quantity_unit: "Quantity Type"

Columns Available to Service Vehicles (service_vehicle)

  vin: "VIN"
  service_status: "Service Status"
  chassis: "Chassis"
  fuel_type: "Fuel Type"
  license_plate: "Plate #"
  primary_mode: "Primary Mode"
  mileage: "Odometer Reading"
  asset_id: "Asset ID"
  org_name: "Organization"
  manufacturer: "Manufacturer"
  model: "Model"
  year: "Year"
  type: "Type"
  subtype:  "Subtype"
  last_life_cycle_action: "Last Life Cycle Action"
  life_cycle_action_date: "Life Cycle Action Date"
  fta_asset_class:  "Class"
  external_id: "External ID"
  purchase_cost:="Cost (Purchase)"
  in_service_date:  "In Service Date"      `
  operator: "Operator"
  direct_capital_responsibility:  "Direct Capital Responsibility"
  pcnt_capital_responsibility: "Capital Responsibility %"
  term_condition: "TERM Condition"
  term_rating: "TERM Condition"
  location: "Location"
  description: "Description"
  quantity: "Quantity"
  quantity_unit: "Quantity Type"

Columns Available to Capital Equipment (capital_equipment)

  service_status: "Service Status"
  asset_id: "Asset ID"
  org_name: "Organization"
  manufacturer: "Manufacturer"
  model: "Model"
  year: "Year"
  type: "Type"
  subtype:  "Subtype"
  last_life_cycle_action: "Last Life Cycle Action"
  life_cycle_action_date: "Life Cycle Action Date"
  fta_asset_class:  "Class"
  external_id: "External ID"
  purchase_cost:="Cost (Purchase)"
  in_service_date:  "In Service Date"      `
  operator: "Operator"
  direct_capital_responsibility:  "Direct Capital Responsibility"
  pcnt_capital_responsibility: "Capital Responsibility %"
  term_condition: "TERM Condition"
  term_rating: "TERM Condition"
  location: "Location"
  description: "Description"
  quantity: "Quantity"
  quantity_unit: "Quantity Type"

Columns Available to Facilities (admin_facility, maintenance_facility, parking_facility, passenger_facility)

  WORK IN PROGRESS