Report with Json DataSource return node field

[ricardo.a.blanco]

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.

[narcism]

What does your JSON data look like?

[ricardo.a.blanco]

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"
  }
]

[narcism]

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.'

[ricardo.a.blanco]

That's it!

Thank you very much :)