MS Teams integration - Printable Version

Code:

https = require('ssl.https')

json = require('json')

ltn12 = require('ltn12')



--variables

clientID = 'xxxxxxxxx'

tenantName = 'xxxxxx.onmicrosoft.com'

clientSecret = 'xxxxxxxxx'

url_token = "https://login.microsoftonline.com/".. tostring(tenantName) .. "/oauth2/v2.0/token"



--componer peticion token

ReqTokenBody = "client_id=" .. clientID .. "&scope=https%3A%2F%2Fgraph.microsoft.com%2F.default&client_secret=" .. clientSecret .. "&grant_type=client_credentials"





function GetTokenMSGraph()

  local response_body = {}

  local export_data = {}



  res, code = https.request({

    url = url_token,

    method = 'POST',

    protocol = 'tlsv12',

    headers = {

      ['Content-Type'] = 'application/x-www-form-urlencoded';

      ['Content-Length'] = #ReqTokenBody;

      ['Host'] = 'login.microsoftonline.com';    

    };

    source = ltn12.source.string(ReqTokenBody);

    sink = ltn12.sink.table(response_body);

  })

  --log(res, code)

  if code == 200 then

      response_decode = json.decode(table.concat(response_body))

      --log(response_decode)

        token = response_decode["access_token"] 

        --log(token)

      return token 

  end

end

Code:

function WiserKNX(value) 

  local response_body = {}

  --log(tokenMSgraph)

  log(value)

  

  time = os.date('%Y-%m-%d %H:%M:%S', os.time())

  

  title = 'Tienda CO2'

  url = "https://graph.microsoft.com/v1.0/groups/xxxxxxxxx/sites/root/lists/xxxxxx/items"

  insert = "{ 'fields': {'Title': '".. title .."' ,'value': '"..value.."','tiempo': '"..time.."'}}" 

  

  log(insert) 

    res, code = https.request({

    url = url,

    method = 'POST',

    protocol = 'tlsv12',

    headers = {

      ['authorization'] = 'Bearer ' .. tokenMSgraph,

        ['content-type']  = 'application/json',

           ['content-length'] = #insert,

    };

    source = ltn12.source.string(insert);

    sink = ltn12.sink.table(response_body);

  })



  log(res, code)

end



--read value from KNX  

read = grp.getvalue('x/x/x')

WiserKNX(read)

Code:

require('ssl.https')

require('json')



local token = 'TU_TOKEN_DE_ACCESO'  -- Token de acceso de la aplicación en Microsoft 

local team_id = 'ID_DEL_EQUIPO'

local channel_id = 'ID_DEL_CANAL'



-----------------------------------------------------------------------------------------



function send_message(message)

  local url = 'https://graph.microsoft.com/v1.0/teams/' .. team_id .. '/channels/' .. channel_id .. '/messages'

  local message_data = { body = { content = message } }

  local json_data = json.encode(message_data)

  local headers = {

    ["Authorization"] = "Bearer " .. token,

    ["Content-Type"] = "application/json",

    ["Content-Length"] = tostring(#json_data)

  }

  return https.request(url, {

    method = "POST",

    headers = headers,

    source = ltn12.source.string(json_data)

  })

end