Sesame Data
  • Introduction
  • Authentication
    • Create and manage your API token
    • How to Authenticate
    • IP Whitelisting
  • API Endpoints
    • Entity List
    • Entity Dates
    • Transactions
    • Holdings
    • Sub Portfolio Holdings
    • Entity Risk
    • Asset Risk
    • Entity Performance
  • Sesame Data Developer Portal
  • Data Feeds
  • Tutorials/Recipes
    • How to use pagination
    • Using Sesame Data with Postman
    • Using Sesame Data with Excel
    • Using Sesame Data with PowerBi
  • FAQ and Troubleshooting
    • Viewing Logs
    • Glossary
Powered by GitBook
On this page

Was this helpful?

  1. API Endpoints

Transactions

PreviousEntity DatesNextHoldings

Last updated 13 days ago

Was this helpful?

The transactions endpoint returns the transactions which have occurred for a specific entity. For each valueDate where transactions are received from a custodian, data will be available in the transactions endpoint once standardised through data processing layer. Requests are made using the entityId parameter, which is mandatory.

For the full list of parameters accepted as well as which are required, see Parameters below. To view Sample response data, expand the menu under Responses and refer to the Example tab. To see the format of the response fields, as well as which are mandatory (that is, always returned in the response), select the tab Schema, and then expand object followed by content and finally object once more.

Request and Response

You might find it helpful to access our Sesame Data Developer Portal

The format of all Sesame Custodial Data APIs is the same. The user is required to provide their account UUID and token in the authorisation, and then make a GET request to the transactions endpoint, specifying the entityId of the entity being requested.

Investment Hub and Doc AI

While Sesame Data Custodial generally involves data from custodied feeds being requested over API, Sesame also supports loading of transactions pertaining to private assets in general, and private funds in particular. The Investment Hub allows users to manage all their non-custodied transactions and positions. Doc AI allows you to quickly and accurately extract data from private equity and private credit notices (like capital statements, call and distribution notices), making maintaining your privates in Sesame easy. These transactions and positions are also available in the Sesame Data API.

Supported Transaction Subtypes

  • Admin Fees

  • Borrowing

  • Brokerage Fees

  • Capital Call

  • Commitment

  • Commitment Reduction

  • Custodian Fees

  • Deposits

  • Derivative Cash Settlement

  • Derivative Premium

  • Distribution

  • Dividend

  • Dividend in Kind

  • Equalisation

  • Interest

  • Internal FX Transaction

  • Management Fees

  • Other Costs

  • Other Fees

  • Principal Repayment

  • Purchase

  • Redemption

  • Reverse Stock Split

  • Rights Issue

  • Rights Issue Exercise

  • Sales

  • Security Transfer In

  • Security Transfer Out

  • Spin Off

  • Stock Split

  • Subscription

  • Taxes

  • Withdrawals

get
Path parameters
entityIdinteger · int64Required

Unique identifier provided by Landytech

Example: 123
Query parameters
fromDatestring · dateOptional

Start of Date Range (Inclusive)

Example: 2025-05-01
toDatestring · dateOptional

End of Date Range (Inclusive)

Example: 2025-05-13
lookThroughbooleanOptional

Enable/disable look through. For bookkeeping use-cases, this should be set to false.

Default: false
pageNumberinteger · int32Optional

The current page, the first page should be '0'

Default: 0
pageSizeinteger · int32 · max: 100Optional

Number of records per page

Default: 100
Responses
200
OK
application/json
get
GET /api/v1/transactions/{entityId} HTTP/1.1
Host: data.api.landytech.net
Accept: */*
200

OK

{
  "content": [
    {
      "entityId": 36403,
      "tradeDate": "2025-05-13",
      "settlementDate": "2025-05-15",
      "valueDate": "2025-05-13",
      "entityName": "HSBC (7095754)",
      "assetName": "PCSB Financial Ord Shs",
      "assetId": 118183,
      "assetType": "Common Stock",
      "isin": "US69324R1041",
      "transactionSubtype": "Purchase",
      "quantity": 10000,
      "localCurrency": "USD",
      "unitPrice": 18.05,
      "amount": -185362.45,
      "commissionsLc": -362.45,
      "transactionId": "187318436 USD 2025-05-13",
      "description": "Purchase - PCSB Financial Corp",
      "stampDutyLc": 0,
      "withholdingTaxLc": 0,
      "collectionChargeLc": 0,
      "taxLc": 0,
      "reversal": false,
      "reversedTransactionId": false,
      "subPortfolioCode": "7095754.001.01",
      "capitalOrIncome": "CAPITAL",
      "movementRc": -145907.13,
      "grossMovementLc": -185000,
      "grossMovementRc": -145621.83,
      "subPortfolioCode2": "7095754.002.01",
      "localCurrency2": "GBP",
      "accruedInterestLc": 0,
      "capitalCallDeductible": -90000,
      "capitalCallNonDeductible": -10000,
      "capitalCallInvestment": -90000,
      "capitalCallManagementFees": -2000,
      "capitalCallFundExpenses": -3000,
      "capitalCallOtherFees": -5000,
      "equalisation": 0,
      "distributionRecallable": 10000,
      "distributionNonRecallable": 95000,
      "distributionReturnOfCapital": 10000,
      "distributionCapitalGain": 90000,
      "distributionIncome": 5000
    }
  ],
  "totalPages": 1,
  "totalElements": 1,
  "last": true,
  "size": 100,
  "first": true,
  "number": 0,
  "numberOfElements": 1,
  "empty": false
}
  • Request and Response
  • GET/api/v1/transactions/{entityId}
  • Investment Hub and Doc AI
  • Supported Transaction Subtypes