topic Re: How do I send email using VIYA REST api? in SAS Viya

How do I send email using VIYA REST api?

geroldpw — Mon, 16 Jan 2023 09:01:16 GMT

When trying to send email through the VIYA REST api from a shell script I get the following message:

{"version":2,"httpStatusCode":400,"message":"The request body was missing or invalid.",
"details":["path: /mail/messages","correlator: 70862b93-1626-4763-ad6d-b7d5d6e1032e"]}

This is how I issue the request:

curl -s -k -X POST "$base_url/mail/messages" \
     -H "Authorization: Bearer $IDTOKEN" \
     -H 'Content-Type: application/vnd.sas.mail+json' \
     -d '{
       "to":"me@email.adres",
       "subject":"testmail door Gerold van viya LTEST",
       "message":"Deze mail wordt verstuurd met de VIYA REST API"
     }'

I can't find documentation on the data part of the request. Documetation only mentions to have the three fields. I tried making the "message" field a list but that doesn't work either.

Re: How do I send email using VIYA REST api?

gwootton — Tue, 17 Jan 2023 12:23:09 GMT

The format for the data would be (you could also use "textMessage" instead of "htmlMessage" for a message in plain text):
{
"to": [
{
"address": "user@example.com",
"personal": "Example User"
}
],
"from": {
"address": "from@example.com"
},
"subject": "Subject goes here",
"htmlMessage": "<html><b>Note:</b>This is an HTML email.</html>"
}

Re: How do I send email using VIYA REST api?

geroldpw — Tue, 17 Jan 2023 12:48:40 GMT

Thanks a lot! I have it working. By the way, .. 'from' address can't be overruled. It is immutably configured in VIYA.
Is all this documented anywhere?

Thanks again,
Gérold

Re: How do I send email using VIYA REST api?

gwootton — Tue, 17 Jan 2023 17:09:51 GMT

The mail service API is not currently documented.

Re: How do I send email using VIYA REST api?

paterd2 — Fri, 05 Jan 2024 13:26:41 GMT

Mr. Gwooton,

how can i use this with starttls, the example is not working with starttls eventhough we have mail.smtp.starttls.enable : true in configuration.

Example error output :

{"version":2,"httpStatusCode":400,"errorCode":11104,"message":"Couldn't connect to host, port: OURSMTPSERVER, 25; timeout -1","details":["Caused by gomail: could not send email 1: 530 #5.7.0 Must issue a STARTTLS command first","path: /mail/messages","correlator: f965315d-08e9-4af1-bf19-e4227f7fda74"]}sh-4.4$

Re: How do I send email using VIYA REST api?

gwootton — Fri, 05 Jan 2024 14:05:33 GMT

How did you set mail.smtp.starttls.enable? In sas.mail configuration under customProperties? It sounds like this is not being honored.

Re: How do I send email using VIYA REST api?

paterd2 — Fri, 05 Jan 2024 14:07:32 GMT

Yes we did this.

Re: How do I send email using VIYA REST api?

gwootton — Fri, 05 Jan 2024 14:10:50 GMT

Have you tried using the secure TLS ports (587 or 465) instead?

Re: How do I send email using VIYA REST api?

paterd2 — Fri, 05 Jan 2024 14:20:32 GMT

We do not have these ports open, but if I lauch it with curl directly it works fine with --ssl-reqd on port 25.
even if I mail from studio, with starttls it works fine.

Re: How do I send email using VIYA REST api?

gwootton — Fri, 05 Jan 2024 16:40:00 GMT

You should engage SAS Technical Support to have them take a look at your configuration.

Re: How do I send email using VIYA REST api?

paterd2 — Thu, 21 Mar 2024 09:12:04 GMT

Greg,

this is what I sended to support today.

Dear Support,

eureka !

I found a workaround by accident .

I saw that we have DEBUG=true as optional parameter.

I removed it, and the sas-mail pod was not able to start.

I added DEBUG=true and the pod started again.

Then today I had a brainwave.

I changed DEBUG=true in ...... mail.smtp.starttls.enable=true.

Optional custom properties set on the remote mail server.

mail.smtp.starttls.enable: true

IT WORKS !!!!

Re: How do I send email using VIYA REST api?

paterd2 — Thu, 21 Mar 2024 09:26:25 GMT

Excuse me :
Not optional but properties.

properties:
mail.smtp.starttls.enable=true
(Deprecated) Optional properties set on the remote mail server.

Re: How do I send email using VIYA REST api?

gwootton — Thu, 21 Mar 2024 13:59:24 GMT

Great news! I'm pleased to hear you got it working.

So you modified the mail.debug=false set by default in the deprecated properties field (that had been changed to true in your case) to mail.smtp.starttls.enable=true and it picked it up?

Re: How do I send email using VIYA REST api?

paterd2 — Mon, 25 Mar 2024 07:22:08 GMT

Greg, exactly !

Regards.

Dik

Re: How do I send email using VIYA REST api?

Sathyaseelan_C — Fri, 05 Apr 2024 12:57:11 GMT

Any idea how to send with attachments, using this same method

Re: How do I send email using VIYA REST api?

paterd2 — Mon, 08 Apr 2024 06:47:01 GMT

https://communities.sas.com/t5/SAS-Viya/Example-for-sending-email-using-REST-Api/m-p/888375#M1967

contains the answer to your question