BlackTDN :: Select * From Custom Data Table in Data Model :: userRestCrudTLPPCoreFunction :: AllToJSON

![All To JSON](https://files.oaiusercontent.com/file-5vrE97EYZMdR8b7NNOeYilbQ?se=2024-10-09T16%3A19%3A10Z&sp=r&sv=2024-08-04&sr=b&rscc=max-age%3D604800%2C%20immutable%2C%20private&rscd=attachment%3B%20filename%3D0ed63ef3-a94f-4355-9ec5-42e77c94a604.webp&sig=Ldyx4bXhS4qJFm4G1nKFtC3L7S8blTRyJzK58c1lB0o%3D)
_Créditos da imagem: Gerada com auxílio do ChatGPT_

#### Request

```json
{
    "ClassName":"userRestCrudTLPPCoreFunction",
    "FunctionName":"dna.tech.codModelPost",
    "codModel":"TURNOVERGERALEMPRESA",
    "PageNumber":1,
    "RowspPage":10,
    "parModel":"ewogICJwYXJhbWV0ZXJzIjogWwogICAgWyIhRU1QUkVTQSEiLCInMDEnIl0sCiAgICBbIiFGSUxJQUxERSEiLCInMDEnIl0sCiAgICBbIiFGSUxJQUxBVEUhIiwiJzA4JyJdLAogICAgWyIhREFUQVJRREUhIiwiJzIwMjQwMSciXSwKICAgIFsiIURBVEFSUUFURSEiLCInMjAyNDEyJyJdLAogICAgWyIhQ0NERSEiLCInICciXSwKICAgIFsiIUNDQVRFISIsIid6JyJdLAogICAgWyIhRlVOQ0FPREUhIiwiJyAnIl0sCiAgICBbIiFGVU5DQU9BVEUhIiwiJ3onIl0KICBdCn0K"    
}
```

#### Result

```json
{
    "method": "get",
    "path": "/userRestCrudADVPL/codModel/",
    "PageNumber": 1,
    "RowspPage": 9,
    "model": "TURNOVERGERALEMPRESA",
    "table": {
        "alias": "SCGN0000AB",
        "name": "",
        "description": "",
        "index": "PERIODO",
        "items": [
            {
                "detail": {
                    "row": 1,
                    "HasError": false,
                    "key": "202401",
                    "recNo": 1,
                    "items": {
                        "codPeriodo": "202401",
                        "totalTransferenciasSaida": 583,
                        "totalTransferenciasEntrada": 582,
                        "totalFuncionariosInicioMes": 722,
                        "totalFuncionariosAdmitidos": 34,
                        "totalFuncionariosMes": 756,
                        "totalFuncionariosDemitidos": 11,
                        "totalFuncionariosFinalMes": 745,
                        "turnOverGeral": 3.12,
                        "turnOverDemissoes": 0.76
                    }
                }
            },
            {
                "detail": {
                    "row": 2,
                    "HasError": false,
                    "key": "202402",
                    "recNo": 2,
                    "items": {
                        "codPeriodo": "202402",
                        "totalTransferenciasSaida": 47,
                        "totalTransferenciasEntrada": 45,
                        "totalFuncionariosInicioMes": 739,
                        "totalFuncionariosAdmitidos": 15,
                        "totalFuncionariosMes": 754,
                        "totalFuncionariosDemitidos": 12,
                        "totalFuncionariosFinalMes": 742,
                        "turnOverGeral": 1.83,
                        "turnOverDemissoes": 0.81
                    }
                }
            },
            {
                "detail": {
                    "row": 3,
                    "HasError": false,
                    "key": "202403",
                    "recNo": 3,
                    "items": {
                        "codPeriodo": "202403",
                        "totalTransferenciasSaida": 10,
                        "totalTransferenciasEntrada": 9,
                        "totalFuncionariosInicioMes": 742,
                        "totalFuncionariosAdmitidos": 18,
                        "totalFuncionariosMes": 760,
                        "totalFuncionariosDemitidos": 13,
                        "totalFuncionariosFinalMes": 747,
                        "turnOverGeral": 2.09,
                        "turnOverDemissoes": 0.88
                    }
                }
            },
            {
                "detail": {
                    "row": 4,
                    "HasError": false,
                    "key": "202404",
                    "recNo": 4,
                    "items": {
                        "codPeriodo": "202404",
                        "totalTransferenciasSaida": 20,
                        "totalTransferenciasEntrada": 14,
                        "totalFuncionariosInicioMes": 747,
                        "totalFuncionariosAdmitidos": 28,
                        "totalFuncionariosMes": 775,
                        "totalFuncionariosDemitidos": 23,
                        "totalFuncionariosFinalMes": 752,
                        "turnOverGeral": 3.41,
                        "turnOverDemissoes": 1.54
                    }
                }
            },
            {
                "detail": {
                    "row": 5,
                    "HasError": false,
                    "key": "202405",
                    "recNo": 5,
                    "items": {
                        "codPeriodo": "202405",
                        "totalTransferenciasSaida": 5,
                        "totalTransferenciasEntrada": 3,
                        "totalFuncionariosInicioMes": 751,
                        "totalFuncionariosAdmitidos": 10,
                        "totalFuncionariosMes": 761,
                        "totalFuncionariosDemitidos": 16,
                        "totalFuncionariosFinalMes": 745,
                        "turnOverGeral": 1.73,
                        "turnOverDemissoes": 1.07
                    }
                }
            },
            {
                "detail": {
                    "row": 6,
                    "HasError": false,
                    "key": "202406",
                    "recNo": 6,
                    "items": {
                        "codPeriodo": "202406",
                        "totalTransferenciasSaida": 1,
                        "totalTransferenciasEntrada": 1,
                        "totalFuncionariosInicioMes": 744,
                        "totalFuncionariosAdmitidos": 7,
                        "totalFuncionariosMes": 751,
                        "totalFuncionariosDemitidos": 23,
                        "totalFuncionariosFinalMes": 728,
                        "turnOverGeral": 2.02,
                        "turnOverDemissoes": 1.55
                    }
                }
            },
            {
                "detail": {
                    "row": 7,
                    "HasError": false,
                    "key": "202407",
                    "recNo": 7,
                    "items": {
                        "codPeriodo": "202407",
                        "totalTransferenciasSaida": 0,
                        "totalTransferenciasEntrada": 0,
                        "totalFuncionariosInicioMes": 729,
                        "totalFuncionariosAdmitidos": 10,
                        "totalFuncionariosMes": 739,
                        "totalFuncionariosDemitidos": 10,
                        "totalFuncionariosFinalMes": 729,
                        "turnOverGeral": 1.37,
                        "turnOverDemissoes": 0.69
                    }
                }
            },
            {
                "detail": {
                    "row": 8,
                    "HasError": false,
                    "key": "202408",
                    "recNo": 8,
                    "items": {
                        "codPeriodo": "202408",
                        "totalTransferenciasSaida": 0,
                        "totalTransferenciasEntrada": 0,
                        "totalFuncionariosInicioMes": 729,
                        "totalFuncionariosAdmitidos": 0,
                        "totalFuncionariosMes": 729,
                        "totalFuncionariosDemitidos": 0,
                        "totalFuncionariosFinalMes": 729,
                        "turnOverGeral": 0,
                        "turnOverDemissoes": 0
                    }
                }
            },
            {
                "detail": {
                    "row": 9,
                    "HasError": false,
                    "key": "202409",
                    "recNo": 9,
                    "items": {
                        "codPeriodo": "202409",
                        "totalTransferenciasSaida": 0,
                        "totalTransferenciasEntrada": 0,
                        "totalFuncionariosInicioMes": 729,
                        "totalFuncionariosAdmitidos": 0,
                        "totalFuncionariosMes": 729,
                        "totalFuncionariosDemitidos": 0,
                        "totalFuncionariosFinalMes": 729,
                        "turnOverGeral": 0,
                        "turnOverDemissoes": 0
                    }
                }
            }
        ]
    },
    "hasNextPage": false,
    "TotalPages": 1
}
```

#### Ou... Request

```json
{
    "ClassName":"userRestCrudTLPPCoreFunction",
    "FunctionName":"dna.tech.codModelPost",
    "codModel":"CAMPOS",
    "PageNumber":1,
    "RowspPage":5,
    "Filter" : "X3_ARQUIVO='CTT' AND X3_CAMPO<>'' AND X3_VISUAL<>'V'"
}
```

#### Result

```json
{
    "method": "get",
    "path": "/userRestCrudADVPL/codModel/",
    "PageNumber": 1,
    "RowspPage": 5,
    "model": "CAMPOS",
    "table": {
        "alias": "SX3",
        "name": "SX3010",
        "description": "",
        "index": "X3_ARQUIVO+X3_ORDEM",
        "items": [
            {
                "detail": {
                    "row": 1,
                    "HasError": false,
                    "key": "CTT01",
                    "recNo": 25686,
                    "items": {
                        "fieldAlias": "CTT",
                        "fieldName": "CTT_FILIAL",
                        "fieldDesc": "Filial do Sistema",
                        "fieldDescEng": "System Branch",
                        "fieldDescSpa": "Sucursal del Sistema",
                        "fieldType": "C",
                        "fieldSize": 2,
                        "fieldDec": 0,
                        "fieldPicture": "",
                        "fieldCBox": ""
                    }
                }
            },
            {
                "detail": {
                    "row": 2,
                    "HasError": false,
                    "key": "CTT02",
                    "recNo": 25687,
                    "items": {
                        "fieldAlias": "CTT",
                        "fieldName": "CTT_CUSTO",
                        "fieldDesc": "Centro de Custo",
                        "fieldDescEng": "Cost Center",
                        "fieldDescSpa": "Centro de Costo",
                        "fieldType": "C",
                        "fieldSize": 9,
                        "fieldDec": 0,
                        "fieldPicture": "@!",
                        "fieldCBox": ""
                    }
                }
            },
            {
                "detail": {
                    "row": 3,
                    "HasError": false,
                    "key": "CTT03",
                    "recNo": 25688,
                    "items": {
                        "fieldAlias": "CTT",
                        "fieldName": "CTT_CLASSE",
                        "fieldDesc": "Classe",
                        "fieldDescEng": "Class",
                        "fieldDescSpa": "Clase",
                        "fieldType": "C",
                        "fieldSize": 1,
                        "fieldDec": 0,
                        "fieldPicture": "@!",
                        "fieldCBox": "1=Sintetico;2=Analitico"
                    }
                }
            },
            {
                "detail": {
                    "row": 4,
                    "HasError": false,
                    "key": "CTT04",
                    "recNo": 25689,
                    "items": {
                        "fieldAlias": "CTT",
                        "fieldName": "CTT_NORMAL",
                        "fieldDesc": "Condicao Normal",
                        "fieldDescEng": "Regular Condition",
                        "fieldDescSpa": "Condicion Normal",
                        "fieldType": "C",
                        "fieldSize": 1,
                        "fieldDec": 0,
                        "fieldPicture": "@!",
                        "fieldCBox": "0=Nenhum;1=Despesa;2=Receita"
                    }
                }
            },
            {
                "detail": {
                    "row": 5,
                    "HasError": false,
                    "key": "CTT05",
                    "recNo": 25690,
                    "items": {
                        "fieldAlias": "CTT",
                        "fieldName": "CTT_DESC01",
                        "fieldDesc": "Descricao Moeda 1",
                        "fieldDescEng": "Currency 1 Description",
                        "fieldDescSpa": "Descripcion Moneda 1",
                        "fieldType": "C",
                        "fieldSize": 40,
                        "fieldDec": 0,
                        "fieldPicture": "@!",
                        "fieldCBox": ""
                    }
                }
            }
        ]
    },
    "hasNextPage": true,
    "NextPage": 2,
    "TotalPages": 18
}
```