The TS API provides endpoints for users or datacentres to access data sets derived from Report or Market Data.

• The Report Data API will fetch a snapshot of a data set on a given day. The snapshot is taken daily at 21:00 (CET) based on a System Report that is managed and edited in the TS application. It is possible to update the snapshot via the TS Autopilot, please see Set up of Autopilot "Update Transaction API Data" Activity  
• The Market Data API returns data as it is stored in TS.

Get Started

To get started using the API, follow the below steps. 

Entra ID User Organizational Account for Access via Excel and/or Power BI 

Log in to Treasury Systems as a TS User with permission to edit users and grant permission 'Public API Access' to the TS User (forename.surename@customer.com in the picture below) who wants to access the API via Excel and/or Power BI. The API will now accept requests using the endpoints below. See  Use Excel or Power BI to access TS Report and Market data API.

Token for API Tools, Scripting, and/or Code/Customer Application Access

Set up an "Application" in your Identity Provider; see guideline Register an Application in Microsoft Entra ID to enable TS API Authentication when your organisation is using Entra ID.

Call the API to prompt the system to create a user; see Use Tools, Scripting or Integration Platforms to access TS Report and Market Data API.

Log in to Treasury Systems as a TS User with the permission to edit users and grant permission ('Public API Access') to the new API user. The API will now accept requests using the endpoints below. 

API Consumers

Excel or Power BI

Report Data Endpoints

The base URL for this endpoint is: https://ts.treasurysystems.com/tenants/[CUSTOMERNAME]/api/reportdata/ 

Endpoints 

/atdate/  

Description: This endpoint is the most basic of the report data endpoints. It will fetch and return a single dataset that’s been saved and created on the specified date. 

Parameters: 

param1 (string): This is the one and only parameter for this endpoint. It specifies the dataset at the date that you wish to fetch. The date is a date code, which is commonplace in Treasury Systems service. At the end of this documentation, we provide a list of the available date codes that are available. The parameter name is 'dateCode'.  

Example 

https://ts.treasurysystems.com/tenants/CUSTOMERNAME/api/reportdata/atdate/v2?dateCode=20241001

/realtime/  

Description: This endpoint returns a data set as it is now. That means Treasury Systems will run the on a System Report in real-time and return its data. If anything changes in the system and this is requested again the same day, you might receive differing datasets. 

Parameters: 

This endpoint has no parameters.  
 

Example:

https://ts.treasurysystems.com/tenants/CUSTOMERNAME/api/reportdata/realtime/v2

/daterange/  
 

Description: The endpoint works like the 'atdate' endpoint but has 2 parameters. It fetches every dataset between two date codes. It will be returned as a JSON collection.  

Parameters:  

param1 (string): The first parameter is 'fromDateCode'. The codes that this endpoint accepts are at the end of this document. This date code is the start in the date range. 

param2 (string): The second parameter is 'toDateCode'. The codes that this endpoint accepts are at the end of this document. This date code is the end of the date range. 

For example, with:  
{ 

    "param1": "20240301", 

    "param2": "20240401" 

} 

daily datasets from the 1st of March to the first of April will be returned. 

Example:

Market Data Endpoints

The base URL for this endpoint is: https://ts.treasurysystems.com/tenants/[CUSTOMERNAME]/api/marketdata/ 

Endpoints  

/fx/  
  
Description: This endpoint gets FX rates at the given date. It will return a JSON containing the Time the rate is valid, the base currency and the price currency, the periods that the rates are valid and lastly, the Bid rate, Ask Rate and FWD points. 

Parameters: 

param1 (string): This endpoint accepts one parameter, a string called 'dateCode'. It functions as the other date code parameters in this document. At the end of this documentation we provide a list of the date codes available. 

Example: