Dim json As Object
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", URL, False
.SetRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT"
.send
Set json = JsonConverter.ParseJson(.ResponseText)
End With
BookTitle = json("items")(1)("volumeInfo")("title")
End Function
ICh bedanke mich schon mal im voraus.
MfG
Felix Sternsdorf
Claus Busch
unread,
Jun 9, 2022, 1:35:21 PM6/9/22
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hallo,
Am Thu, 9 Jun 2022 09:52:43 -0700 (PDT) schrieb Ferrari 77:
> Public Function BookTitle(isbn As String)
> 'Const URL As String = "https://www.googleapis.com/books/v1/volumes?q=isbn:9780134092669"
> Dim URL
> Set URL = "https://www.googleapis.com/books/v1/volumes?q=isbn:9780134092669"
>
> Dim json As Object
> With CreateObject("MSXML2.XMLHTTP")
> .Open "GET", URL, False
> .SetRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT"
> .send
> Set json = JsonConverter.ParseJson(.ResponseText)
> End With
>
> BookTitle = json("items")(1)("volumeInfo")("title")
> End Function
eine URL ist ein String und kein Objekt. Deshalb wird der String einfach
zugewiesen und nicht über Set: