How do I use a json file to animate a bar graph?

Maybe this question/answer is as easy as this:

To import the JSON file

Just import it to your project panel as any other footage. File - import.

To connect to the data

myData = footage("myJasonFile.json").sourceData;

Depending on the structure of your JSON file you can extract the data from the variable myData like this:

myData.City.Stockholm.Price;

or if it's an array, perhaps:

myData[2].Price;

Use a validator for your JSON file if you have problems getting the data. It might be a comma (,) at the wrong place. And be sure to use dots (.) for decimals and not commas (,)

Best wishes

Markus

Here is super useful tutorial from Lloyd about interacting with JSON files:

http://aescripts.com/learn/After-Effects-Scripting-JSON-Tutorial/‌

After you`ll import JSON file, I think you can use such construction to change your values:

var theComp = app.project.activeItem;
var DataBar01 = theComp.layer("Data Controls").effect("Data Bar01")("Slider"); // grab slider
var time =  1 // specify where you want to set graph value
var jsonBar01 =  jsonFile.bar01;    // parsed value from JSON 
DataBar01.setValueAtTime(time, jsonBar01);    // set keyframe

/*or apply several values at different time with*/

DataBar01.setValuesAtTimes(time, jsonBar01);    // where "time" is an array with your time and "jsonBar01" is an array with value