GET api/ImportExcel?sheetName={sheetName}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| sheetName | string |
Required |
Body Parameters
Collection of Data| Name | Description | 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 | Description | 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": "c5f6a200-abc9-4371-a269-2312468d297b",
"InvoiceNo": "sample string 2",
"InvoiceDate": "2025-12-13T03:26:03.7096214-06:00",
"InvoiceAmount": 1.0,
"SDAmount": 1.0,
"Discount": "sample string 3",
"GSTAmount": 1.0,
"AdjustAmount": 1.0,
"NetAmount": 1.0
}