Right, so I'm querying names, and everything has been working fine until today. Basically, I'm trying to get the ID of Chloë Grace Moretz.
Now, if you search for Chloe Grace Moretz it returns zero results ({"page":1,"results":[],"total_pages":0,"total_results":0}). Presumably because it absolutely definitely wants the ë in her name, or else.
However, if I then search for Chloë Grace Moretz, I simply get {"status_code":6,"status_message":"Invalid id - The pre-requisite id is invalid or not found"}".
I assume it doesn't like the Umlaut.
Now perhaps it's the way I've coded it (I'm having to use VBA for various reasons so that comes with it's own challenges), but it does work fine for every other name (and movie), just not names with an umlaut.
For the record, I'm using the following function to simply open the URL to get at the JSON response:
Public Function GetWebSource(ByRef URL As String) As String 'Opens URL's
Dim xml As IXMLHTTPRequest
On Error Resume Next
Set xml = CreateObject("Microsoft.XMLHTTP")
With xml
.Open "GET", URL, False
.send
GetWebSource = .responseText
End With
Set xml = Nothing
End Function
Can't find a movie or TV show? Login to create it.
Want to rate or add this item to a list?
Not a member?
Reply by Simon
on September 4, 2013 at 10:00 PM
I do usually use a separate function that strips out special characters like this from names to avoid issues, but in this case I have to keep the umlaut in there or the API won't find any results (not sure if that can be made more flexible from your end)?
Reply by Travis Bell
on September 6, 2013 at 9:02 AM
Hi,
I'm currently on vacation and won't be back in the office to look at this until Monday. Cheers.
Reply by Travis Bell
on September 7, 2013 at 11:19 AM
Hi Simon,
I can't seem to reproduce this issue as a whole. Here's my API query:
I see Chloë (id 56734) being returned. I also double checked the website: https://www.themoviedb.org/search?query=Chloë+Grace+Moretz
Now, with regards to being able to search for "Chloe Grace Moretz", I think I know what's causing that and I will look into it. In the meantime, I cheated and just added it as an alternative name. I'll look at properly fixing it soon. Here's the ticket.
https://www.themoviedb.org/search?query=Chloe+Grace+Moretz
Reply by Simon
on September 10, 2013 at 8:01 PM
Thanks Travis. Perhaps my app was just being a spaz at the time.
Thanks for looking into the "umlaut-less" search issue though, that's the main problem anyway I guess.