Getting started

INSERT INTO
    Bills (Contact, Reference, Dated_On, Due_On, Bill_Items)
VALUES
    (
        'https://api.freeagent.com/v2/contacts/18541472',
        'YEB002',
        '2024-11-28',
        '2024-12-28',
        '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB Line 2 standing charge","sales_tax_rate":"20","total_value_ex_tax":49.99}]'
    )

[
  {
    "category": "https://api.freeagent.com/v2/categories/291",
    "description": "YEB Line 2 standing charge",
    "sales_tax_rate": "20",
    "total_value_ex_tax": 49.99
  }
]

INSERT INTO
    Contacts (
        First_Name,
        Last_Name,
        Email,
        Billing_Email,
        Phone_Number,
        Mobile,
        Address1,
        Address2,
        Address3,
        Town,
        Region,
        Postcode,
        Country,
        Uses_Contact_Invoice_Sequence,
        Contact_Name_On_Invoices,
        Charge_Sales_Tax,
        Sales_Tax_Registration_Number,
        [Status],
        Default_Payment_Terms_In_Days,
        Locale
    )
VALUES
    (
        'Thomas, ' Axen ', ' ta@example.com ', ' bills@example.com ', ' (123) 555 -0101 ', ' (321) 555 -0101 ', ' 123 Third Street ', '', '', ' Los Angeles ', ' CA ', ' 99999 ', USA',
        'false',
        'true',
        'Always',
        'US123456789',
        'Active',
        '30',
        'en'
    )

INSERT INTO
    Credit_Notes (Contact, Dated_On, Currency, Credit_Note_Items)
VALUES
    (
        'https://api.freeagent.com/v2/contacts/18494140',
        '2024-11-27',
        'GBP',
        '[{"item_type":"Days","quantity":"1","price":"-999.99","description":"Consultancy Days"}]'
    )

[
  {
    "item_type": "Days",
    "quantity": "1",
    "price": "-999.99",
    "description": "Consultancy Days"
  }
]

INSERT INTO
    Estimates (
        Contact,
        Dated_On,
        [Status],
        Estimate_Type,
        Currency,
        Reference,
        Estimate_Items
    )
VALUES
    (
        'https://api.freeagent.com/v2/contacts/18494140',
        '2024-11-27',
        'Draft',
        'Quote',
        'USD',
        'Customer Ref 2',
        '[{"item_type":"Days","quantity":"2","price":"999.99","description":"Consultancy Days"}]'
    )

[
  {
    "item_type": "Days",
    "quantity": "2",
    "price": "999.99",
    "description": "Consultancy Days"
  }
]

INSERT INTO
    Expenses (
        User,
        Category,
        Dated_On,
        Currency,
        Gross_Value,
        Sales_Tax_Rate,
        Sales_Tax_Status,
        [Description]
    )
VALUES
    (
        'https://api.freeagent.com/v2/users/1861284',
        'https://api.freeagent.com/v2/categories/287',
        '2024-12-03',
        'GBP',
        '-200',
        '20',
        'TAXABLE',
        'Overnight stay'
    )

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"}]'
    )

[
  {
    "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 Bank_Transaction_Explanations
SET
    Description = 'New FEE description text.'
WHERE
    Id = '532804092'

UPDATE Bills
SET
    Comments = 'Standing charge for second line.'
WHERE
    Id = '31467166'

UPDATE Contacts
SET
    Mobile = '(321)555-0101'
WHERE
    Email = 'ta@example.com'
DELETE FROM Contacts
WHERE
    Id = '18482080'

UPDATE Credit_Notes
SET
    Credit_Note_Items = '[{"item_type":"Days","quantity":"4","price":"-999.99","description":"Consultancy Days"},{"item_type":"Hours","quantity":"32","price":"-172.22","description":"Developer Hours"}]'
WHERE
    Id = '73934615'

[
  {
    "item_type": "Days",
    "quantity": "4",
    "price": "-999.99",
    "description": "Consultancy Days"
  },
  {
    "item_type": "Hours",
    "quantity": "32",
    "price": "-172.22",
    "description": "Developer Hours"
  }
]

UPDATE Expenses
SET
    Description = 'Hotel Stay'
WHERE
    Id = '53063365'

UPDATE Price_List_Items
SET
    Price = 10.99
WHERE
    Code = 'CS001'

UPDATE Users
SET
    Last_Name = 'Jones'
WHERE
    Id = '1853395'