Convert CAMT to PARQUET
Turn CAMT files into PARQUET. Every entry of the camt.053 statements, camt.052 reports and camt.054 notifications gives a row with the account's IBAN, the booking date, the signed amount, its currency, the other party's name, the remittance text, the end-to-end reference, the bank transaction code as the type and the bank's reference as the id.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop CAMT files on the dialor turn it to pick what to do
Bank statements as a table of rows.Each entry in a camt file becomes one row in a Parquet table.
What you get
One Parquet file with a row for every entry of your camt.053 statements, camt.052 reports and camt.054 notifications. Each row holds the account's IBAN, the booking date, the signed amount and its currency.
The row also holds the other party's name, the remittance text and the end-to-end reference. The bank transaction code is stored as the type, and the bank's reference as the id.
How the columns are typed
The table has a column for each key of the json conversion, typed from the values. Dates become dates, amounts and balances become numbers, and the other columns are text.
An entry that books several payments at once stays one row. The names of the payments are joined in that row.
Balances
Each balance is counted from the opening balance. The count is kept when it meets the closing balance.
When you want the result as one file with other tables, you can merge PARQUET afterward. For other targets, see every PARQUET conversion.
CAMT and PARQUET.What each format is.
The formats
ISO 20022 camt Statement
The XML bank statements of ISO 20022 that SEPA banks deliver: camt.053 statements, camt.052 intraday reports and camt.054 notifications.
- Extensions
- .camt
- MIME type
- application
/x -camt +xml - Kind
- Text and data
Parquet
The columnar data format of analytics. Compressed, typed and fast to scan.
- Extensions
- .parquet .pq
- MIME type
- application
/vnd .apache .parquet - Kind
- Text and data
In your code.The same CAMT to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.camt report.parquet$ cv convert report.camt report.parquetQuestions.What people ask about CAMT to PARQUET.
One entry of the statement, report or notification. An entry that books several payments at once is still one row, with the names joined.
The camt.053 statements, camt.052 intraday reports and camt.054 notifications are all read. Each entry gives a row.
No. Dates become dates, and amounts and balances become numbers. The other columns are text.
The amount is signed, so the sign tells them apart.