Read data from Database within After Effect

[cheriw2889394]

Hello 

What I want to do is, read data "some words" dynamically from a database using MySQL and display it on screen. I want to know if this is possible in Adobe After Effects? And how do I connect if possible? Do I have to write a script where it can be written?

Thank you

[Arie Stavchansky]

It's definitely possible.  You would need to use Sockets to communicate via ExtendScript.  You can also use something like Templater from Dataclay to easily handle this, but you would need to create a small server that you point Templater to rather than a direct connection to the database.  See this support article for more information on how Templater communicates to an endpoint exposed by an API that you implement.

[Justin T - Hyper Brew]

You can build your own system with sockets as outlined in the docs

or even easier someone built a fairly simple to use library for making HTTP requests in ExtendScript.

Example Usage:

var data = $http({
method: 'GET',
url: 'http://example.com/data.json',
headers: {'Accept': 'application/json','Content-Type': 'application/json'}
});
alert(data.payload);

Unfortunately HTTPS is not supported FYI. If you need it, you may want to make a CEP panel instead.