POST api/excel_upload/upload/{mode}

Request Information

URI Parameters

NameDescriptionTypeAdditional information
mode

string

Required

Body Parameters

Collection of Sheet
NameDescriptionTypeAdditional information
CategoryId

globally unique identifier

None.

Name

string

None.

FileName

string

None.

TableName

string

None.

Columns

Collection of Columns

None.

ColumnMappings

Collection of ColumnMapping

None.

OffsetLine

integer

None.

Rows

Collection of Object

None.

Request Formats

application/json, text/json

Sample:
[
  {
    "rows": [
      {},
      {}
    ],
    "categoryId": "00bda096-d466-4b1a-b732-ea8dd3375e47",
    "name": "sample string 2",
    "fileName": "sample string 3",
    "tableName": "sample string 4",
    "columns": [
      {
        "name": "sample string 1",
        "dataType": "sample string 2",
        "dataTypeDisp": "sample string 3"
      },
      {
        "name": "sample string 1",
        "dataType": "sample string 2",
        "dataTypeDisp": "sample string 3"
      }
    ],
    "columnMappings": [
      {
        "name": "sample string 1",
        "name_x": "sample string 2"
      },
      {
        "name": "sample string 1",
        "name_x": "sample string 2"
      }
    ],
    "offsetLine": 5
  },
  {
    "rows": [
      {},
      {}
    ],
    "categoryId": "00bda096-d466-4b1a-b732-ea8dd3375e47",
    "name": "sample string 2",
    "fileName": "sample string 3",
    "tableName": "sample string 4",
    "columns": [
      {
        "name": "sample string 1",
        "dataType": "sample string 2",
        "dataTypeDisp": "sample string 3"
      },
      {
        "name": "sample string 1",
        "dataType": "sample string 2",
        "dataTypeDisp": "sample string 3"
      }
    ],
    "columnMappings": [
      {
        "name": "sample string 1",
        "name_x": "sample string 2"
      },
      {
        "name": "sample string 1",
        "name_x": "sample string 2"
      }
    ],
    "offsetLine": 5
  }
]

application/xml, text/xml

Sample:
<ArrayOfSheet xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Margin.Core.Utils">
  <Sheet>
    <CategoryId>00bda096-d466-4b1a-b732-ea8dd3375e47</CategoryId>
    <ColumnMappings>
      <ColumnMapping>
        <Name>sample string 1</Name>
        <Name_x>sample string 2</Name_x>
      </ColumnMapping>
      <ColumnMapping>
        <Name>sample string 1</Name>
        <Name_x>sample string 2</Name_x>
      </ColumnMapping>
    </ColumnMappings>
    <Columns>
      <Columns>
        <DataType>sample string 2</DataType>
        <DataTypeDisp>sample string 3</DataTypeDisp>
        <Name>sample string 1</Name>
      </Columns>
      <Columns>
        <DataType>sample string 2</DataType>
        <DataTypeDisp>sample string 3</DataTypeDisp>
        <Name>sample string 1</Name>
      </Columns>
    </Columns>
    <FileName>sample string 3</FileName>
    <Name>sample string 2</Name>
    <OffsetLine>5</OffsetLine>
    <Rows xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:anyType />
      <d3p1:anyType />
    </Rows>
    <TableName>sample string 4</TableName>
  </Sheet>
  <Sheet>
    <CategoryId>00bda096-d466-4b1a-b732-ea8dd3375e47</CategoryId>
    <ColumnMappings>
      <ColumnMapping>
        <Name>sample string 1</Name>
        <Name_x>sample string 2</Name_x>
      </ColumnMapping>
      <ColumnMapping>
        <Name>sample string 1</Name>
        <Name_x>sample string 2</Name_x>
      </ColumnMapping>
    </ColumnMappings>
    <Columns>
      <Columns>
        <DataType>sample string 2</DataType>
        <DataTypeDisp>sample string 3</DataTypeDisp>
        <Name>sample string 1</Name>
      </Columns>
      <Columns>
        <DataType>sample string 2</DataType>
        <DataTypeDisp>sample string 3</DataTypeDisp>
        <Name>sample string 1</Name>
      </Columns>
    </Columns>
    <FileName>sample string 3</FileName>
    <Name>sample string 2</Name>
    <OffsetLine>5</OffsetLine>
    <Rows xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:anyType />
      <d3p1:anyType />
    </Rows>
    <TableName>sample string 4</TableName>
  </Sheet>
</ArrayOfSheet>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

ApiResult
NameDescriptionTypeAdditional information
Status

ApiResultStatus

None.

Data

Object

None.

Message

string

None.

Code

integer

None.

Response Formats

application/json, text/json

Sample:
{
  "status": "success",
  "data": {},
  "message": "sample string 2",
  "code": 1
}

application/xml, text/xml

Sample:
<ApiResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Margin.Models">
  <Code>1</Code>
  <Data />
  <Message>sample string 2</Message>
  <Status>Success</Status>
</ApiResult>