FINANCIAL_BANK_ACCOUNT_TRANSACTION_SOURCE_PROCESS | CORE Endpoint | |
/ondemand/core/?method=FINANCIAL_BANK_ACCOUNT_TRANSACTION_SOURCE_PROCESS | ||
This method allows you to process a QIF, CSV, or XML file containing financial transactions. This file must be attached to a FINANCIAL_BANK_ACCOUNT_TRANSACTION_SOURCE_SEARCH record. These transactions can then be read via FINANCIAL_BANK_ACCOUNT_TRANSACTION_SEARCH |
PARAMETERS | TYPE | ||
Id | Numeric | Mandatory. Attachment Id |
RETURN | TYPE | ||
IgnoreCount | Numeric | Number of records ignored | |
IgnoreReasonN | Text | The reason why each records was ignored (if any). The first will be IgnoreReason0, then IgnoreReason1 etc | |
InsertCount | Numeric | Number of records inserted | |
LineCount | Numeric | Number of lines in the file |
FILE FORMAT - QIF | |
!Type:Bank D03/03/10 MINTEREST T32.50 LDEP ^ D03/03/10 MACTIVITY FEE - REFER ANALYSIS & FEE STMT 290208 T-15.51 LFEE ^ D03/03/10 MMONTHLY PLAN FEE T-6.50 LFEE ^ |
FILE FORMAT - CSV | |
Account Number,Account Name,Transaction Date,Transaction Description,Cheque/Reference Number,Debit Amount,Credit Amount,Balance |
|
The first row needs to be the header row. If a Debit Amount is supplied, the Credit Amount is ignored. |
FILE FORMAT - XML | |
Contact myDigitalStructure support |
EXAMPLES | |