Journal_Sets table

Column Type

Id

Integer

Url

URI

From_Date

Parameter

To_Date

Parameter

Updated_Since

Parameter

Tag

Parameter

Updated_At

Timestamp

Dated_On

String

Description

String

Journal_Entries

Array

Bank_Accounts

Array

Stock_Items

Array

Examples

SELECT
    *
FROM
    Journal_Sets
WHERE
    Id = '5754992'

INSERT INTO
    Journal_Sets (Dated_On, [Description], Journal_Entries)
VALUES
    (
        '2024-12-03',
        'Sample Journal Created',
        '[{"category":"https://api.freeagent.com/v2/categories/363","description":"Sample journal line 1","debit_value":"10"},{"category":"https://api.freeagent.com/v2/categories/001","description":"Sample journal line 2","debit_value":"-10"}]'
    )

UPDATE Journal_Sets
SET
    Journal_Entries = REPLACE (
        REPLACE (
            Journal_Entries,
            '""debit_value"":""10.0""',
            '""debit_value"":""10.99""'
        ),
        '""debit_value"":""-10.0""',
        '""debit_value"":""-10.99""'
    )
WHERE
    Id = '5762019'

DELETE FROM Journal_Sets
WHERE
    Id = '5762019'