Tasks table

Column Type

Id

Integer

Url

URI

Updated_At

Timestamp

Project

String

Name

String

Currency

String

Is_Billable

Boolean

Status

String

Billing_Rate

Decimal

Billing_Period

String

Created_At

Timestamp

Is_Deletable

Boolean

Examples

SELECT
    *
FROM
    Tasks
WHERE
    Is_Deletable = False

INSERT INTO
    Tasks (
        [Name],
        Currency,
        Is_Billable,
        Billing_Period,
        Billing_Rate,
        Project,
        [Status],
        Is_Deletable
    )
VALUES
    (
        'Test task.',
        'GBP',
        'true',
        'hour',
        '249.95',
        'https://api.freeagent.com/v2/projects/4088689',
        'Active',
        'true'
    )

UPDATE TASKS
SET
    Name = 'Test task 2.'
WHERE
    Id = '5399215'

DELETE FROM Tasks
WHERE
    Id = '5399215'