CData Cmdlets for OFX 2019J - Online Help


CData Cmdlets for OFX 2019J - Build 19.0.7354

Query balances for a single investment account.


Name Type Description
Id [KEY] String Id assigned for the transaction by the financial institution.
Aggregate String Balance information aggregate.
Name String The name for the current balance.
Amount String The value of the current balance.
Description String Description of the current balance.
TypeDescription String Description of the balance type.
CurrencyCode String Default currency code for transactions.
StatementDate Datetime Date and time for the statement download.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
OFXReadFile String Specify a file path to read OFX data from a local file. Data will not be requested from the financial institution and the local OFX data will be parsed.
OFXWriteFile String Specify a file path to create a local file containing the OFX data, including OFX headers, returned by the financial institution.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0