You can translate the question and the replies:

Data Source creation using an api call

Hi I am a newbie and was wondering how to create a DS using an api call. I have a website whichas paramaters and when run it generates data in any format of choice and I want to use that as my datasource. I tried using json and csv datasources. I can create the sources but the data seems to be empty when queried through denodo but not when queried directly using a browser. The address is something like below http:/IP:9080/v2_0/Service/?start_period=date1&end_period=date2&format=csv I have used interpolation variables and have used http client as data route for my datasource (csv aswell as json) http:/IP:9080/v2_0/Service/?start_period=@{startdate}&end_period=@{enddate}&format=csv Any help will be appreciated. Thanks
API
user
26-02-2018 13:38:17 -0500

1 Answer

Hi, I'm able to create a JSON datasource and fetch data using GET method so a I couldn't reproduce your issue. I'd suggest you to take a look the documentation about the ["Path types in Virtual DataPort - 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) and the ["Execution Context of a Query and Interpolation Strings"](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/advanced_characteristics/execution_context_of_a_query_and_interpolation_strings/execution_context_of_a_query_and_interpolation_strings) to check if everything is configured properly. Take into account that dates usually causes issues in terms of format so require special attention when configuring these fields. Maybe you could enable the logs on your website to check that the request sent by Virtual DataPort is correct. Also, you could take a look to the [JSON](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/json_sources) and [Delimited files](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/delimited_file_sources) sources configuration. Hope this helps!
Denodo Team
28-02-2018 02:31:17 -0500
You must sign in to add an answer. If you do not have an account, you can register here