Base de conhecimento
Encontre respostas para suas dúvidas em quatro fontes de conhecimento diferentes ao mesmo tempo, simplificando o processo de pesquisa.
  1. Central de Atendimento TOTVS
  2. TOTVS Carol
  3. TOTVS CAROL - CAROL CONNECT (2C)
Central do Cliente

TOTVS CAROL - Carol Connect (2C) - Como utilizar o 2C via Swagger-API?

Com o novo 2C é possível utilizar o 2C via API, siga os passos a seguir para autenticar e utilizar as principais requisições disponíveis.

 

Acessar o Swagger

Após acessar o 2C, clique no ícone do usuário no canto superior direito, e acesse a opção Go to Swagger API

 

mceclip0.png

Assim será aberta uma nova aba com as requisições disponíveis:

mceclip1.png

 

 

Autorização

Para utilizar as principais requisições é necessário realizar a autorização com um Token de Login válido do 2C, siga os passos abaixo para obter um token de autorização para utilizar no 2C.

 

Obtendo um token via API

Utilize a requisição /api/v2/auth/login clique em Try it out

mceclip6.png

Preencha os campos do Request body conforme seus dados de acesso na Carol

mceclip8.png

Segue um exemplo de preenchimento, depois clique em Execute para obter o resultado, um token válido

mceclip7.png

Resultado

mceclip9.png

Agora podemos preencher a autorização no swagger com esse token, clique em Authorize

mceclip4.png

 

 

  • Faça um Login no 2C com a Ferramenta de Desenvolvedor ativa;
  • realize um Logout caso o usuário já esteja logado;
  • ative a Ferramenta de Desenvolvedor com a Aba ativa do navegador no 2C com a tecla F12 do teclado;

mceclip2.png

Inspecionando a requisição de login encontramos o token obtido no login

mceclip3.png

Agora podemos preencher a autorização no swagger com esse token, clique em Authorize

mceclip4.png

Preencha o valor do Token, depois clique em Authorize, e em seguida em Close

mceclip5.png

 

Criar uma Conexão com o Banco de Dados

Iremos utilizar a API POST /api/v2/connection

 

Não temos que fornecer parâmetros, porém o Request body contém alguns itens que podemos obter executando outras requisições de API, e cada banco de dados possui parâmetros distintos de conexão, vamos realizar um exemplo com SQL SERVER, mas evidenciaremos como obter cada parâmetro de cada banco a seguir. Abaixo segue o exemplo padrão o Request body, analisaremos cada item.

{

  "id": "string",

  "alias": "string",

  "type": "ORACLE",

  "supportsOnline": true,

  "supportsTriggers": true,

  "datasulGPS": true,

  "connector": {

    "id": "string",

    "name": "string",

    "label": "string",

    "project": "string",

    "connectorTokens": [

      {

        "connectorId": "string",

        "createdDate": "2022-05-13T01:09:38.133Z",

        "createdUser": "string",

        "description": "string"

      }

    ]

  },

  "environment": {

    "id": "string",

    "name": "string",

    "subDomain": "string",

    "label": "string"

  },

  "play": true,

  "loadingTables": true,

  "online": true,

  "config": [

    {

      "type": "TEXT",

      "identifier": "string",

      "name": "string",

      "possibleValues": {

        "componentList": [

          {

            "key": "string",

            "value": "string"

          }

        ]

      },

      "instructions": "string",

      "value": {}

    }

  ]

}

 

id : Identificação UUID da conexão. EX: 0afbac9e1b7789b729619b89aa5e5095c18a1dc6 (Utilizar nesse formato para a Carol identificar, para mais de uma conexão, alterar qualquer letra ou número)

alias: Nome, apelido para indicar nominalmente a conexão. EX: MSSQL SERVER

type: Qual o bando de Dados utilizado na conexão. Esse temos valores que podem ser obtidos executando uma outra requisição:

Executando a /api/v2database temos:

[ { "type": "oracle", "name": "Oracle" }, { "type": "sql_server", "name": "SQL Server" }, { "type": "postgres", "name": "PostgreSQL" }, { "type": "mysql", "name": "MySQL" }, { "type": "openedge", "name": "OpenEdge" }, { "type": "directory", "name": "Directory" }, { "type": "mongodb", "name": "MongoDB" } ]

Para conectar com MSSQL SERVER utiizaremos então o type = 'sql_server', para qualquer outro banco basta preencher conforme o type demostrado.

supportsOnline: Indica se o bando de dados suporta o envio online. Ex true ou false

supportsTriggers: Indica se o bando de dados suporta o envio via Triggers. Ex true ou false

datasulGPS: Indica se o bando de Dados utiliza a tabela de fila Totvs Health, opção utilizada em conexões com Datasul do segmento de Saúde. Ex true ou false

connector: Identifica e informa os parâmetros necessários do connector na Carol para onde serão enviados os dados pelo 2C. Nesse caso precisamos informar os seguintes parâmetros, que podem ser obtidos executando uma outra requisição:

  • id
  • name
  • label
  • project
  • connectorTokens
    • connectorId
    • createDate
    • createUser
    • description

 

Executando a /api/v2/connector/{environmentId}

  • Para obter o environmentId precisamos executar outra requisição:
    • Environment API /api/v2/environment

Valor obtido :

0a0601c0a40f11e7a981dec7170128a9

Retornando para a /api/v2/connector/{environmentId}

 {

    "id": "68a81f3364ef413b8cdc8f548e8e9b6d",

    "name": "mssqlprotheus",

    "label": "MSSQL Protheus",

    "project": "Test",

    "connectorTokens": []

  }

  • id = "68a81f3364ef413b8cdc8f548e8e9b6d"
  • name = "mssqlprotheus"
  • label = "MSSQL Protheus"
  • project = "Test"
  • connectorTokens
    • connectorId
    • createDate
    • createUser
    • description

As informações sobre connectorTokens são obtidas dentro da plataforma da Carol, seguindo os seguintes passos:

No ambiente da Carol, clicar no ícone do usuário

Clicar na opção Environment Admin

Clicando na opção Tokens

  • connectorTokens
    • connectorId = 68a81f3364ef413b8cdc8f548e8e9b6d
    • createDate =2022-05-13T09:34:42.152Z(Importante seguir o formato)
    • createUser = chamam.caires@totvs.com (Email do usuário da Carol utilizado no 2C para criar o token)
    • description = Generated by 2C (Quando gerado pelo 2C o token já vem com essa descrição para identificar onde ele foi gerado, caso o Token seja gerado manualmente na Carol, você pode preencher com uma descrição que identifique esse Token)

Com essas informações o preenchimento da conexão por enquanto ficou assim

{

"id": "0afbac9e1b7789b729619b89aa5e5095c18a1dc6",

"alias": "MSSQL SERVER",

"type": "sql_server",

"supportsOnline": true,

"supportsTriggers": true,

"datasulGPS": false,

"connector": {

  "id": "0a0601c0a40f11e7a981dec7170128a9",

  "name": "mssqlprotheus",

  "label": "MSSQL Protheus",

  "project": "Test",

  "connectorTokens": [

     {

       "connectorId": "0a0601c0a40f11e7a981dec7170128a9",

       "createdDate": "2022-05-13T09:34:42.152Z",

       "createdUser": "chamam.caires@totvs.com",

       "description": "Generated by 2C"

     }

  ]

}

Seguindo para o próximo bloco de parâmetros temos os itens para identificar o ambiente/tenant onde serão enviados os dados para a Carol:

"environment": {

   "id": "string",

   "name": "string",

   "subDomain": "string",

   "label": "string"

}

Temos que executar outra api para obter esses dados /api/v2/environment

mceclip2.png

id : 0a0601c0a40f11e7a981dec7170128a9

name: qas

subDomain: qas

label: qas

Próximos parâmetros são referentes ao status da conexão, por padrão esses itens são iniciados com o valor true:

play: true
loadingTables: true
online: true

Vamos consolidar de novo os parâmetros de forma geral antes de ir para os próximos itens

{
"id": "0afbac9e1b7789b729619b89aa5e5095c18a1dc6",
"alias": "MSSQL SERVER",
"type": "sql_server",
"supportsOnline": true,
"supportsTriggers": true,
"datasulGPS": false,
"connector": {
    "id": "0a0601c0a40f11e7a981dec7170128a9",
    "name": "mssqlprotheus",
    "label": "MSSQL Protheus",
    "project": "Test",
    "connectorTokens": [
    {
        "connectorId": "0a0601c0a40f11e7a981dec7170128a9",
        "createdDate": "2022-05-13T09:34:42.152Z",
        "createdUser": "chamam.caires@totvs.com",
        "description": "Generated by 2C"
    }
  ]
},
"environment": {
     "id": "0a0601c0a40f11e7a981dec7170128a9",
"name": "qas",
"subDomain": "qas",
"label": "qas"
},
"play": true,
"loadingTables": true,
"online": true

O próximo item é o config onde informamos os parâmetros de conexão de fato para se conectar com o banco de dados, como cada um deles possuem itens distintos para realizar essa tarefa, temos uma outra API que podemos consultar pelo type de cada banco para obter esses parâmetros. Segue exemplos:

Relembrando que executando a /api/v2database temos os types de cada banco:

[ { "type": "oracle", "name": "Oracle" }, { "type": "sql_server", "name": "SQL Server" }, { "type": "postgres", "name": "PostgreSQL" }, { "type": "mysql", "name": "MySQL" }, { "type": "openedge", "name": "OpenEdge" }, { "type": "directory", "name": "Directory" }, { "type": "mongodb", "name": "MongoDB" } ]

Para cosultar os parâmetros do MSSQL SERVER utiizaremos então o type = 'sql_server', e iremos obter os seguintes itens

{ "type": "sql_server", "name": "SQL Server", "config": [ { "type": "TEXT", "identifier": "sqlserver.host", "name": "IP or Hostname", "instructions": "Input the database IP or Hostname in order to connect" }, { "type": "INTEGER", "identifier": "sqlserver.port", "name": "Port", "instructions": "Please, input Sql Server network port. The default is 1433." }, { "type": "TEXT", "identifier": "sqlserver.instancename", "name": "Instance name / path", "instructions": "This is the instance name for the database. Use it without slashes or dots. The default is MSSQLSERVER" }, { "type": "TEXT", "identifier": "sqlserver.username", "name": "Username", "instructions": "Input the username to connect to the Sql Server database" }, { "type": "PASSWORD", "identifier": "sqlserver.password", "name": "User's password on this database", "instructions": "For the given user, input the password" }, { "type": "TEXT", "identifier": "sqlserver.databasename", "name": "Database name", "instructions": "Input the database name to connect to" }, { "type": "TEXT", "identifier": "sqlserver.schemaname", "name": "Schema name (normally, dbo)", "instructions": "Input the schema to be watched" }, { "type": "MULTIPLE_VALUE", "identifier": "sqlserver.authentication", "name": "SQL Server authentication type?", "possibleValues": { "componentList": [ { "key": "NotSpecified", "value": "NotSpecified" }, { "key": "ActiveDirectoryPassword", "value": "ActiveDirectoryPassword" } ] }, "instructions": "What is the type of authentication used by SQL Server? The default is Not Specified." }, { "type": "MULTIPLE_VALUE", "identifier": "sqlserver.protheus", "name": "TOTVS Protheus database?", "possibleValues": { "componentList": [ { "key": "false", "value": "false" }, { "key": "true", "value": "true" } ] }, "instructions": "Is this database connection a TOTVS Protheus database? The default is false." }, { "type": "MULTIPLE_VALUE", "identifier": "sqlserver.protheuscompaycode", "name": "TOTVS Protheus use company group code from table name?", "possibleValues": { "componentList": [ { "key": "false", "value": "false" }, { "key": "true", "value": "true" } ] }, "instructions": "Use company group code from table name? The default is false." }, { "type": "TEXT", "identifier": "sqlserver.companycodes", "name": "TOTVS Protheus company group codes", "instructions": "Input company group codes separated by commas. The default is consider all company groups" } ] }

Caso seja o type = 'oracle', teremos outros itens:

{ "type": "oracle", "name": "Oracle", "config": [ { "type": "TEXT", "identifier": "oracle.host", "name": "IP or Hostname", "instructions": "Input the database IP or Hostname in order to connect" }, { "type": "INTEGER", "identifier": "oracle.port", "name": "Port", "instructions": "Please, input Oracle's network port. The default is 1521." }, { "type": "TEXT", "identifier": "oracle.username", "name": "Username", "instructions": "Input the username to connect to the Oracle database" }, { "type": "PASSWORD", "identifier": "oracle.password", "name": "User's password on this database", "instructions": "For the given user, input the password" }, { "type": "TEXT", "identifier": "oracle.schemaname", "name": "Schema name (normally, the same as the user's name)", "instructions": "Input the schema to be watched" }, { "type": "MULTIPLE_VALUE", "identifier": "oracle.serviceorsid.choice", "name": "Connection type - Service or SID? ", "possibleValues": { "componentList": [ { "key": "SID", "value": "SID" }, { "key": "SERVICE_NAME", "value": "SERVICE_NAME" } ] }, "instructions": "Select if you either want to connect to the database using a SID or a Service Name" }, { "type": "TEXT", "identifier": "oracle.serviceorsid", "name": "Service or SID name: ", "instructions": "Informe the SID or Service Name" }, { "type": "MULTIPLE_VALUE", "identifier": "oracle.protheus", "name": "TOTVS Protheus database?", "possibleValues": { "componentList": [ { "key": "false", "value": "false" }, { "key": "true", "value": "true" } ] }, "instructions": "This database connection is a TOTVS Protheus database? The default is false." }, { "type": "MULTIPLE_VALUE", "identifier": "oracle.protheuscompaycode", "name": "TOTVS Protheus use company group code from table name?", "possibleValues": { "componentList": [ { "key": "false", "value": "false" }, { "key": "true", "value": "true" } ] }, "instructions": "Use company group code from table name? The default is false." }, { "type": "TEXT", "identifier": "oracle.companycodes", "name": "TOTVS Protheus company group codes", "instructions": "Input company group codes separated by commas. The default is consider all company groups" }, { "type": "MULTIPLE_VALUE", "identifier": "oracle.dsHealth", "name": "TOTVS Health - Line Datasul?", "possibleValues": { "componentList": [ { "key": "false", "value": "false" }, { "key": "true", "value": "true" } ] }, "instructions": "This database connection is a TOTVS Health - Line Datasul? The default is false." }, { "type": "TEXT", "identifier": "oracle.dffile", "name": "TOTVS Datasul Schema Holder DF File", "instructions": "Input the DF file name" } ] }

Nem todos os itens são obrigatórios, de acordo com cada banco de dados, o nosso request body completo ficaria assim

{
"id":"0afbac9e1b7789b729619b89aa5e5095c18a1dc6",
"alias":"MSSQL SERVER",
"type":"sql_server",
"supportsOnline":true,
"supportsTriggers":true,
"datasulGPS":false,
"connector":{
    "id":"0a0601c0a40f11e7a981dec7170128a9",
    "name":"mssqlprotheus",
    "label":"MSSQL Protheus",
    "project":"Test",
    "connectorTokens":[
        {
          "connectorId":"0a0601c0a40f11e7a981dec7170128a9",
          "createdDate":"2022-05-13T09:34:42.152Z",
          "createdUser":"chamam.caires@totvs.com",
          "description":"Generated by 2C"
        }
     ]
},
"environment":{
     "id":"0a0601c0a40f11e7a981dec7170128a9", 
     "name":"qas",
     "subDomain":"qas",
     "label":"qas"
},
"play":true,
"loadingTables":true,
"online":true,
"config":[
   {
     "type":"TEXT",
     "identifier":"sqlserver.host",
     "name":"IP or Hostname",
     "instructions":"Input the database IP or Hostname in order to connect",
     "value":"localhost"
   },
   {
     "type":"INTEGER",
     "identifier":"sqlserver.port",
     "name":"Port",
     "instructions":"Please, input Sql Server network port. The default is 1433.",
     "value":"1433"
   },
   {
     "type":"TEXT",
     "identifier":"sqlserver.instancename",
     "name":"Instance name / path",
     "instructions":"This is the instance name for the database. Use it without slashes or dots. The default is MSSQLSERVER"
   },
   {
     "type":"TEXT",
     "identifier":"sqlserver.username",
     "name":"Username",
     "instructions":"Input the username to connect to the Sql Server database",
     "value":"sa"
   },
   {
     "type":"PASSWORD",
     "identifier":"sqlserver.password",
     "name":"User's password on this database",
     "instructions":"For the given user, input the password",
     "value":"totvs@123"
   },
   {
     "type":"TEXT",
     "identifier":"sqlserver.databasename",
     "name":"Database name",
     "instructions":"Input the database name to connect to",
     "value":"P12125MNTDB"
   },
   {
     "type":"TEXT",
     "identifier":"sqlserver.schemaname",
     "name":"Schema name (normally, dbo)",
     "instructions":"Input the schema to be watched",
     "value":"dbo"
   },
   {
     "type":"MULTIPLE_VALUE",
     "identifier":"sqlserver.authentication",
     "name":"SQL Server authentication type?",
     "possibleValues":{
     "componentList":[
        {
          "key":"NotSpecified",
          "value":"NotSpecified"
        },
        {
          "key":"ActiveDirectoryPassword",
          "value":"ActiveDirectoryPassword"
        }
     ]
   },
   "instructions":"What is the type of authentication used by SQL Server? The default is Not Specified.",
   "value":"NotSpecified"
   },
{
"type":"MULTIPLE_VALUE",
"identifier":"sqlserver.protheus",
"name":"TOTVS Protheus database?",
"possibleValues":{
    "componentList":[
   {
     "key":"false",
     "value":"false"
   },
   {
     "key":"true",
     "value":"true"
    }
   ]
},
   "instructions":"Is this database connection a TOTVS Protheus database? The default is false.",
   "value":"false"},
{
"type":"MULTIPLE_VALUE",
"identifier":"sqlserver.protheuscompaycode",
"name":"TOTVS Protheus use company group code from table name?",
"possibleValues":{
     "componentList":[
     {
        "key":"false",
        "value":"false"
     },
     {
        "key":"true",
        "value":"true"
     }
     ]
  },
"instructions":"Use company group code from table name? The default is false.",
"value":"false"},
{
"type":"TEXT",
"identifier":"sqlserver.companycodes",
"name":"TOTVS Protheus company group codes",
"instructions":"Input company group codes separated by commas. The default is consider all company groups"}]
}

Conexão criada com Sucesso

mceclip4.png

Verificando na interface gráfica do 2C

mceclip5.png

Habilitar uma entidade pra enviar para a Carol

Após criar uma conexão, temos um Id, esse item é importante pois temos que informá-lo para habilitar uma tabela, no nosso exemplo temos o seguinte valor 

id: 0afbac9e1b7789b729619b89aa5e5095c18a1dc6

A api utilizada é a seguinte PUT /api/v2/entity/{connectionIdd}

mceclip6.png

Veja que temos um parâmetro que precisa ser informado, connectionId, e posteriormente o request body com as informações da tabela 

{
  "tableName": "AA1T10",
  "fields": [
    {
      "name": "string",
      "type": "STRING",
      "isPrimaryKey": true,
      "isArtificialKey": true,
      "isTimestamp": true,
      "isTrigger": true,
      "isSelectedToSync": true,
      "anonymization": {
        "field": "string",
        "type": "NONE",
        "options": "string"
      }
    }
  ],
  "enabled": true,
  "play": true,
  "conditionalSql": "string",
  "syncByTimestamp": true,
  "syncByFullLoad": true,
  "carolModel": true,
  "lookupTable": true,
  "initialDate": "2022-05-14",
  "initialNumber": 0,
  "daysToResend": 0,
  "basedOnLastSync": true,
  "cdsClearData": true,
  "generateFirstFullLoad": true,
  "status": "DISABLED",
  "hasPrimaryKey": true,
  "hasArtificialKey": true,
  "totalRecords": 0,
  "resendData": true,
  "triggerWhenInsert": true,
  "triggerWhenUpdate": true,
  "triggerWhenDelete": true,
  "view": true
}

Para obter os campos (fields) da tabela em questão, precisamos executar outra requisição 

/api/v2/entity/{connectionId}/{tableName}

mceclip7.png

Passando como parâmetros o Id da conexão que obtivemos anteriormente e o nome da tabela, no nosso exemplo com a tabela AA1T10, temos o seguinte resultado:

{ "tableName": "AA1T10", "fields": [ { "name": "AA1_FILIAL", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_FILIAL", "type": "NONE" } }, { "name": "AA1_CODTEC", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CODTEC", "type": "NONE" } }, { "name": "AA1_NOMTEC", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_NOMTEC", "type": "NONE" } }, { "name": "AA1_FUNCAO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_FUNCAO", "type": "NONE" } }, { "name": "AA1_CC", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CC", "type": "NONE" } }, { "name": "AA1_CENTRA", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CENTRA", "type": "NONE" } }, { "name": "AA1_PAGER", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_PAGER", "type": "NONE" } }, { "name": "AA1_EMAIL", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_EMAIL", "type": "NONE" } }, { "name": "AA1_FONE", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_FONE", "type": "NONE" } }, { "name": "AA1_REGIAO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_REGIAO", "type": "NONE" } }, { "name": "AA1_TURNO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_TURNO", "type": "NONE" } }, { "name": "AA1_VALOR", "type": "DOUBLE", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": false, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_VALOR", "type": "NONE" } }, { "name": "AA1_RATE", "type": "DOUBLE", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": false, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_RATE", "type": "NONE" } }, { "name": "AA1_EMINFI", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_EMINFI", "type": "NONE" } }, { "name": "AA1_CUSTO", "type": "DOUBLE", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": false, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CUSTO", "type": "NONE" } }, { "name": "AA1_FUNPRO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_FUNPRO", "type": "NONE" } }, { "name": "AA1_LOCAL", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_LOCAL", "type": "NONE" } }, { "name": "AA1_LIBOSV", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_LIBOSV", "type": "NONE" } }, { "name": "AA1_LOCLZB", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_LOCLZB", "type": "NONE" } }, { "name": "AA1_LOCLZR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_LOCLZR", "type": "NONE" } }, { "name": "AA1_DULTES", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_DULTES", "type": "NONE" } }, { "name": "AA1_LOCLZF", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_LOCLZF", "type": "NONE" } }, { "name": "AA1_CULTES", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CULTES", "type": "NONE" } }, { "name": "AA1_DATUES", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_DATUES", "type": "NONE" } }, { "name": "AA1_CATUES", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CATUES", "type": "NONE" } }, { "name": "AA1_REQPEC", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_REQPEC", "type": "NONE" } }, { "name": "AA1_DATADM", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_DATADM", "type": "NONE" } }, { "name": "AA1_DATDEM", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_DATDEM", "type": "NONE" } }, { "name": "AA1_CODVEN", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CODVEN", "type": "NONE" } }, { "name": "AA1_NOMUSU", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_NOMUSU", "type": "NONE" } }, { "name": "AA1_TIPO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_TIPO", "type": "NONE" } }, { "name": "AA1_CODUSR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CODUSR", "type": "NONE" } }, { "name": "AA1_CONTRB", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CONTRB", "type": "NONE" } }, { "name": "AA1_TIPVEN", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_TIPVEN", "type": "NONE" } }, { "name": "AA1_ALOCA", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_ALOCA", "type": "NONE" } }, { "name": "AA1_CODFOR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CODFOR", "type": "NONE" } }, { "name": "AA1_LOJFOR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_LOJFOR", "type": "NONE" } }, { "name": "AA1_ACESSO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_ACESSO", "type": "NONE" } }, { "name": "AA1_CDFUNC", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CDFUNC", "type": "NONE" } }, { "name": "AA1_VISTOR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_VISTOR", "type": "NONE" } }, { "name": "AA1_VISVLR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_VISVLR", "type": "NONE" } }, { "name": "AA1_VISPRO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_VISPRO", "type": "NONE" } }, { "name": "AA1_IMPPRO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_IMPPRO", "type": "NONE" } }, { "name": "AA1_CATEGO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CATEGO", "type": "NONE" } }, { "name": "AA1_ALTVIS", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_ALTVIS", "type": "NONE" } }, { "name": "AA1_FTVIST", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_FTVIST", "type": "NONE" } }, { "name": "AA1_CRMSIM", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CRMSIM", "type": "NONE" } }, { "name": "AA1_FUNFIL", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_FUNFIL", "type": "NONE" } }, { "name": "AA1_MPONTO", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_MPONTO", "type": "NONE" } }, { "name": "AA1_SEQTUR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_SEQTUR", "type": "NONE" } }, { "name": "AA1_PERQTD", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_PERQTD", "type": "NONE" } }, { "name": "AA1_VINCUL", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_VINCUL", "type": "NONE" } }, { "name": "AA1_RSPMNT", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_RSPMNT", "type": "NONE" } }, { "name": "AA1_RSPTRA", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_RSPTRA", "type": "NONE" } }, { "name": "AA1_EXTVIG", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_EXTVIG", "type": "NONE" } }, { "name": "AA1_CNV", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_CNV", "type": "NONE" } }, { "name": "AA1_NREDUZ", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_NREDUZ", "type": "NONE" } }, { "name": "AA1_SENHA", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_SENHA", "type": "NONE" } }, { "name": "AA1_TIPMAR", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "AA1_TIPMAR", "type": "NONE" } }, { "name": "D_E_L_E_T_", "type": "STRING", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "D_E_L_E_T_", "type": "NONE", "options": "" } }, { "name": "R_E_C_N_O_", "type": "INTEGER", "isPrimaryKey": true, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "R_E_C_N_O_", "type": "NONE", "options": "" } }, { "name": "R_E_C_D_E_L_", "type": "INTEGER", "isPrimaryKey": false, "isArtificialKey": false, "isTimestamp": true, "isTrigger": false, "isSelectedToSync": false, "anonymization": { "field": "R_E_C_D_E_L_", "type": "NONE", "options": "" } } ], "enabled": true, "play": true, "conditionalSql": "", "syncByTimestamp": false, "syncByFullLoad": false, "carolModel": false, "lookupTable": false, "initialNumber": 0, "daysToResend": 0, "basedOnLastSync": false, "cdsClearData": false, "generateFirstFullLoad": true, "status": "ENABLED", "hasPrimaryKey": true, "hasArtificialKey": false, "totalRecords": 78, "resendData": true, "triggerWhenInsert": true, "triggerWhenUpdate": true, "triggerWhenDelete": true, "view": false }

Assim o request body completo ficaria assim

{
"tableName": "AA1T10",
"fields": [
{
"name": "AA1_FILIAL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FILIAL",
"type": "NONE"
}
},
{
"name": "AA1_CODTEC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODTEC",
"type": "NONE"
}
},
{
"name": "AA1_NOMTEC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_NOMTEC",
"type": "NONE"
}
},
{
"name": "AA1_FUNCAO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FUNCAO",
"type": "NONE"
}
},
{
"name": "AA1_CC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CC",
"type": "NONE"
}
},
{
"name": "AA1_CENTRA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CENTRA",
"type": "NONE"
}
},
{
"name": "AA1_PAGER",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_PAGER",
"type": "NONE"
}
},
{
"name": "AA1_EMAIL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_EMAIL",
"type": "NONE"
}
},
{
"name": "AA1_FONE",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FONE",
"type": "NONE"
}
},
{
"name": "AA1_REGIAO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_REGIAO",
"type": "NONE"
}
},
{
"name": "AA1_TURNO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TURNO",
"type": "NONE"
}
},
{
"name": "AA1_VALOR",
"type": "DOUBLE",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": false,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VALOR",
"type": "NONE"
}
},
{
"name": "AA1_RATE",
"type": "DOUBLE",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": false,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_RATE",
"type": "NONE"
}
},
{
"name": "AA1_EMINFI",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_EMINFI",
"type": "NONE"
}
},
{
"name": "AA1_CUSTO",
"type": "DOUBLE",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": false,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CUSTO",
"type": "NONE"
}
},
{
"name": "AA1_FUNPRO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FUNPRO",
"type": "NONE"
}
},
{
"name": "AA1_LOCAL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCAL",
"type": "NONE"
}
},
{
"name": "AA1_LIBOSV",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LIBOSV",
"type": "NONE"
}
},
{
"name": "AA1_LOCLZB",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCLZB",
"type": "NONE"
}
},
{
"name": "AA1_LOCLZR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCLZR",
"type": "NONE"
}
},
{
"name": "AA1_DULTES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DULTES",
"type": "NONE"
}
},
{
"name": "AA1_LOCLZF",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCLZF",
"type": "NONE"
}
},
{
"name": "AA1_CULTES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CULTES",
"type": "NONE"
}
},
{
"name": "AA1_DATUES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DATUES",
"type": "NONE"
}
},
{
"name": "AA1_CATUES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CATUES",
"type": "NONE"
}
},
{
"name": "AA1_REQPEC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_REQPEC",
"type": "NONE"
}
},
{
"name": "AA1_DATADM",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DATADM",
"type": "NONE"
}
},
{
"name": "AA1_DATDEM",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DATDEM",
"type": "NONE"
}
},
{
"name": "AA1_CODVEN",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODVEN",
"type": "NONE"
}
},
{
"name": "AA1_NOMUSU",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_NOMUSU",
"type": "NONE"
}
},
{
"name": "AA1_TIPO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TIPO",
"type": "NONE"
}
},
{
"name": "AA1_CODUSR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODUSR",
"type": "NONE"
}
},
{
"name": "AA1_CONTRB",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CONTRB",
"type": "NONE"
}
},
{
"name": "AA1_TIPVEN",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TIPVEN",
"type": "NONE"
}
},
{
"name": "AA1_ALOCA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_ALOCA",
"type": "NONE"
}
},
{
"name": "AA1_CODFOR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODFOR",
"type": "NONE"
}
},
{
"name": "AA1_LOJFOR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOJFOR",
"type": "NONE"
}
},
{
"name": "AA1_ACESSO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_ACESSO",
"type": "NONE"
}
},
{
"name": "AA1_CDFUNC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CDFUNC",
"type": "NONE"
}
},
{
"name": "AA1_VISTOR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VISTOR",
"type": "NONE"
}
},
{
"name": "AA1_VISVLR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VISVLR",
"type": "NONE"
}
},
{
"name": "AA1_VISPRO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VISPRO",
"type": "NONE"
}
},
{
"name": "AA1_IMPPRO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_IMPPRO",
"type": "NONE"
}
},
{
"name": "AA1_CATEGO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CATEGO",
"type": "NONE"
}
},
{
"name": "AA1_ALTVIS",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_ALTVIS",
"type": "NONE"
}
},
{
"name": "AA1_FTVIST",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FTVIST",
"type": "NONE"
}
},
{
"name": "AA1_CRMSIM",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CRMSIM",
"type": "NONE"
}
},
{
"name": "AA1_FUNFIL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FUNFIL",
"type": "NONE"
}
},
{
"name": "AA1_MPONTO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_MPONTO",
"type": "NONE"
}
},
{
"name": "AA1_SEQTUR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_SEQTUR",
"type": "NONE"
}
},
{
"name": "AA1_PERQTD",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_PERQTD",
"type": "NONE"
}
},
{
"name": "AA1_VINCUL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VINCUL",
"type": "NONE"
}
},
{
"name": "AA1_RSPMNT",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_RSPMNT",
"type": "NONE"
}
},
{
"name": "AA1_RSPTRA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_RSPTRA",
"type": "NONE"
}
},
{
"name": "AA1_EXTVIG",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_EXTVIG",
"type": "NONE"
}
},
{
"name": "AA1_CNV",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CNV",
"type": "NONE"
}
},
{
"name": "AA1_NREDUZ",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_NREDUZ",
"type": "NONE"
}
},
{
"name": "AA1_SENHA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_SENHA",
"type": "NONE"
}
},
{
"name": "AA1_TIPMAR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TIPMAR",
"type": "NONE"
}
},
{
"name": "D_E_L_E_T_",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "D_E_L_E_T_",
"type": "NONE",
"options": ""
}
},
{
"name": "R_E_C_N_O_",
"type": "INTEGER",
"isPrimaryKey": true,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "R_E_C_N_O_",
"type": "NONE",
"options": ""
}
},
{
"name": "R_E_C_D_E_L_",
"type": "INTEGER",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "R_E_C_D_E_L_",
"type": "NONE",
"options": ""
}
}
],
"enabled": true,
"play": true,
"conditionalSql": "",
"syncByTimestamp": false,
"syncByFullLoad": false,
"carolModel": false,
"lookupTable": false,
"initialDate": "2022-05-14",
"initialNumber": 0,
"daysToResend": 0,
"basedOnLastSync": true,
"cdsClearData": true,
"generateFirstFullLoad": true,
"status": "DISABLED",
"hasPrimaryKey": true,
"hasArtificialKey": false,
"totalRecords": 0,
"resendData": false,
"triggerWhenInsert": true,
"triggerWhenUpdate": true,
"triggerWhenDelete": true,
"view": false
}{
"tableName": "AA1T10",
"fields": [
{
"name": "AA1_FILIAL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FILIAL",
"type": "NONE"
}
},
{
"name": "AA1_CODTEC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODTEC",
"type": "NONE"
}
},
{
"name": "AA1_NOMTEC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_NOMTEC",
"type": "NONE"
}
},
{
"name": "AA1_FUNCAO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FUNCAO",
"type": "NONE"
}
},
{
"name": "AA1_CC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CC",
"type": "NONE"
}
},
{
"name": "AA1_CENTRA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CENTRA",
"type": "NONE"
}
},
{
"name": "AA1_PAGER",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_PAGER",
"type": "NONE"
}
},
{
"name": "AA1_EMAIL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_EMAIL",
"type": "NONE"
}
},
{
"name": "AA1_FONE",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FONE",
"type": "NONE"
}
},
{
"name": "AA1_REGIAO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_REGIAO",
"type": "NONE"
}
},
{
"name": "AA1_TURNO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TURNO",
"type": "NONE"
}
},
{
"name": "AA1_VALOR",
"type": "DOUBLE",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": false,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VALOR",
"type": "NONE"
}
},
{
"name": "AA1_RATE",
"type": "DOUBLE",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": false,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_RATE",
"type": "NONE"
}
},
{
"name": "AA1_EMINFI",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_EMINFI",
"type": "NONE"
}
},
{
"name": "AA1_CUSTO",
"type": "DOUBLE",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": false,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CUSTO",
"type": "NONE"
}
},
{
"name": "AA1_FUNPRO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FUNPRO",
"type": "NONE"
}
},
{
"name": "AA1_LOCAL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCAL",
"type": "NONE"
}
},
{
"name": "AA1_LIBOSV",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LIBOSV",
"type": "NONE"
}
},
{
"name": "AA1_LOCLZB",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCLZB",
"type": "NONE"
}
},
{
"name": "AA1_LOCLZR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCLZR",
"type": "NONE"
}
},
{
"name": "AA1_DULTES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DULTES",
"type": "NONE"
}
},
{
"name": "AA1_LOCLZF",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOCLZF",
"type": "NONE"
}
},
{
"name": "AA1_CULTES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CULTES",
"type": "NONE"
}
},
{
"name": "AA1_DATUES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DATUES",
"type": "NONE"
}
},
{
"name": "AA1_CATUES",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CATUES",
"type": "NONE"
}
},
{
"name": "AA1_REQPEC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_REQPEC",
"type": "NONE"
}
},
{
"name": "AA1_DATADM",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DATADM",
"type": "NONE"
}
},
{
"name": "AA1_DATDEM",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_DATDEM",
"type": "NONE"
}
},
{
"name": "AA1_CODVEN",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODVEN",
"type": "NONE"
}
},
{
"name": "AA1_NOMUSU",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_NOMUSU",
"type": "NONE"
}
},
{
"name": "AA1_TIPO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TIPO",
"type": "NONE"
}
},
{
"name": "AA1_CODUSR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODUSR",
"type": "NONE"
}
},
{
"name": "AA1_CONTRB",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CONTRB",
"type": "NONE"
}
},
{
"name": "AA1_TIPVEN",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TIPVEN",
"type": "NONE"
}
},
{
"name": "AA1_ALOCA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_ALOCA",
"type": "NONE"
}
},
{
"name": "AA1_CODFOR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CODFOR",
"type": "NONE"
}
},
{
"name": "AA1_LOJFOR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_LOJFOR",
"type": "NONE"
}
},
{
"name": "AA1_ACESSO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_ACESSO",
"type": "NONE"
}
},
{
"name": "AA1_CDFUNC",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CDFUNC",
"type": "NONE"
}
},
{
"name": "AA1_VISTOR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VISTOR",
"type": "NONE"
}
},
{
"name": "AA1_VISVLR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VISVLR",
"type": "NONE"
}
},
{
"name": "AA1_VISPRO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VISPRO",
"type": "NONE"
}
},
{
"name": "AA1_IMPPRO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_IMPPRO",
"type": "NONE"
}
},
{
"name": "AA1_CATEGO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CATEGO",
"type": "NONE"
}
},
{
"name": "AA1_ALTVIS",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_ALTVIS",
"type": "NONE"
}
},
{
"name": "AA1_FTVIST",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FTVIST",
"type": "NONE"
}
},
{
"name": "AA1_CRMSIM",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CRMSIM",
"type": "NONE"
}
},
{
"name": "AA1_FUNFIL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_FUNFIL",
"type": "NONE"
}
},
{
"name": "AA1_MPONTO",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_MPONTO",
"type": "NONE"
}
},
{
"name": "AA1_SEQTUR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_SEQTUR",
"type": "NONE"
}
},
{
"name": "AA1_PERQTD",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_PERQTD",
"type": "NONE"
}
},
{
"name": "AA1_VINCUL",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_VINCUL",
"type": "NONE"
}
},
{
"name": "AA1_RSPMNT",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_RSPMNT",
"type": "NONE"
}
},
{
"name": "AA1_RSPTRA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_RSPTRA",
"type": "NONE"
}
},
{
"name": "AA1_EXTVIG",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_EXTVIG",
"type": "NONE"
}
},
{
"name": "AA1_CNV",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_CNV",
"type": "NONE"
}
},
{
"name": "AA1_NREDUZ",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_NREDUZ",
"type": "NONE"
}
},
{
"name": "AA1_SENHA",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_SENHA",
"type": "NONE"
}
},
{
"name": "AA1_TIPMAR",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "AA1_TIPMAR",
"type": "NONE"
}
},
{
"name": "D_E_L_E_T_",
"type": "STRING",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "D_E_L_E_T_",
"type": "NONE",
"options": ""
}
},
{
"name": "R_E_C_N_O_",
"type": "INTEGER",
"isPrimaryKey": true,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "R_E_C_N_O_",
"type": "NONE",
"options": ""
}
},
{
"name": "R_E_C_D_E_L_",
"type": "INTEGER",
"isPrimaryKey": false,
"isArtificialKey": false,
"isTimestamp": true,
"isTrigger": false,
"isSelectedToSync": false,
"anonymization": {
"field": "R_E_C_D_E_L_",
"type": "NONE",
"options": ""
}
}
],
"enabled": true,
"play": true,
"conditionalSql": "",
"syncByTimestamp": false,
"syncByFullLoad": false,
"carolModel": false,
"lookupTable": false,
"initialDate": "2022-05-14",
"initialNumber": 0,
"daysToResend": 0,
"basedOnLastSync": true,
"cdsClearData": true,
"generateFirstFullLoad": true,
"status": "DISABLED",
"hasPrimaryKey": true,
"hasArtificialKey": false,
"totalRecords": 0,
"resendData": false,
"triggerWhenInsert": true,
"triggerWhenUpdate": true,
"triggerWhenDelete": true,
"view": false
}

 

Alguns itens importantes para mudar o tipo e algumas configurações de sincronização:

enabled: true, indica ação para habilitar a tabela
play: true, ativada a sincronização, se alterar para false, vai pausar a integração
conditionalSql: , caso seja necessário adicionar algum filtro, direto na tabela
syncByTimestamp: false, informa que a sincronização será agendada por timestamp(campo data)
syncByFullLoad: false, informa que a sincronização será agendada por fullLoad(carregando a tabela inteira sempre)
carolModel: false, caso seja uma tabela já mapeada e criada de acordo com algum modelo na Carol
lookupTable: false, caso seja uma tabela identificada como LK na Carol
initialDate: 2022-05-14, - data inicial da sincronização - utilizado no timestamp
initialNumber: 0, número inicial da sincronização - utilizado no timestamp
daysToResend: 0, dias para reenviar da tabela - utilizado no timestamp
basedOnLastSync: true, baseado na última sincronização
cdsClearData: true, limpar os dados na Carol antes de enviar - utilizado no FullLoad
generateFirstFullLoad: true, realizar primeira carga imediatamente - utilizado no FullLoad
status: DISABLED, status de momento, deixar assim para habilitar
hasPrimaryKey: true, chave primeira da tabela, caso exista
hasArtificialKey: false, chave artificial na Carol
totalRecords: 0, registros identificados
resendData: false, reenviar dados
triggerWhenInsert: true, para sincronizar online e criar a trigger no banco
triggerWhenUpdate: true, para sincronizar online e criar a trigger no banco
triggerWhenDelete: true, para sincronizar online e criar a trigger no banco
view: false, caso seja uma view

Resultado

mceclip8.png

 

Então esses passos podem ser replicados para outras tabelas e caso necessário outros bancos de dados.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Esse artigo foi útil?
Usuários que acharam isso útil: 0 de 0

0 Comentários

Por favor, entre para comentar.
Como podemos ajudar?
Entre em contato e fale conosco!
X Fechar

Olá ,

Há pendência referente a um de seus produtos contratados para a empresa ().

Entre em contato com o Centro de Serviços TOTVS para tratativa.

Ligue! 4003-0015 opção 4 e 9 ou registre uma solicitação para CST – Cobrança – Verificação de pendências financeiras . clique aqui.

TOTVS

X Fechar

Olá ,

Seu contato não está cadastrado no Portal do Cliente como um perfil autorizado a solicitar consultoria telefônica.

Por gentileza, acione o administrador do Portal de sua empresa para: (1)configurar o seu acesso ou (2)buscar um perfil autorizado para registro desse atendimento.

Em caso de dúvidas sobre a identificação do contato administrador do Portal, ligue (11) 4003-0015, opção 7 e, em seguida, opção 4 para buscar o suporte com o time de Assessoria ao Portal do Cliente. . clique aqui.

TOTVS

X Fechar

Olá ,

Para o atendimento de "Consultoria Telefônica" você deverá estar de acordo com o Faturamento.

TOTVS

X Fechar

Olá,

Algo inesperado ocorreu, e o usuario nao foi reconhecido ou você nao se encontra logado

Por favor realize um novo login

Em caso de dúvidas, entre em contato com o administrador do Portal de Clientes de sua empresa para verificação do seu usuário, ou Centro de Serviços TOTVS.

Ligue! 4003-0015 opção 4 e 9 ou registre uma solicitação para CST – Cadastros . clique aqui.

TOTVS

Chat _

Preencha os campos abaixo para iniciar o atendimento:

Chat _

NC#o encontrou o que procura?