
_Créditos da imagem: Gerada com auxílio do Copilot_
#### Request
```json
{
"ClassName": "dna.tech.JSONCoreFunction",
"FunctionName": "MemoRead",
"FunctionParameters": {
"cFile": {
"type": "O",
"value": {
"ClassName": "dna.tech.JSONCoreFunction",
"FunctionName": "Eval",
"FunctionParameters": {
"CodeBlock": {
"type": "B",
"value": "{|odbTools|odbTools:cFile()}"
},
"odbTools": {
"type": "O",
"value": {
"ClassName": "dna.tech.JSONCoreFunction",
"FunctionName": "dna.tech.dbTools():ToJSON",
"FunctionParameters": {
"cQuery": "SELECT SX5.* FROM SX5010 SX5 WHERE SX5.X5_TABELA='32'",
"cFile": null,
"cJSONMain": "dna.tech.JSONCoreFunction",
"lX3Titulo": false,
"lIEmptyFields": false,
"lHeader": true,
"lRowNumber": true
}
}
}
}
}
}
},
"cHTTPCTType": "application/json; charset=UTF-8",
"lHTTPCTType": true
}
```
#### Result
```json
{
"table": "dna.tech.JSONCoreFunction",
"Header": [
[
"X5_FILIAL",
"C",
2,
0
],
[
"X5_TABELA",
"C",
2,
0
],
[
"X5_CHAVE",
"C",
6,
0
],
[
"X5_DESCRI",
"C",
55,
0
],
[
"X5_DESCSPA",
"C",
55,
0
],
[
"X5_DESCENG",
"C",
55,
0
],
[
"R_E_C_N_O_",
"N",
15,
0
],
[
"R_E_C_D_E_L_",
"N",
15,
0
]
],
"items": [
{
"Row": 1,
"item": [
"",
"32",
"A",
"FUNCIONARIO RECEBE ANUENIO",
"EMPLEADO COBRA ANUENIO",
"EMPLOYEE RECEIVES ANNUAL",
9385,
0
]
},
{
"Row": 2,
"item": [
"",
"32",
"B",
"FUNCIONARIO RECEBE BIENIO",
"FUNCIONARIO RECIBE BIENIO",
"EMPLOYEE RECEIVES BIENNIUM",
9386,
0
]
},
{
"Row": 3,
"item": [
"",
"32",
"D",
"FUNCIONARIO RECEBE QUADRIENIO",
"EMPLEADO COBRA CUADRIENIO",
"EMPLOYEE RECEIVES QUADRENNIAL",
9387,
0
]
},
{
"Row": 4,
"item": [
"",
"32",
"N",
"FUNCIONARIO NAO RECEBE ADICIONAL",
"EMPLEADO NO COBRA ADICIONAL",
"EMPLOYEE DOES NOT RECEIVE ANY ADDITIONAL",
9388,
0
]
},
{
"Row": 5,
"item": [
"",
"32",
"Q",
"FUNCIONARIO RECEBE QUINQUENIO",
"EMPLEADO COBRA QUINQUENIO",
"EMPLOYEE RECEIVES QUINQUENNIUM",
9389,
0
]
},
{
"Row": 6,
"item": [
"",
"32",
"T",
"FUNCIONARIO RECEBE TRIENIO",
"EMPLEADO RECIBE CAPACITACION",
"EMPLOYEE RECEIVES TRIENNIAL",
9390,
0
]
}
]
}
```
Comentários
Postar um comentário