- Criado por Matheus Monteiro da Silva em 22 fev, 2024
Tempo aproximado para leitura: superior a 15 minutosCONTEÚDO
- Visão Geral
- Serviços Disponíveis
- Exemplo de utilização
- GET
- Assuntos Relacionados
01. VISÃO GERAL
Para clientes que possuem rotinas ou aplicativos customizados e precisam consultar as informações na rotina Consulta Rateio de Múltiplas Naturezas(FINA050RT), foram disponibilizados métodos Web Service REST.
02. SERVIÇOS DISPONÍVEIS
| GET Consulta | POST | PUT Alteração | DELETE Exclusão |
 |  | | |
03. EXEMPLO DE UTILIZAÇÃO
Para realizar testes, pode ser utilizado qualquer programa de sua preferência, que teste API Web Service REST.
Como exemplos de programas, podemos citar o SoapUI ou Postman . Ambos são excelentes aplicativos.
Os exemplo a seguir serão demonstrados utilizando programa Postman, executando os métodos GET, POST, PUT e DELETE.
Para inclusão ou alteração do registro, pode utilizar a mesma estrutura (body), os campos podem ser adicionados dentro da tag FIELDS.
Maiores detalhes referente a montagem da estrutura, verificar modelo abaixo.
Onde:
id: é id da API
operation: é o código da operação, valor padrão: 1,
pk: é a chave primária do alias do modelo de dados encodado em base64,
models: são os modelos de negócios de cada API, ou seja, modelo de dados do MVC, que é definido por:
id: é o modelo de dados definido no MVC
modeltype: é tipo de modelo de dados, "FIELDS" ou "GRID"
fields: é um vetor com os campos, definido por:
id: é nome do campo
order: ordem do campo na tabela SBE
value: é o valor do campo
Importante
Por padrão, para realizar consulta, alteração ou deleção de um determinado dado do servidor através dos métodos GET, PUT ou DELETE, é necessário informar a PK (Primary Key), valor da chave primaria do alias do modelo, encodado em base64, caso contrário não informado, serão retornado os registros conforme sua paginação.
a. GET
Retorno - Modelo Estrutura GET Expandir origem
{
"id": "FINA050RT",
"operation": 1,
"pk": "RCBNRyAwMSBEIE1HIDAxIEZJTkZJTjAwMDM5NCBEUCAwMDAwMDEwMA==",
"models": [
{
"id": "SE2MASTER",
"modeltype": "FIELDS",
"fields": [
{
"id": "E2_FILIAL",
"order": 1,
"value": "D MG 01"
},
{
"id": "E2_PREFIXO",
"order": 2,
"value": "FIN"
},
{
"id": "E2_NUM",
"order": 3,
"value": "FIN000394"
},
{
"id": "E2_TIPO",
"order": 5,
"value": "DP"
},
{
"id": "E2_NATUREZ",
"order": 6,
"value": "000001"
},
{
"id": "E2_FORNECE",
"order": 8,
"value": "000001"
},
{
"id": "E2_LOJA",
"order": 9,
"value": "00"
},
{
"id": "E2_NOMFOR",
"order": 10,
"value": "TESTE IT"
},
{
"id": "E2_EMISSAO",
"order": 11,
"value": "20220602"
},
{
"id": "E2_VENCTO",
"order": 12,
"value": "20220602"
},
{
"id": "E2_VENCREA",
"order": 13,
"value": "20220602"
},
{
"id": "E2_VALOR",
"order": 14,
"value": "140.00"
},
{
"id": "E2_BAIXA",
"order": 19,
"value": "20220602"
},
{
"id": "E2_BCOPAG",
"order": 20,
"value": "001"
},
{
"id": "E2_EMIS1",
"order": 21,
"value": "20220602"
},
{
"id": "E2_MOVIMEN",
"order": 26,
"value": "20220602"
},
{
"id": "E2_MOEDA",
"order": 31,
"value": "1"
},
{
"id": "E2_RATEIO",
"order": 36,
"value": "N"
},
{
"id": "E2_VLCRUZ",
"order": 38,
"value": "140.00"
},
{
"id": "E2_OCORREN",
"order": 43,
"value": "01"
},
{
"id": "E2_ORIGEM",
"order": 44,
"value": "FINA050"
},
{
"id": "E2_FLUXO",
"order": 46,
"value": "S"
},
{
"id": "E2_DESDOBR",
"order": 49,
"value": "N"
},
{
"id": "E2_MULTNAT",
"order": 60,
"value": "1"
},
{
"id": "E2_PROJPMS",
"order": 62,
"value": "2"
},
{
"id": "E2_DIRF",
"order": 64,
"value": "2"
},
{
"id": "E2_MODSPB",
"order": 66,
"value": "1"
},
{
"id": "E2_FILORIG",
"order": 71,
"value": "D MG 01"
},
{
"id": "E2_BASECOF",
"order": 91,
"value": "140.00"
},
{
"id": "E2_BASEPIS",
"order": 92,
"value": "140.00"
},
{
"id": "E2_BASECSL",
"order": 93,
"value": "140.00"
},
{
"id": "E2_MDRTISS",
"order": 96,
"value": "1"
},
{
"id": "E2_FRETISS",
"order": 104,
"value": "1"
},
{
"id": "E2_APLVLMN",
"order": 106,
"value": "1"
},
{
"id": "E2_BASEISS",
"order": 119,
"value": "140.00"
},
{
"id": "E2_BASEIRF",
"order": 120,
"value": "140.00"
},
{
"id": "E2_DATAAGE",
"order": 121,
"value": "20220602"
},
{
"id": "E2_TEMDOCS",
"order": 129,
"value": "2"
},
{
"id": "E2_BASEINS",
"order": 132,
"value": "140.00"
},
{
"id": "E2_TPDESC",
"order": 166,
"value": "C"
},
{
"id": "E2_MSUIDT",
"order": 187,
"value": "876BB3EB-237A-ED11-9236-005056ACF625"
}
],
"models": [
{
"id": "FK7DETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "FK7_FILIAL",
"order": 1
},
{
"id": "FK7_IDDOC",
"order": 2
},
{
"id": "FK7_ALIAS",
"order": 3
},
{
"id": "FK7_CHAVE",
"order": 4
},
{
"id": "FK7_FILTIT",
"order": 5
},
{
"id": "FK7_PREFIX",
"order": 6
},
{
"id": "FK7_NUM",
"order": 7
},
{
"id": "FK7_PARCEL",
"order": 8
},
{
"id": "FK7_TIPO",
"order": 9
},
{
"id": "FK7_CLIFOR",
"order": 10
}
],
"items": [
{
"id": 1,
"deleted": 0,
"fields": [
{
"id": "FK7_FILIAL",
"value": "D MG 01"
},
{
"id": "FK7_IDDOC",
"value": "1138d8c2fee540008811ad46ef589d08"
},
{
"id": "FK7_ALIAS",
"value": "SE2"
},
{
"id": "FK7_CHAVE",
"value": "D MG 01 |FIN|FIN000394| |DP |000001|00"
},
{
"id": "FK7_FILTIT",
"value": "D MG 01"
},
{
"id": "FK7_PREFIX",
"value": "FIN"
},
{
"id": "FK7_NUM",
"value": "FIN000394"
},
{
"id": "FK7_TIPO",
"value": "DP"
},
{
"id": "FK7_CLIFOR",
"value": "000001"
}
],
"models": [
{
"id": "SEVDETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "EV_FILIAL",
"order": 1
},
{
"id": "EV_PARCELA",
"order": 2
},
{
"id": "EV_CLIFOR",
"order": 3
},
{
"id": "EV_LOJA",
"order": 4
},
{
"id": "EV_VALOR",
"order": 5
},
{
"id": "EV_NATUREZ",
"order": 6
},
{
"id": "EV_PERC",
"order": 7
},
{
"id": "EV_LA",
"order": 8
},
{
"id": "EV_RATEICC",
"order": 9
},
{
"id": "EV_IDENT",
"order": 10
},
{
"id": "EV_SEQ",
"order": 11
},
{
"id": "EV_IDDOC",
"order": 12
},
{
"id": "EV_PORCENT",
"order": 13
}
],
"items": [
{
"id": 1,
"deleted": 0,
"fields": [
{
"id": "EV_FILIAL",
"value": "D MG 01"
},
{
"id": "EV_CLIFOR",
"value": "000001"
},
{
"id": "EV_LOJA",
"value": "00"
},
{
"id": "EV_VALOR",
"value": "70.00"
},
{
"id": "EV_NATUREZ",
"value": "0000000001"
},
{
"id": "EV_PERC",
"value": "0.5000000"
},
{
"id": "EV_RATEICC",
"value": "2"
},
{
"id": "EV_IDENT",
"value": "1"
},
{
"id": "EV_IDDOC",
"value": "1138d8c2fee540008811ad46ef589d08"
},
{
"id": "EV_PORCENT",
"value": "0"
}
],
"models": [
{
"id": "SEZDETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "EZ_FILIAL",
"order": 1
},
{
"id": "EZ_VALOR",
"order": 2
},
{
"id": "EZ_CCUSTO",
"order": 3
},
{
"id": "EZ_PERC",
"order": 4
},
{
"id": "EZ_ITEMCTA",
"order": 5
},
{
"id": "EZ_CLVL",
"order": 6
},
{
"id": "EZ_SEQ",
"order": 7
},
{
"id": "EZ_CONTA",
"order": 8
},
{
"id": "EZ_EC05DB",
"order": 9
},
{
"id": "EZ_EC05CR",
"order": 10
},
{
"id": "EZ_EC06DB",
"order": 11
},
{
"id": "EZ_EC06CR",
"order": 12
},
{
"id": "EZ_IDDOC",
"order": 13
},
{
"id": "EZ_EC07DB",
"order": 14
},
{
"id": "EZ_EC07CR",
"order": 15
},
{
"id": "EZ_EC08DB",
"order": 16
},
{
"id": "EZ_EC08CR",
"order": 17
},
{
"id": "EZ_EC09DB",
"order": 18
},
{
"id": "EZ_EC09CR",
"order": 19
},
{
"id": "EZ_PORCENT",
"order": 20
},
{
"id": "EZ_MSUIDT",
"order": 21
}
]
}
]
},
{
"id": 2,
"deleted": 0,
"fields": [
{
"id": "EV_FILIAL",
"value": "D MG 01"
},
{
"id": "EV_CLIFOR",
"value": "000001"
},
{
"id": "EV_LOJA",
"value": "00"
},
{
"id": "EV_VALOR",
"value": "70.00"
},
{
"id": "EV_NATUREZ",
"value": "0000000002"
},
{
"id": "EV_PERC",
"value": "0.5000000"
},
{
"id": "EV_RATEICC",
"value": "2"
},
{
"id": "EV_IDENT",
"value": "1"
},
{
"id": "EV_IDDOC",
"value": "1138d8c2fee540008811ad46ef589d08"
},
{
"id": "EV_PORCENT",
"value": "0"
}
],
"models": [
{
"id": "SEZDETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "EZ_FILIAL",
"order": 1
},
{
"id": "EZ_VALOR",
"order": 2
},
{
"id": "EZ_CCUSTO",
"order": 3
},
{
"id": "EZ_PERC",
"order": 4
},
{
"id": "EZ_ITEMCTA",
"order": 5
},
{
"id": "EZ_CLVL",
"order": 6
},
{
"id": "EZ_SEQ",
"order": 7
},
{
"id": "EZ_CONTA",
"order": 8
},
{
"id": "EZ_EC05DB",
"order": 9
},
{
"id": "EZ_EC05CR",
"order": 10
},
{
"id": "EZ_EC06DB",
"order": 11
},
{
"id": "EZ_EC06CR",
"order": 12
},
{
"id": "EZ_IDDOC",
"order": 13
},
{
"id": "EZ_EC07DB",
"order": 14
},
{
"id": "EZ_EC07CR",
"order": 15
},
{
"id": "EZ_EC08DB",
"order": 16
},
{
"id": "EZ_EC08CR",
"order": 17
},
{
"id": "EZ_EC09DB",
"order": 18
},
{
"id": "EZ_EC09CR",
"order": 19
},
{
"id": "EZ_PORCENT",
"order": 20
},
{
"id": "EZ_MSUIDT",
"order": 21
}
]
}
]
}
]
},
{
"id": "FK2DETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "FK2_FILIAL",
"order": 1
},
{
"id": "FK2_IDFK2",
"order": 2
},
{
"id": "FK2_DATA",
"order": 3
},
{
"id": "FK2_VALOR",
"order": 4
},
{
"id": "FK2_MOEDA",
"order": 5
},
{
"id": "FK2_NATURE",
"order": 6
},
{
"id": "FK2_VENCTO",
"order": 7
},
{
"id": "FK2_RECPAG",
"order": 8
},
{
"id": "FK2_TPDOC",
"order": 9
},
{
"id": "FK2_HISTOR",
"order": 10
},
{
"id": "FK2_VLMOE2",
"order": 11
},
{
"id": "FK2_LOTE",
"order": 12
},
{
"id": "FK2_MOTBX",
"order": 13
},
{
"id": "FK2_ORDREC",
"order": 14
},
{
"id": "FK2_FILORI",
"order": 15
},
{
"id": "FK2_ARCNAB",
"order": 16
},
{
"id": "FK2_CNABOC",
"order": 17
},
{
"id": "FK2_TXMOED",
"order": 18
},
{
"id": "FK2_SERREC",
"order": 19
},
{
"id": "FK2_MULNAT",
"order": 20
},
{
"id": "FK2_AUTBCO",
"order": 21
},
{
"id": "FK2_CCUSTO",
"order": 22
},
{
"id": "FK2_ORIGEM",
"order": 23
},
{
"id": "FK2_SEQ",
"order": 24
},
{
"id": "FK2_DIACTB",
"order": 25
},
{
"id": "FK2_NODIA",
"order": 26
},
{
"id": "FK2_LA",
"order": 27
},
{
"id": "FK2_IDDOC",
"order": 28
},
{
"id": "FK2_DOC",
"order": 29
},
{
"id": "FK2_IDCOMP",
"order": 30
},
{
"id": "FK2_IDPROC",
"order": 31
},
{
"id": "FK2_DTDISP",
"order": 32
},
{
"id": "FK2_DTDIGI",
"order": 33
},
{
"id": "FK2_REINF",
"order": 34
}
],
"items": [
{
"id": 1,
"deleted": 0,
"fields": [
{
"id": "FK2_FILIAL",
"value": "D MG 01"
},
{
"id": "FK2_IDFK2",
"value": "7e7e0138483a40008C3B32582b388ff6"
},
{
"id": "FK2_DATA",
"value": "20220602"
},
{
"id": "FK2_VALOR",
"value": "140.00"
},
{
"id": "FK2_MOEDA",
"value": "01"
},
{
"id": "FK2_NATURE",
"value": "000001"
},
{
"id": "FK2_RECPAG",
"value": "P"
},
{
"id": "FK2_TPDOC",
"value": "BA"
},
{
"id": "FK2_HISTOR",
"value": "Valor pago s/ Titulo"
},
{
"id": "FK2_VLMOE2",
"value": "140.00"
},
{
"id": "FK2_MOTBX",
"value": "NOR"
},
{
"id": "FK2_FILORI",
"value": "D MG 01"
},
{
"id": "FK2_MULNAT",
"value": "1"
},
{
"id": "FK2_ORIGEM",
"value": "FINA080"
},
{
"id": "FK2_SEQ",
"value": "02"
},
{
"id": "FK2_LA",
"value": "N"
},
{
"id": "FK2_IDDOC",
"value": "1138d8c2fee540008811ad46ef589d08"
},
{
"id": "FK2_DTDISP",
"value": "20220602"
},
{
"id": "FK2_DTDIGI",
"value": "20220602"
}
],
"models": [
{
"id": "SEV1DETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "EV_FILIAL",
"order": 1
},
{
"id": "EV_PARCELA",
"order": 2
},
{
"id": "EV_CLIFOR",
"order": 3
},
{
"id": "EV_LOJA",
"order": 4
},
{
"id": "EV_VALOR",
"order": 5
},
{
"id": "EV_NATUREZ",
"order": 6
},
{
"id": "EV_PERC",
"order": 7
},
{
"id": "EV_LA",
"order": 8
},
{
"id": "EV_RATEICC",
"order": 9
},
{
"id": "EV_IDENT",
"order": 10
},
{
"id": "EV_SEQ",
"order": 11
},
{
"id": "EV_IDDOC",
"order": 12
},
{
"id": "EV_PORCENT",
"order": 13
}
],
"items": [
{
"id": 1,
"deleted": 0,
"fields": [
{
"id": "EV_FILIAL",
"value": "D MG 01"
},
{
"id": "EV_CLIFOR",
"value": "000001"
},
{
"id": "EV_LOJA",
"value": "00"
},
{
"id": "EV_VALOR",
"value": "70.00"
},
{
"id": "EV_NATUREZ",
"value": "0000000001"
},
{
"id": "EV_PERC",
"value": "0.5000000"
},
{
"id": "EV_RATEICC",
"value": "2"
},
{
"id": "EV_IDENT",
"value": "2"
},
{
"id": "EV_SEQ",
"value": "02"
},
{
"id": "EV_IDDOC",
"value": "7e7e0138483a40008C3B32582b388ff6"
},
{
"id": "EV_PORCENT",
"value": "0"
}
],
"models": [
{
"id": "SEZ1DETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "EZ_FILIAL",
"order": 1
},
{
"id": "EZ_VALOR",
"order": 2
},
{
"id": "EZ_CCUSTO",
"order": 3
},
{
"id": "EZ_PERC",
"order": 4
},
{
"id": "EZ_ITEMCTA",
"order": 5
},
{
"id": "EZ_CLVL",
"order": 6
},
{
"id": "EZ_SEQ",
"order": 7
},
{
"id": "EZ_CONTA",
"order": 8
},
{
"id": "EZ_EC05DB",
"order": 9
},
{
"id": "EZ_EC05CR",
"order": 10
},
{
"id": "EZ_EC06DB",
"order": 11
},
{
"id": "EZ_EC06CR",
"order": 12
},
{
"id": "EZ_IDDOC",
"order": 13
},
{
"id": "EZ_EC07DB",
"order": 14
},
{
"id": "EZ_EC07CR",
"order": 15
},
{
"id": "EZ_EC08DB",
"order": 16
},
{
"id": "EZ_EC08CR",
"order": 17
},
{
"id": "EZ_EC09DB",
"order": 18
},
{
"id": "EZ_EC09CR",
"order": 19
},
{
"id": "EZ_PORCENT",
"order": 20
},
{
"id": "EZ_MSUIDT",
"order": 21
}
]
}
]
},
{
"id": 2,
"deleted": 0,
"fields": [
{
"id": "EV_FILIAL",
"value": "D MG 01"
},
{
"id": "EV_CLIFOR",
"value": "000001"
},
{
"id": "EV_LOJA",
"value": "00"
},
{
"id": "EV_VALOR",
"value": "70.00"
},
{
"id": "EV_NATUREZ",
"value": "0000000002"
},
{
"id": "EV_PERC",
"value": "0.5000000"
},
{
"id": "EV_RATEICC",
"value": "2"
},
{
"id": "EV_IDENT",
"value": "2"
},
{
"id": "EV_SEQ",
"value": "02"
},
{
"id": "EV_IDDOC",
"value": "7e7e0138483a40008C3B32582b388ff6"
},
{
"id": "EV_PORCENT",
"value": "0"
}
],
"models": [
{
"id": "SEZ1DETAIL",
"modeltype": "GRID",
"optional": 1,
"struct": [
{
"id": "EZ_FILIAL",
"order": 1
},
{
"id": "EZ_VALOR",
"order": 2
},
{
"id": "EZ_CCUSTO",
"order": 3
},
{
"id": "EZ_PERC",
"order": 4
},
{
"id": "EZ_ITEMCTA",
"order": 5
},
{
"id": "EZ_CLVL",
"order": 6
},
{
"id": "EZ_SEQ",
"order": 7
},
{
"id": "EZ_CONTA",
"order": 8
},
{
"id": "EZ_EC05DB",
"order": 9
},
{
"id": "EZ_EC05CR",
"order": 10
},
{
"id": "EZ_EC06DB",
"order": 11
},
{
"id": "EZ_EC06CR",
"order": 12
},
{
"id": "EZ_IDDOC",
"order": 13
},
{
"id": "EZ_EC07DB",
"order": 14
},
{
"id": "EZ_EC07CR",
"order": 15
},
{
"id": "EZ_EC08DB",
"order": 16
},
{
"id": "EZ_EC08CR",
"order": 17
},
{
"id": "EZ_EC09DB",
"order": 18
},
{
"id": "EZ_EC09CR",
"order": 19
},
{
"id": "EZ_PORCENT",
"order": 20
},
{
"id": "EZ_MSUIDT",
"order": 21
}
]
}
]
}
]
}
]
}
]
}
]
}
]
}
]
}
]
}
04. ASSUNTOS RELACIONADOS
FWRestModel - API RESTful dos modelos de dados do Protheus
Integração do Easy Import Control via API REST
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas