Pular para conteúdo

2024

  • 1 min de leitura

Teams API

Enviando dados para um canal no Teams via incoming webhook

Usando PROC HTTP
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
filename resp temp;

proc http
    url="https://banco365.webhook.office.com"
    method="POST"
    in='{"title": "Titulo mensagem", "text":"mensagem **teste** formatada."}'
    out=resp;
    headers
        "Content-Type"="application/json"
    ;
run;

data _null_;
    infile resp;
    input;
    put _infile_;
run;
Usando CURL
1
x curl -H 'Content-Type: application/json' -d '{"text": "Hello World"}' https://banco365.webhook.office.com ;
  • 1 min de leitura

DB2 Metadados

listar tabelas do DB2 pelo nome e schema
1
2
3
4
select * from sysibm.systables
where owner = 'SCHEMA'
and name like '%CUR%'
and type = 'T';
listar colunas pelo nome e tabela
1
2
3
4
5
6
7
8
select * from sysibm.syscolumns LIMIT 100;


SELECT * FROM "SYSIBM".SYSCOLUMNS a 
       WHERE 
        A.TBCREATOR IN ('DB2MCO') 
        -- AND a.TBNAME IN ('PRPT_SRVC_CTRD', 'TCOP183', 'TCOP117', 'TCOP117')
        AND (a.NAME LIKE '%COD_ORIG_RECU%');