You can translate the question and the replies:

Rest API - Unable to obtain the data structure

Here is the sample ReST API . I can access this API thru Postman or the Browser https://api.example.com/client-api/v2/suppliers?apikey=12345abcede When I built this API using the JSON Test connection was working fine but when I try to create base view its throwing an error Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected error accessing the server Any thoughts or help is highly appreciated
user
18-11-2017 15:09:59 -0500

3 Answers

Hi, This error could have occurred when you try to create a base view over a json datasource using POST method which does not have an output schema. I would use the 'GET' method in the JSON datasource and create a base view over it to retrieve the data from the REST web service. When using 'POST' method if there is no output schema available for the REST web service then you could not create a base view over it. For more information on Post method, you could refer the Community answer [Cannot create base view on JSON data source](https://community.denodo.com/answers/question/details?questionId=90670000000fyo8AAA&title=Cannot+create+base+view+on+JSON+data+source) as it is similar to your scenario. Hope this helps you!
Denodo Team
20-11-2017 07:06:53 -0500
Actually my Method is GET . I am able to work thu Postman . But we need to know why its not working with denodo
user
20-11-2017 13:06:13 -0500
Hi, I tried to access a REST API through GET method and it worked fine for me. The error could have occurred when the Virtual DataPort Server could not access the REST API. When accessing a REST API, I would ensure that proper authentication method is chosen so that the Virtual DataPort server could recognize API and connect to the server. For more information on the error, you could check the VDP.log file located in <Denodo-Home>/logs/vdp. Refer the section [HTTP](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/path_types_in_virtual_dataport#http) of the Virtual DataPort Administration Guide for more information on supported authentication methods in Denodo Platform. Hope this helps you!
Denodo Team
28-11-2017 06:22:01 -0500
You must sign in to add an answer. If you do not have an account, you can register here