Download OpenAPI specification:Download
The API is organized around REST and is designed to have predictable, resource-oriented URLs and to use HTTP response codes to indicate API errors.
We use built-in HTTP features, like HTTP authentication and HTTP verbs (methods), which can be understood by off-the-shelf HTTP clients, and we support cross-origin resource sharing to allow you to interact securely with our API.
The URL you will target depends on how you're using the service. If using your own network, you'll need to use the URL/IP address on which you are hosting the service. Refer to product specific documentation for more details.
The server uses conventional HTTP response codes to indicate the success or failure of an API request.
Any unsuccessful response codes will contain more information to help you to identify the cause of the problem.
In general:
Authenticate your account by performing a handshake to obtain a CSRF token and JSESSIONID, these are used in the login request. All API calls should then contain the header information obtained from the handshake and authentication and must be made over HTTPS. Calls made over plain HTTP will fail. API requests without authentication will also fail.
The authentication will expire after approximately 10 minutes and the process will then need to be repeated.
First perform the handshake with the API to obtain the CSRF token and the JSESSIONID:
GET /payments-service/api/security/handshake
Extract the JSESSIONID cookie from the Set-Cookie field in the response cookie (not the header response), extracting the ID only (highlighted in bold in the example below):
JSESSIONID=yGQz2iZLf8mDb2D7M8nL0f8cxFcjNwBjVimJab8C41kUiNTkVyMA!1781984570; path=/; HttpOnly; Secure;
Then extract the CSRF Token from the X-CSRF field in the response header.
The JSESSIONID and CSRF are then used in the login request header below.
Using the JSESSIONID cookie, and X-CSRF header token from the handshake call, make a POST call to this URL:
/payments-service/api/security/login HTTP/1.1
Ensure to include the following additional, mandatory headers:
User-Agent:api-v2.5
Content-Type:application/json
Here is an example below. (Note: Items in bold are fixed/mandatory):
POST /payments-service/api/security/login HTTP/1.1
Host:example.com
User-Agent:api-v2.5
Cookie:JSESSIONID=Ig3ayRxj1vV17QzUrqPRj-OPgIkQ4Vtihj3lu09TRgt135wAcjQF!-1331583496; TS010ce9a5=0188c34b1367edbe78653c5225eb697178166c6eab65b122b65781e659677d74265561228edc25616390080c41a285aa5e245eb45a
X-CSRF:Ys9duXU4p4aixevzWzG/qK6MNLitom5cYkceMplsFr4=
Content-Type:application/json
Cache-Control:no-cache
Accept-Encoding:gzip, deflate, br
Connection:keep-alive
Content-Length:450
{
"loginTokens": [{
"key": "com.bottomline.security.provider.login.email",
"value": "Include email address here"
}, {
"key": "com.bottomline.security.provider.login.password",
"value": "Include password here"
}],
"apiVersion": "{\"major\": \"1\",\"minor\": \"0\",\"patch\": \"0\",\"build\": \"0\"}",
"purpose": "cpay-auth",
"tokenLocation": "HEADER"
}
Here is an example below for the Live system. (Note: Items in bold are fixed/mandatory):
POST /payments-service/api/security/login HTTP/1.1
Host:example.com
User-Agent:api-v2.5
Cookie:f5avraaaaaaaaaaaaaaaa_session_=DFEALBAPPPCOMKFPMHAKMPKHMLOJBNAGGGJLKOHELAEOACOEOOPLCKEMKDFMAPDGIOODBMJACDOGMBHNCCDAFABCOOAIICONKAHEOOIKOMIPOGDDKFHNPLJKOOHONLJN; JSESSIONID=Ig3ayRxj1vV17QzUrqPRj-OPgIkQ4Vtihj3lu09TRgt135wAcjQF!-1331583496; TS010ce9a5=0188c34b1367edbe78653c5225eb697178166c6eab65b122b65781e659677d74265561228edc25616390080c41a285aa5e245eb45a X-CSRF:Ys9duXU4p4aixevzWzG/qK6MNLitom5cYkceMplsFr4=
Content-Type:application/json
Cache-Control:no-cache
Accept-Encoding:gzip, deflate, br
Connection:keep-alive
Content-Length:450
{
"loginTokens": [{
"key": "com.bottomline.security.provider.login.email",
"value": "Include email address here"
}, {
"key": "com.bottomline.security.provider.login.password",
"value": "Include password here"
}],
"apiVersion": "{\"major\": \"1\",\"minor\": \"0\",\"patch\": \"0\",\"build\": \"0\"}",
"purpose": "cpay-auth",
"tokenLocation": "HEADER"
}
Please note: - Some languages may add HTTP/1.1 by default so may not need to be manually added. - The JSESSIONID cookie may be added automatically by some API programs but must start with JSESSIONID= - Use the JSESSIONID from the response cookies, as the same cookie may not always be presented in the response headers. - Ensure all mandatory fields and values (shown in bold in examples) are added exactly the same, including positioning. - Some API programs will normally include the TS and F5 cookies with the final payload being sent, so may not be necessary to add in addition. - The apiVerson in some languages may need additional slashes included to ensure the values are added exactly.
The X-CSRF token and auth.token returned in the Authenticate response are then required in all future API calls.
Once the authentication is successful, it will expire in approximately 10 minutes if not used (the timer is reset with successful API request). API integrations will need to correctly handle HTTP401 responses and repeat the above handshake and authenticate steps.
API calls should contain the header information collected from the handshake and login.
Note: Ensure that the CSRF token that is used is the value returned by the login call and not the handshake call which will be out of date.
The API call below is an example for creating a new payment batch and most calls will follow this format. However, always refer to the specific documentation for each API call regarding header, request and response information.
POST /payments-service/api/bacs/batches HTTP/1.1
User-Agent:api-v2.5
Cookie:JSESSIONID=Y1cXNhhhCapIMdC3EKnsKP0djemJoq7DorVHf6zNzyHnLxTVmId5!-1275828986; TS010ce9a5=0188c34b1367edbe78653c5225eb697178166c6eab65b122b65781e659677d74265561228edc25616390080c41a285aa5e245eb45a X-CSRF:WQgmaV4zskFD0DzPdiii5ESbwx+G9EJlZ7mTL2Zz7Kc=
Content-Type:application/json
com.bottomline.auth.token:AAABcRcyoUYTHdHNVjB2d496zvTNGVzOgPu+sNhY4xZSVYtHIDx4weJY6WpcQMZcI627EOgYnbEAM3W57zM7p9HGN712Tz+YEIHM4UG6mtUVKNpKxk6qkrIc4KaFp/ue+/qCHf+FDIyMAd7F8YvwTpVL1t8/N+bUnyO+qqOk/e4EcDHOrvbyHL0cDRMBcZ4V+vToZQRA333sPc8RdqbT3Xs08qOvlXZyns9ux1/haGAyMuyYuFGBAU2GDernzcosSAlCTr0HAII24XTJKSK1uRdO59fbbe6rwIGCXASemMoXpMFaY8xx22oxMKrc5HAolcmYNGSlmEXJ/CiXJkDtnJxu4nryEHgJAvd/uU6TGOS+BfWwELXsZOkpGzshDe6O+FCptIsMTYNPBTCebHgQmBeCUGDKCRMHTJYCpPRPHgwZGm7f5Oe+VCII9Mqeb+m90s+aNDY9x9cYirAhoGEs1gHvt+K92vftulgeOWdYLR2hnmxK9wYa/hJg38f3w9fap00VEcjzEsGBuO1qql5OuWwVcomcdXpW41ioM83eZFfDlMKMDUCc/2OK8vFXlhEttk3ygg8q3M2myo0DlmmypptbpNZrcZGTqnirrgKGuqOJo7LSFaMjbSvVAzOcCwNUKPuuuQGEke/QRJkLfK8yEZ6RD9VW5gnB6oBmtAiVyMyKgnVS8CYTNbCnIHwZyr25zY2W4A5hHa8I03TclglRc1wi1bKe6pndiLVX1UKbzeAR0Xgqq7pNWTLotxtBmj2e/VB7Eb60yjNbjao1y5YoyzzFcQP9sPFNQ1kWWxBSkEawIbGMT+tD3NR6wqAjK5j2Bjfuu4r9PhOC/0R/FSkLhpxnxsUR36bb1FteWe4YcC2nFfFcxgmCBjyQ/tE/6uLfQWAWH8aBUw+FWpZH18tZJYxzKMPjJkMZ1+m28p+htQM8zqne6uT7U6jxWHcUxR8tLQN7KK8myCg7BA0k4tTJZu4v6jz6U/LyIvnnKYRupFp9sQVKXuh77npGLExhLoir2BeegkhYpv60zDEuOELuZyb/d3TyBRLrjUkBLCjM/AkKoAd1IlvD1AABoMPjLLRlAVJwCc2Vd7Lj7Hw6GfPsm1Bc4Pbfb8TwIfMirfBt4SpCQIVmGzGDzkz98h15wlptThST43t/ZNgx33LdnhOBNyTJQWgc11F/1SlO1zLVg8FqCPS4LgutZSSBMX6HZkUezGT8LETAaxq1WrYh2JyeWrmyBvydoVqmqoo5MJ+PSJXIuUXTqkcx39HygqZLHmXQBcxg9vuTcfVdvLaI1wrPnh2uUP98L6JCltGBeFHhMF5fp/ekqRyII8SqpCua6Se99JMk3KpQcsi8sVZ5STnS47wN8WhcdBWgf1h1CTn/My3/Cs8XHKJCUVseS8jkaKYYMGpF0DLeEXhWUuq58qxIugtaAjQUxr0iHEwcjVZEC88f523ngfGwbwWBt58ECmLuR+jIXhwOTuAj3HjR2vlYjEXcllRyRNn3xcjIjUlLajsv9EjcSzbbpWWykQ6xiaVwCpJyXGwg72gnQZNjV+dvBRG1Qh7C3VWYTzXjSsLynsxDt0ziT4ZWyO9xnSeamgBZPPPsux6BPjekvnI8ppQCjrt5Qm9sJSxoyaTKyPx0lq1/nzMYyx+spIdmBiwkUPsw/Dnli7gAOnSgH3B/xl6l1Ss4Y5RDhG0ElQ==
Accept:/
Cache-Control:no-cache
Host: example.com Accept-Encoding:gzip, deflate, br Connection:keep-alive Content-Length:199 { "inputMethod":"manual",
"description":"BATCH 2",
"application":"1234",
"applicationName":"-",
"status":"-",
"paymentDate":"-",
"submissionSigningMethod":"SMARTCARD" }
For all API calls, parameters of type string cannot start with any of the following charaters: =, +, -, @
Payment batches are used for making payments. A payment batch contains payment instructions details.
The API allows you to create a batch which will upload the payment into the system. You can create a batch template and create a batch from the template. You can also move a batch from draft to entered, approved or committed status.
Creates a new payment batch.
Note: Create an empty batch first and then use the Create an instruction call to add instructions to the batch.
The MdeHeader
inputMethod | string <string> Input method, set to either Manual or File. |
description | string <string> Description for batch. |
application required | string <string> Unique identifier of the selected payment profile. |
applicationName | string <string> The name of the selected payment profile. |
status | string <string> Default: "DRAFT" The status of the batch. |
paymentDate | string <date-time> The payment date of the batch. If supplied then must adhere to Bacs scheme rules (the earliest date is two days from the current date excluding bank holidays and weekends). |
paymentType | string <string> The payment type, set to either Bacs or Faster Payments. |
submissionSigningMethod | string Default: "SMARTCARD" The signing method when submitting files to Bacs, set to either Smartcard or HSM. |
{- "inputMethod": "manual",
- "description": "New batch",
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "status": "-",
- "paymentDate": "-",
- "paymentType": "Bacs",
- "submissionSigningMethod": "SMARTCARD"
}
{- "@type": "MdeHeader",
- "id": 100,
- "application": 33,
- "applicationName": "Direct MDE Profile",
- "enteredDate": "2018-10-18T13:13:24.000+0000",
- "paymentDate": "2018-10-22T00:00:00.000",
- "enteredBy": "JGX3FTUOQF1PPIDQTMLF",
- "description": "TEST PAYMENT PROFILE-1539868404142",
- "status": "DRAFT",
- "statusDescription": "Draft",
- "debitCount": 3,
- "debitTotal": 623.45,
- "creditCount": 0,
- "creditTotal": 0,
- "paymentType": "Bacs",
- "originatorInfo": {
- "sortCode": "309470",
- "accountNumber": "12341234",
- "accountName": "test account name",
- "statementText": "statement text",
- "sun": 100265,
- "destinationStatementText": "dest statement text"
}, - "errorCount": 0,
- "warningCount": 0,
- "auddisCount": 0,
- "submission": 126091,
- "multiplePaymentDates": false,
- "entryCount": 0,
- "includedCount": 0,
- "rti": false,
- "possibleDuplicate": false,
- "indirect": false,
- "paymentFileSigned": false,
- "riskCount": 0,
- "isDDMEntry": false
}
Creates a new payment batch template.
batchId required | integer <int64> Unique identifier of batch for template creation. |
The Bacs template descriptor.
templateName | string <string> Template name. |
batchId | integer <int64> The batch ID for template creation. |
{- "templateName": "MyWeeklyBatchFile",
- "batchId": 100
}
{- "model": { },
- "informationMessages": [
- {
- "key": "string",
- "message": "string"
}
], - "warningMessages": [
- {
- "key": "string",
- "message": "string"
}
], - "errorMessages": [
- {
- "key": "string",
- "message": "string"
}
], - "debugMessages": [
- {
- "key": "string",
- "message": "string"
}
]
}
Creates a new payment batch from a template.
templateId required | integer <int64> Unique identifier of template for batch creation. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/batches/124/template/batch
{- "id": 100,
- "submissionId": 99,
- "application": 33,
- "applicationName": "Direct MDE Profile",
- "entries": [
- {
- "id": 10045,
- "paymentType": "Bacs",
- "included": true,
- "index": 1,
- "transactionType": "0",
- "transactionTypeCode": "99",
- "sortCode": "200000",
- "accountNumber": "42222222",
- "batchId": 100,
- "reference": "Reference-1234",
- "amount": "2450.99",
- "paymentDate": "2019-08-24T14:15:22Z",
- "type": "DBACS",
- "name": "JON SMITH",
- "rti": "",
- "isDDMEntry": false
}
], - "applicationDescription": "Direct MDE Profile {100124}",
- "paymentDate": "2019-08-24T14:15:22Z",
- "type": "DBACS",
- "description": "DirectMDEProfile-1515062817535",
- "debitCount": 3,
- "debitTotal": 623.45,
- "creditCount": 14,
- "creditTotal": 125650.9
}
Completes a payment batch moving the batch from draft to entered status.
Warning: This call is not thread safe therefore DO NOT use this call while instructions are being added to the batch manually or via the API.
submissionId required | integer <int64> Submission identifier obtained from the Create a new payment batch call. |
paymentProfileId required | integer <int64> Payment profile identifier obtained from the Query list all payment profiles or Query payment profile by payment profile name call. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/submissions/126091/enter/6421
Completes a payment batch moving the batch from entered to approved status.
Warning: This call can only be used for batches that are in the entered state.
submissionId required | integer <int64> Submission identifier obtained from the Create a new payment batch call. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/submissions/126091/approve
Rejects a payment batch.
submissionId required | integer <int64> Submission identifier obtained from the Create a new payment batch call. |
reason | string <string> Reject reason. |
{- "reason": "Duplicate payment"
}
Unapproves a payment batch, moving the status of the batch back to Entered.
submissionId required | integer <int64> Submission identifier obtained from the Create a new payment batch call. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/submissions/126091/unapprove
Completes a payment batch moving the batch from approved to committed status.
Warning: This call can only be used for batches that have been created using a payment profile for indirect submitters and are in the approved state.
submissionId required | integer <int64> Submission identifier obtained from the Create a new payment batch call. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/submissions/126091/commit
Archives a payment batch.
submissionId required | integer <int64> Submission identifier obtained from the Create a new payment batch call. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/submissions/126091/archive
Executes a query for a rejected payment batch between two dates.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "Submission",
- "symbol": "com.bottomline.cpay.model.bacs.submission",
- "key": "com.bottomline.cpay.model.bacs.submission"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "status",
- "symbol": "com.bottomline.cpay.model.bacs.submission.status",
- "fieldType": "STRING",
- "key": false
}, - "operator": {
- "symbol": "IN"
}, - "queryValue": {
- "@type": "string",
- "$value": "RJ"
}
}, - {
- "@type": "QueryRelationship",
- "name": "AND",
- "description": "AND relationship.",
- "symbol": "AND"
}, - {
- "@type": "QueryParameter",
- "field": {
- "name": "paymentDate",
- "symbol": "com.bottomline.cpay.model.bacs.submission.paymentDate",
- "fieldType": "DATE",
- "key": false
}, - "operator": {
- "symbol": "BETWEEN"
}, - "queryValue": [
- {
- "@type": "date",
- "$value": "2022-06-08T00:00:00.000Z"
}, - {
- "@type": "date",
- "$value": "2022-06-11T23:59:59.100Z"
}
]
}
]
}, - "resultFields": [
- {
- "name": "Submission",
- "symbol": "com.bottomline.cpay.model.bacs.SubmissionResponse",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "Submission",
- "symbol": "com.bottomline.cpay.model.bacs.SubmissionResponse",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88444,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:49:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88442,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:48:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88438,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:47:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88434,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:44:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88428,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:41:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88426,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:41:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "SubmissionResponse",
- "id": 88422,
- "application": 6421,
- "applicationName": "TEST PAYMENT PROFILE",
- "applicationDescription": "TEST PAYMENT PROFILE (000000)",
- "entryMethod": "FILEIMPORT",
- "enteredDate": "2022-01-06T14:37:00.000",
- "paymentDate": "2022-01-08T00:00:00.000",
- "enteredBy": "Alex Smith",
- "enteredById": "JGX3FTUOQF1PPIDQTMLF",
- "description": "One-Off Collections.txt",
- "status": "RJ",
- "statusDescription": "Rejected",
- "numFiles": 1,
- "debitTotal": 0,
- "creditTotal": 0,
- "debitCount": 0,
- "creditCount": 0,
- "paymentType": "Bacs",
- "multiplePaymentDates": false,
- "errorCount": 2,
- "warningCount": 0,
- "auddisCount": 0,
- "entryCount": 0,
- "entryTotal": 0,
- "sun": "000000",
- "indirect": false,
- "earliestProcessingDate": "2022-01-07T00:00:00.000",
- "transmissionType": "StructuralTest",
- "possibleDuplicate": false,
- "submissionSigningMethod": "SMARTCARD",
- "bureau": false,
- "workflowStatus": "Created",
- "riskCount": 0,
- "numberOfApprovals": 1
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 7
}
}
]
}
]
}
]
}
Payment instructions are used for making payments.
A payment instruction contains the payment details including sort code, account number, payment type and amount. The API allows you to create, delete and update your payment instructions. You can clear the amount in an instruction and identify which instructions to include in a batch.
Creates a new instruction.
The MdeEntry
paymentType | string <string> Payment type of the instruction. |
included | boolean Identifier of the instruction state, if it is included in the batch file or not. |
transactionType required | string <string> Default: "0" Transaction type of the instruction, example "0". Possible values are:
|
text required | string <string> Default: "STC TEXT" Text that appears on the statement. |
paymentDate required | string <date-time> Default: "2021-06-15T00:00:00.000" The payment date of the instruction. |
sortCode required | string <string> Default: "111111" The destination sort code. |
accountNumber required | string <string> Default: "11111111" The destination account number. |
reference | string <string> The payment reference. |
name | string <string> The destination account name. |
batchId required | integer <int64> Default: 101036 Unique identifier of batch for update. |
@type | string <string> Default: "MdeEntry" The type of record. |
isDDMEntry | boolean Default: false Alternative identifier for DDM instructions. |
amount required | string <amounts> Default: "1222211" The payment amount. |
{- "paymentType": "Bacs",
- "included": true,
- "transactionType": "0",
- "text": "STC TEXT",
- "paymentDate": "2021-06-14T00:00:00.000",
- "sortCode": "200000",
- "accountNumber": "42222222",
- "reference": "Reference-101",
- "name": "JON SMITH",
- "batchId": 101,
- "@type": "MdeEntry",
- "isDDMEntry": false,
- "amount": "402.35"
}
{- "@type": "MdeEntry",
- "id": 1056,
- "batchId": 101,
- "index": 42,
- "sortCode": "200000",
- "accountNumber": "42222222",
- "text": "STC TEXT",
- "type": "DBACS",
- "transactionType": "0",
- "transactionTypeCode": "99",
- "paymentDate": "2021-06-14T00:00:00.000",
- "amount": "402.35",
- "status": "DF",
- "included": true,
- "isDDMEntry": false,
- "createdDate": "2021-06-15T00:00:00.000",
- "warning": {
- "accountNumber": [
- "Account number 11111111 does not have a valid checksum for sort code 111111"
]
}
}
Updates an instruction.
entryId required | integer <int64> Unique identifier of entry for the update. |
Unique identifier of entry for the update.
batchId required | integer <int64> Unique identifier of batch for update. |
index required | integer <int64> The index identifier of the instruction within the batch file. |
sortCode required | string <string> The destination sort code. |
accountNumber required | string <string> The destination account number. |
text required | string <string> Text that appears on the statement. |
transactionType required | string <string> Transaction type of the instruction, example "0". Possible values are:
|
amount required | string <amounts> The payment amount. |
status required | string <string> The status of the instruction. |
createdDate required | string <date-time> The date the instruction was created. |
paymentType required | string <string> Payment type of the instruction. |
isRefund required | boolean Defines if the payment is a refund. Always set to false. |
{- "batchId": 101,
- "index": 1,
- "sortCode": "200000",
- "accountNumber": "42222222",
- "text": "STC TEXT",
- "transactionType": "0",
- "amount": "402.35",
- "status": "DF",
- "createdDate": "2021-06-09T15:21:53.124",
- "paymentType": "Bacs",
- "isRefund": false
}
{- "@type": "MdeEntry",
- "id": 1056,
- "batchId": 101,
- "index": 42,
- "sortCode": "200000",
- "accountNumber": "42222222",
- "text": "STC TEXT",
- "type": "DBACS",
- "transactionType": "0",
- "transactionTypeCode": "99",
- "amount": "402.35",
- "status": "DF",
- "included": true,
- "isDDMEntry": false,
- "createdDate": "2021-06-15T00:00:00.000",
- "warning": [
- {
- "accountNumber": [
- "Account number 11111111 does not have a valid checksum for sort code 111111"
]
}
]
}
Identifies which instructions to include in a batch.
batchId required | integer <int64> Unique identifier of batch for update. |
included required | boolean Has the value true if the instructions should be included. |
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/bacs/instructions/101/included/true
Payment profiles are used for making payments.
Payment Profiles contain all the information that the system needs to process payments including if the payments is to be made via Bacs or Faster Payments, if the payment is to be submitted via a bureau or submitted to Bacs on behalf of a bureau and how the payment data will be uploaded to the system.
Executes a query to list all payment profiles.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "Applications",
- "symbol": "com.bottomline.cpay.model.applications",
- "key": "com.bottomline.cpay.model.applications"
}, - "resultFields": [
- {
- "name": "All Applications Minimal",
- "symbol": "com.bottomline.cpay.model.AllApplicationsMinimal",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "All Applications Minimal",
- "symbol": "com.bottomline.cpay.model.AllApplicationsMinimal",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "PaymentProfileMinimal",
- "id": 8543,
- "name": "TEST FPS PAYMENT PROFILE",
- "createdDate": "2018-10-17T13:33:08.749",
- "status": "AP",
- "bacsTransmissionType": "STRUCTURALTEST",
- "type": "BACS",
- "dataEntryMethod": "MANUALENTRY",
- "serviceType": "SECUREIP",
- "paymentFileSigningType": "NONE",
- "submissionSigningMethod": "SMARTCARD",
- "connectionType": "DIRECT",
- "promptForDate": false,
- "originatingAccountName": "FPS ACCOUNT NAME",
- "originatingSortCode": "444444",
- "originatingAccountNumber": "44444444",
- "originatorsStatementText": "FPS STATE TEXT",
- "firstUseOfAccount": "NONE",
- "duplicateAccount": "NONE",
- "duplicateAmount": "NONE",
- "blackListedAccount": "NONE",
- "autoArchiveSentSubmissions": false,
- "numberOfDaysToProcessSentSubmissions": 7,
- "numberOfApprovals": 1,
- "automaticSubmission": "false+"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "PaymentProfileMinimal",
- "id": 8308,
- "name": "TEST INDIRECT PROFILE",
- "createdDate": "2018-08-10T13:47:36.224",
- "status": "AP",
- "bacsTransmissionType": "TEST",
- "type": "BACS",
- "dataEntryMethod": "MANUALENTRY",
- "serviceType": "BACSTELIP",
- "paymentFileSigningType": "NONE",
- "submissionSigningMethod": "SMARTCARD",
- "connectionType": "INDIRECT",
- "promptForDate": false,
- "originatingAccountName": "INDIRECT ACC NAME",
- "originatingSortCode": "217217",
- "originatingAccountNumber": "21702170",
- "originatorsStatementText": "IND STATE TEXT",
- "firstUseOfAccount": "NONE",
- "duplicateAccount": "NONE",
- "duplicateAmount": "NONE",
- "blackListedAccount": "NONE",
- "autoArchiveSentSubmissions": false,
- "numberOfDaysToProcessSentSubmissions": 7,
- "numberOfApprovals": 1,
- "automaticSubmission": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "PaymentProfileMinimal",
- "id": 6421,
- "name": "TEST PAYMENT PROFILE",
- "createdDate": "2017-11-27T13:38:52.339",
- "status": "AP",
- "bacsTransmissionType": "STRUCTURALTEST",
- "type": "BACS",
- "dataEntryMethod": "FILEIMPORT",
- "serviceType": "BACSTELIP",
- "paymentFileSigningType": "NONE",
- "submissionSigningMethod": "SMARTCARD",
- "connectionType": "DIRECT",
- "promptForDate": true,
- "originatingAccountName": "TEST ACC NAME",
- "originatingSortCode": "000000",
- "originatingAccountNumber": "00000000",
- "originatorsStatementText": "TEST STATE TEXT",
- "firstUseOfAccount": "NONE",
- "duplicateAccount": "NONE",
- "duplicateAmount": "NONE",
- "blackListedAccount": "NONE",
- "autoArchiveSentSubmissions": false,
- "numberOfDaysToProcessSentSubmissions": 7,
- "numberOfApprovals": 1,
- "automaticSubmission": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 3
}
}
]
}
]
}
]
}
Executes a query to search for a payment profile by name.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "Applications",
- "symbol": "com.bottomline.cpay.model.applications",
- "key": "com.bottomline.cpay.model.applications"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "name",
- "symbol": "com.bottomline.cpay.model.application.name",
- "fieldType": "STRING_CI",
- "key": false
}, - "operator": {
- "symbol": "CONTAINS"
}, - "queryValue": {
- "@type": "string",
- "$value": "indirect"
}
}
]
}, - "resultFields": [
- {
- "name": "All Applications Minimal",
- "symbol": "com.bottomline.cpay.model.AllApplicationsMinimal",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "All Applications Minimal",
- "symbol": "com.bottomline.cpay.model.AllApplicationsMinimal",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "PaymentProfileMinimal",
- "id": 8308,
- "name": "TEST INDIRECT PROFILE",
- "createdDate": "2018-08-10T13:47:36.224",
- "status": "AP",
- "bacsTransmissionType": "TEST",
- "type": "BACS",
- "dataEntryMethod": "MANUALENTRY",
- "serviceType": "BACSTELIP",
- "paymentFileSigningType": "NONE",
- "submissionSigningMethod": "SMARTCARD",
- "connectionType": "INDIRECT",
- "promptForDate": false,
- "originatingAccountName": "INDIRECT ACC NAME",
- "originatingSortCode": "217217",
- "originatingAccountNumber": "21702170",
- "originatorsStatementText": "IND STATE TEXT",
- "firstUseOfAccount": "NONE",
- "duplicateAccount": "NONE",
- "duplicateAmount": "NONE",
- "blackListedAccount": "NONE",
- "autoArchiveSentSubmissions": false,
- "numberOfDaysToProcessSentSubmissions": 7,
- "numberOfApprovals": 1,
- "automaticSubmission": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 1
}
}
]
}
]
}
]
}
Payment instructions are used for making payments and can be added to the system by uploading a file.
The API allows you to upload a Bacs file and retrieve the result of the upload.
Uploads a Bacs payment file.
id required | integer <int64> Payment profile identifier |
file required | string <binary> File to upload |
curl -F 'file=@PAYER_FILE' https://example.com/payments-service/api/file/6421
{- "version": "null",
- "extensions": [ ]
}
Retrieves the result of uploading a Bacs payment file.
id required | integer <int64> File identifier as generated by the system, obtained from the Upload a file call. |
curl -H "Content-Type: application/json" -X GET https://example.com/payments-service/api/file/19456
{- "id": 19456,
- "filename": "Payment file type.csv",
- "size": 253,
- "status": "SUCCESS",
- "submissionId": 88863,
- "applicationId": 6264,
- "batchId": 88864
}
Executes a query for successful Bacs file upload by batch id.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "payments",
- "symbol": "com.bottomline.cpay.model.bacs.payment.entry",
- "key": "com.bottomline.cpay.model.bacs.payment.entry"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "batchId",
- "symbol": "com.bottomline.cpay.model.bacs.payment.batchid",
- "fieldType": "INTEGER",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "integer",
- "$value": 127233
}
}
]
}, - "resultFields": [
- {
- "name": "Payment Detail",
- "symbol": "com.bottomline.cpay.model.bacs.payment.BacsInstruction",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "Payment Detail",
- "symbol": "com.bottomline.cpay.model.bacs.payment.BacsInstruction",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ModelMessages",
- "model": {
- "@type": "BacsInstruction",
- "id": 20943821,
- "batchId": 127233,
- "index": 1,
- "sortCode": "200000",
- "accountNumber": "55555555",
- "transactionType": "2",
- "transactionTypeCode": "01",
- "amount": 1,
- "text": "TEST DEST TEXT",
- "reference": "00009662",
- "name": "THE VICTORIAN SOCI",
- "paymentDate": "2018-11-07T00:00:00.000",
- "type": "DBACS",
- "status": "EN",
- "included": true,
- "isDDMEntry": false,
- "createdDate": "2018-11-05T00:00:00.000"
}, - "warning": {
- "entered": [
- "Originator details: The sort code has not been found in the sort code directory"
]
}
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 1
}
}
]
}
]
}
]
}
Executes a query for failed Bacs file upload by batch id.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.transformer.event",
- "key": "com.bottomline.cpay.model.bacs.transformer.event"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "BacsTransformerEvent BatchId",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent.batchId",
- "fieldType": "INTEGER",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "integer",
- "$value": 88860
}
}
]
}, - "resultFields": [
- {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4634086,
- "batchId": 88860,
- "createdTimeStamp": "2018-06-07T17:33:08",
- "eCode": "BV3006",
- "eventType": "Error",
- "lineNum": 0,
- "message": "No data records were extracted from file. Check XML mapping template and/or data file.",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 0,
- "submissionId": 88859,
- "type": "HEADER"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4634087,
- "batchId": 88860,
- "createdTimeStamp": "2018-06-07T17:33:08",
- "eventType": "Error",
- "lineNum": 0,
- "message": "Failed extracting CSV field[AMOUNT] because Input string was not in a correct format.",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 0,
- "submissionId": 88859,
- "type": "HEADER"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 2
}
}
]
}
]
}
]
}
Executes a query for failed Bacs file upload by submission id.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.transformer.event",
- "key": "com.bottomline.cpay.model.bacs.transformer.event"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "BacsTransformerEvent SubmissionId",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent.submissionid",
- "fieldType": "INTEGER",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "integer",
- "$value": 88860
}
}
]
}, - "resultFields": [
- {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4634086,
- "batchId": 88860,
- "createdTimeStamp": "2018-06-07T17:33:08",
- "eCode": "BV3006",
- "eventType": "Error",
- "lineNum": 0,
- "message": "No data records were extracted from file. Check XML mapping template and/or data file.",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 0,
- "submissionId": 88859,
- "type": "HEADER"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4634087,
- "batchId": 88860,
- "createdTimeStamp": "2018-06-07T17:33:08",
- "eventType": "Error",
- "lineNum": 0,
- "message": "Failed extracting CSV field[AMOUNT] because Input string was not in a correct format.",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 0,
- "submissionId": 88859,
- "type": "HEADER"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 2
}
}
]
}
]
}
]
}
Executes a query for failed Bacs file upload by batch id and error.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.transformer.event",
- "key": "com.bottomline.cpay.model.bacs.transformer.event"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "BacsTransformerEvent BatchId",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent.batchId",
- "fieldType": "INTEGER",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "integer",
- "$value": 112222
}
}, - {
- "@type": "QueryRelationship",
- "name": "AND",
- "description": "AND relationship.",
- "symbol": "AND"
}, - {
- "@type": "QueryParameter",
- "field": {
- "name": "BacsTransformerEvent Event Type",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent.eventType",
- "fieldType": "STRING",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "string",
- "$value": "Error"
}
}
]
}, - "resultFields": [
- {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "BacsTransformerEvent",
- "symbol": "com.bottomline.cpay.model.bacs.BacsTransformerEvent",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4662654,
- "batchId": 112222,
- "createdTimeStamp": "2018-08-01T08:57:37",
- "eCode": "BV3012",
- "eventType": "Error",
- "lineNum": 0,
- "message": "Data integrity check. The number of data records processed don't match database records.",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 0,
- "submissionId": 112221,
- "type": "HEADER"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4662652,
- "batchId": 112222,
- "createdTimeStamp": "2018-08-01T08:57:37",
- "eCode": "RV0102",
- "eventType": "Error",
- "lineNum": 1,
- "message": "Destination SortCode length is larger than the permitted length of 6 digits: 200000ERROR",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 1,
- "sourceDetail": "200000ERROR,55555555,01,200000,55555554,00000000100,\"The Victorian Soci\",00009662,\"Mr C J CONSTANCE\"\n",
- "submissionId": 112221,
- "type": "INSTRUCTION"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsTransformerEvent",
- "id": 4662653,
- "batchId": 112222,
- "createdTimeStamp": "2018-08-01T08:57:37",
- "eventType": "Error",
- "lineNum": 1,
- "message": "Validation Error: Destination SortCode length is larger than the permitted length of 6 digits: 200000ERROR Source Record:1 Data:200000ERROR,55555555,01,200000,55555554,00000000100,\"The Victorian Soci\",00009662,\"Mr C J CONSTANCE\"\n",
- "occurances": 0,
- "preSubmissionFlag": false,
- "recId": 1,
- "sourceDetail": "200000ERROR,55555555,01,200000,55555554,00000000100,\"The Victorian Soci\",00009662,\"Mr C J CONSTANCE\"\n",
- "submissionId": 112221
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 3
}
}
]
}
]
}
]
}
Bacs Messages are reports sent from Bacs to the system for Direct Debit collections.
The API allows you to list, view, export, mark as downloaded and update the status of Bacs messages.
Returns a list of Bacs messages (which are not downloaded). The information returned can then be used in the Bacs messages calls.
Note: This call is only available for collection profiles set up for file import. Use the Query list all messages call for collection profiles set up for Manual Data Entry and file import.
curl -H "Content-Type: application/json" -X POST { "entity":{ "name": "BacsMessage", "symbol": "com.bottomline.cpay.model.bacs.reports.ReportItem", "key": "com.bottomline.cpay.model.bacs.reports.ReportItem" }, "resultFields":[ { "name": "BacsMessage", "symbol": "com.bottomline.cpay.model.bacs.reports.ReportItem", "fieldType": "OBJECT", "key": false }, { "name": "rowCount", "symbol": "com.bottomline.query.count", "fieldType": "LONG", "key": false } ], "resultsPage":{ "firstResult": 0, "maxResults": 50 } } https://example.com/payments-service/api/bacs-messages/downloadable
{- "fields": [
- {
- "fieldType": "STRING",
- "key": true,
- "name": "string",
- "description": "string",
- "symbol": "string"
}
], - "rows": [
- {
- "rowValues": [
- {
- "values": [
- {
- "value": { },
- "displayValue": "string"
}
]
}
]
}
]
}
Returns a XML representation of the message. The service type, report Id and report format are mandatory for the request.
serviceType required | string <int64> Unique identifier of the service type. Set to either BACSTel-IP or SECURE-IP. |
reportId required | integer <int64> Unique identifier of the Bacs report. |
reportFormat required | string <int64> Default: 0 Unique identifier of the report type to be downloaded. Set to:
|
curl -H "Content-Type: text/html" -X GET https://example.com/payments-service/api/bacs-messages/BACSTel-IP/9774/0
Updates the status of the Bacs message. The service type, report Id, document Id and readStatus are mandatory for the request.
serviceType required | string <int64> Unique identifier of the service type. |
reportId required | integer <int64> Unique identifier of the Bacs report, obtained from calling List bacs messages. |
documentId required | integer <int64> Unique identifier of the Bacs document, obtained from calling List bacs messages. |
readStatus required | integer <int64> Indicates if the system should mark the message as read after the download (0 - false, 1 - true) |
curl -H "Content-Type: application/json" -X PUT https://example.com/payments-service/api/bacs-messages/BACSTel-IP/bacs-report/9774/223879829/set-read-status/1
null
Marks a Bacs message as downloaded, even if the document is not downloaded. The service type, report Id and document Id are mandatory.
serviceType required | string <int64> Unique identifier of the service type. Set to either BACSTel-IP or SECURE-IP. |
reportId required | integer <int64> Unique identifier of the Bacs report. |
documentId required | integer <int64> Unique identifier of the Bacs document. |
curl -H "Content-Type: */*" -X POST https://example.com/payments-service/api/bacs-messages/mark-downloaded/BACSTel-IP/9774/223879829
Executes a query to list all Bacs messages. This call is available for collection profiles set up for Manual Data Entry and file import.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "BacsMessage",
- "symbol": "com.bottomline.cpay.model.bacs.reportitem",
- "key": "com.bottomline.cpay.model.bacs.reports.reportitem"
}, - "resultFields": [
- {
- "name": "BacsMessage",
- "symbol": "com.bottomline.cpay.model.bacs.reports.ReportItem",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "BacsMessage",
- "symbol": "com.bottomline.cpay.model.bacs.reports.ReportItem",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8556",
- "reportId": 8556,
- "type": "Arrival",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "REFT Arrival Report (2011)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 920556730,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8557",
- "reportId": 8557,
- "type": "Input",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "REFT Input Report (2013)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 2083356144,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8558",
- "reportId": 8558,
- "type": "Test Input",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "Test Input Report (2025)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 1405042097,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8559",
- "reportId": 8559,
- "type": "ARUCS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "ARUCS Report (1027)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 1027100265,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8560",
- "reportId": 8560,
- "type": "ARUDD",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "ARUDD Report (1016)",
- "read": true,
- "isFasterPayments": false,
- "documentId": 1016100265,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8561",
- "reportId": 8561,
- "type": "Test",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "Generic Test Report",
- "read": false,
- "isFasterPayments": false,
- "documentId": 86735623,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8569",
- "reportId": 8569,
- "type": "DDICA",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "DDICA",
- "read": false,
- "isFasterPayments": false,
- "documentId": 10196602,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8563",
- "reportId": 8563,
- "type": "Withdrawal",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "Withdrawal Report (2014)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 1323841257,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8564",
- "reportId": 8564,
- "type": "ADDACS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "ADDACS (7001)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7001100265,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8565",
- "reportId": 8565,
- "type": "AUDDIS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS Bank Returned DDI (7002)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7002100265,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8566",
- "reportId": 8566,
- "type": "AUDDIS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS File Acceptance (7003)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7003100265,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8567",
- "reportId": 8567,
- "type": "AUDDIS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS File Rejection (7004)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7004100265,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8568",
- "reportId": 8568,
- "type": "AWACS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AWACS (7007)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 242242584,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8562",
- "reportId": 8562,
- "type": "Test Advice",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS Bank Returned DDI",
- "read": false,
- "isFasterPayments": false,
- "documentId": 405276514,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 14
}
}
]
}
]
}
]
}
Executes a query for Bacs messages not downloaded.
In the reponse the possible values for the processed field are:
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
resultFields required | Array of any The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "BacsMessage",
- "symbol": "com.bottomline.cpay.model.bacs.reports.reportitem",
- "key": "com.bottomline.cpay.model.bacs.reports.reportitem"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "Downloaded",
- "symbol": "com.bottomline.cpay.model.bacs.reportitem.downloaded",
- "fieldType": "BOOLEAN",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "boolean",
- "$value": false
}
}
]
}, - "resultFields": [
- {
- "name": "BacsMessage",
- "symbol": "com.bottomline.cpay.model.bacs.reports.ReportItem",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "BacsMessage",
- "symbol": "com.bottomline.cpay.model.bacs.reports.ReportItem",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8557",
- "reportId": 8557,
- "type": "Input",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "REFT Input Report (2013)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 2083356144,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8558",
- "reportId": 8558,
- "type": "Test Input",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "Test Input Report (2025)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 1405042097,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8559",
- "reportId": 8559,
- "type": "ARUCS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "ARUCS Report (1027)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 1027100265,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8560",
- "reportId": 8560,
- "type": "ARUDD",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "ARUDD Report (1016)",
- "read": true,
- "isFasterPayments": false,
- "documentId": 1016100265,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8562",
- "reportId": 8562,
- "type": "Test Advice",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS Bank Returned DDI",
- "read": false,
- "isFasterPayments": false,
- "documentId": 405276514,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8569",
- "reportId": 8569,
- "type": "DDICA",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "DDICA",
- "read": false,
- "isFasterPayments": false,
- "documentId": 10196602,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8564",
- "reportId": 8564,
- "type": "ADDACS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "ADDACS (7001)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7001100265,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8565",
- "reportId": 8565,
- "type": "AUDDIS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS Bank Returned DDI (7002)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7002100265,
- "processed": "REVIEW",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8566",
- "reportId": 8566,
- "type": "AUDDIS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS File Acceptance (7003)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7003100265,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8567",
- "reportId": 8567,
- "type": "AUDDIS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AUDDIS File Rejection (7004)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 7004100265,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8568",
- "reportId": 8568,
- "type": "AWACS",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "AWACS (7007)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 242242584,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "ReportViewItem",
- "id": "BACS8563",
- "reportId": 8563,
- "type": "Withdrawal",
- "serviceUserNumber": "100265",
- "date": "2018-08-06T00:00:00.000",
- "name": "Withdrawal Report (2014)",
- "read": false,
- "isFasterPayments": false,
- "documentId": 1323841257,
- "processed": "BLANK",
- "downloaded": false
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 12
}
}
]
}
]
}
]
}
Executes a query for Bacs messages instruction detail by report id.
The query to be executed.
required | object (QueryEntity) The entity in the query. |
object (QueryCriteria) The criteria of the query to be performed on the database. | |
required | Array of objects (QueryField) The field values to be returned as the query result. |
object (QueryResultsPage) The controller of the page size to be returned within the processed query. It is recommended that no more than 500 results are returned in a search. |
{- "entity": {
- "name": "BacsReportDdmLog",
- "symbol": "com.bottomline.ddm.model.bacsreportddmlog",
- "key": "com.bottomline.ddm.model.bacsreportddmlog"
}, - "criteria": {
- "searchCriteria": [
- {
- "@type": "QueryParameter",
- "field": {
- "name": "reportId",
- "symbol": "com.bottomline.ddm.model.BacsReportDdmLog.profileId",
- "fieldType": "LONG",
- "key": false
}, - "operator": {
- "symbol": "="
}, - "queryValue": {
- "@type": "long",
- "$value": 8560
}
}
]
}, - "resultFields": [
- {
- "name": "BacsReportDdmLog",
- "symbol": "com.bottomline.ddm.model.bacs.reports.BacsReportDdmLo",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "resultsPage": {
- "firstResult": 0,
- "maxResults": 50
}
}
{- "fields": [
- {
- "name": "BacsReportDdmLog",
- "symbol": "com.bottomline.ddm.model.bacs.reports.BacsReportDdmLog",
- "fieldType": "OBJECT",
- "key": false
}, - {
- "name": "rowCount",
- "symbol": "com.bottomline.query.count",
- "fieldType": "LONG",
- "key": false
}
], - "rows": [
- {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26160,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"00783789U\", sort code: \"902194\", account number: \"49204813\", payment date: \"2010-08-10\", amount: \"253.68\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.601",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26161,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"00793597U\", sort code: \"902274\", account number: \"49959781\", payment date: \"2010-08-10\", amount: \"35.48\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.633",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26162,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"01004361R\", sort code: \"404324\", account number: \"92091712\", payment date: \"2010-08-10\", amount: \"273.48\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.636",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26163,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"01011344M\", sort code: \"902100\", account number: \"27640059\", payment date: \"2010-08-10\", amount: \"78.68\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.640",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26164,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"01051230M\", sort code: \"902194\", account number: \"20437779\", payment date: \"2010-08-10\", amount: \"31.17\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.643",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26165,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"01054981A\", sort code: \"089417\", account number: \"01001105\", payment date: \"2010-08-10\", amount: \"21.22\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.647",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26166,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"01140413G\", sort code: \"902311\", account number: \"38062143\", payment date: \"2010-08-10\", amount: \"31.07\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.650",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26167,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"01159616V\", sort code: \"609204\", account number: \"91704315\", payment date: \"2010-08-10\", amount: \"33.04\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.653",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26168,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"00212352N\", sort code: \"601730\", account number: \"83452818\", payment date: \"2010-08-11\", amount: \"58.19\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.656",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26169,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"00213294T\", sort code: \"010838\", account number: \"23463880\", payment date: \"2010-08-11\", amount: \"51.08\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.659",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26170,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"00215186B\", sort code: \"309826\", account number: \"02762618\", payment date: \"2010-08-11\", amount: \"53.72\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.663",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26171,
- "message": "ARUDD Report (1016) (id: 8,560):Instruction not found by SUN: \"121212\", reference: \"00221814C\", sort code: \"090126\", account number: \"20474664\", payment date: \"2010-08-11\", amount: \"20.05\", status: \"SUCCESS\".",
- "appliedTimestamp": "2018-09-07T02:00:00.666",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "BacsReportDdmLog",
- "id": 26172,
- "message": "ARUDD report Id 8,560 process failed.Unable to process 12 items of 12.",
- "appliedTimestamp": "2018-09-07T02:00:00.669",
- "reportId": 8560,
- "reportType": "ARUDD"
}
}
]
}
]
}, - {
- "values": [
- {
- "resultValues": [
- {
- "value": {
- "@type": "long",
- "$value": 13
}
}
]
}
]
}
]
}
Submission summary reports are provided by the Bacs service at the point of submission and are used to feed back information on payments so that they can be followed up accordingly.
Retrieves a submission summary report. The HTTP 200 response will contain either the report (if the report exists) or the text "Report is unavailable".
submissionId required | integer <int64> Example: 126091 Submission identifier obtained from the Create a new payment batch call. |
curl -H "Content-Type: application/json" -X GET https://example.com/payments-service/api/bacs/submissions/126091/report
<html xmlns:sub="http://bacs.co.uk/submissions"><head><meta http-equiv="Content-Type" content="text/html;" charset="utf-8" /><title>Bacs Payment Servivces - Submissions Summary</title></head><body> .... </body></html>
Returns a list of all current users.
realmid required | string Example: TEST Realm ID (obtained from Bottomline support) |
Search criteria
curl -H "Content-Type: application/json" -X POST https://example.com/payments-service/api/principal/user/TEST/search?maint=true
[- {
- "@type": "UserPrincipal",
- "name": "Test Test",
- "comment": "Approved",
- "identifier": {
- "realmKey": "TEST",
- "key": "5DNLJAY7WUDJJNPPUITF"
}, - "expiry": 9223372036854776000,
- "reason": "NONE",
- "attributes": {
- "statusCode": "AP",
- "lastName": "Test",
- "admin": "No",
- "firstName": "Test",
- "administrator": "false",
- "twoStepVerificationToken": "None",
- "status": "Approved",
- "email": "aTest@bottomlinetest.com",
- "role": "",
- "mfaMode": "NONE"
}
}, - {
- "@type": "UserPrincipal",
- "name": "Alex Jones",
- "comment": "Approved",
- "identifier": {
- "realmKey": "TEST",
- "key": "DEX8FTUOQF1JHIDQTMTH"
}, - "expiry": 9223372036854776000,
- "reason": "NONE",
- "attributes": {
- "statusCode": "AP",
- "lastName": "Jones",
- "admin": "Yes",
- "firstName": "Alex",
- "administrator": "true",
- "twoStepVerificationToken": "None",
- "status": "Approved",
- "email": "alex.jones@bottomline.com",
- "role": "Full",
- "mfaMode": "NONE"
}
}, - {
- "@type": "UserPrincipal",
- "name": "Joe_Irving",
- "comment": "Approved",
- "identifier": {
- "realmKey": "TEST",
- "key": "GBFVUHDBXVSJER1JZ4JD"
}, - "expiry": 9223372036854776000,
- "reason": "NONE",
- "attributes": {
- "statusCode": "AP",
- "lastName": "Irving",
- "admin": "Yes",
- "firstName": "Joe",
- "administrator": "true",
- "twoStepVerificationToken": "None",
- "status": "Approved",
- "email": "joe.irving@bottomline.com",
- "role": "Full",
- "mfaMode": "NONE"
}
}
]
Returns a list of all roles.
Identifier
realmKey | string Realm key (obtained from Bottomline support). |
curl -H "Content-Type: application/json" -X POST { "identifier":{ "realmKey":"TEST" } } https://example.com/payments-service/api/roles/providers/com.bottomline.banking.webseries.roles.provider.webseries/com.bottomline.banking.webseries.roles.provider.WebSeriesRolesProvider/getRolesForRealm
[- {
- "@type": "Role",
- "extensions": [
- {
- "@type": "WebSeriesRoleEntitlement",
- "id": "ROLE_ENTITLEMENT",
- "paymentRoleType": "ALL",
- "createPaymentProfileAllowed": false,
- "reportsAllowed": true,
- "viewAllowed": true,
- "createAllowed": true,
- "approveAllowed": true,
- "submitAllowed": true,
- "commitAllowed": true,
- "archiveAllowed": true,
- "approveOwnAllowed": true,
- "commitOwnAllowed": true,
- "submitOwnAllowed": false,
- "ddmAllowed": true,
- "ddmRoleType": "ALL",
- "allowAllProfiles": true,
- "oneOffInstructions": true,
- "oneOffRefund": true,
- "allowAllDdmProfiles": true,
- "viewDdmAllowed": true,
- "manageTemplatesAllowed": false,
- "selectTemplatesAllowed": false,
- "createCompanyAllowed": false,
- "editCompanyAllowed": false,
- "deleteCompanyAllowed": false,
- "disableCompanyAllowed": false,
- "viewCompanyAllowed": false,
- "riskAssessmentAllowed": true,
- "manageBlackListAllowed": true,
- "vSeriesEntitlementsAllowed": false,
- "creditCardsEntitlementsAllowed": false,
- "paymentsAllowed": true,
- "protectAllowed": true
}, - {
- "@type": "WebSeriesRoleChanges",
- "id": "ROLE_PENDINGCHANGES"
}
], - "name": "Full",
- "comment": "Full Permissions",
- "roleIdentifierImpl": {
- "identifierKey": "Full"
}, - "attributes": {
- "statusCode": "AP"
}
}, - {
- "@type": "Role",
- "extensions": [
- {
- "@type": "WebSeriesRoleEntitlement",
- "id": "ROLE_ENTITLEMENT",
- "paymentRoleType": "ALL",
- "createPaymentProfileAllowed": false,
- "reportsAllowed": true,
- "viewAllowed": true,
- "createAllowed": true,
- "approveAllowed": true,
- "submitAllowed": true,
- "commitAllowed": true,
- "archiveAllowed": true,
- "approveOwnAllowed": true,
- "commitOwnAllowed": true,
- "submitOwnAllowed": false,
- "ddmAllowed": false,
- "ddmRoleType": "ALL",
- "allowAllProfiles": true,
- "oneOffInstructions": false,
- "oneOffRefund": false,
- "allowAllDdmProfiles": false,
- "viewDdmAllowed": false,
- "manageTemplatesAllowed": false,
- "selectTemplatesAllowed": false,
- "createCompanyAllowed": false,
- "editCompanyAllowed": false,
- "deleteCompanyAllowed": false,
- "disableCompanyAllowed": false,
- "viewCompanyAllowed": false,
- "riskAssessmentAllowed": false,
- "manageBlackListAllowed": false,
- "vSeriesEntitlementsAllowed": false,
- "creditCardsEntitlementsAllowed": false,
- "paymentsAllowed": true,
- "protectAllowed": false
}, - {
- "@type": "WebSeriesRoleChanges",
- "id": "ROLE_PENDINGCHANGES"
}
], - "name": "PayOnly",
- "comment": "Payments Access Only",
- "roleIdentifierImpl": {
- "identifierKey": "PayOnly"
}, - "attributes": {
- "statusCode": "AP"
}
}
]