How to create datastore for REST webservice using OAuth 2.0 in SAP BODS.

[bittu_sharma]

Dear All,

Needed Help...

I am trying to create a datastore in SAP BODS using authorization schema as OAuth 2.0. for webservice type REST.

I have client ID, client secret, endpoint URL, what are the field's will be required as mandatory to connect successfully.

Kindly suggest stepwise process to do so.

Thanks in Advance!!!

Regards,

Bittu

[jmuiruri]

Greetings bittu_sharma ,

Please read the documentation

Connection options for OAuth 2.0 (2-legged) authorization schema

BR,

Joe

[bittu_sharma]

Hi Joseph,

I have gone through this document .

even after adding required details like client id, client secret, access URL, webservice URL i am getting same error every time-

screenshot-2023-12-18-114311.png

whereas same credentials are working in POSTMAN tool with the POST method but not in BODS.

Does BODS support OAuth 2.0 or not ?

Regards,

Bittu

[jmuiruri]

@ bittu_sharma ,

I hope you are providing the URL to the Web Application Description File (WADL) when asked to provide the Web Service URL?

BR,

Joe

[bittu_sharma]

Hi Joseph,

No, Webservice provider can not provide WADL file.

They only provided client id, client secret and endpoint URL, access token URL.

WADL file is mandatory to stablish connection via OAuth 2.0 in SAP BODS ?.

Regards,

Karishma

[jmuiruri]

Hi bittu_sharma ,

The provider will not provide you with a WADL. You have to create it yourself.

• Working With REST Services and WADL
• https://www.w3.org/submissions/wadl/
• https://en.wikipedia.org/wiki/Web_Application_Description_Language
• https://blogs.sap.com/2016/06/07/consuming-rest-web-service-in-sap-data-services-using-web-service-r...

And yes it is mandatory as it describes the format of the data you are reading from the source.

The error message you are facing is not because of authentication, but because data services could not parse the structure of the REST API Metadata.

Br,

Joe