You can translate the question and the replies:

JSON Datasource Tuple Root Rows

Hello, I'm trying to create a JSONDatasource from this sample: ``` [ { "Header": { "publishedDateTime": "20211110150141", "messageId": null, "messageType": null, }, "Investment": { "investmentUid": "0e06633d-6e2c-43ca-9394-00feef74e7d2", "investmentId": "H723", "investmentName": "H723- project" }, "Links": [ { "Title": "Link1", "Content": "Link1" }, { "Title": "Link2", "Content": "Link2" } ] }, { "Header": { "publishedDateTime": "20211110150141", "messageId": null, "messageType": null, }, "Investment": { "investmentUid": "3222341-6e2c-43ca-9394-00feef74e7d2", "investmentId": "G33", "investmentName": "G33- project" }, "Links": [ { "Title": "Link1", "Content": "Link1" }, { "Title": "Link2", "Content": "Link2" } ] } ] ``` For the requirement, i should manage to get the list of "Investments" on the creation of the base view. Currently when i try the tuple root as: `/JSONFile/JSONArray/Investment` It creates null rows. Can you enlighten us how does this tuple root works and why does it creates null rows. Thanks
user
10-11-2021 08:42:02 -0500
code

1 Answer

Hi, This is a known issue and will be fixed in a future update of the Denodo Platform. As a workaround, I would leave /JSONFile/JSONArray as the Tuple Root and create a selection view to project the subfields of “Investment”. If you have a valid support account, you can open a case so that whenever the update is released you will be notified as soon as it is available for download. Hope this helps!
Denodo Team
10-11-2021 15:14:19 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here