Get Json from Google-Drive work on Windows but not on Mac

[PeterOstermann]

Hi,

The follow script returns Status-Code 301 on Mac (macOS Catalina).
On Windows it works fine.
Can you resolve it?

Greetings Peter

I use Excel Version 16.16.27 (201012) on Mac.
I use Excl Version 16.0.15629.20152 on Windows 10.

Sub web()
Dim Client As New WebClient
Dim Url As String
Url = "http://drive.google.com/uc?export=download&id=14xMSYLPMZNxCslpzbzUiiRbkmiG7nCeS"
Dim Response As WebResponse
Client.FollowRedirects = True
Set Response = Client.GetJson(Url)
Debug.Print Response.Data("letzte_esra_version")
End Sub

[MubaiHua]

Having the same issue here, the actual content is in Response.Body in my case, it is not correctly parsed to 200 OK and data