This is the first in a series of articles about the SAP Datasphere API and what you can do with it. I will start by explaining how to configure the OAuth and start with the first request using Postman. Postman is a tool for creating requests to web services. 

So let's dive into it. If you want to consume the SAP Datasphere API, you need to find the right endpoints. A good place to start is api.sap.com. But how can we test and see if the request is correct? If we get the right result?

In this post, I will go through the configuration of Postman that allows you to send requests and also receive data from those requests. To do this, we use OAuth technology. I won't explain what OAuth is. If you are interested, take a look at Wikipedia. 

First, we need an OAuth connection. To create an OAuth connection, go to your SAP Datasphere tenant and select System >> Administration >> APP Integration. There you will find the authorization and token URL that you will need to create a token later.

Now we need to create a client so we have a client id and a secret id. Click Create New OAuth Client.

Define a name, the purpose, a redirect URL (in this case http://localhost:8080), and as of release 2024.8 you can also define some details about the token. After clicking add, the new OAuth client is created. Now we need the secret and the client id for authorization. Copy the OAuth client ID and secret for later use. 

Now we have everything we need to access the API. Let's switch to Postman, you can use it either on the web or via the downloaded program. Visit https://www.postman.com for more information.

Go to the Authorization tab, select the OAuth 2.0 type, and select Request Headers for the "Add the authorization information to" section. Now we need to add the token information.  

• Use token type: Access Token
• Header Prefix: Bearer
• Auto-refresh token: True
• Grant type: Authorization Code
• Callback URL: http://localhost:8080
• Auth URL: Auth URL from the Datasphere tenant (e.g. https://xyz.authentication.eu10.hana.ondemand.com/oauth/authorize)
• Access Token URL: Token URL from the tenant (e.g. https://xyz.authentication.eu10.hana.ondemand.com/oauth/token)
• Client ID: Client ID from the OAuth we created earlier
• Client secret: Client Secret we get earlier from the OAuth.
• Client authentication: Send as Basic Auth header

Click "Get New Access Token" to create a new token. This will take you to your SAP Datasphere login page, where you will need to log in for the first time. You will receive the token and can use it. 

Now we are ready to kick against the Datasphere API and get some results. To give you a first look at the API, we use the following URL https://xyz.eu10.hcs.cloud.sap/api/v1/dwc/catalog/spaces to get a result of all the spaces. As you can see in the screenshot below, the http status is 200. This means that the request was successful.

The next post will go deeper into the API endpoints and some use cases.

This is the first of a series of posts about the SAP Datasphere API. I hope you now understand the basics and how to check if your requests return data or if something went wrong. There is also an old post in the SAP community about Postman configuration. But as far as I know, sometimes SAP deletes all the old stuff, and you cannot find it anymore. So feel free to use the comments and give me some ideas what I should show with the API in the next posts.

• In my newsletter, you get informed about new topics
• You learn how to use Analysis Office
• You get tips and tricks about SAP BI topics
• You get the first 3 chapters of my e-book Analysis Office - The Comprehensive Guide for free