Proc Lua and RESTful APIs

dcmacedo — Mon, 09 Oct 2023 14:41:43 GMT

I'm testing "Proc Lua" to produce a simpler program, which performs multiple "RESTful" requests, based on a listing.

As a result, this generates much simpler code than if you had used Macro programming. As in the example below:

proc lua ;
submit;
  local dsid = sas.open("work.stg_organograma_sefaz")
  for row in sas.rows(dsid) do
    local guid = row.guid
	local sigla = row.sgl_sigla
	local resp_json = "'/SASDATA_PRD/usuarios/GETEC/SIC/apiOrganograma/unidade/resp_" .. sigla .. ".json'"
	local api_url = "'https://api.organograma.es.gov.br/unidades/" .. guid .. "'"
	sas.submit[[

filename resp @resp_json@;
proc http
url=@api_url@
method="GET"
out=resp
OAUTH_BEARER="&token_access";
run;
filename resp clear;
	]]

  end
  sas.close(dsid)

endsubmit;
run;

I would like to explore this feature further, and the next step would be to use LUA modules to process URLs and JSON.

Therefore, I would like to know suggestions for the best LUA modules for this objective.

I am currently using the following paper as a reference: PRE_AD06.pdf (lexjansen.com)

topic Proc Lua and RESTful APIs in SAS Procedures

Proc Lua and RESTful APIs