Treasury Systems Report Data and Market API

This API provides endpoints for users or other data-centers to access a certain set of data that derives from a Treasury Systems report (a specific Balance report). This API will fetch a snapshot of how that specified report looked on a given day. The snapshot is taken daily at 21:00 (CET) and the Report is managed and edited in Treasury Systems. 

Get Started 

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

Sign Up 

A user within Treasury Systems, with the permissions to edit and create new users, must setup a new user in Roles & Permissions view. Once the new API-user is created, this user must be assigned with the permission 'Public API Access'. When creating the user, the user needs to have the same Name in Treasury Systems as the user ID used requesting from the API. 
 
Example: If the request authentication has the user ID [email protected], the same Name needs to be defined in Treasury Systems. 

There is a second way to create an account, and that is to call the API before creating the user, prompting the system to create a user. A Treasury Systems user with the proper permissions must then login to Treasury Systems and grant permission to the new API-user ('Public API Access') before the API will accept any requests. 

Examples for Python with Office 365 SSO

Download the attched file reportdata.ipynb

Import to your jupyter notebook update url with your customer name (domain)

Authentication 

This API uses JWT bearer tokens as it’s authentication. As explained previously, the token needs to match the Name in Treasury Systems to grant access to any requests. 

There are two different ways to authenticate to the API

1. As your self, used when connecting excel to the API, please see Use Excel for TS Report and Marketdata API
2. Use JWT bearer tokens. This method works well with tools such as Integration Platforms (such as Logic Apps) or scripting (PowerShell, cURL, postman). Please see TS Report & Marketdata API Authentication. 

Report Data API URL 

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

Endpoints 

/atdate/ 
 
Description: This endpoint is the most basic one 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. This parameter specifies the dataset at the date that you wish to fetch. The date is a date code, which are commonplace in Treasury Systems environment. At the end of this documentation we provide a list of the date codes available. The parameter name is 'dateCode'.  

Example

/realtime/ 
 
Description: This endpoint returns a data set as it is now. That means that Treasury Systems will run the specified report at real time and return its data. If anything is changed in the system and this is requested again in the same day, you might receive differing datasets. 

Parameters: 

This endpoint has no parameters. 
 

Example

/daterange/ 
 

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

Parameters:  

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

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

Example: 
 
{ 

    "param1": "20240301", 

    "param2": "20240401" 

} 

This will return datasets from the 1st of march to the first of April. 

Example

Market Data API URL 

The base URL for this endpoint is: https:// [COMPANY].treasurysystems.com/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 at, the base currency and the price currency,  the periods that the rates are valid at and lastly the Bid rate, Ask Rate and FWD points. 

Parameters: 

param1 (string): This endpoint accepts one parameter. It’s 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