json file in timeline does not work properly

[elisa.df]

I added a Json file in a composition and opened the properties, I can see my list of values, some of them are correct but most report the value  32768 (I don't know why, I don't have this value in my file)

If instead I write an expression to acces datas

I get the right values for each property.

(I used the expression

(eval("var report="+footage("fatturato.json").sourceText);

fat=report[0].marzo)... and it works fine)

I'd like to use them in timeline with the pick whip anyway, it would be easier and faster... Is there e way to solve this problem?

[Mylenium]

Impossible to know without seeing the actual JSON code. You could simply have unused data in there somewhere or comments that throw things off.

Mylenium

[elisa.df]

Thank you Mylenium,

it is a very simple file that I created from an xls.

I copy and paste the text:

[

  {

    "azienda": "videotv",

    "anno": 2016,

    "gennaio": 81303,

    "febbraio": 22400,

    "marzo": 92500,

    "aprile": 41300,

    "maggio": 23500,

    "giugno": 54300,

    "luglio": 47800,

    "agosto": 25880,

    "settembre": 44550,

    "ottobre": 74668,

    "novembre": 45200,

    "dicembre": 45650

  },

  {

    "azienda": "videotv",

    "anno": 2017,

    "gennaio": 43800,

    "febbraio": 45600,

    "marzo": 47500,

    "aprile": 90888,

    "maggio": 44300,

    "giugno": 47000,

    "luglio": 62500,

    "agosto": 53800,

    "settembre": 17800,

    "ottobre": 75820,

    "novembre": 78152,

    "dicembre": 98211

  }

]

[Mylenium]

This won't work. Your JSON isn't structured hierarchically. It's just a flat list and naturally it can only be addressed directly as an array. The months need to be in a separate sub-tree, and the year and subject be the parent categories. You might want to read up on how JSON actually works. In your list of course you will get errors, because the string in the first entry and possibly also the completely different value in the year entry throw things off. You need to reformat like this:

{

    "azienda": "videotv"

     {

    "anno": 2017

          {

         "gennaio": 43800,

         "febbraio": 45600,

         "marzo": 47500,

         "aprile": 90888,

          }

      }

  }

Mylenium

[mauriziol45037531 · Accepted solution]

Thank you Mylenium,

I've just discovered that the problem was not the structure but the values too high.

Json seems to have a maximum value of 32768, which is why this number was repeated in my chart to replace all the higher values.

I lowered the values using 3-digit values and now everything works perfectly. Hope this information will help!