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",
  "VehicleIDs": [
    1,
    2,
    3
  ],
  "OverrideVehicleProfileAndUnitType": true,
  "Token": "sample string 3",
  "FreeText": "sample string 4",
  "GroupIds": [
    1,
    2,
    3
  ],
  "FromIndex": 5,
  "ToIndex": 6,
  "IsWebCalling": true,
  "RequestMode": "sample string 8",
  "Client": "sample string 9",
  "AppVersion": "sample string 10",
  "AppOperatingSystem": "sample string 11",
  "AppName": "sample string 12",
  "MasterUserID": 13,
  "IsRecurringRequest": true
}

text/html

Sample:

{"UniqueFilename":"sample string 1","VehicleIDs":[1,2,3],"OverrideVehicleProfileAndUnitType":true,"Token":"sample string 3","FreeText":"sample string 4","GroupIds":[1,2,3],"FromIndex":5,"ToIndex":6,"IsWebCalling":true,"RequestMode":"sample string 8","Client":"sample string 9","AppVersion":"sample string 10","AppOperatingSystem":"sample string 11","AppName":"sample string 12","MasterUserID":13,"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 12</AppName>
  <AppOperatingSystem xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 11</AppOperatingSystem>
  <AppVersion xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 10</AppVersion>
  <Client xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 9</Client>
  <FreeText xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 4</FreeText>
  <FromIndex xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">5</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">13</MasterUserID>
  <RequestMode xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 8</RequestMode>
  <ToIndex xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">6</ToIndex>
  <Token xmlns="http://schemas.datacontract.org/2004/07/Accessor.Common.Models.APIModels">sample string 3</Token>
  <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>
</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,
    "HasAccessToMetaBaseReport": true,
    "HasAccessToMetaBaseUserDashboard": true,
    "HasAccessToRecoveryMode": 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,"HasAccessToMetaBaseReport":true,"HasAccessToMetaBaseUserDashboard":true,"HasAccessToRecoveryMode":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>
    <HasAccessToMetaBaseReport>true</HasAccessToMetaBaseReport>
    <HasAccessToMetaBaseUserDashboard>true</HasAccessToMetaBaseUserDashboard>
    <HasAccessToPOI>true</HasAccessToPOI>
    <HasAccessToProfileTrigger>true</HasAccessToProfileTrigger>
    <HasAccessToRecoveryMode>true</HasAccessToRecoveryMode>
    <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>2025-12-18T16:51:39.3657484+01:00</LastIncomingMessageOn>
      <LastIncomingMessageOnToDisplay>sample string 13</LastIncomingMessageOnToDisplay>
      <LastUpdatedOn>2025-12-18T16:51:39.3657484+01: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>2025-12-18T16:51:39.3657484+01:00</LastIncomingMessageOn>
      <LastIncomingMessageOnToDisplay>sample string 13</LastIncomingMessageOnToDisplay>
      <LastUpdatedOn>2025-12-18T16:51:39.3657484+01: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>2025-12-18T16:51:39.3657484+01:00</LastIncomingMessageOn>
      <LastIncomingMessageOnToDisplay>sample string 13</LastIncomingMessageOnToDisplay>
      <LastUpdatedOn>2025-12-18T16:51:39.3657484+01: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>