Bank_Search Schema
Documentation {..} JSON XML
Mandatory field
Optional field
Returns a list of bank statement transactions for a set of given set of search parameters.
Header
Document header container
MessageType
string
Enumerated value: Request
Enumerated value: Response
TestMode
Test mode set as true will make no database modifications.
boolean
DeviceID
ID of the calling device where applicable. Use for mobile devices such as I-Phones and Android units
string
Minimum length: 0
Maximum length: 100
SubmissionNumber
string
A unique reference used for each API request. The Submission Number is seeded within the Authentication MD5 Value to prevent cloning.
Authentication
Account Number and an MD5 Hash of "API Key, Password and Submission Number"
AccNumber
MD5Value
ApplicationID
Unique identiifier for the application making the request. Mandoatory from 10th Dec 2013
string
Minimum length: 1
Maximum length: 100
Body
SearchParameters
ReturnCount
How many records would you like the API to return (max 200). To just return the meta data with no transaction enter zero.
int
Minimum inclusive value: 0
Maximum inclusive value: 200
Offset
int
Page offset. Zero (0) would show results from the begining of the record set. Offset can be used for paging functions.
OrderResultsBy
Which columns should be used for ordering the record set.
string
Enumerated value: TransactionDate
Enumerated value: Amount
OrderDirection
Order direction. Ascending (ASC) or Descending (DESC).
string
Enumerated value: ASC
Enumerated value: DESC
NominalCode
The nominal code of the bank account you wish to query
int
Minimum inclusive value: 1200
Maximum inclusive value: 1299
Reference
string
Search by whole or partial reference
Notes
string
Search by whole or partial notes.
FromDate
date
From date
ToDate
date
To date
AmountFrom
double
Amount range from (use - prefix for debits)
AmountTo
double
Amount range to (use - prefix for debits)
Endpoint: https://api.quickfile.co.uk/1_2/bank/search
Example Request:
We had a problem retrieving a JSON sample for this method, please retry later
Example Response:
Example Request:
We had a problem retrieving an XML sample for this method, please retry later
Example Response:
Other Bank Methods
Query bank account transactions by date range, nominal code, reference or amount
Create a new bank account
Create untagged bank transactions
Quick File Limited - Copyright © 2019
QuickFile Accounting | Community | Knowledgebase