New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open

PeterOstermann opened this issue Oct 7, 2022 · 1 comment

PeterOstermann commented Oct 7, 2022 •

edited

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 commented Jul 30, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment