This option is only possible if your company uses Microsoft Entra ID.
The attached video shows an example of importing Report Data to Excel and Power BI via API version v2 part of TS version 25.1.
Please see How to access and use TS Report Data and Market API for more information on how to:
- Add the permission “Public API Access” to the user in the TS Application.
- Learn about different endpoints and their respective parameters.
Use Excel or Power BI - log in with your organization account
Open Excel and choose Data => From Web
For example, enter the following endpoint/URL:
https://ts.treasurysystems.com/tenants/[CUSTOMERNAME]/api/marketdata/ir/v1?dateCode=20240312
or
https://ts.treasurysystems.com/tenants/[CUSTOMERNAME]/api/reportdata/realtime/v1
Replace [CUSTOMERNAME] with your company name:
Click OK. When prompted, choose Organizational account to log in:
Unpack the API data (see Applied steps in the picture below and the attached video):
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article