Call GET bulkloadrpt with your Pro2 log-in credentials to get a JSON report for a bulk load process that you specify as query parameters in the API call.

About this API

The GET bulk load report API is a REST API that, when called, queries a Pro2 database for a data report of a bulk load job. 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 check the progress of a bulk load process when initially seeding a database.

Request

Direct the API call to the URL:

http://host_name:port/pro2/rest/Pro2/DPR?dMode=System/getbulkloadrpt&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/getbulkloadrpt&pVars=

Response

The response returns a data-set report of the bulk load job in JSON format.

The following is an example response:

{
  "ProDataSet": {
    "ttRpt": [
      {
        "ttDB": "sports",
        "ttFileName": "Benefits",
        "ttTbl": "Benefits",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:00",
        "ttRowsLoaded": 21,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "BillTo",
        "ttTbl": "BillTo",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:01",
        "ttRowsLoaded": 2,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Bin",
        "ttTbl": "Bin",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:04",
        "ttRowsLoaded": 770,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Customer",
        "ttTbl": "Customer",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:04",
        "ttRowsLoaded": 1118,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Department",
        "ttTbl": "Department",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:03",
        "ttRowsLoaded": 7,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Employee",
        "ttTbl": "Employee",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:04",
        "ttRowsLoaded": 55,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Family",
        "ttTbl": "Family",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:04",
        "ttRowsLoaded": 72,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Feedback",
        "ttTbl": "Feedback",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:05",
        "ttRowsLoaded": 8,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "InventoryTrans",
        "ttTbl": "InventoryTrans",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:06",
        "ttRowsLoaded": 75,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Invoice",
        "ttTbl": "Invoice",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:06",
        "ttRowsLoaded": 147,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Item",
        "ttTbl": "Item",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:07",
        "ttRowsLoaded": 55,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "LocalDefault",
        "ttTbl": "LocalDefault",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:08",
        "ttRowsLoaded": 10,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Order",
        "ttTbl": "Order",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:14",
        "ttRowsLoaded": 3953,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "OrderLine",
        "ttTbl": "OrderLine",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:26",
        "ttRowsLoaded": 13970,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "POLine",
        "ttTbl": "POLine",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:18",
        "ttRowsLoaded": 5337,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "PurchaseOrder",
        "ttTbl": "PurchaseOrder",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:13",
        "ttRowsLoaded": 2129,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "RefCall",
        "ttTbl": "RefCall",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:11",
        "ttRowsLoaded": 13,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Salesrep",
        "ttTbl": "Salesrep",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:12",
        "ttRowsLoaded": 9,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "ShipTo",
        "ttTbl": "ShipTo",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:12",
        "ttRowsLoaded": 3,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "State",
        "ttTbl": "State",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:13",
        "ttRowsLoaded": 51,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Supplier",
        "ttTbl": "Supplier",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:14",
        "ttRowsLoaded": 10,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "SupplierItemXref",
        "ttTbl": "SupplierItemXref",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:14",
        "ttRowsLoaded": 56,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "TimeSheet",
        "ttTbl": "TimeSheet",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:15",
        "ttRowsLoaded": 25,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Vacation",
        "ttTbl": "Vacation",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:16",
        "ttRowsLoaded": 12,
        "ttRowsLocked": 0
      },
      {
        "ttDB": "sports",
        "ttFileName": "Warehouse",
        "ttTbl": "Warehouse",
        "ttStatus": "COMPLETE",
        "ttDateTime": "01/28/2020-01:23:16",
        "ttRowsLoaded": 14,
        "ttRowsLocked": 0
      }
    ]
  }
}