the @microsoft.graph.downloadUrl Url obtained from from the API Graph.Microsoft is pre-authenticated and does not need bearer token. However when i try to read the file it gives
ERROR: SSL Error: Invalid subject name in partner's certificate. Subject name must match machine name..
if i copy the URL and paste it in chrome incognito, it downloads the excel file. but i cannot get it to work on SAS .
if i try PROC IMPORT it gives error
ERROR: File Name value exceeds maximum length of 201 characters.
PROC SQL;
SELECT cats("'",_microsoft_graph_downloadUrl,"'") as web_dwnld_Url length=2000 into :_web_dwnld_Url FROM
WORK.SMIJO t1 WHERE Item_Name = "CROSSWALK_GROUPS_TO_INCLUDE v201904.XLS";
QUIT;
filename fileout url
'https://sp-cloud.xx.org/sites/xxx-xxxxx/_layouts/15/download.aspx?UniqueId=0bf75b29-18b3-4314-9baa-3b608cdc4686&Translate=false&temp
auth=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvc3AtY2xvdWQua3Aub3JnQDNmOGE3YmM
0LWUzMzctNDdhNS1hMGZjLTBkNTEyYzBlMDVmMSIsImlzcyI6IjAwMDAwMDAzLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMCIsIm5iZiI6IjE1NTU1NjYzMDciLCJleHA
iOiIxNTU1NTY5OTA3IiwiZW5kcG9pbnR1cmwiOiJBeEVoRWRvNFRnQ3l2RFdIb2xqMGZtNW9lSFFkRnlKbUVjaTVNZUh5NTBJPSIsImVuZHBvaW50dXJsTGVuZ3RoIjoiMTI
2IiwiaXNsb29wYmFjayI6IlRydWUiLCJjaWQiOiJPR1l4WlRka09UY3RORFl6TWkwMFpXRXhMV0l4Tm1FdE1UQm1Zak0xWTJObVlqWTAiLCJ2ZXIiOiJoYXNoZWRwcm9vZnR
va2VuIiwic2l0ZWlkIjoiT0Rrd016UTFObVV0TlRNMllpMDBaVGs0TFRsbVl6Z3RaVGMyWkRFeE5UYzJaRGN5IiwiYXBwX2Rpc3BsYXluYW1lIjoiU21pam9fU0FTX3ZpYV9
Qcm9jX0hUVFAiLCJhcHBpZCI6IjUxYzUwNTBjLTk0YTMtNDc5Ni04MjEyLWNiNzYwMjM1ODk0ZCIsInRpZCI6IjNmOGE3YmM0LWUzMzctNDdhNS1hMGZjLTBkNTEyYzBlMDV
mMSIsInVwbiI6InNtaWpvLnguc2ltb25Aa3Aub3JnIiwicHVpZCI6IjEwMDNCRkZEOTg1RTRERUYiLCJjYWNoZWtleSI6IjBoLmZ8bWVtYmVyc2hpcHwxMDAzYmZmZDk4NWU
0ZGVmQGxpdmUuY29tIiwic2NwIjoiYWxsZmlsZXMud3JpdGUgYWxscHJvZmlsZXMucmVhZCIsInR0IjoiMiIsInVzZVBlcnNpc3RlbnRDb29raWUiOm51bGx9.Y0l2Nmh3Vm
tROFoxaXpLUDJuWDhjM2lhWFRWR2pvVTI1STREbHlPZnIxOD0&ApiVersion=2.0' ;
MPRINT(DOWNLOAD_FILE): data _null_;
MPRINT(DOWNLOAD_FILE): infile fileout;
MPRINT(DOWNLOAD_FILE): input ;
MPRINT(DOWNLOAD_FILE): put _infile_;
MPRINT(DOWNLOAD_FILE): run;
What version of SAS are you using? This filename is accepted for me.
26 filename fileout url 27 'https://sp-cloud.xx.org/sites/xxx-xxxxx/_layouts/15/download.aspx?UniqueId=0bf75b29-18b3-4314-9baa-3b608cdc4686&Translat 27 ! e=false&temp 28 auth=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvc3AtY2xvdWQua3Aub3Jn 28 ! QDNmOGE3YmM WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 29 0LWUzMzctNDdhNS1hMGZjLTBkNTEyYzBlMDVmMSIsImlzcyI6IjAwMDAwMDAzLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMCIsIm5iZiI6IjE1NTU1NjYz 29 ! MDciLCJleHA 30 iOiIxNTU1NTY5OTA3IiwiZW5kcG9pbnR1cmwiOiJBeEVoRWRvNFRnQ3l2RFdIb2xqMGZtNW9lSFFkRnlKbUVjaTVNZUh5NTBJPSIsImVuZHBvaW50dXJsTGVu 30 ! Z3RoIjoiMTI 31 2IiwiaXNsb29wYmFjayI6IlRydWUiLCJjaWQiOiJPR1l4WlRka09UY3RORFl6TWkwMFpXRXhMV0l4Tm1FdE1UQm1Zak0xWTJObVlqWTAiLCJ2ZXIiOiJoYXNo 31 ! ZWRwcm9vZnR 32 va2VuIiwic2l0ZWlkIjoiT0Rrd016UTFObVV0TlRNMllpMDBaVGs0TFRsbVl6Z3RaVGMyWkRFeE5UYzJaRGN5IiwiYXBwX2Rpc3BsYXluYW1lIjoiU21pam9f 32 ! U0FTX3ZpYV9 33 Qcm9jX0hUVFAiLCJhcHBpZCI6IjUxYzUwNTBjLTk0YTMtNDc5Ni04MjEyLWNiNzYwMjM1ODk0ZCIsInRpZCI6IjNmOGE3YmM0LWUzMzctNDdhNS1hMGZjLTBk 33 ! NTEyYzBlMDV 34 mMSIsInVwbiI6InNtaWpvLnguc2ltb25Aa3Aub3JnIiwicHVpZCI6IjEwMDNCRkZEOTg1RTRERUYiLCJjYWNoZWtleSI6IjBoLmZ8bWVtYmVyc2hpcHwxMDAz 34 ! YmZmZDk4NWU 35 0ZGVmQGxpdmUuY29tIiwic2NwIjoiYWxsZmlsZXMud3JpdGUgYWxscHJvZmlsZXMucmVhZCIsInR0IjoiMiIsInVzZVBlcnNpc3RlbnRDb29raWUiOm51bGx9 35 ! .Y0l2Nmh3Vm 36 tROFoxaXpLUDJuWDhjM2lhWFRWR2pvVTI1STREbHlPZnIxOD0&ApiVersion=2.0' ; 37 data _null_; 38 infile fileout; 39 input ; 40 put _infile_; 41 run; NOTE: Unable to connect to host sp-cloud.xx.org. Check validity of host name. ERROR: Host name sp-cloud.xx.org not found. NOTE: The SAS System stopped processing this step because of errors.
Hi Chris, Thank you for replying.
I am using SAS Grid 9.4 M4.
Show us the full log please.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.