POST api/excel_upload

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

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.

Response Formats

application/json, text/json

Sample:

[
  {
    "rows": [
      {},
      {}
    ],
    "categoryId": "8367bb06-cf40-4532-b47f-9cf9c9d3162a",
    "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": "8367bb06-cf40-4532-b47f-9cf9c9d3162a",
    "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>8367bb06-cf40-4532-b47f-9cf9c9d3162a</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>8367bb06-cf40-4532-b47f-9cf9c9d3162a</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>