GET api/Portal/TimesheetTable?EmployeeID={EmployeeID}

Gather Timesheet records.

Request Information

URI Parameters

Name	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.

Body Parameters

None.

Response Information

Resource Description

Collection of IBMS_Cloud_API.TimesheetModel+TimesheetFields

Name	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-04-28T15:21:48.1122571+01: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-04-28T15:21:48.1122571+01: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-04-28T15:21:48.1122571+01: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-04-28T15:21:48.1122571+01: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-04-28T15:21:48.1122571+01: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-04-28T15:21:48.1122571+01: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>