POST 17.0/database/bankreconciliations/list

Description

Retrieve a list of Bank Reconciliations

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 BankReconciliationsUpdate
Name Description Type Additional information
ID

integer

None.
BankAccountID

integer

None.
AddedDate

date

None.
UpdatedDate

date

None.
StartDate

date

None.
EndDate

date

None.
StartBalance

decimal number

None.
EndBalance

decimal number

None.
Adjustment

decimal number

None.
SiteID

integer

None.
UserID

integer

None.
Notes

string

None.

application/json, text/json
Sample: 
[
  {
    "id": 1,
    "bankAccountID": 1,
    "addedDate": "2025-01-09T20:21",
    "updatedDate": "2025-01-09T20:21",
    "startDate": "2025-01-09T20:21",
    "endDate": "2025-01-09T20:21",
    "startBalance": 1.0,
    "endBalance": 1.0,
    "adjustment": 1.0,
    "siteID": 1,
    "userID": 1,
    "notes": "sample string 1"
  },
  {
    "id": 1,
    "bankAccountID": 1,
    "addedDate": "2025-01-09T20:21",
    "updatedDate": "2025-01-09T20:21",
    "startDate": "2025-01-09T20:21",
    "endDate": "2025-01-09T20:21",
    "startBalance": 1.0,
    "endBalance": 1.0,
    "adjustment": 1.0,
    "siteID": 1,
    "userID": 1,
    "notes": "sample string 1"
  }
]

application/xml, text/xml
Sample: 
<ArrayOfBankReconciliationsUpdate xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <BankReconciliationsUpdate>
    <ID>1</ID>
    <BankAccountID>1</BankAccountID>
    <AddedDate>2025-01-09T20:21:19.0803043+00:00</AddedDate>
    <UpdatedDate>2025-01-09T20:21:19.0803043+00:00</UpdatedDate>
    <StartDate>2025-01-09T20:21:19.0803043+00:00</StartDate>
    <EndDate>2025-01-09T20:21:19.0803043+00:00</EndDate>
    <StartBalance>1</StartBalance>
    <EndBalance>1</EndBalance>
    <Adjustment>1</Adjustment>
    <SiteID>1</SiteID>
    <UserID>1</UserID>
    <Notes>sample string 1</Notes>
  </BankReconciliationsUpdate>
  <BankReconciliationsUpdate>
    <ID>1</ID>
    <BankAccountID>1</BankAccountID>
    <AddedDate>2025-01-09T20:21:19.0803043+00:00</AddedDate>
    <UpdatedDate>2025-01-09T20:21:19.0803043+00:00</UpdatedDate>
    <StartDate>2025-01-09T20:21:19.0803043+00:00</StartDate>
    <EndDate>2025-01-09T20:21:19.0803043+00:00</EndDate>
    <StartBalance>1</StartBalance>
    <EndBalance>1</EndBalance>
    <Adjustment>1</Adjustment>
    <SiteID>1</SiteID>
    <UserID>1</UserID>
    <Notes>sample string 1</Notes>
  </BankReconciliationsUpdate>
</ArrayOfBankReconciliationsUpdate>