Report with Json DataSource return node field

Posted on August 28, 2019 at 12:20am

Hello,

I have created a report that gets the data from a json file. When I add it through "Dataset and Query Dialog" tool it returns only one field called node that is empty.

Any idea why?

 

 

 

 

 

 

 

 

 

 

 

 

 

Thank you very much in advance.

Jaspersoft® Studio
ricardo.a.blanco's picture
ricardo.a.blanco
59
Joined: Jul 30 2019 - 3:06am
Last seen: 4 days 7 hours ago

What does your JSON data look like?

narcism - 4 years 1 month ago

This is the example of json file that I am passing:

[
    {
    "slccReponseBesoins": "44332",
    "slccFrequence": "lundi/13h/j",
    "slccNomDuReferent": "nom_10119 prenom_10119(Masseur-Kinésithérapeute)",
    "slccPhone": "tel_10119",
    "slccEmail": "",
    "Author": "Et_Gestionnairedecas ET_GESTIONNAIREDECAS",
    "IDNUMBER_9LV7R": "000000212588"
  },
    {
    "slccReponseBesoins": "33114",
    "slccFrequence": "mardi/18h/s",
    "slccNomDuReferent": "nom_10119 prenom_10119(Masseur-Kinésithérapeute)",
    "slccPhone": "tel_10119",
    "slccEmail": "",
    "Author": "Et_Gestionnairedecas ET_GESTIONNAIREDECAS",
    "IDNUMBER_9LV7R": "000000212588"
  }
]

ricardo.a.blanco - 4 years 1 month ago
add comment

2 Answers:

Posted on August 28, 2019 at 10:38am

You have entered a json query(slccReponseBesoins) in the text area below the 'Read Fields' button. You need to clear it up and press 'Read Fields' again.'

narcism's picture
narcism
6502
Joined: Nov 22 2010 - 12:39am
Last seen: 6 hours 33 min ago
Posted on August 28, 2019 at 11:24pm

That's it!

Thank you very much :)

ricardo.a.blanco's picture
ricardo.a.blanco
59
Joined: Jul 30 2019 - 3:06am
Last seen: 4 days 7 hours ago
Feedback