POST api/Employee/GetEmployeeSalaryDetailsforexcel
Request Information
URI Parameters
None.
Body Parameters
ExportExcelModel| Name | Description | Type | Additional information |
|---|---|---|---|
| Empid | integer |
None. |
|
| Prefixfromdate | date |
None. |
|
| suffixtodate | date |
None. |
|
| Month | string |
None. |
|
| TotalDays | integer |
None. |
|
| empno | integer |
None. |
|
| year | integer |
None. |
|
| SLNO | integer |
None. |
|
| EMPLOYEECODE | string |
None. |
|
| NAME_OF_EMPLOYEES | string |
None. |
|
| SITE | string |
None. |
|
| W | string |
None. |
|
| O | string |
None. |
|
| Department | string |
None. |
|
| Designation | string |
None. |
|
| E | string |
None. |
|
| T_D | string |
None. |
|
| BASIC | decimal number |
None. |
|
| STIPEND | decimal number |
None. |
|
| WORKING_DAYS | integer |
None. |
|
| DAY_S_ABSENT | decimal number |
None. |
|
| DEDUCTION_AGAINST_ABSENSE | decimal number |
None. |
|
| E_L_ | decimal number |
None. |
|
| PAYMENT_AGAINST_E_L_ | decimal number |
None. |
|
| GROSS_AMOUNT | decimal number |
None. |
|
| HRA | decimal number |
None. |
|
| LODGING_ALLOWANCE | decimal number |
None. |
|
| Attire_Allowance | decimal number |
None. |
|
| TRAINING_ALLOWANCE_ACHIEVED | decimal number |
None. |
|
| MOBILE | decimal number |
None. |
|
| BOOKS_AND_PERIODICALS_ALLOWANCE | decimal number |
None. |
|
| INTERNET_ALLOWANCE | decimal number |
None. |
|
| CONINUOUS_ATTENDENCE_ALLOWANCE | decimal number |
None. |
|
| Conveyence_Allowance | decimal number |
None. |
|
| PRODUCTION_BONUS | decimal number |
None. |
|
| PRODUCTION_BONUS_ACHIEVED | decimal number |
None. |
|
| OVERTIME | decimal number |
None. |
|
| OVERTIME_AMOUNT | decimal number |
None. |
|
| MEDICAL_ALLOWANCES | decimal number |
None. |
|
| LTA | decimal number |
None. |
|
| EDUCATION_ALLOWANCES | decimal number |
None. |
|
| TOTAL_ALLOWANCES | decimal number |
None. |
|
| PF | decimal number |
None. |
|
| PTAX | decimal number |
None. |
|
| E_S_I | decimal number |
None. |
|
| TOTAL_DEDUCTION | decimal number |
None. |
|
| OPENING_BALANCE | decimal number |
None. |
|
| DEDUCTION | decimal number |
None. |
|
| CLOSING_BALANCE | decimal number |
None. |
|
| NET_AMOUNT | decimal number |
None. |
|
| PAID_DATE | string |
None. |
Request Formats
application/json, text/json
Sample:
{
"Empid": 1,
"Prefixfromdate": "2025-12-06T09:45:13.0150216+05:30",
"suffixtodate": "2025-12-06T09:45:13.0150216+05:30",
"Month": "sample string 2",
"TotalDays": 3,
"empno": 4,
"year": 5,
"SLNO": 6,
"EMPLOYEECODE": "sample string 7",
"NAME_OF_EMPLOYEES": "sample string 8",
"SITE": "sample string 9",
"W": "sample string 10",
"O": "sample string 11",
"Department": "sample string 12",
"Designation": "sample string 13",
"E": "sample string 14",
"T_D": "sample string 15",
"BASIC": 1.1,
"STIPEND": 1.1,
"WORKING_DAYS": 1,
"DAY_S_ABSENT": 1.1,
"DEDUCTION_AGAINST_ABSENSE": 1.1,
"E_L_": 1.1,
"PAYMENT_AGAINST_E_L_": 1.1,
"GROSS_AMOUNT": 1.1,
"HRA": 1.1,
"LODGING_ALLOWANCE": 1.1,
"Attire_Allowance": 1.1,
"TRAINING_ALLOWANCE_ACHIEVED": 1.1,
"MOBILE": 1.1,
"BOOKS_AND_PERIODICALS_ALLOWANCE": 1.1,
"INTERNET_ALLOWANCE": 1.1,
"CONINUOUS_ATTENDENCE_ALLOWANCE": 1.1,
"Conveyence_Allowance": 1.1,
"PRODUCTION_BONUS": 1.1,
"PRODUCTION_BONUS_ACHIEVED": 1.1,
"OVERTIME": 1.1,
"OVERTIME_AMOUNT": 1.1,
"MEDICAL_ALLOWANCES": 1.1,
"LTA": 1.1,
"EDUCATION_ALLOWANCES": 1.1,
"TOTAL_ALLOWANCES": 1.1,
"PF": 1.1,
"PTAX": 1.1,
"E_S_I": 1.1,
"TOTAL_DEDUCTION": 1.1,
"OPENING_BALANCE": 1.0,
"DEDUCTION": 1.1,
"CLOSING_BALANCE": 1.0,
"NET_AMOUNT": 1.1,
"PAID_DATE": "sample string 16"
}
application/xml, text/xml
Sample:
<ExportExcelModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/MendinePayroll.Models"> <Attire_Allowance>1.1</Attire_Allowance> <BASIC>1.1</BASIC> <BOOKS_AND_PERIODICALS_ALLOWANCE>1.1</BOOKS_AND_PERIODICALS_ALLOWANCE> <CLOSING_BALANCE>1</CLOSING_BALANCE> <CONINUOUS_ATTENDENCE_ALLOWANCE>1.1</CONINUOUS_ATTENDENCE_ALLOWANCE> <Conveyence_Allowance>1.1</Conveyence_Allowance> <DAY_S_ABSENT>1.1</DAY_S_ABSENT> <DEDUCTION>1.1</DEDUCTION> <DEDUCTION_AGAINST_ABSENSE>1.1</DEDUCTION_AGAINST_ABSENSE> <Department>sample string 12</Department> <Designation>sample string 13</Designation> <E>sample string 14</E> <EDUCATION_ALLOWANCES>1.1</EDUCATION_ALLOWANCES> <EMPLOYEECODE>sample string 7</EMPLOYEECODE> <E_L_>1.1</E_L_> <E_S_I>1.1</E_S_I> <Empid>1</Empid> <GROSS_AMOUNT>1.1</GROSS_AMOUNT> <HRA>1.1</HRA> <INTERNET_ALLOWANCE>1.1</INTERNET_ALLOWANCE> <LODGING_ALLOWANCE>1.1</LODGING_ALLOWANCE> <LTA>1.1</LTA> <MEDICAL_ALLOWANCES>1.1</MEDICAL_ALLOWANCES> <MOBILE>1.1</MOBILE> <Month>sample string 2</Month> <NAME_OF_EMPLOYEES>sample string 8</NAME_OF_EMPLOYEES> <NET_AMOUNT>1.1</NET_AMOUNT> <O>sample string 11</O> <OPENING_BALANCE>1</OPENING_BALANCE> <OVERTIME>1.1</OVERTIME> <OVERTIME_AMOUNT>1.1</OVERTIME_AMOUNT> <PAID_DATE>sample string 16</PAID_DATE> <PAYMENT_AGAINST_E_L_>1.1</PAYMENT_AGAINST_E_L_> <PF>1.1</PF> <PRODUCTION_BONUS>1.1</PRODUCTION_BONUS> <PRODUCTION_BONUS_ACHIEVED>1.1</PRODUCTION_BONUS_ACHIEVED> <PTAX>1.1</PTAX> <Prefixfromdate>2025-12-06T09:45:13.0150216+05:30</Prefixfromdate> <SITE>sample string 9</SITE> <SLNO>6</SLNO> <STIPEND>1.1</STIPEND> <TOTAL_ALLOWANCES>1.1</TOTAL_ALLOWANCES> <TOTAL_DEDUCTION>1.1</TOTAL_DEDUCTION> <TRAINING_ALLOWANCE_ACHIEVED>1.1</TRAINING_ALLOWANCE_ACHIEVED> <T_D>sample string 15</T_D> <TotalDays>3</TotalDays> <W>sample string 10</W> <WORKING_DAYS>1</WORKING_DAYS> <empno>4</empno> <suffixtodate>2025-12-06T09:45:13.0150216+05:30</suffixtodate> <year>5</year> </ExportExcelModel>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
HttpResponseMessage| Name | Description | Type | Additional information |
|---|---|---|---|
| Version | Version |
None. |
|
| Content | HttpContent |
None. |
|
| StatusCode | HttpStatusCode |
None. |
|
| ReasonPhrase | string |
None. |
|
| Headers | Collection of Object |
None. |
|
| RequestMessage | HttpRequestMessage |
None. |
|
| IsSuccessStatusCode | boolean |
None. |