Timeslips table

Column Type

Id

Integer

Url

URI

From_Date

Parameter

To_Date

Parameter

Updated_Since

Parameter

Created_At

Timestamp

User_Id

String

User

URI

Project_Id

String

Project

URI

Task

URI

Hours

Decimal

Dated_On

String

Updated_At

Timestamp

Comment

String

Examples

SELECT
    *
FROM
    Timeslips
WHERE
    Hours >= 6

INSERT INTO
    Timeslips (User, Project, Task, Dated_On, [Hours])
VALUES
    (
        'https://api.freeagent.com/v2/users/1853395',
        'https://api.freeagent.com/v2/projects/4088689',
        'https://api.freeagent.com/v2/tasks/5394290',
        '2024-12-03',
        '6'
    )

UPDATE Timeslips
SET
    Hours = 10
WHERE
    Id = '48653687'

DELETE FROM Timeslips
WHERE
    Id = '48653687'