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!
user
08-06-2021 03:14:17 -0400

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
You must sign in to add an answer. If you do not have an account, you can register here