topic Re: how to publish to a Microsoft Teams channel using SAS in SAS Programming

how to publish to a Microsoft Teams channel using SAS

learn_SAS_23 — Tue, 21 Dec 2021 10:30:52 GMT

filename resp temp;
options noquotelenmax;
proc http
/* Substitute your webhook URL here */
url="https :webhook uRL"
method="POST"
in=
'{
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"type": "AdaptiveCard",
"version": "1.0",
"summary": "Test message from SAS",
"text": "This message was sent by **SAS**!"
}'
out=resp;
run;

Hello Team ,

Am trying to send messages in teams channel with above code

and getting below error ,

ERROR: Error connecting to 111.11.111:113. (The connection has timed out.)
ERROR: Unable to establish connection to microsoft365.webhook.office.com.
ERROR: Unable to connect to Web server.

with reference documentation as below link created a webhook and used in the above code from sas EG

https://blogs.sas.com/content/sasdummy/2019/09/05/sas-microsoft-teams/ ,

please post your taught on above error.

Re: how to publish to a Microsoft Teams channel using SAS

andreas_lds — Tue, 21 Dec 2021 10:42:03 GMT

Talk to your network admins, maybe outbound connection are blocked, due to log4shell.

Re: how to publish to a Microsoft Teams channel using SAS

ChrisHemedinger — Tue, 21 Dec 2021 12:56:40 GMT

Use this method to test that PROC HTTP can access the internet from your SAS environment.

Re: how to publish to a Microsoft Teams channel using SAS

learn_SAS_23 — Tue, 21 Dec 2021 14:13:03 GMT

Thanks Chris , I tried with all methods in the link , but i still get below error

filename resp "%sysfunc(getoption(WORK))/echo.json";
proc http
url="https://httpbin.org/stream/1"
method="GET"
out=resp;
run;

ERROR: Host name resolution failed

Re: how to publish to a Microsoft Teams channel using SAS

SASKiwi — Tue, 21 Dec 2021 21:28:31 GMT

That suggests to me that your SAS server has firewall rules blocking access to public internet sites like httpbin.org. I tried it from my home PC and I can get to that website. You will need to talk to your SAS administrator about what rules are in place and how to gain access.