Test the Dataset service

In order to ease the readability of this tutorial, the C4PAURL token was used
to replace the predictive services Application URL displayed on the overview page.

Therefore you can replace any occurrence of the token by your value listed.

The Application URL should look like this (where XYZ is your SAP Cloud Platform account name):

https://aac4paservicesXYZ.hanatrial.ondemand.com/com.sap.aa.c4pa.services

If you are unclear with what is your SAP Cloud Platform account name, you can refer to the following blog entry: SAP Cloud Platform login, user name, account id, name or display name: you are lost? Not anymore!

In order to use any of the SAP Predictive services, you will need a registered dataset.

When registering a dataset, you will define and store the structure of the dataset which will be used by the other services.

You uploaded 3 datasets in one of the previous steps, but here you will be using the CashFlow dataset as an example.

You can replicate the steps for the other 2 datasets.

This service:

• Analyze the database object DDL to return you the name and the data type of each columns
• Analyze a few hundreds rows to determine the value type of the column (continuous, nominal or ordinal)
• Get the number of rows and columns

Once registered, you will be able to use the dataset ID to call the other services.

Open a new tab in Postman.

If you don’t have Postman installed yet, you can refer to the following how-to guide: Install Postman extension for Google Chrome as a REST client

Fill in the following information:

Select the Authorization tab and fill in the following information:

Note:
Your SAP Cloud Platform Account login is usually the email address used to register your SAP Cloud Platform account.

Select the Body tab.

Enable the raw mode.

Pick JSON (application/json) in the drop down (instead of Text).

Select the Body tab, enable the raw mode and select JSON (application/json) in the drop down, then add the following content:

{
  "location": {
    "schema" : "PSDEMO",
    "table" : "CashFlow"
  }
}

Click on Send

It will now display the data set registration identifier, the number of rows and the variable descriptions.

Now, you can use the ID value to reference the registered dataset with other SAP Predictive services calls.

Click on Send an additional 2 or 3 times, so you will have multiple dataset registered to play with.

Provide an answer to the question below then click on Validate.

Open a new tab in Postman.

Fill in the following information:

Make sure you replace the ID token in the URL with the one returned by the dataset ID return in the previous service call.

Select the Authorization tab and fill in the same details as in the previous call.

Click on Send

You should receive the same description as from the previous call.

If you try with an unknown ID, you should receive a 404 response.

Open a new tab in Postman.

Fill in the following information

Make sure you replace the ID token in the URL with the one returned by the dataset ID return in the first service call.

Select the Authorization tab and fill in the same details as in the previous call.

Click on Send.

You should receive the description of the first variable from your data set.

Provide an answer to the question below then click on Validate.

Note:
This service is available since version 1.7, please make sure you have upgraded the C4PA application, else you will receive a 404 error.

To check which version you are currently using, please go to the following URL and check the X-Maven-Project-Version property:
- C4PAURL/adminUI/index.html#/about

By default, the variable storage and value type (nominal, continuous, ordinal) properties returned by the registration service are guessed from the data, which may sometime be inaccurate.

For example, with variable 4 (MondayMonthInd), it is guessed as a continuous integer, but should rather be an ordinal integer.

Let’s see how you can fix that.

Open a new tab in Postman.

Fill in the following information:

Make sure you replace the ID token in the URL with the one returned by the dataset ID return in the first service call.

Select the Authorization tab and fill in the same details as in the previous call.

Select the Body tab, enable the raw mode and select JSON (application/json) in the drop down, then add the following entries:

[
    {
     "name": "MondayMonthInd",
     "value": "ordinal"
    }
]

Open a new tab in Postman.

Fill in the following information:

Make sure you replace the ID token in the URL with the one returned by the dataset ID return in the first service call.

Select the Authorization tab and fill in the same details as in the previous call.

Click on Send.

You have now deleted the second data set you have registered.

You can try to retrieve the registration details as in step 2 for dataset 2, and you should receive an error message.

Open a new tab in Postman.

Fill in the following information:

Select the Authorization tab and fill in the same details as in the previous call.

Click on Send.

You have now listed all the data set registered in your environment.