You can translate the question and the replies:

How to connect to a csv file placed in an HTTPpath?

Hi Team, I need to connect to a csv file placed in https path . Every day this path will get updated with a new csv file to which denodo needs to be connected and extraced the data. I tried to create using 'Delimited file' but the data doesnt show up accurately Thanks
user
18-05-2020 07:32:29 -0400

1 Answer

Hi, To pass the CSV file name at dynamic, I would create the [Delimited File data source](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#paths-using-date-ranges) and provide the URL with *interpolation variable* (@) to parameterize its path at runtime. For instance, if I need to access a CSV file, then I would use the Data route as below, > https://host/folder/@{file_name}.csv For more information on passing interpolation variables, you could refer to the [Paths and Other Values with Interpolation Variables](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables) section of the Virtual DataPort Administration Guide. If I have the file name based on the date-based naming convention, then I could use the DateRange interpolation function to read the files between a given start date and a given end date. For example, you could use the below path to access the files with date-based naming convention, > https://host/folder/^DateRange('yyyy/MM/dd',@startdate,@enddate,'yyyyMMdd') To know more about the DateRange function, you could refer to the [Paths Using Date Ranges](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#paths-using-date-ranges) section of Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
19-05-2020 04:38:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here