API reference

Transactions

Two endpoints return transactions. Use Transactions for reporting on a period. Use the Transaction log to sync changes by posting date, including deletions.

Transactions by period

GET/Transactions/{id}
MCP tool get_transactionsCore license

Returns transaction detail for a client over a period ending at yearMonth, in the reporting currency you choose.

Parameters

NameInTypeDescription
idpathintegerrequiredClient id. 0 returns all clients you can access.
yearMonthqueryintegerrequiredEnd of the period, YYYYMM.
periodqueryintegeroptional0 MTD (default), 1 YTD, 2 3 months, 3 6 months, 4 12 months.
ccyquerystringoptionalReporting currency. Default USD.
investmentVehiclequerystringoptionalOnly return transactions of this investment vehicle. Default: all.
nodeIdquerystringoptionalOnly return transactions under this GWM node. Default: all.
tenantIdquerystringoptionalTenant to query, from /Tenants. Default: your user's main tenant.

Example request

Response

Response fields
FieldTypeDescription
transactionIdstringTransaction id.
clientIDstringClient ID as shown in Clients.
clientAliasstringClient alias.
invVehiclestringInvestment vehicle name.
invVehicleCodestring | nullInvestment vehicle code.
parentNodeIdstring | nullParent node in the GWM.
transactionDatestring | nullTransaction date.
bankBrokerstringBank or broker. Applies to account nodes.
accountNumberstring | nullAccount number.
assetNamestring | nullAsset or security name.
nodeIdstringNode id.
securityIdinteger | nullMasttro security id.
isin, sedol, cusipstringSecurity identifiers.
assetClassstring | nullAsset class from your Asset Master.
securityTypestring | nullSecurity type from your Asset Master.
transactionTypestring | nullType of transaction.
conceptstring | nullTransaction concept.
gwmInExTypestring | nullIncome or expense type, for transactions entered in GWM.
commentsstring | nullComments.
quantitystring | nullUnits traded.
netPriceLocalCCYnumber | nullNet price per unit, local currency.
netAmountLocalCCYnumber | nullTotal amount, local currency.
withholdingTaxLocalCCYnumber | nullTax withheld, local currency.
commissionLocalCCYnumber | nullExecution commission, local currency.
otherFeesLocalCCYnumber | nullOther fees, local currency.
localCCYstring | nullLocal currency of the asset.
netAmountRepCCYnumber | nullTotal amount, reporting currency.
initialDatestring | nullStart of the selected period.
datestring | nullDate selected in the request.
postDatestring | nullDate the transaction was posted in Masttro.
symbolstring | nullSecurity symbol.

Errors

StatusBody
400"The user does not have access to this client or the client does not exist."
400Validation problem when yearMonth is missing or not a number.
400"The user does not have access to this tenant or the tenant does not exist."

Transaction log

GET/Transactions/log/{id}
REST onlyCore license

Returns every transaction posted in a date range, regardless of its transaction date, with a deletionFlag so you can mirror deletions. This is the endpoint to use for incremental syncs.

Parameters

NameInTypeDescription
idpathintegerrequiredClient id. 0 returns all clients you can access.
postStartDatequeryintegerrequiredFirst posting date, YYYYMMDD.
postEndDatequeryintegerrequiredLast posting date, YYYYMMDD.
ccyquerystringoptionalReporting currency. Default USD.
nodeIdquerystringoptionalOnly return transactions under this GWM node. Default: all.
tenantIdquerystringoptionalTenant to query, from /Tenants. Default: your user's main tenant.

Example request

Response

The same fields as Transactions by period, plus:

FieldTypeDescription
deletionFlagstringWhether the transaction was deleted. Remove deleted transactions from your copy.
settleDatestringSettlement date.

Errors

StatusBody
400"The user does not have access to this client or the client does not exist."
400Validation problem when postStartDate or postEndDate is missing or not a number.
400"The user does not have access to this tenant or the tenant does not exist."

Plus the common 401 and 429 responses. See Errors.