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

• The Report Data API will fetch a snapshot of a system report 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 the article Set up of Autopilot "Update Transaction API Data" Activity  
• The Market Data API returns data as it is displayed in TS.

Get Started

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

Entra ID User Organisational 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 the 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 will fetch and return a dataset that’s been saved and created on the specified date; please see the System Report. 

Parameters: 

param1 (string): 'date' in v3 and 'dateCode' in v2. Specifies the date that you wish to fetch a dataset. The date is a date code, which is commonplace in Treasury Systems service. At the end of this documentation, there is a list of the available date codes.

Example v3

https://ts.treasurysystems.com/tenants/CUSTOMERNAME/api/reportdata/atdate/v3?date=20241001

Example v2

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

/realtime/  

Description: This endpoint returns a dataset as it is now. That means Treasury Systems will run the 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 v3 (same as v2)
https://ts.treasurysystems.com/tenants/CUSTOMERNAME/api/reportdata/realtime/v3

/daterange/  
 

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

Parameters:  

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

param2 (string): 'toDate' in v3 and 'toDateCode' in v2. 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, daily datasets from the 1st of March to the 1st of April will be returned with:  
{ 

    "param1": "20240301", 

    "param2": "20240401" 

} 

Example v3:

Example v2:

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 for a given date. It will return a JSON containing the time the rate is valid, the base currency and the price currency, the mid, bid, ask rates, and the period(s) the rates are valid. YTD and MTD rates are included for the SPOT period. This endpoint accepts three parameters.

Parameters v3 (Only one parameter 'dateCode' in v2): 

param1 (string): 'date' in v3 and 'dateCode' in v2. It functions as the other date code parameters in this document. At the end of this documentation, there is a list of the available date codes. 

param2 (string): 'currency'. It specifies the against currency, please see the FX rates - Overview article.

param3 (string): 'periods'. You can optionally specify one or more periods. The default period is "SPOT". Available periods are ALL, SPOT, 1W, 2W, 3W, 1M, 2M, 3M, 4M, 5M, 6M, 7M, 8M, 9M, 10M, 11M, 1Y, 2Y, 3Y. A semicolon separates two or more periods (SPOT;3M;6M, etc). Period "ALL" returns all periods.

Examples v3:

Example v2: