You can translate the question and the replies:

Generate Refresh Token for an API

Hello everyone I am new to Denodo and using free license version of Denodo Express 8.0. I need to Generate Refresh Token from API call. As much I know Denodo don't have Option to support multipart/form-data. I need to pass username and password from multipart/form-data. Is it possible in denodo. Any kind of help is appreciated. Thank You. I have provided some helpful links reguarding issue I am facing. https://drive.google.com/file/d/1icCdUmTxqYA_KCiSoY3_Zm-h8EXUb-aj/view?usp=sharing Image in above url is through Postman I am able to generate Refresh Token from form-data. https://drive.google.com/file/d/1AF_rRVc6AcyKi-PZkCXgoVyrv0FNT0Ij/view?usp=sharing Image in above url is JSON Body which I pass in Denodo through interpolation variable. https://drive.google.com/file/d/1EuMNbmSGbPnEUwVwVXTaj7iQj5qXQ7Me/view?usp=sharing Image in above url is Error I get in Denodo Web Design Studio when I test connection.
#API #Rest_API
user
24-03-2022 02:07:34 -0400
code

3 Answers

Hi, The error that you are receiving while testing the JSON connection from the Web Design Studio is due to the limitation of the Denodo Platform Express version. The sources with the Denodo Browser client cannot be used to retrieve data from CSV, JSON or XML files in the Denodo Express version. To know the limitation imposed on the Denodo Express, refer to the [Restrictions of Denodo Express](https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/appendix/limitations_of_the_denodo_express_license/limitations_of_the_denodo_express_license#restrictions-of-denodo-express) section of the Denodo Platform Installation Guide. If you would like to get a full featured trial license for Denodo, which would allow you to perform this operation in Denodo, please contact our Sales Team at sales@denodo.com or fill out the contact form at https://www.denodo.com/action/contact-us/. Hope this helps!
Denodo Team
24-03-2022 06:21:02 -0400
code
Hello Sir, I used Datasource as JSON and many times called API and created base views in denodo but never faced this issue. This is also JSON Datasource which I created to get Refresh Token from API. My question is just can we use multipart/form-datain Denodo? If yes how we can do it. Thanks
user
24-03-2022 11:12:29 -0400
Hi, I understand that you are using the HTTP Client as the Data Route method and it's supported in the Express version. Regarding the HTTP error 401, it occurs when the credentials provided for accessing the API is not correct. So, please check the authentication credentials provided are valid. Also, to get the access token from form-data, you could add the below header in the JSON data source configuration. `Content-Type: multipart/form-data` Check if this works for you. Hope this helps!
Denodo Team
29-03-2022 08:24:43 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here