You can translate the question and the replies:

Can JSON Data source do join operation?

I have a JSON data source from RESTful API and create a view. I want do join operation and can't select the join conditions. Cause in JSON View, it's Object type not the same type as normal table view. JSON view: { "name" : "test", "elements" : [{"c1" : "test1", "c2":"test2", "c3" : "test3"}], "link":"/view/test" } normal table view: c1 c2 c3 test1 test2 test3 And I try to set the jsonroot in order to read the elements data only, but failed.
user
18-09-2019 03:19:57 -0400

1 Answer

Hi, For your scenario, you could use the **tuple root** option when you create the base view for your JSON data source, which will allow you to access a specific portion of your JSON document. For example, if you want to access the "**elements**" portion of our JSON document, then you could uncheck JSON root checkbox in the "**Configure JSON Wrapper**" dialog and use a JSON tuple root like: * ** /JSONFile/elements** Once after creating the base view with a required structure for the JSON document, you could create a derived view on top of it in order to perform [**Join**](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views#creating-join-views) operation. You can refer to the section [**JSON Sources**](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
20-09-2019 06:57:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here