Hi Simon,

Did you take a look at the person responses on the API? It's already there.

http://api.themoviedb.org/3/person/287?api_key=###

For example…

Ah, so it is!

I missed it as I'm actually using the 2.1 API at the moment as I'm building a little tool for myself in VBA (like you do :D) and whilst I know how to manipulate XML, I'm not sure at all how to parse JSON in VBA (not sure if anyone can point me in the right direction there?). I realise I only have 3 weeks or so until 2.1 is retired, so at that point I'll have to work out how to use the JSON feed anyway, but not 100% sure where to start if I'm honest :)

And as soon as I typed that I found this: http://www.ediy.co.nz/vbjson-json-parser-library-in-vb6-xidc55680.html

I'll have a play ;)

Ok just a quick question if that's OK.

I've got most of it working, but I'm a little stuck on how to handle null values (eg, if a movie has no youtube trailer). The JSON still lists it (as "trailers":{"quicktime":[],"youtube":[]}}), I'm not sure on the VBA syntax to get it to check if that value is null or not.

The furthest I've gotten so far is:

If IsNull(js.Item("trailers").Item("youtube")) Then

but that doesn't show as null as I guess there's data ([]). I tried some sort of LEN to check the length, but it doesn't like that at all :)

Sorry for the noob questions, but I'm learning a lot ;)