...
Bloco de código |
---|
{
idnotafiscal:
url:
usuario:
senha:
} |
...
HEADERS: Authorization: Basic {TOKEN}
Bloco de código | ||
---|---|---|
| ||
SELECT n.numeronotafiscal AS DOCUMENTO,
n.serie AS SERIE,
l.numeromatricula AS FILIAL,
CASE
WHEN (SELECT valor
FROM pluginintconfig p
WHERE codigoelemento = 'DOWNNF'
AND sglcampo = 'DOWNNF_GROUP') <> NULL THEN
(SELECT valor FROM pluginintconfig p WHERE codigoelemento = 'DOWNNF' AND sglcampo = 'DOWNNF_GROUP')
ELSE Split_part(N.codigoerp, '#', 1)
END AS EMPRESA
FROM notafiscal n
INNER JOIN local l
ON l.idlocal = n.idlocalfilialfaturamento
WHERE n.idnotafiscal = IDNOTAFISCAL;
SELECT ( CASE
WHEN sglcampo = 'DOWNNF_PASSWORD' THEN valor
END ) AS SENHA,
( CASE
WHEN sglcampo = 'DOWNNF_USER' THEN valor
END ) AS USUARIO,
( CASE
WHEN sglcampo = 'DOWNNF_URL' THEN valor
END ) AS URL
FROM pluginintconfig
WHERE codigoelemento = 'DOWNNF'
AND sglcampo IN ( 'DOWNNF_PASSWORD', 'DOWNNF_USER', 'DOWNNF_URL' ); |
...