Call GET threaddata with your Pro2 log-in credentials to get a JSON report for replication queue records associated with specific threads.

About this API

The GET replication queue records API is a REST API that, when called, queries a Pro2 replication database for a list of replication queue records that are associated with specific threads in a replication database. You specify the database host name and port in the URL of the call. To ensure security, you include the log-in credentials for your account in the query. You can use this API to get a detailed report of the threads in a replication database, and up to 10 records associated with those threads.

Request

Direct the API call to the URL:

http://host_name:port/pro2/rest/Pro2/DPR?dMode=System/threaddata
Request format example as a curl command:
curl 
-X GET 
-u username:password 
-v http://host_name:port/pro2/rest/Pro2/DPR?dMode=System/threaddata

Response

The response returns a data-set report of the replication queue records in JSON format under the ttReplQueue array.

The following is an example response:
{
  "ProDataSet": {
    "THREADCTL": [
      {
        "ThreadID": 0,
        "Updtime": "2020-04-02T03:33:30.444",
        "ThreadStatus": "STOPPED",
        "LogLevel": "Moderate",
        "Disposition": "Delete Record",
        "RepControl": "Enabled",
        "ThreadType": "CDC",
        "ControlType": "",
        "isAdd": false,
        "isRunning": false,
        "ttReplQueue": [
          {
            "Sequence": 1,
            "EventType": "C",
            "SrcDB": "sports",
            "SrcTable": "Customer",
            "SrcRecord": "0x0000000000000a10",
            "EventDate": "2020-04-02",
            "EventTime": "03:33:47",
            "SrcTransID": 0,
            "Username": "Administrator",
            "Applied": false,
            "ApplDate": null,
            "ApplTime": "",
            "Audited": false,
            "AudDate": null,
            "AudTime": "",
            "UserCust": "Administrator",
            "RawData": "",
            "QThread": 0,
            "THREADTYPE": "CDC"
          },
          {
            "Sequence": 2,
            "EventType": "W",
            "SrcDB": "sports",
            "SrcTable": "Customer",
            "SrcRecord": "0x0000000000000a10",
            "EventDate": "2020-04-02",
            "EventTime": "03:33:47",
            "SrcTransID": 0,
            "Username": "Administrator",
            "Applied": false,
            "ApplDate": null,
            "ApplTime": "",
            "Audited": false,
            "AudDate": null,
            "AudTime": "",
            "UserCust": "Administrator",
            "RawData": "",
            "QThread": 0,
            "THREADTYPE": "CDC"
          },
          {
            "Sequence": 3,
            "EventType": "C",
            "SrcDB": "sports",
            "SrcTable": "Customer",
            "SrcRecord": "0x0000000000000a11",
            "EventDate": "2020-04-02",
            "EventTime": "03:33:47",
            "SrcTransID": 0,
            "Username": "Administrator",
            "Applied": false,
            "ApplDate": null,
            "ApplTime": "",
            "Audited": false,
            "AudDate": null,
            "AudTime": "",
            "UserCust": "Administrator",
            "RawData": "",
            "QThread": 0,
            "THREADTYPE": "CDC"
          }
      }
    ]
  }
}