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 licenseReturns transaction detail for a client over a period ending at yearMonth, in the reporting currency you choose.
Parameters
| Name | In | Type | Description | |
|---|---|---|---|---|
id | path | integer | required | Client id. 0 returns all clients you can access. |
yearMonth | query | integer | required | End of the period, YYYYMM. |
period | query | integer | optional | 0 MTD (default), 1 YTD, 2 3 months, 3 6 months, 4 12 months. |
ccy | query | string | optional | Reporting currency. Default USD. |
investmentVehicle | query | string | optional | Only return transactions of this investment vehicle. Default: all. |
nodeId | query | string | optional | Only return transactions under this GWM node. Default: all. |
tenantId | query | string | optional | Tenant to query, from /Tenants. Default: your user's main tenant. |
Example request
Response
Response fields
| Field | Type | Description |
|---|---|---|
transactionId | string | Transaction id. |
clientID | string | Client ID as shown in Clients. |
clientAlias | string | Client alias. |
invVehicle | string | Investment vehicle name. |
invVehicleCode | string | null | Investment vehicle code. |
parentNodeId | string | null | Parent node in the GWM. |
transactionDate | string | null | Transaction date. |
bankBroker | string | Bank or broker. Applies to account nodes. |
accountNumber | string | null | Account number. |
assetName | string | null | Asset or security name. |
nodeId | string | Node id. |
securityId | integer | null | Masttro security id. |
isin, sedol, cusip | string | Security identifiers. |
assetClass | string | null | Asset class from your Asset Master. |
securityType | string | null | Security type from your Asset Master. |
transactionType | string | null | Type of transaction. |
concept | string | null | Transaction concept. |
gwmInExType | string | null | Income or expense type, for transactions entered in GWM. |
comments | string | null | Comments. |
quantity | string | null | Units traded. |
netPriceLocalCCY | number | null | Net price per unit, local currency. |
netAmountLocalCCY | number | null | Total amount, local currency. |
withholdingTaxLocalCCY | number | null | Tax withheld, local currency. |
commissionLocalCCY | number | null | Execution commission, local currency. |
otherFeesLocalCCY | number | null | Other fees, local currency. |
localCCY | string | null | Local currency of the asset. |
netAmountRepCCY | number | null | Total amount, reporting currency. |
initialDate | string | null | Start of the selected period. |
date | string | null | Date selected in the request. |
postDate | string | null | Date the transaction was posted in Masttro. |
symbol | string | null | Security symbol. |
Errors
| Status | Body |
|---|---|
400 | "The user does not have access to this client or the client does not exist." |
400 | Validation 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
| Name | In | Type | Description | |
|---|---|---|---|---|
id | path | integer | required | Client id. 0 returns all clients you can access. |
postStartDate | query | integer | required | First posting date, YYYYMMDD. |
postEndDate | query | integer | required | Last posting date, YYYYMMDD. |
ccy | query | string | optional | Reporting currency. Default USD. |
nodeId | query | string | optional | Only return transactions under this GWM node. Default: all. |
tenantId | query | string | optional | Tenant to query, from /Tenants. Default: your user's main tenant. |
Example request
Response
The same fields as Transactions by period, plus:
| Field | Type | Description |
|---|---|---|
deletionFlag | string | Whether the transaction was deleted. Remove deleted transactions from your copy. |
settleDate | string | Settlement date. |
Errors
| Status | Body |
|---|---|
400 | "The user does not have access to this client or the client does not exist." |
400 | Validation 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.