You can translate the question and the replies:

JSON-stat Data Sources

Hi everyone, I need to import a Data Source which is in JSON-stat format (https://json-stat.org/), which basically represents multidimensional arrays of data in a flattened fashion. I wanted to ask you if there is a predefined Denodo routine to import such data, if not do you have any suggestion on how to handle this problem? Thank you, any help is much appreciated!
json source JSON Data Source JSON Json json
user
08-06-2021 03:14:17 -0400
code

1 Answer

Hi, I was able to connect to the JSON-stat format datasource by following the similar steps mentioned in the document [JSON Sources](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources#json-sources). Also, if you would like to flatten the array in virtual layer then you can flatten them using the [flatten operation](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queries_select_statement/from_clause/flatten_view_flattening_data_structures) available in Denodo For more information, you can refer to the [JSON Sources](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources#json-sources) and [Path Types in Virtual DataPort](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#path-types-in-virtual-dataport) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
09-06-2021 21:03:56 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here