REPLICATION DOES NOT INSERT DATA IN BIGQUERY VIA REST API

  • 71Views
  • Last Post 17 June 2021
0
votes
marcos chacaliaza posted this 13 June 2021

{  

"ProviderConfiguration" : {

},

  "Metadata" : [

  {

 

      "Name":"t_centrocosto",

 

      "Url":"/t_centrocosto",

 

      "ResultPath": "",

 

"Columns": [

        {

          "Name": "id_centrocosto",

          "APIPath": "Id",

          "DbType": "Int32",

          "Primary": true,

          "Createable": false,

          "Updateable": false

        },

        {

          "Name": "nombre_cc",

          "APIPath": "nombre_cc",

          "DbType": "String",

          "Required": false

        },

        {

          "Name": "est",

          "APIPath": "est",

          "DbType": "Int32",

          "Required": false

        }

      ], "InsertOperation": 

         { 

           "UrlSuffix": "", 

           "Method": "POST", 

           "ReturningStrategy": { "Type": "Row" },

           "InputType" : "RestParameters" 

       },

           "UpdateOperation" : {

           "UrlSuffix" : "/<id_centrocosto>",

               "Arguments" : [ { "ColumnName":"Id", "ParameterName" : "id_centrocosto", 

           "ParameterType" : "UrlPath" }

          ],

          "Method" : "PUT",

          "ReturningStrategy" : {

          "Type":"Row"

          },

          "InputType" : "RestParameters" 

       },

          "DeleteOperation" : {

          "UrlSuffix" : "/<id_centrocosto>",

          "Arguments" : [ { "ColumnName":"Id", "ParameterName" : "id_centrocosto", 

               "ParameterType" : "UrlPath" }

          ],

          "Method" : "DELETE" 

      }

     }

  ]

}

0
votes
Nataliia Nikulina posted this 17 June 2021

Hello Marcos,

 

Thank you for contacting Skyvia Support team.

 

It looks like you are talking about the package -

https://app.skyvia.com/#/84257/packages/131463

 

Please send us the results of the following query - SELECT * FROM t_centrocosto

 

You can use our Query tool for this. Create a new query by clicking +NEW in the top menu

and selecting SQL under Query.

 

In the new window, select a source connection (REST) on the left part -> add the following command

 

SELECT * FROM t_centrocosto

 

Click the Execute button and send us the results.

 

Also, the Source table does not contain CreatedDate and UpdatedDate fields.

 

We recommend that you clear an Incremental Updates checkbox in your package.

 

We look forward to hearing from you.

 

Kind regards,

Nataliia

Close