POST api/ExcelImportMappings

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Id	integer	None.
Name	string	Required Max length: 50
ExcelImportMappingType	ExcelImportMappingType	None.
CustomerFirstName	string	Max length: 50
CustomerLastName	string	Max length: 50
CustomerPhoneNumber	string	Max length: 50
CustomerAltPhoneNumber	string	Max length: 50
PickupAddress	string	Max length: 50
PickupCity	string	Max length: 50
PickupState	string	Max length: 50
PickupLat	string	Max length: 50
PickupLong	string	Max length: 50
PickupPostalCode	string	Max length: 50
DropoffAddress	string	Max length: 50
DropoffCity	string	Max length: 50
DropoffState	string	Max length: 50
DropoffLat	string	Max length: 50
DropoffLong	string	Max length: 50
DropoffPostalCode	string	Max length: 50
RideDate	string	Max length: 50
PickupTime	string	Max length: 50
RideDateTime	string	Max length: 50
AppointmentDate	string	Max length: 50
AppointmentTime	string	Max length: 50
VehicleType	string	Max length: 50
TripType	string	Max length: 50
Instructions	string	Max length: 50
IgnoreRow	string	Max length: 50
Message	string	Max length: 50
AdditionalItems	Collection of ExcelImportMappingAdditionalItemDto	None.
FieldsFormat	string	Max length: 4096
GroupingColumn	string	Max length: 50
FleetId	integer	None.
ExternalAccountId	string	None.
FleetName	string	None.
Status	ExcelImportMappingStatus	None.
CustomerFullName	string	Max length: 50
FullNameSeparator	string	Max length: 50
FullNameOrder	FullNameOrder	None.
IsMTMTrip	boolean	None.
Cost	string	Max length: 50
Price	string	Max length: 50
ExternalDriverId	string	Max length: 50
DiscriminatorColumnName	string	Max length: 50

Request Formats

application/json, text/json

Sample:

{
  "id": 1,
  "name": "sample string 2",
  "excelImportMappingType": "ColumnIndex",
  "customerFirstName": "sample string 3",
  "customerLastName": "sample string 4",
  "customerPhoneNumber": "sample string 5",
  "customerAltPhoneNumber": "sample string 6",
  "pickupAddress": "sample string 7",
  "pickupCity": "sample string 8",
  "pickupState": "sample string 9",
  "pickupLat": "sample string 10",
  "pickupLong": "sample string 11",
  "pickupPostalCode": "sample string 12",
  "dropoffAddress": "sample string 13",
  "dropoffCity": "sample string 14",
  "dropoffState": "sample string 15",
  "dropoffLat": "sample string 16",
  "dropoffLong": "sample string 17",
  "dropoffPostalCode": "sample string 18",
  "rideDate": "sample string 19",
  "pickupTime": "sample string 20",
  "rideDateTime": "sample string 21",
  "appointmentDate": "sample string 22",
  "appointmentTime": "sample string 23",
  "vehicleType": "sample string 24",
  "tripType": "sample string 25",
  "instructions": "sample string 26",
  "ignoreRow": "sample string 27",
  "message": "sample string 28",
  "additionalItems": [
    {
      "id": 1,
      "propertyName": "sample string 1",
      "excelColumn": "sample string 2",
      "isExtra": true,
      "trueValue": "sample string 4",
      "falseValue": "sample string 5",
      "displayName": "sample string 6"
    },
    {
      "id": 1,
      "propertyName": "sample string 1",
      "excelColumn": "sample string 2",
      "isExtra": true,
      "trueValue": "sample string 4",
      "falseValue": "sample string 5",
      "displayName": "sample string 6"
    }
  ],
  "fieldsFormat": "sample string 29",
  "groupingColumn": "sample string 30",
  "fleetId": 31,
  "externalAccountId": "sample string 32",
  "fleetName": "sample string 33",
  "status": "Draft",
  "customerFullName": "sample string 34",
  "fullNameSeparator": "sample string 35",
  "fullNameOrder": "FirstNameLastName",
  "ismtmTrip": true,
  "cost": "sample string 37",
  "price": "sample string 38",
  "externalDriverId": "sample string 39",
  "discriminatorColumnName": "sample string 40"
}

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

IHttpActionResult

None.

Response Formats

application/json, text/json

Sample:

Sample not available.