Read transaction lines

GET /transactionlines

Read a list of transaction lines for a defined period, based on various filtering criteria.

Headers

Query parameters

  • dateFrom string(date) Required

    The starting date (inclusive) from which transactions will be retrieved.

  • dateTo string(date) Required

    The ending date (exclusive) until which transactions will be retrieved. If set to 2024-01-01, the latest result will be retrieved before 23:59 on 2023-12-31.

  • The unique number representing the transaction.

  • ID representing the type of transaction.

  • ID of the customer involved in the transaction.

  • ID of the account involved in the transaction.

  • The number of the account involved in the transaction.

  • The invoice number associated with the transaction.

  • The currency code used in the transaction.

  • limit integer

    The maximum number of transactions to retrieve.

    Default value is 50.

  • page integer

    The page number of the results to retrieve.

    Default value is 1.

Responses

  • Hide headers attributes Show headers attributes
    Hide response attributes Show response attributes object
    • id number

      A unique identifier for the transaction line within 24SevenOffice accounting module.

    • Details of the transaction within the 24SevenOffice accounting module to which the transaction line pertains.

      Note: Many other Norway-based accounting systems refer to transactions as "vouchers".

      Additional properties are allowed.

      Hide transaction attributes Show transaction attributes object
      • id number

        A unique identifier for the transaction within 24SevenOffice accounting module.

      • number number

        The unique number representing the transaction.

    • account object Required

      Details of an account within the 24SevenOffice accounting module to which the transaction line is posted.

      Additional properties are allowed.

      Hide account attributes Show account attributes object
      • id number

        A unique identifier for the account within 24SevenOffice.

      • number number

        The unique number within the organization's chart of accounts that indicates which type of account the account belongs to.

      • name string

        The human-readable name that describes the purpose or nature of the account.

    • Details of a transaction type used within the 24SevenOffice accounting module.

      Additional properties are allowed.

      Hide transactionType attribute Show transactionType attribute object
      • id number

        A unique identifier for the transaction type within 24SevenOffice accounting module.

    • tax object

      Details of a tax used within 24SevenOffice.

      Additional properties are allowed.

      Hide tax attributes Show tax attributes object
      • id number

        A unique identifier for the tax within 24SevenOffice.

      • rate number

        The tax rate applied to the transaction line.

    • amount number Required

      The monetary amount for the transaction line.

    • currency object

      Details of the currency used within 24SevenOffice.

      Additional properties are allowed.

      Hide currency attributes Show currency attributes object
      • code string(regex)

        The currency code used in the transaction line.

        Format should match the following pattern: ^([A-Z]{3}|LOCAL)$.

      • rate number Required

        The exchange rate for the currency.

        Minimum value is 0.

    • date string(date) Required

      The date when the transaction line was posted.

    • invoice object

      Details of an invoice used within 24SevenOffice.

      Additional properties are allowed.

      Hide invoice attributes Show invoice attributes object
    • customer object

      Details of a customer used within 24SevenOffice CRM.

      Additional properties are allowed.

      Hide customer attribute Show customer attribute object
      • id number

        A unique identifier for the customer within 24SevenOffice CRM.

    • comment string

      A brief description of the transaction.

      Maximum length is 75.

    • createdAt string(date-time)

      A timestamp for when a record was created, in ISO 8601 format.

    • modifiedAt string(date-time)

      A timestamp for when one of the properties of a record was last modified, in ISO 8601 format.

    Hide response attributes Show response attributes object
    • id number

      A unique identifier for the transaction line within 24SevenOffice accounting module.

    • Details of the transaction within the 24SevenOffice accounting module to which the transaction line pertains.

      Note: Many other Norway-based accounting systems refer to transactions as "vouchers".

      Additional properties are allowed.

      Hide transaction attributes Show transaction attributes object
      • id number

        A unique identifier for the transaction within 24SevenOffice accounting module.

      • number number

        The unique number representing the transaction.

    • account object Required

      Details of an account within the 24SevenOffice accounting module to which the transaction line is posted.

      Additional properties are allowed.

      Hide account attributes Show account attributes object
      • id number

        A unique identifier for the account within 24SevenOffice.

      • number number

        The unique number within the organization's chart of accounts that indicates which type of account the account belongs to.

      • name string

        The human-readable name that describes the purpose or nature of the account.

    • Details of a transaction type used within the 24SevenOffice accounting module.

      Additional properties are allowed.

      Hide transactionType attribute Show transactionType attribute object
      • id number

        A unique identifier for the transaction type within 24SevenOffice accounting module.

    • tax object

      Details of a tax used within 24SevenOffice.

      Additional properties are allowed.

      Hide tax attributes Show tax attributes object
      • id number

        A unique identifier for the tax within 24SevenOffice.

      • rate number

        The tax rate applied to the transaction line.

    • amount number Required

      The monetary amount for the transaction line.

    • currency object

      Details of the currency used within 24SevenOffice.

      Additional properties are allowed.

      Hide currency attributes Show currency attributes object
      • code string(regex)

        The currency code used in the transaction line.

        Format should match the following pattern: ^([A-Z]{3}|LOCAL)$.

      • rate number Required

        The exchange rate for the currency.

        Minimum value is 0.

    • date string(date) Required

      The date when the transaction line was posted.

    • invoice object

      Details of an invoice used within 24SevenOffice.

      Additional properties are allowed.

      Hide invoice attributes Show invoice attributes object
    • customer object

      Details of a customer used within 24SevenOffice CRM.

      Additional properties are allowed.

      Hide customer attribute Show customer attribute object
      • id number

        A unique identifier for the customer within 24SevenOffice CRM.

    • comment string

      A brief description of the transaction.

      Maximum length is 75.

    • createdAt string(date-time)

      A timestamp for when a record was created, in ISO 8601 format.

    • modifiedAt string(date-time)

      A timestamp for when one of the properties of a record was last modified, in ISO 8601 format.

GET /transactionlines
curl \
 -X GET https://rest.api.24sevenoffice.com/v1/transactionlines?dateFrom=2024-05-04&dateTo=2024-05-04 \
 -H "Authorization: string"
Response examples (200)
[
  {
    "id": 7001,
    "tax": {
      "id": 2001,
      "rate": 25
    },
    "date": "2022-07-01",
    "amount": 1500,
    "account": {
      "id": 1000001,
      "name": "Cash, NOK",
      "number": 1900
    },
    "comment": "Payment for services",
    "invoice": {
      "number": "INV-2022-001",
      "dueDate": "2022-08-01",
      "remittanceReference": "OCR-123456789"
    },
    "currency": {
      "code": "USD",
      "rate": 10
    },
    "customer": {
      "id": 6001
    },
    "createdAt": "2022-01-01T18:00:00Z",
    "modifiedAt": "2023-12-31T18:00:00Z",
    "transaction": {
      "id": 3001,
      "number": 1010
    },
    "transactionType": {
      "id": 5001
    }
  },
  {
    "id": 7002,
    "tax": {
      "id": 2002,
      "rate": 20
    },
    "date": "2022-07-15",
    "amount": 2500,
    "account": {
      "id": 1000002,
      "name": "Accounts Receivable",
      "number": 1800
    },
    "comment": "Consulting fees",
    "invoice": {
      "number": "INV-2022-002",
      "dueDate": "2022-08-15",
      "remittanceReference": "OCR-987654321"
    },
    "currency": {
      "code": "NOK",
      "rate": 1
    },
    "customer": {
      "id": 6002
    },
    "createdAt": "2022-02-01T12:00:00Z",
    "modifiedAt": "2023-11-30T14:30:00Z",
    "transaction": {
      "id": 3002,
      "number": 1020
    },
    "transactionType": {
      "id": 5002
    }
  },
  {
    "id": 7003,
    "tax": {
      "id": 2003,
      "rate": 15
    },
    "date": "2022-07-20",
    "amount": 3000,
    "account": {
      "id": 1000003,
      "name": "Inventory",
      "number": 2000
    },
    "comment": "Product sales",
    "invoice": {
      "number": "INV-2022-003",
      "dueDate": "2022-08-20",
      "remittanceReference": "OCR-543216789"
    },
    "currency": {
      "code": "NOK",
      "rate": 1
    },
    "customer": {
      "id": 6003
    },
    "createdAt": "2022-03-01T10:30:00Z",
    "modifiedAt": "2023-10-31T16:45:00Z",
    "transaction": {
      "id": 3003,
      "number": 1030
    },
    "transactionType": {
      "id": 5003
    }
  }
]
Response examples (200)
[
  {
    "id": 7001,
    "tax": {
      "id": 2001,
      "rate": 25
    },
    "date": "2022-07-01",
    "amount": 1500,
    "account": {
      "id": 1000001,
      "name": "Cash, NOK",
      "number": 1900
    },
    "comment": "Payment for services",
    "invoice": {
      "number": "INV-2022-001",
      "dueDate": "2022-08-01",
      "remittanceReference": "OCR-123456789"
    },
    "currency": {
      "code": "USD",
      "rate": 10
    },
    "customer": {
      "id": 6001
    },
    "createdAt": "2022-01-01T18:00:00Z",
    "modifiedAt": "2023-12-31T18:00:00Z",
    "transaction": {
      "id": 3001,
      "number": 1010
    },
    "transactionType": {
      "id": 5001
    }
  },
  {
    "id": 7002,
    "tax": {
      "id": 2002,
      "rate": 20
    },
    "date": "2022-07-15",
    "amount": 2500,
    "account": {
      "id": 1000002,
      "name": "Accounts Receivable",
      "number": 1800
    },
    "comment": "Consulting fees",
    "invoice": {
      "number": "INV-2022-002",
      "dueDate": "2022-08-15",
      "remittanceReference": "OCR-987654321"
    },
    "currency": {
      "code": "NOK",
      "rate": 1
    },
    "customer": {
      "id": 6002
    },
    "createdAt": "2022-02-01T12:00:00Z",
    "modifiedAt": "2023-11-30T14:30:00Z",
    "transaction": {
      "id": 3002,
      "number": 1020
    },
    "transactionType": {
      "id": 5002
    }
  },
  {
    "id": 7003,
    "tax": {
      "id": 2003,
      "rate": 15
    },
    "date": "2022-07-20",
    "amount": 3000,
    "account": {
      "id": 1000003,
      "name": "Inventory",
      "number": 2000
    },
    "comment": "Product sales",
    "invoice": {
      "number": "INV-2022-003",
      "dueDate": "2022-08-20",
      "remittanceReference": "OCR-543216789"
    },
    "currency": {
      "code": "NOK",
      "rate": 1
    },
    "customer": {
      "id": 6003
    },
    "createdAt": "2022-03-01T10:30:00Z",
    "modifiedAt": "2023-10-31T16:45:00Z",
    "transaction": {
      "id": 3003,
      "number": 1030
    },
    "transactionType": {
      "id": 5003
    }
  }
]