Changing images/video using a Json file

How do you have the images referenced?

You might have the filenames similar to a field in the JSON, e.g. a student ID code which can match the filename.
In that case you can write a simple expression that will display the correct footage.

You can do this by just loading all 450 images in the project and then adding an if-statement on the Opacity Property of each image layer in the comp.

Here is an example:

StudentImageSelection_20201102.zip 

------

If the image is referenced by an URL or if the image has to be retrieved in some way or another, you can make another type of script that will pre-flight your project by creating a copy of the project, downloading the images and placing the project with the specific data in a seperate folder to be rendered or send it directly of to a render system.

The suggested AEScripts Templater is a great place to start if you do not want to write your own code or above example doesn't do the trick for you.

Hi Darren,

I'll have to second the recommendation from Code One Films about Templater from Dataclay.  You can acheive what you want very quickly allowing you to focus on your creativity in After Effects while maintaining the data in a live connection with a Google Sheet.  JSON files can be cumbersome to maintain,  update, and edit.

Hope this helps!

Hey @darrenM17680356, take a look at Templator, a plugin that does this automatically for you: https://aescripts.com/templater/

There are different versions at different price points available dependant on your needs. It can read text & media sources (photo, video etc) from a link on a google sheet. Or a link in a JSON I suppose.