Leverage Data Export Service to View Currency Table Data

[shivampurwar]

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. 

https://your-sac-tenant-url.cloud/api/v1/dataexport/administration/Namespaces(NamespaceID=' sac_curr... 

** 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.

API Response

Step 2: Paste the Service URL in the ‘Data Service URL’.

Odata Connection Setup Screen

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

1. Setup a New Model to load the currency table data.
2. 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.

Sample Model

Sample Story

Summary

1. 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.