POST api/OleDb

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
FilePath	string	None.
XlsFile	Collection of byte	None.
ExcelConfiguration	ExcelConfiguration	None.
WebApiAccessKey	string	None.

Request Formats

application/json, text/json

Sample:

{
  "FilePath": "sample string 1",
  "XlsFile": "QEA=",
  "ExcelConfiguration": {
    "Imex": "A",
    "AllSheets": true,
    "IncludeSheetNameInData": true,
    "EmptyContentsFilter": {
      "IncludeEmptyRows": true,
      "AllowedEmptyRowGroupSize": 2,
      "AllowedEmptyCellGroupSize": 3
    },
    "SheetIndex": 3,
    "SheetName": "sample string 4",
    "FixScientificNotation": true,
    "UseHeaderRow": true
  },
  "WebApiAccessKey": "sample string 2"
}

application/xml, text/xml

Sample:

<XlsDataImportRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Iparcel.DataImport">
  <WebApiAccessKey xmlns="http://schemas.datacontract.org/2004/07/Iparcel.Common.Services.Contracts">sample string 2</WebApiAccessKey>
  <ExcelConfiguration xmlns:d2p1="http://schemas.datacontract.org/2004/07/Iparcel.DataImport.Import.OleDb">
    <d2p1:FixScientificNotation>true</d2p1:FixScientificNotation>
    <d2p1:Imex>65</d2p1:Imex>
    <d2p1:IncludeSheetNameInData>true</d2p1:IncludeSheetNameInData>
    <d2p1:UseHeaderRow>true</d2p1:UseHeaderRow>
  </ExcelConfiguration>
  <FilePath>sample string 1</FilePath>
  <XlsFile>QEA=</XlsFile>
</XlsDataImportRequest>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

XlsDataImportResponse

Name	Type	Additional information
ImportResult	XlsDataImportResult	None.
Success	boolean	None.
FailureInformation	string	None.

Response Formats

application/json, text/json

Sample:

{
  "ImportResult": null,
  "Success": true,
  "FailureInformation": "sample string 2"
}

application/xml, text/xml

Sample:

<XlsDataImportResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Iparcel.DataImport">
  <FailureInformation xmlns="http://schemas.datacontract.org/2004/07/Iparcel.Common.Services.Contracts">sample string 2</FailureInformation>
  <Success xmlns="http://schemas.datacontract.org/2004/07/Iparcel.Common.Services.Contracts">true</Success>
  <ImportResult i:nil="true" />
</XlsDataImportResponse>