SAP HANA REST API.

[Former Member]

Hi,I need to extract the metadata from SAP HANA Database using REST API.

I found this link : https://help.sap.com/doc/f32a797a5ec94d8ba4d7ed240d95bfae/2.0.01/en-US/tutorial-API___.html

Can you guys explain this link, i mean request parameters?

Thank you,

[thomas_jung]

A word of caution about using this REST API. It is implemented in XSC and reliant upon the HANA Repository - both things which are obsolete and will be removed in the future. XSA and HDI do not support this REST API. So before developing something new using this REST API, note the limited future it might have.

[Former Member]

Thanks Thomas,

Actually, i am using SAP HANA Studio is installed in Windows and HANA Database is installed in Linux.

My question's are,

1) Can i use this REST API's (https://help.sap.com/http.svc/rc/f32a797a5ec94d8ba4d7ed240d95bfae/2.0.01/en-US/tutorial-API___.html) for extract the metadata from HANA Database?

2)If not, how can i extract the metadata?I can see the metadata in SAP HANA Studio.

Please help me,

[thomas_jung]

Yes this REST API exposes some metadata but with the warning I gave above.

[zack_morris]

@thomas.jung, is there no plan for a REST API in XSA or the future? Is there opportunity for similar functionality in a different manner?

[thomas_jung]

These REST APIs aren't just general HANA but largely expose functionality of the HANA Repository and enabled the development tools. But there is no HANA Repository any longer. That's handled by Git. And the developer tools are now separate from HANA (Web IDE for SAP HANA and Business Application Studio). Therefore most of the scope of what this REST API covered doesn't really come from HANA any longer.

[architectSAP]

Please check the Using the SAP HANA REST API documentation.

Best regards

Frank

[Former Member]

I find some code in Metadata API.

Which code it is ?

var strPayloadFromJava = "{}";
var strHeaderServiceName = "checkMetadataExistence";
var strSapBackPack = strPayloadFromJava;
var strAccessPath = cMetaDataAccessP + '/VIEW/RT/TABLES';  
var request = new $.net.http.Request($.net.http.GET, strAccessPath);  
request.headers.set('SapBackPack', strSapBackPack); 
request.headers.set('Service-Name', strHeaderServiceName);         
var response = client.request(request, destination).getResponse();