推送数据

接口地址:/zq/push

请求方式:POST

请求数据类型:application/json

响应数据类型:application/json;charset=utf-8

接口描述:

请求示例:

{
  "ifmarkfull": 0,
  "jsondata": [],
  "nodeid": 0,
  "pushtablename": "",
  "pushtableschema": ""
}

请求参数:

请求参数:

参数名称 参数说明 请求类型 是否必须 数据类型 schema
zcbusQueuePushDataBean zcbusQueuePushDataBean body true ZcbusQueuePushDataBean ZcbusQueuePushDataBean
  ifmarkfull false integer(int32)
  jsondata false array object
  nodeid false integer(int32)
  pushtablename false string
  pushtableschema false string
token token header false string

响应状态:

状态码 说明 schema
200 OK 返回消息?string?
201 Created
401 Unauthorized
403 Forbidden
404 Not Found

响应参数:

参数名称 参数说明 类型 schema
code 返回编码 200:成功 300:参数错误 400:错误 201:错误 500:DDL 501:创建容器异常 501:创建容器异常 600:发布 601:发布 602:发布数据库配置 700:订阅 701:订阅 731:比对服务 732:比对服务 901:权限异常 902:权限异常 910:传输通道异常 911:传输通道异常 701:订阅数据库 800:ETL 801:ETL 900:一键同步 611:kafka 1000:API 10000:未知异常 1001:SQL运行中 1002:SQL异常 1003:SQL匹配失败 1004:拓扑图异常 1005:拓扑图异常 650:启动一键同步服务异常 651:检查一键同步信息异常 652:停止一键同步服务异常 653:检查全链路进程异常 656:启动通道发布异常 657:检查发布节点信息 658:停止发布节点通道 659:检查发布节点进程通道 660:启动通道订阅异常 661:检查订阅节点通道 662:停止订阅节点通道 663:检查订阅节点进程通道 665:启动ETL服务异常 666:检查ETL服务进程异常 667:停止ETL服务异常 668:ETL服务异常 670:启动传输通道异常 671:检查传输通道异常 672:停止传输通道异常 673:传输通道进程异常 675:启动容器异常 676:检查容器信息异常 677:停止容器异常 678:检查容器进程异常 680:启动订阅节点比对服务 681:检查比对服务信息 682:检查订阅比对修复 683:停止订阅节点比对服务 684:检查比对服务异常 integer(int32) integer(int32)
data 返回消息体 string
desc 返回描述 string
rtdate 返回时间 string

响应示例:

{
    "code": 0,
    "data": "",
    "desc": "",
    "rtdate": ""
}
  • 测试数据demo
    [
{
  "optype":"update",
  "database_name":"databus_v4",
  "optime":"2021-02-02 15:01:12",
  "before":{
      "deletes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "bus_client_product_object_id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"11664"
      },
      "ddls":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "lastoptime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:04"
      },
      "loaddelayseconds":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"8"
      },
      "insertes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "updates":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"90368"
      },
      "offsettime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:05"
      },
      "customerid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"32070"
      },
      "tableid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"98178"
      },
      "loadthread":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"1"
      },
      "id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"168371157"
      },
      "updatetime":{
          "zbomc_column_type":"timestamp",
          "zbomc_column_value":"2021-02-02 15:01:12"
      },
      "daytime":{
          "zbomc_column_type":"date",
          "zbomc_column_value":"2021-02-02"
      },
      "ctlid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"434"
      }
  },
  "dbtype":1,
  "after":{
      "deletes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "bus_client_product_object_id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"11664"
      },
      "ddls":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "lastoptime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:05"
      },
      "loaddelayseconds":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"7"
      },
      "insertes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "updates":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"90369"
      },
      "offsettime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:06"
      },
      "customerid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"32070"
      },
      "tableid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"98178"
      },
      "loadthread":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"1"
      },
      "id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"168371157"
      },
      "updatetime":{
          "zbomc_column_type":"timestamp",
          "zbomc_column_value":"2021-02-02 15:01:12"
      },
      "daytime":{
          "zbomc_column_type":"date",
          "zbomc_column_value":"2021-02-02"
      },
      "ctlid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"434"
      }
  },
  "table_name":"bus_client_op_real_load_info"
},
{
  "optype":"insert",
  "database_name":"databus_v4",
  "optime":"2021-02-02 15:01:12",
  "dbtype":1,
  "after":{
      "deletes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "bus_client_product_object_id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"11664"
      },
      "ddls":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "lastoptime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:05"
      },
      "loaddelayseconds":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"7"
      },
      "insertes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "updates":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"90369"
      },
      "offsettime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:06"
      },
      "customerid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"32070"
      },
      "tableid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"98178"
      },
      "loadthread":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"1"
      },
      "id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"168371157"
      },
      "updatetime":{
          "zbomc_column_type":"timestamp",
          "zbomc_column_value":"2021-02-02 15:01:12"
      },
      "daytime":{
          "zbomc_column_type":"date",
          "zbomc_column_value":"2021-02-02"
      },
      "ctlid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"434"
      }
  },
  "table_name":"bus_client_op_real_load_info"
},
{
  "optype":"delete",
  "database_name":"databus_v4",
  "optime":"2021-02-02 15:01:12",
  "dbtype":1,
  "before":{
      "deletes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "bus_client_product_object_id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"11664"
      },
      "ddls":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "lastoptime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:05"
      },
      "loaddelayseconds":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"7"
      },
      "insertes":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"0"
      },
      "updates":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"90369"
      },
      "offsettime":{
          "zbomc_column_type":"datetime",
          "zbomc_column_value":"2021-02-02 15:01:06"
      },
      "customerid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"32070"
      },
      "tableid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"98178"
      },
      "loadthread":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"1"
      },
      "id":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"168371157"
      },
      "updatetime":{
          "zbomc_column_type":"timestamp",
          "zbomc_column_value":"2021-02-02 15:01:12"
      },
      "daytime":{
          "zbomc_column_type":"date",
          "zbomc_column_value":"2021-02-02"
      },
      "ctlid":{
          "zbomc_column_type":"number",
          "zbomc_column_value":"434"
      }
  },
  "table_name":"bus_client_op_real_load_info"
}
]
文档更新时间: 2022-04-14 16:06   作者：阿力