[OBSOLETE]: Retrieves all user timesheets, optionally filtered via OData query options.
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult containing the list of user timesheets.
user_timesheet| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| user_id |
Foreign key of the user this timesheet entry belongs to. |
globally unique identifier | |
| hour_type_id |
Foreign key of the hour type |
globally unique identifier |
Required |
| date_from |
Date+Time timesheet FROM |
date |
Required |
| date_from_rounded |
rounded to the nearest configured interval, used for billing/display. |
date |
Required |
| date_to |
Date+Time timesheet TO |
date |
Required |
| date_to_rounded |
rounded to the nearest configured interval, used for billing/display. |
date |
Required |
| remark |
Additional remark field |
string |
Max length: 4000 |
| is_approved |
Inform if this user_timesheet belongs to a week approved (readonly) |
boolean | |
| is_start_stop |
Indicates this entry was recorded via a start/stop timer rather than manually keyed in. |
boolean | |
| is_time_for_money |
Indicates this time is billable ("time for money") rather than purely informational. |
boolean | |
| db_table_id |
Foreign key to the table timesheet is linked. Can be a jobs,project,company or empty |
globally unique identifier | |
| id_in_table |
Foreign key of the object linked. Can be a jobs.id, project.id , company.id or empty |
globally unique identifier | |
| property_1_checked |
Checked state of the hour type's configurable custom property #1 (see ) for this entry. |
boolean | |
| property_2_checked |
Checked state of the hour type's configurable custom property #2 for this entry. |
boolean | |
| property_3_checked |
Checked state of the hour type's configurable custom property #3 for this entry. |
boolean | |
| property_4_checked |
Checked state of the hour type's configurable custom property #4 for this entry. |
boolean | |
| property_5_checked |
Checked state of the hour type's configurable custom property #5 for this entry. |
boolean | |
| start_latitude_decimal |
Latitude of the user's location when the timer was started. |
decimal number | |
| start_longitude_decimal |
Longitude of the user's location when the timer was started. |
decimal number | |
| end_latitude_decimal |
Latitude of the user's location when the timer was stopped. |
decimal number | |
| end_longitude_decimal |
Longitude of the user's location when the timer was stopped. |
decimal number | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| is_confirmed |
offline field: is_confirmed flag |
boolean |
Response Formats
application/json, text/json
{
"id": "d729a2cd-d06c-458c-b9ba-4fc6b7ce5ea9",
"user_id": "fadadbc1-c354-40a4-aef8-b8b5b0932555",
"hour_type_id": "29be5aaa-2a6a-4a64-81bc-cb17ea4f415a",
"date_from": "2026-11-12T14:27:33.2278364+00:00",
"date_from_rounded": "2026-11-12T14:27:33.2278364+00:00",
"date_to": "2026-11-12T14:27:33.2278364+00:00",
"date_to_rounded": "2026-11-12T14:27:33.2278364+00:00",
"remark": "sample string 8",
"is_approved": true,
"is_start_stop": true,
"is_time_for_money": true,
"db_table_id": "383f9fe0-41f6-417c-acbf-e4caaf890eec",
"id_in_table": "19191aa9-b589-4187-af45-43da43afe9e6",
"property_1_checked": true,
"property_2_checked": true,
"property_3_checked": true,
"property_4_checked": true,
"property_5_checked": true,
"start_latitude_decimal": 19.0,
"start_longitude_decimal": 20.0,
"end_latitude_decimal": 21.0,
"end_longitude_decimal": 22.0,
"modified_dateutc": "2026-11-12T14:27:33.2278364+00:00",
"is_confirmed": true
}
application/xml, text/xml
<user_timesheet xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_from>2026-11-12T14:27:33.227Z</date_from> <date_from_rounded>2026-11-12T14:27:33.227Z</date_from_rounded> <date_to>2026-11-12T14:27:33.227Z</date_to> <date_to_rounded>2026-11-12T14:27:33.227Z</date_to_rounded> <db_table_id>383f9fe0-41f6-417c-acbf-e4caaf890eec</db_table_id> <end_latitude_decimal>21</end_latitude_decimal> <end_longitude_decimal>22</end_longitude_decimal> <hour_type_id>29be5aaa-2a6a-4a64-81bc-cb17ea4f415a</hour_type_id> <id>d729a2cd-d06c-458c-b9ba-4fc6b7ce5ea9</id> <id_in_table>19191aa9-b589-4187-af45-43da43afe9e6</id_in_table> <is_approved>true</is_approved> <is_confirmed>true</is_confirmed> <is_start_stop>true</is_start_stop> <is_time_for_money>true</is_time_for_money> <modified_dateutc>2026-11-12T14:27:33.227Z</modified_dateutc> <property_1_checked>true</property_1_checked> <property_2_checked>true</property_2_checked> <property_3_checked>true</property_3_checked> <property_4_checked>true</property_4_checked> <property_5_checked>true</property_5_checked> <remark>sample string 8</remark> <start_latitude_decimal>19</start_latitude_decimal> <start_longitude_decimal>20</start_longitude_decimal> <user_id>fadadbc1-c354-40a4-aef8-b8b5b0932555</user_id> </user_timesheet>