POST api/Vehicles/ImportExcelVehicles

Import vehicles in excel file

Request Information

Parameters

Name	Description	Additional information
req	No documentation available.	Define this parameter in the request body.

Request body formats

application/json, text/json

Sample:

{
  "UniqueFilename": "sample string 1",
  "DeviceVendor": "sample string 2",
  "VehicleProfileID": 3,
  "VehicleIDs": [
    1,
    2,
    3
  ],
  "OverrideVehicleProfileAndUnitType": true,
  "Token": "sample string 5",
  "FreeText": "sample string 6",
  "GroupIds": [
    1,
    2,
    3
  ],
  "FromIndex": 7,
  "ToIndex": 8,
  "IsWebCalling": true,
  "RequestMode": "sample string 10",
  "Client": "sample string 11",
  "AppVersion": "sample string 12",
  "AppOperatingSystem": "sample string 13",
  "AppName": "sample string 14",
  "MasterUserID": 15,
  "IsRecurringRequest": true
}

text/html

Sample:

{"UniqueFilename":"sample string 1","DeviceVendor":"sample string 2","VehicleProfileID":3,"VehicleIDs":[1,2,3],"OverrideVehicleProfileAndUnitType":true,"Token":"sample string 5","FreeText":"sample string 6","GroupIds":[1,2,3],"FromIndex":7,"ToIndex":8,"IsWebCalling":true,"RequestMode":"sample string 10","Client":"sample string 11","AppVersion":"sample string 12","AppOperatingSystem":"sample string 13","AppName":"sample string 14","MasterUserID":15,"IsRecurringRequest":true}

application/xml, text/xml

Sample:

<APIImportExcelVehicleRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Model.APIModels">
  <AppName xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 14</AppName>
  <AppOperatingSystem xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 13</AppOperatingSystem>
  <AppVersion xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 12</AppVersion>
  <Client xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 11</Client>
  <FreeText xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 6</FreeText>
  <FromIndex xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">7</FromIndex>
  <GroupIds xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
    <d2p1:int>3</d2p1:int>
  </GroupIds>
  <IsRecurringRequest xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">true</IsRecurringRequest>
  <IsWebCalling xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">true</IsWebCalling>
  <MasterUserID xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">15</MasterUserID>
  <RequestMode xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 10</RequestMode>
  <ToIndex xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">8</ToIndex>
  <Token xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 5</Token>
  <DeviceVendor>sample string 2</DeviceVendor>
  <OverrideVehicleProfileAndUnitType>true</OverrideVehicleProfileAndUnitType>
  <UniqueFilename>sample string 1</UniqueFilename>
  <VehicleIDs xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
    <d2p1:int>3</d2p1:int>
  </VehicleIDs>
  <VehicleProfileID>3</VehicleProfileID>
</APIImportExcelVehicleRequest>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Response body formats

application/json, text/json

Sample:

{
  "VehicleData": [
    {
      "ID": 1,
      "RegistrationNumber": "sample string 2",
      "Description": "sample string 3",
      "Model": "sample string 4",
      "Make": "sample string 5",
      "ODO": 6.1,
      "ChassisNumber": "sample string 7",
      "LatestStreetAddress": "sample string 8",
      "CurrentDriverName": "sample string 9",
      "CurrentDriverId": 10,
      "LatestStatusCode": "sample string 11",
      "LastUpdatedOnToDisplay": "sample string 12",
      "LastIncomingMessageOnToDisplay": "sample string 13",
      "ImageName": "sample string 14",
      "AccessRights": {
        "HasRetrieveAccess": true,
        "HasUpdateAccess": true,
        "HasDeleteAccess": true,
        "HasCreateAccess": true
      },
      "AccessRightIdCSV": "sample string 15",
      "SerialNumber": "sample string 20"
    },
    {
      "ID": 1,
      "RegistrationNumber": "sample string 2",
      "Description": "sample string 3",
      "Model": "sample string 4",
      "Make": "sample string 5",
      "ODO": 6.1,
      "ChassisNumber": "sample string 7",
      "LatestStreetAddress": "sample string 8",
      "CurrentDriverName": "sample string 9",
      "CurrentDriverId": 10,
      "LatestStatusCode": "sample string 11",
      "LastUpdatedOnToDisplay": "sample string 12",
      "LastIncomingMessageOnToDisplay": "sample string 13",
      "ImageName": "sample string 14",
      "AccessRights": {
        "HasRetrieveAccess": true,
        "HasUpdateAccess": true,
        "HasDeleteAccess": true,
        "HasCreateAccess": true
      },
      "AccessRightIdCSV": "sample string 15",
      "SerialNumber": "sample string 20"
    },
    {
      "ID": 1,
      "RegistrationNumber": "sample string 2",
      "Description": "sample string 3",
      "Model": "sample string 4",
      "Make": "sample string 5",
      "ODO": 6.1,
      "ChassisNumber": "sample string 7",
      "LatestStreetAddress": "sample string 8",
      "CurrentDriverName": "sample string 9",
      "CurrentDriverId": 10,
      "LatestStatusCode": "sample string 11",
      "LastUpdatedOnToDisplay": "sample string 12",
      "LastIncomingMessageOnToDisplay": "sample string 13",
      "ImageName": "sample string 14",
      "AccessRights": {
        "HasRetrieveAccess": true,
        "HasUpdateAccess": true,
        "HasDeleteAccess": true,
        "HasCreateAccess": true
      },
      "AccessRightIdCSV": "sample string 15",
      "SerialNumber": "sample string 20"
    }
  ],
  "SummaryData": {
    "AverageSpeed": 1.1,
    "AverageDrivingTime": 2.1,
    "AverageStopTime": 3.1,
    "TotalVehicles": 4
  },
  "ErrorCode": 1,
  "Success": true,
  "ErrorMessage": "sample string 3",
  "MenuAccessData": {
    "HasAccessToMap": true,
    "HasAccessToVehicle": true,
    "HasAccessToVehicleAdministration": true,
    "HasAccessToDriver": true,
    "HasAccessToPOI": true,
    "HasAccessToReports": true,
    "HasAccessToSettings": true,
    "HasAccessToTrips": true,
    "HasAccessToTranslations": true,
    "HasAccessToDashboard": true,
    "HasAccessToLogBook": true,
    "HasAccessToGroup": true,
    "HasAccessToTemplate": true,
    "HasAccessToUnit": true,
    "HasAccessToUser": true,
    "HasAccessToTicket": true,
    "HasAccessToContract": true,
    "HasAccessToSIM": true,
    "HasAccessToCommand": true,
    "HasAccessToUnitProfile": true,
    "HasAccessToProfileTrigger": true,
    "HasAccessToScript": true,
    "HasAccessToTriggerSchedule": true
  },
  "StatusCode": 4,
  "ComponentFilterIds": [
    1,
    2,
    3
  ]
}

text/html

Sample:

{"VehicleData":[{"ID":1,"RegistrationNumber":"sample string 2","Description":"sample string 3","Model":"sample string 4","Make":"sample string 5","ODO":6.1,"ChassisNumber":"sample string 7","LatestStreetAddress":"sample string 8","CurrentDriverName":"sample string 9","CurrentDriverId":10,"LatestStatusCode":"sample string 11","LastUpdatedOnToDisplay":"sample string 12","LastIncomingMessageOnToDisplay":"sample string 13","ImageName":"sample string 14","AccessRights":{"HasRetrieveAccess":true,"HasUpdateAccess":true,"HasDeleteAccess":true,"HasCreateAccess":true},"AccessRightIdCSV":"sample string 15","SerialNumber":"sample string 20"},{"ID":1,"RegistrationNumber":"sample string 2","Description":"sample string 3","Model":"sample string 4","Make":"sample string 5","ODO":6.1,"ChassisNumber":"sample string 7","LatestStreetAddress":"sample string 8","CurrentDriverName":"sample string 9","CurrentDriverId":10,"LatestStatusCode":"sample string 11","LastUpdatedOnToDisplay":"sample string 12","LastIncomingMessageOnToDisplay":"sample string 13","ImageName":"sample string 14","AccessRights":{"HasRetrieveAccess":true,"HasUpdateAccess":true,"HasDeleteAccess":true,"HasCreateAccess":true},"AccessRightIdCSV":"sample string 15","SerialNumber":"sample string 20"},{"ID":1,"RegistrationNumber":"sample string 2","Description":"sample string 3","Model":"sample string 4","Make":"sample string 5","ODO":6.1,"ChassisNumber":"sample string 7","LatestStreetAddress":"sample string 8","CurrentDriverName":"sample string 9","CurrentDriverId":10,"LatestStatusCode":"sample string 11","LastUpdatedOnToDisplay":"sample string 12","LastIncomingMessageOnToDisplay":"sample string 13","ImageName":"sample string 14","AccessRights":{"HasRetrieveAccess":true,"HasUpdateAccess":true,"HasDeleteAccess":true,"HasCreateAccess":true},"AccessRightIdCSV":"sample string 15","SerialNumber":"sample string 20"}],"SummaryData":{"AverageSpeed":1.1,"AverageDrivingTime":2.1,"AverageStopTime":3.1,"TotalVehicles":4},"ErrorCode":1,"Success":true,"ErrorMessage":"sample string 3","MenuAccessData":{"HasAccessToMap":true,"HasAccessToVehicle":true,"HasAccessToVehicleAdministration":true,"HasAccessToDriver":true,"HasAccessToPOI":true,"HasAccessToReports":true,"HasAccessToSettings":true,"HasAccessToTrips":true,"HasAccessToTranslations":true,"HasAccessToDashboard":true,"HasAccessToLogBook":true,"HasAccessToGroup":true,"HasAccessToTemplate":true,"HasAccessToUnit":true,"HasAccessToUser":true,"HasAccessToTicket":true,"HasAccessToContract":true,"HasAccessToSIM":true,"HasAccessToCommand":true,"HasAccessToUnitProfile":true,"HasAccessToProfileTrigger":true,"HasAccessToScript":true,"HasAccessToTriggerSchedule":true},"StatusCode":4,"ComponentFilterIds":[1,2,3]}

application/xml, text/xml

Sample:

<APICreateBulkVehicleResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Model.APIModels">
  <ResponseCode xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Model.Transport">Success</ResponseCode>
  <ComponentFilterIds xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
    <d2p1:int>3</d2p1:int>
  </ComponentFilterIds>
  <ErrorMessage xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 3</ErrorMessage>
  <MenuAccessData xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">
    <HasAccessToCommand>true</HasAccessToCommand>
    <HasAccessToContract>true</HasAccessToContract>
    <HasAccessToDashboard>true</HasAccessToDashboard>
    <HasAccessToDriver>true</HasAccessToDriver>
    <HasAccessToGroup>true</HasAccessToGroup>
    <HasAccessToLogBook>true</HasAccessToLogBook>
    <HasAccessToMap>true</HasAccessToMap>
    <HasAccessToPOI>true</HasAccessToPOI>
    <HasAccessToProfileTrigger>true</HasAccessToProfileTrigger>
    <HasAccessToReports>true</HasAccessToReports>
    <HasAccessToSIM>true</HasAccessToSIM>
    <HasAccessToScript>true</HasAccessToScript>
    <HasAccessToSettings>true</HasAccessToSettings>
    <HasAccessToTemplate>true</HasAccessToTemplate>
    <HasAccessToTicket>true</HasAccessToTicket>
    <HasAccessToTranslations>true</HasAccessToTranslations>
    <HasAccessToTriggerSchedule>true</HasAccessToTriggerSchedule>
    <HasAccessToTrips>true</HasAccessToTrips>
    <HasAccessToUnit>true</HasAccessToUnit>
    <HasAccessToUnitProfile>true</HasAccessToUnitProfile>
    <HasAccessToUser>true</HasAccessToUser>
    <HasAccessToVehicle>true</HasAccessToVehicle>
    <HasAccessToVehicleAdministration>true</HasAccessToVehicleAdministration>
  </MenuAccessData>
  <StatusCode xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">4</StatusCode>
  <Success xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">true</Success>
  <ErrorCode>1</ErrorCode>
  <SummaryData>
    <AverageDrivingTime>2.1</AverageDrivingTime>
    <AverageSpeed>1.1</AverageSpeed>
    <AverageStopTime>3.1</AverageStopTime>
    <TotalVehicles>4</TotalVehicles>
  </SummaryData>
  <VehicleData>
    <APIAdminVehicleWithSummaryData>
      <AccessRightIdCSV>sample string 15</AccessRightIdCSV>
      <AccessRights xmlns:d4p1="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">
        <d4p1:HasCreateAccess>true</d4p1:HasCreateAccess>
        <d4p1:HasDeleteAccess>true</d4p1:HasDeleteAccess>
        <d4p1:HasRetrieveAccess>true</d4p1:HasRetrieveAccess>
        <d4p1:HasUpdateAccess>true</d4p1:HasUpdateAccess>
      </AccessRights>
      <ChassisNumber>sample string 7</ChassisNumber>
      <ColumnsForExport>sample string 17</ColumnsForExport>
      <CurrentDriverId>10</CurrentDriverId>
      <CurrentDriverName>sample string 9</CurrentDriverName>
      <Description>sample string 3</Description>
      <ExportFileDateTimeText>sample string 19</ExportFileDateTimeText>
      <ExportFileHeaderNameText>sample string 18</ExportFileHeaderNameText>
      <ID>1</ID>
      <ImageName>sample string 14</ImageName>
      <LastIncomingMessageOn>2024-10-16T23:00:44.0117923+02:00</LastIncomingMessageOn>
      <LastIncomingMessageOnToDisplay>sample string 13</LastIncomingMessageOnToDisplay>
      <LastUpdatedOn>2024-10-16T23:00:44.0117923+02:00</LastUpdatedOn>
      <LastUpdatedOnToDisplay>sample string 12</LastUpdatedOnToDisplay>
      <LatestStatusCode>sample string 11</LatestStatusCode>
      <LatestStreetAddress>sample string 8</LatestStreetAddress>
      <Make>sample string 5</Make>
      <Model>sample string 4</Model>
      <ODO>6.1</ODO>
      <RegistrationNumber>sample string 2</RegistrationNumber>
      <SerialNumber>sample string 20</SerialNumber>
      <TotalDriveTime>16</TotalDriveTime>
    </APIAdminVehicleWithSummaryData>
    <APIAdminVehicleWithSummaryData>
      <AccessRightIdCSV>sample string 15</AccessRightIdCSV>
      <AccessRights xmlns:d4p1="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">
        <d4p1:HasCreateAccess>true</d4p1:HasCreateAccess>
        <d4p1:HasDeleteAccess>true</d4p1:HasDeleteAccess>
        <d4p1:HasRetrieveAccess>true</d4p1:HasRetrieveAccess>
        <d4p1:HasUpdateAccess>true</d4p1:HasUpdateAccess>
      </AccessRights>
      <ChassisNumber>sample string 7</ChassisNumber>
      <ColumnsForExport>sample string 17</ColumnsForExport>
      <CurrentDriverId>10</CurrentDriverId>
      <CurrentDriverName>sample string 9</CurrentDriverName>
      <Description>sample string 3</Description>
      <ExportFileDateTimeText>sample string 19</ExportFileDateTimeText>
      <ExportFileHeaderNameText>sample string 18</ExportFileHeaderNameText>
      <ID>1</ID>
      <ImageName>sample string 14</ImageName>
      <LastIncomingMessageOn>2024-10-16T23:00:44.0117923+02:00</LastIncomingMessageOn>
      <LastIncomingMessageOnToDisplay>sample string 13</LastIncomingMessageOnToDisplay>
      <LastUpdatedOn>2024-10-16T23:00:44.0117923+02:00</LastUpdatedOn>
      <LastUpdatedOnToDisplay>sample string 12</LastUpdatedOnToDisplay>
      <LatestStatusCode>sample string 11</LatestStatusCode>
      <LatestStreetAddress>sample string 8</LatestStreetAddress>
      <Make>sample string 5</Make>
      <Model>sample string 4</Model>
      <ODO>6.1</ODO>
      <RegistrationNumber>sample string 2</RegistrationNumber>
      <SerialNumber>sample string 20</SerialNumber>
      <TotalDriveTime>16</TotalDriveTime>
    </APIAdminVehicleWithSummaryData>
    <APIAdminVehicleWithSummaryData>
      <AccessRightIdCSV>sample string 15</AccessRightIdCSV>
      <AccessRights xmlns:d4p1="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">
        <d4p1:HasCreateAccess>true</d4p1:HasCreateAccess>
        <d4p1:HasDeleteAccess>true</d4p1:HasDeleteAccess>
        <d4p1:HasRetrieveAccess>true</d4p1:HasRetrieveAccess>
        <d4p1:HasUpdateAccess>true</d4p1:HasUpdateAccess>
      </AccessRights>
      <ChassisNumber>sample string 7</ChassisNumber>
      <ColumnsForExport>sample string 17</ColumnsForExport>
      <CurrentDriverId>10</CurrentDriverId>
      <CurrentDriverName>sample string 9</CurrentDriverName>
      <Description>sample string 3</Description>
      <ExportFileDateTimeText>sample string 19</ExportFileDateTimeText>
      <ExportFileHeaderNameText>sample string 18</ExportFileHeaderNameText>
      <ID>1</ID>
      <ImageName>sample string 14</ImageName>
      <LastIncomingMessageOn>2024-10-16T23:00:44.0117923+02:00</LastIncomingMessageOn>
      <LastIncomingMessageOnToDisplay>sample string 13</LastIncomingMessageOnToDisplay>
      <LastUpdatedOn>2024-10-16T23:00:44.0117923+02:00</LastUpdatedOn>
      <LastUpdatedOnToDisplay>sample string 12</LastUpdatedOnToDisplay>
      <LatestStatusCode>sample string 11</LatestStatusCode>
      <LatestStreetAddress>sample string 8</LatestStreetAddress>
      <Make>sample string 5</Make>
      <Model>sample string 4</Model>
      <ODO>6.1</ODO>
      <RegistrationNumber>sample string 2</RegistrationNumber>
      <SerialNumber>sample string 20</SerialNumber>
      <TotalDriveTime>16</TotalDriveTime>
    </APIAdminVehicleWithSummaryData>
  </VehicleData>
</APICreateBulkVehicleResponse>