One requirement is to Export the content of SAC Currency Table and view it in a Story. Today, There is no option to export the content of Currency Table either as csv file or view the contents of the Currency Table in a Story or Dashboard.
In this blog, I will introduce you a way to achieve this by leveraging the Data Export Service and OData Import Connection without external tool or platform.
Prerequisite:
Your SAC tenant is a Cloud Foundry Tenant deployed either in AWS, Azure, Ali Cloud or Google Cloud.
Setup OAuth Client
Please follow the exact step 1, 2, 3 and 4 of Amanda’s blog on how to configure the OAuth Client in your SAC tenant.
Create an OData Connection
Create an OData connection on the source tenant (SAME tenant pointing to itself).
**Note that a new connection is required for each currency table as every connection is specific to a currency table on the source system.
Refer to the steps outlined in Amanda’s Blog for creation of a new Odata Connection, which will be used later to create a Model and setup the import Job for the Model to load the Currency Data from the Currency Table.
I will be outlining the steps below to generate the ‘Data Service URL’ which will be used during the creation of Odata connection.
Step 1: Use the endpoint to derive the ‘Data Service URL’ for the currency Table using the GET request type.
You will require the NamespaceID and ProviderID to call the endpoint.
NamespaceID: It is ‘sac_currency_tables’ for the Currency Table. You can also find Namespace ID using the GET request on the below API endpoint.
Sample:
https://your-sac-tenant-url.cloud/api/v1/dataexport/administration/Namespaces
** use the above endpoint link and replace it with your SAC Tenant.
ProviderID: It is the technical name of the currency table. You can also find ProviderID using the GET request on the below API endpoint.
** use the above endpoint link and replace it with your SAC Tenant.
Above request will list down all the Currency Table available for your tenant. As highlighted below, copy the ‘ServiceURL’ for the relevant currency table you want to view the data.
Step 2: Paste the Service URL in the ‘Data Service URL’.
Step 3: Enter the remaining required parameters such as
- Set Authentication Type to OAuth 2.0 Client Credentials.
- The OAuth Client ID from Section A OAuth Client Setup
- The Secret from Section A OAuth Client Setup
- The Token URL from Section A OAuth Client Setup
Refer to Amanda Blog on the same for step step by details.
Setup the Model
Once the Connection is created, Next Step is to
- Setup a New Model to load the currency table data.
- Setup an Import Job based on the above connection to load the data.
Follow the steps provided in William Blog to achieve the above steps.
Summary
- This approach can be handy when the end user wants to see the currency rates-maintained in the table directly in a Story or a Dashboard without navigating to the currency table, which can also lead to user changing the rates by mistake.
Bluesky
