-
Expression for json-file
Hi,
I’ve never used a .json file in an expression before. This is the data, and I’ve downloaded the file to my computer and imported it to After Effects:
https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/owid-covid-data.jsonI want to make a list with all countries, and I want the list to change depending on the variable total_deaths_per_million for every date.
I realise my expression is far off. My first problem is that I can’t work out how I get the right variable. With the expression I’ve tried I get the error message “Couldn’t turn result into numeric value”.
First of all, is it even possible to create an expression that works like I want it to? Anyone have any good advices?
Kind regards
footage("owid-covid-data.json").sourceData;p1="AFG"[1].total_deaths_per_million;
p2="AFG"[2].total_deaths_per_million;exDepth = 360
min = 0;
max = 1000;startVal = ((p1 - min)/max)*exDepth;
endVal = (p2/max)*exDepth;z = ease(time, 1, 4, startVal, endVal);
x=640;
y=z;[x,y];
-
18 Replies
-
You want to make a list of countries…so what does this expression have to return ?
a textSource with countries ordered by total_deaths_per_million ? -
Yes, that is what I am trying to do. But I also want the countries to change order depending on the date.
-
This works, surprisingly well and fast given the huge dataset…
date = "2020-05-11";data = footage("owid-covid-data.json").sourceData;
countries = Object.keys(data);results=[];
for (c=0; c element.date === date).total_deaths_per_million;
} catch(e) {
tdpm=0;
}
results.push( [data[countries[c]]["location"], tdpm] );
}results.sort( (a,b) => b[1]-a[1] );
results.reduce( ( acc, cur ) => acc + cur[0]+"—"+cur[1]+"\r", ""); -
Sorry, problems with the <-symbol in the previous post…
date = "2020-05-11";data = footage("owid-covid-data.json").sourceData;
countries = Object.keys(data);results=[];
for (c=0; c<countries.length; c++) {
try{
tdpm= data[countries[c]]["data"].find( element => element.date === date).total_deaths_per_million;
} catch(e) {
tdpm=0;
}
results.push( [data[countries[c]]["location"], tdpm] );
}results.sort( (a,b) => b[1]-a[1] );
results.reduce( ( acc, cur ) => acc + cur[0]+"—"+cur[1]+"\r", "");
-
Tried it now, but I dont’t seem to get it correct (Sorry, I’m a total newbie when it comes to this).
I copied your expression into Expression: Source Text in an empty text layer. But I do not get any text out of it. So what am I doing wrong here?
-
Did you try the second post ?
Does the name of the Footage-file match yours ?
Is the Javascript Engine in Project Settings set to “Javascript”, not “Extendscript Legacy”
Are you getting an empty layer and no error, or an error ?
-
Yes, tried the second post, and the footage-file name is the same as yours. Also checked the Javascript engine at it was set to “Javascript”.
I get an empty layer and no error.
Really appreciate your help by the way!
-
Tried it again and now I got a list of text.
But on every row it says “undefined–0″…. -
Update! Now it seems to be working perfectly, I just had to reload the footage file.
Thank you very much for your help! Was worth alot!
-
Let me know how it turns out! Or if you need more help.
Reply to this Discussion! Login or Sign Up