GET api/ImportExcel?sheetName={sheetName}

Request Information

URI Parameters

Name	Description	Type	Additional information
sheetName		string	Required

Body Parameters

Collection of Data

Name	Type	Additional information
colName	string	None.
rowNumber	integer	None.
modelName	string	None.

Request Formats

application/json, text/json

Sample:

[
  {
    "colName": "sample string 1",
    "rowNumber": 2,
    "modelName": "sample string 3"
  },
  {
    "colName": "sample string 1",
    "rowNumber": 2,
    "modelName": "sample string 3"
  }
]

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

InvoiceData

Name	Type	Additional information
VendorName	string	None.
VendorId	globally unique identifier	None.
InvoiceNo	string	None.
InvoiceDate	date	None.
InvoiceAmount	decimal number	None.
SDAmount	decimal number	None.
Discount	string	None.
GSTAmount	decimal number	None.
AdjustAmount	decimal number	None.
NetAmount	decimal number	None.

Response Formats

application/json, text/json

Sample:

{
  "VendorName": "sample string 1",
  "VendorId": "a3b1c20e-e36f-4344-8d27-6c47ea5ee836",
  "InvoiceNo": "sample string 2",
  "InvoiceDate": "2024-07-05T15:43:27.7139436-05:00",
  "InvoiceAmount": 1.0,
  "SDAmount": 1.0,
  "Discount": "sample string 3",
  "GSTAmount": 1.0,
  "AdjustAmount": 1.0,
  "NetAmount": 1.0
}