Call GET repldbxref with your Pro2 log-in credentials to get a JSON report of triggers, CDC information, and source and target database information for a Pro2 database.

About this API

The GET thread data API is a REST API that, when called, queries a Pro2 instance for a all data on that instance and that instances database. You specify the instance 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. The request returns a variety of data, such as trigger data, CDC information, source and target database information, and more.

Request

Direct the API call to the URL:

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

Response

The response returns a data-set report of all thread data in JSON format.

The following is an example response:
{
  "ProDataSet": {
    "ttReplDBXref": [
      {
        "SrcDB": "sports",
        "SchHldr": "",
        "SchImg": "",
        "TgtType": "OpenEdge",
        "TgtConnName": "",
        "TgtPhysName": "target",
        "GenQRec": true,
        "ProcQRec": true,
        "SrcPhysName": "",
        "SchPhysName": "",
        "SrcConnectType": "LAN",
        "SrcDBMode": "CDC",
        "SrcHostName": "localhost",
        "SrcHostPort": "1122",
        "SrcUserName": "",
        "SrcUserPWD": "",
        "SrcLastJobID": 0,
        "AppsrvName": "",
        "TgtUserName": "",
        "AppsrvConnectStr": "",
        "TgtUserPWD": "",
        "TgtDBHost": "localhost",
        "TgtDBPort": "2233",
        "TgtLastJobID": 3562,
        "SrcDBPath": "",
        "TgtDBPath": "",
        "SchDBPath": ""
      }
    ]
  }
}