CSV File Format (Request)
The CSV request file contains the payment details required to perform multiple Confirmation of Payee checks, with each row representing an individual payee confirmation request.
Coming Soon!
- Support for this file format is in development and coming soon!
Request File Guidance / Best Practice
Please follow the "best practice" formatting guidance set out below. Keeping to this guidance will ensure your file is processed correctly and is not rejected.
- Use the following file naming convention to ensure each file uploaded is unique and identifiable from other file uploads.
- file name must start with the prefix "cop_req" to identify this as a CoP Request file
- file name must include your "company short name", agreed with your assigned Apicunia account manager during technical onboarding
- file name must include a date formatted as "yyyyMMdd"
- file name must include a "batch number" to uniquely identify the file incase of multiple files uploaded on the same date. Format: 3 digits starting 001 through to 999
^(?!000)[0-9]{3}$ - Required format file name: "cop_req_companyshortname_yyyyMMdd_batchnumber.csv"
- Example file name: "cop_req_bobsbank_20260827_001.csv"
- Include column headers in the file, as specified in the table below.
- Use only the specified data type/format for each column in the file, as specified in the table below.
- Trim any leading and trailing spaces around values.
- Do not include empty/blank rows.
- Ensure a comma (,) delimiter is used.
- Enclose all column headers and values in quotation marks (" ").
- Use UTF-8 encoding for the file to ensure preservation of any special characters.
Request File Structure
The structure of the request CSV file to be used for upload is detailed in the table below.
| Column (Header) | Data Type | Format | Required | Description |
|---|---|---|---|---|
CorrelationId | string | max length: 100 | Yes | A unique value to track/trace each individual request within the file. This could be a unique value from an external system (e.g. uuid, integer or another unique identifier) |
AccountType | string | max length: 8 | Yes | One of Personal or Business (case-insensitive) |
Identification | string | max length: 14 | Yes | A concatenation of a 6-digit Sort Code and 8-digit Account Number. Format: ^[0-9]{14}$ |
Name | string | max length: 140 | Yes | The Payee / Beneficiary Name |
SecondaryIdentification | string | max length: 140 | Optional | Optionally include some Secondary Reference information if this is required by the account before the name can be checked (e.g. Company registration number for buinsess accounts) |
Sample Request File Structure
Below is sample CSV request file using both a mixture of Personal and Business based CoP requests.
This is dummmy account data that can be used against the Bulk File Service Sandbox;
cop_req_bobsbank_20260827_001.csv
"correlationid","accounttype","identification","name","secondaryidentification"
"1","personal","GB29NWBK60000190000001","John Smith",""
"2","personal","GB33BUKB20454590000002","Robert Jones",""
"3","personal","GB17RBOS16522190000003","Stephen Brown",""
"4","personal","GB45LOYD30000290000004","Sarah Thomas",""
"5","personal","GB21HLFX11000190000005","Susan White",""
"6","business","GB67HBUK40051580000001","Oak Accounting",""
"7","business","GB62TSBS77010180000002","Beacon Estates","01234567"
"8","business","GB58CLYD82200080000003","Simon Cycles Ltd",""
"9","business","GB11NATI07011680000004","Fienix Solutions",""
"10","business","GB39BOFS80226080000005","Northbridge Consulting",""