topic Re: Using PROC HTTP to POST a mail with Zipped file attachments from SAS Studio in SAS Viya

Using PROC HTTP to POST a mail with Zipped file attachments from SAS Studio

Sathyaseelan_C — Fri, 05 Apr 2024 12:52:28 GMT

I am using the below Json for posting the Mail using our SAS STUDIO from SAS VIYA 3.5 ENV,.

I am getting 200 Response and have received the mail. But not with the attachments. Kindly advise.

data test;

file mail;

put '{'

/'"to":'

/'['

/'{'

/'"address": "sathyaseelan_chandramohan@example.com",'

/'"personal": "Example User"'

/'}'

/'],'

/'"from": {'

/'"address": "sathyaseelan_chandramohan@example.com"'

/'},'

/'"subject": "Subject goes here",'

/'"htmlMessage": "<html><b>Note:</b>This is an HTML email.</html>",'

/'"attachment": ['

/'{'

/'"type": "application/x-zip",'

/'"name": "Summary_SR_20240405_1334.zip",'

/'"data": "/tmp/Summary_SR_20240405_1334.zip"'

/'}'

/']'

/'}'

run;

data _null_;

infile mail;

input;

put _infile_;

run;

filename resp clear;

filename resp temp;

options set=SSLREQCERT="allow";

/*Invoke create parent SR API*/

proc http

url="https://example.com/mail/messages"

method="POST"

out=resp

CLEAR_CACHE

in=mail;

debug level=2;

headers

"Authorization" = "Bearer &access_token"

"Content-type" = "application/vnd.sas.mail+json";

run;

%put &=SYS_PROCHTTP_STATUS_CODE;

Re: Using PROC HTTP to POST a mail with Zipped file attachments from SAS Studio

ballardw — Fri, 05 Apr 2024 13:45:16 GMT

What does the log show?

Re: Using PROC HTTP to POST a mail with Zipped file attachments from SAS Studio

Sathyaseelan_C — Sat, 06 Apr 2024 01:46:13 GMT

Logs showing 200 Response and without any Errors. Also i have received the mail. But without the attachments.

Re: Using PROC HTTP to POST a mail with Zipped file attachments from SAS Studio

Sajid01 — Sun, 07 Apr 2024 13:45:51 GMT

If it is the intention to send email with http post request and if you are open to looking at python, then please have a look at
https://stackoverflow.com/questions/58242068/i-want-to-send-file-as-attachment-to-an-api-post-request

Re: Using PROC HTTP to POST a mail with Zipped file attachments from SAS Studio

gwootton — Mon, 08 Apr 2024 13:09:01 GMT

The "data" of the attachment array needs to be the actual contents of the file rather than a pointer to the file, PROC HTTP would not know to resolve that to the physical file and then properly encode it, it is sending to the mail service literally "/tmp/Summary_SR_20240405_1334.zip".

I think you'd need to base64 encode the file and put it in the "mail" file.