PROC HTTP for Google docs

[HeidiDT]

Hi All!

I am running a very simple PROC HTTP to download an Excel spreadsheet from Google docs, and then a subsequent import step to load the data into SAS. I get a "401 Unauthorized" note in my log for the PROC HTTP, and the imported file contains the following:

Allow Google Sheets access to your necessary cookies
You won't be able to access this content if necessary cookies are turned off
Learn moreAllow cookies

Sign in to your Google Account
You must sign in to access this content
Sign in

Can't access your Google Account
We can't sign you in when the necessary cookies are turned off
Learn more

So I am obviously able to reach the site, but then need to sign in. I have searched and searched on the web for information on how to handle this, but have just been going down rabbit holes. Here is my code:

filename _httpin temp;

proc http 

url="https://docs.google.com/spreadsheets/d/1sFshkC35_cY2qwinv1hNHoFjC7u965yhiHV9ga8t9lk/edit?pli=1#gid=5..."

method="get" 

out=_httpin

WEBUSERNAME="my email"

WEBPASSWORD='my google password';

debug level=3;

run;

proc import file=_httpin out=test dbms=csv replace;

getnames=no;

datarow=1;

run;

I am able to access the file via my browser, and when I submit the GET method in Postman I get the same output. Please can someone who has successfully downloaded Google docs files provide some assistance?

Thanks!

[SASJedi]

Check out these resources:

• SGF2021 paper “There’s an App for That”: It’s Called SAS® ODS! Mobile Data Entry and Reporting via S...
• How Do You Use SAS® to Access Data and APIs From the Web? Q&A, Slides, and On-Demand Recording
• The Google Docs API