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