POST 17.0/database/bankaccounts/list

Description

Retrieve a list of Bank Accounts

URI Parameters

None.

ListOptions
Name Description Type Additional information
Fields

Collection of string

None.
Filters

Collection of DatabaseFilter

None.
Order

string

None.

application/json, text/json
Sample: 
{
  "fields": [
    "sample string 1",
    "sample string 2"
  ],
  "filters": [
    {
      "fieldName": "sample string 1",
      "value": "sample string 2",
      "operator": "sample string 3",
      "valueType": "sample string 4"
    },
    {
      "fieldName": "sample string 1",
      "value": "sample string 2",
      "operator": "sample string 3",
      "valueType": "sample string 4"
    }
  ],
  "order": "sample string 1"
}

application/xml, text/xml
Sample: 
<ListOptions xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Fields>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </Fields>
  <Filters>
    <DatabaseFilter>
      <FieldName>sample string 1</FieldName>
      <Value>sample string 2</Value>
      <Operator>sample string 3</Operator>
      <ValueType>sample string 4</ValueType>
    </DatabaseFilter>
    <DatabaseFilter>
      <FieldName>sample string 1</FieldName>
      <Value>sample string 2</Value>
      <Operator>sample string 3</Operator>
      <ValueType>sample string 4</ValueType>
    </DatabaseFilter>
  </Filters>
  <Order>sample string 1</Order>
</ListOptions>

application/x-www-form-urlencoded
Sample:

Sample not available.

Collection of BankAccountsUpdate
Name Description Type Additional information
ID

integer

None.
Description

string

String length: inclusive between 0 and 30
BankingWith

byte

None.
OpeningBalance

decimal number

None.
OpeningBalanceDate

date

None.
AccountName

string

String length: inclusive between 0 and 50
AccountSortCode

string

String length: inclusive between 0 and 10
AccountNumber

string

String length: inclusive between 0 and 25
AccountIBAN

string

String length: inclusive between 0 and 50
AccountSwiftBIC

string

String length: inclusive between 0 and 12
CompanyID

integer

None.
InvoiceFooterText

string

String length: inclusive between 0 and 4000
InActive

byte

None.

application/json, text/json
Sample: 
[
  {
    "id": 1,
    "description": "sample string 1",
    "bankingWith": 64,
    "openingBalance": 1.0,
    "openingBalanceDate": "2025-01-09T20:52",
    "accountName": "sample string 2",
    "accountSortCode": "sample string 3",
    "accountNumber": "sample string 4",
    "accountIBAN": "sample string 5",
    "accountSwiftBIC": "sample string 6",
    "companyID": 1,
    "invoiceFooterText": "sample string 7",
    "inActive": 64
  },
  {
    "id": 1,
    "description": "sample string 1",
    "bankingWith": 64,
    "openingBalance": 1.0,
    "openingBalanceDate": "2025-01-09T20:52",
    "accountName": "sample string 2",
    "accountSortCode": "sample string 3",
    "accountNumber": "sample string 4",
    "accountIBAN": "sample string 5",
    "accountSwiftBIC": "sample string 6",
    "companyID": 1,
    "invoiceFooterText": "sample string 7",
    "inActive": 64
  }
]

application/xml, text/xml
Sample: 
<ArrayOfBankAccountsUpdate xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <BankAccountsUpdate>
    <ID>1</ID>
    <Description>sample string 1</Description>
    <BankingWith>64</BankingWith>
    <OpeningBalance>1</OpeningBalance>
    <OpeningBalanceDate>2025-01-09T20:52:33.5388654+00:00</OpeningBalanceDate>
    <AccountName>sample string 2</AccountName>
    <AccountSortCode>sample string 3</AccountSortCode>
    <AccountNumber>sample string 4</AccountNumber>
    <AccountIBAN>sample string 5</AccountIBAN>
    <AccountSwiftBIC>sample string 6</AccountSwiftBIC>
    <CompanyID>1</CompanyID>
    <InvoiceFooterText>sample string 7</InvoiceFooterText>
    <InActive>64</InActive>
  </BankAccountsUpdate>
  <BankAccountsUpdate>
    <ID>1</ID>
    <Description>sample string 1</Description>
    <BankingWith>64</BankingWith>
    <OpeningBalance>1</OpeningBalance>
    <OpeningBalanceDate>2025-01-09T20:52:33.5388654+00:00</OpeningBalanceDate>
    <AccountName>sample string 2</AccountName>
    <AccountSortCode>sample string 3</AccountSortCode>
    <AccountNumber>sample string 4</AccountNumber>
    <AccountIBAN>sample string 5</AccountIBAN>
    <AccountSwiftBIC>sample string 6</AccountSwiftBIC>
    <CompanyID>1</CompanyID>
    <InvoiceFooterText>sample string 7</InvoiceFooterText>
    <InActive>64</InActive>
  </BankAccountsUpdate>
</ArrayOfBankAccountsUpdate>