Export SAP DATASPHERE Catalog

[DKK]

Hi and thank you in advance for your help.

Is it possible , for example , to extract all the KPI's defined on the SAP Datasphere catalog ?

From a quick check , 

from this url , i can get all the KPI's defined 

https://{SAP_DSP_TENANT}/deepsea/catalog/v1/search/search/$all?%24top=30&%24skip=0&whyfound=true&%24...

and then if i extract the ID , using the below ,  i can get the information needed.

https://{SAP_DSP_TENANT}/deepsea/catalog/v1/kpi/{KPI_ID}

Is there any documentation regarding this topic? or any other way?

Thank you

[TuncayKaraca]

Hi @DKK,

Just curiosity I've noticed your OData URL's are like https://{SAP_DSP_TENANT}/deepsea/catalog/v1/ What is deepsea? SAP Datasphere Catalog API Reference has different endpoints.  Do you use a different Datasphere's different OData API? 

Thanks,
Tuncay

[PMathieu]

Hi, I am very interested by you point, because I try also to find a solution to retreive my terms, KPI and generated a documentation

[DKK]

Hi @PMathieu , let me try to provide an example with more details.

As i mentioned, enter the below url on your browser,

https:/xxxx/deepsea/catalog/v1/search/search/$all?%24top=30&%24skip=0&whyfound=true&%24count=true&%24apply=filter(Search.search(query%3D%27SCOPE%3AcomsapcatalogsearchprivateSearchKPIsAdmin%20*%27)) , where xxxx is our DSP tenant , for example , our DSP is https://xxxxxx.eu10.hcs.cloud.sap/deepsea/catalog/v1/search/search/$all?%24top=30&%24skip=0&whyfound....

Result :

 So, if we take the highlighted ID , (id  = 1E625C317634F17C1800888E75824F14) and add it to the next URL,

https://xxxx.eu10.hcs.cloud.sap/deepsea/catalog/v1/kpi/1E625C317634F17C1800888E75824F14 ,we get the following result : 

Ending, this is the "Profit Margin" , from SAP DSP Catalog / KPI : 

The KPI is "Profit Margin" and the definition " ....." is like the export of the API.

(IF you want to execute it from postman or other application, is getting a little bit more complex, since you will have to work for the authentication part)

Thanks