GET api/Portal/TimesheetTable?EmployeeID={EmployeeID}
Gather Timesheet records.
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| EmployeeID | integer |
Required |
|
| draw | integer |
None. |
|
| start | integer |
None. |
|
| length | integer |
None. |
|
| order | Collection of IBMS_Cloud_API.Output+TableOrder |
None. |
|
| search | IBMS_Cloud_API.Output+TableSearch |
None. |
|
| columns | Collection of IBMS_Cloud_API.Output+TableColumns |
None. |
|
| contactAssociationType | integer |
None. |
Body Parameters
None.
Response Information
Resource Description
Collection of IBMS_Cloud_API.TimesheetModel+TimesheetFields| Name | Description | Type | Additional information |
|---|---|---|---|
| TimesheetID | integer |
None. |
|
| TimesheetDate | date |
None. |
|
| Notes | string |
None. |
|
| AuthorisedStatusID | integer |
None. |
|
| AuthorisationSubmittedToID | integer |
None. |
|
| AuthorisationSubmittedDate | string |
None. |
|
| AuthorisedByID | integer |
None. |
|
| AuthorisedDate | string |
None. |
|
| AuthorisedDetails | string |
None. |
|
| TimesheetDetails | string |
None. |
|
| TotalHours | decimal number |
None. |
|
| SitesList | string |
None. |
|
| Status | string |
None. |
|
| MondayHours | decimal number |
None. |
|
| TuesdayHours | decimal number |
None. |
|
| WednesdayHours | decimal number |
None. |
|
| ThursdayHours | decimal number |
None. |
|
| FridayHours | decimal number |
None. |
|
| SaturdayHours | decimal number |
None. |
|
| SundayHours | decimal number |
None. |
|
| View | integer |
None. |
|
| EmployeeName | string |
None. |
Response Formats
application/json, text/json
Sample:
[
{
"TimesheetID": 1,
"TimesheetDate": "2025-10-29T12:50:40.9346046+00:00",
"Notes": "sample string 3",
"AuthorisedStatusID": 4,
"AuthorisationSubmittedToID": 5,
"AuthorisationSubmittedDate": "sample string 6",
"AuthorisedByID": 7,
"AuthorisedDate": "sample string 8",
"AuthorisedDetails": "sample string 9",
"TimesheetDetails": "sample string 10",
"TotalHours": 11.1,
"SitesList": "sample string 12",
"Status": "sample string 13",
"MondayHours": 14.1,
"TuesdayHours": 15.1,
"WednesdayHours": 16.1,
"ThursdayHours": 17.1,
"FridayHours": 18.1,
"SaturdayHours": 19.1,
"SundayHours": 20.1,
"View": 21,
"EmployeeName": "sample string 22"
},
{
"TimesheetID": 1,
"TimesheetDate": "2025-10-29T12:50:40.9346046+00:00",
"Notes": "sample string 3",
"AuthorisedStatusID": 4,
"AuthorisationSubmittedToID": 5,
"AuthorisationSubmittedDate": "sample string 6",
"AuthorisedByID": 7,
"AuthorisedDate": "sample string 8",
"AuthorisedDetails": "sample string 9",
"TimesheetDetails": "sample string 10",
"TotalHours": 11.1,
"SitesList": "sample string 12",
"Status": "sample string 13",
"MondayHours": 14.1,
"TuesdayHours": 15.1,
"WednesdayHours": 16.1,
"ThursdayHours": 17.1,
"FridayHours": 18.1,
"SaturdayHours": 19.1,
"SundayHours": 20.1,
"View": 21,
"EmployeeName": "sample string 22"
}
]
text/html
Sample:
[{"TimesheetID":1,"TimesheetDate":"2025-10-29T12:50:40.9346046+00:00","Notes":"sample string 3","AuthorisedStatusID":4,"AuthorisationSubmittedToID":5,"AuthorisationSubmittedDate":"sample string 6","AuthorisedByID":7,"AuthorisedDate":"sample string 8","AuthorisedDetails":"sample string 9","TimesheetDetails":"sample string 10","TotalHours":11.1,"SitesList":"sample string 12","Status":"sample string 13","MondayHours":14.1,"TuesdayHours":15.1,"WednesdayHours":16.1,"ThursdayHours":17.1,"FridayHours":18.1,"SaturdayHours":19.1,"SundayHours":20.1,"View":21,"EmployeeName":"sample string 22"},{"TimesheetID":1,"TimesheetDate":"2025-10-29T12:50:40.9346046+00:00","Notes":"sample string 3","AuthorisedStatusID":4,"AuthorisationSubmittedToID":5,"AuthorisationSubmittedDate":"sample string 6","AuthorisedByID":7,"AuthorisedDate":"sample string 8","AuthorisedDetails":"sample string 9","TimesheetDetails":"sample string 10","TotalHours":11.1,"SitesList":"sample string 12","Status":"sample string 13","MondayHours":14.1,"TuesdayHours":15.1,"WednesdayHours":16.1,"ThursdayHours":17.1,"FridayHours":18.1,"SaturdayHours":19.1,"SundayHours":20.1,"View":21,"EmployeeName":"sample string 22"}]
application/xml, text/xml
Sample:
<ArrayOfTimesheetModel.TimesheetFields xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/IBMS_Cloud_API">
<TimesheetModel.TimesheetFields>
<AuthorisationSubmittedDate>sample string 6</AuthorisationSubmittedDate>
<AuthorisationSubmittedToID>5</AuthorisationSubmittedToID>
<AuthorisedByID>7</AuthorisedByID>
<AuthorisedDate>sample string 8</AuthorisedDate>
<AuthorisedDetails>sample string 9</AuthorisedDetails>
<AuthorisedStatusID>4</AuthorisedStatusID>
<EmployeeName>sample string 22</EmployeeName>
<FridayHours>18.1</FridayHours>
<MondayHours>14.1</MondayHours>
<Notes>sample string 3</Notes>
<SaturdayHours>19.1</SaturdayHours>
<SitesList>sample string 12</SitesList>
<Status>sample string 13</Status>
<SundayHours>20.1</SundayHours>
<ThursdayHours>17.1</ThursdayHours>
<TimesheetDate>2025-10-29T12:50:40.9346046+00:00</TimesheetDate>
<TimesheetDetails>sample string 10</TimesheetDetails>
<TimesheetID>1</TimesheetID>
<TotalHours>11.1</TotalHours>
<TuesdayHours>15.1</TuesdayHours>
<View>21</View>
<WednesdayHours>16.1</WednesdayHours>
</TimesheetModel.TimesheetFields>
<TimesheetModel.TimesheetFields>
<AuthorisationSubmittedDate>sample string 6</AuthorisationSubmittedDate>
<AuthorisationSubmittedToID>5</AuthorisationSubmittedToID>
<AuthorisedByID>7</AuthorisedByID>
<AuthorisedDate>sample string 8</AuthorisedDate>
<AuthorisedDetails>sample string 9</AuthorisedDetails>
<AuthorisedStatusID>4</AuthorisedStatusID>
<EmployeeName>sample string 22</EmployeeName>
<FridayHours>18.1</FridayHours>
<MondayHours>14.1</MondayHours>
<Notes>sample string 3</Notes>
<SaturdayHours>19.1</SaturdayHours>
<SitesList>sample string 12</SitesList>
<Status>sample string 13</Status>
<SundayHours>20.1</SundayHours>
<ThursdayHours>17.1</ThursdayHours>
<TimesheetDate>2025-10-29T12:50:40.9346046+00:00</TimesheetDate>
<TimesheetDetails>sample string 10</TimesheetDetails>
<TimesheetID>1</TimesheetID>
<TotalHours>11.1</TotalHours>
<TuesdayHours>15.1</TuesdayHours>
<View>21</View>
<WednesdayHours>16.1</WednesdayHours>
</TimesheetModel.TimesheetFields>
</ArrayOfTimesheetModel.TimesheetFields>