POST api/excel_upload/upload/{mode}

Request Information

URI Parameters

Name	Description	Type	Additional information
mode		string	Required

Body Parameters

Collection of Sheet

Name	Type	Additional 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": "a67b0e91-f6a6-4a92-85f1-5de249cbe13a",
    "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": "a67b0e91-f6a6-4a92-85f1-5de249cbe13a",
    "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>a67b0e91-f6a6-4a92-85f1-5de249cbe13a</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>a67b0e91-f6a6-4a92-85f1-5de249cbe13a</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

Name	Type	Additional 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>