POST api/excel_upload/upload/{mode}
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
mode | string |
Required |
Body Parameters
Collection of SheetName | Description | 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": "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
ApiResultName | Description | 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>