The Movie Database Support
Support → API Support
Possible to add IMDB cast link (eg nm1041023) to the API?
posted by SimonSTAFFMOD on August 22, 2013 at 7:49 PM
I see this field is available in an actor profile on TMDB, but it'd be really handy to have it as an available field in the API. Any chance of that happening?
Reply by Travis Bell
on August 23, 2013 at 9:42 AM
Hi Simon,
Did you take a look at the person responses on the API? It's already there.
For example…
Reply by Simon
on August 23, 2013 at 9:51 AM
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 :)
Reply by Simon
on August 23, 2013 at 9:54 AM
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 ;)
Reply by Simon
on August 24, 2013 at 12:09 AM
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 ;)