topic Re: SAS API Graph.Microsoft Download file from site in SAS Programming

SAS API Graph.Microsoft Download file from site

smijoss1 — Thu, 18 Apr 2019 06:06:14 GMT

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;

Re: SAS API Graph.Microsoft Download file from site

ChrisNZ — Tue, 23 Apr 2019 00:24:49 GMT

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.

Re: SAS API Graph.Microsoft Download file from site

smijoss1 — Wed, 24 Apr 2019 01:48:13 GMT

Hi Chris, Thank you for replying.

I am using SAS Grid 9.4 M4.

Re: SAS API Graph.Microsoft Download file from site

ChrisNZ — Wed, 24 Apr 2019 02:42:39 GMT

Show us the full log please.

Re: SAS API Graph.Microsoft Download file from site

smijoss1 — Sun, 28 Apr 2019 14:50:19 GMT

Duplicate post

https://communities.sas.com/t5/SAS-Programming/SAS-Proc-HTTP-call-to-API-Graph-Microsoft/m-p/552538