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
¿No encuentras una película o serie? Inicia sesión para crearla:
¿Quieres puntuar o añadir este elemento a una lista?
¿No eres miembro?
Contestado por Simon
el 4 de septiembre de 2013 a las 22:00
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)?
Contestado por Travis Bell
el 6 de septiembre de 2013 a las 09:02
Hi,
I'm currently on vacation and won't be back in the office to look at this until Monday. Cheers.
Contestado por Travis Bell
el 7 de septiembre de 2013 a las 11:19
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
Contestado por Simon
el 10 de septiembre de 2013 a las 20:01
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.