Get Last Job Completed

Last updated
Save as PDF

Use the Retrieve the last completed aggregate query job API operation to get the details of the last completed job.

The completed AQuA jobs that were created 180 days ago are deleted permanently from Zuora, so you cannot query these jobs through API or AQuA job finder.

See the following JSON and cURL examples to learn how to use this API opration.

HTTP request:

GET https://www.zuora.com/apps/api/batch-query/jobs/partner/salesforce/ project/00170000011K3Ub

GET https://apisandbox.zuora.com/apps/api/batch-query/jobs/partner/salesforce/ project/00170000011K3Ub

JSON response:


{
    "batches": [
        {
            "full": false,
            "name": "AccountingPeriod",
            "message": "",
            "query": "select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod",
            "status": "completed",
            "recordCount": 0,
            "apiVersion": "60.0",
            "fileId": "402881824835bb2a01483c1e67c7025d",
            "batchType": "zoqlexport",
            "batchId": "402881824835bb2a01483c1e678c025b"
        }
    ],
    "project": "00170000011K3Ub",
    "partner": "salesforce",
    "name": "Example",
    "id": "402881824835bb2a01483c1e678a025a",
    "version": "1.1",
    "format": "CSV",
    "startTime": "2014-09-03 08:24:58",
    "status": "completed",
    "encrypted": "none"
}

cURL Example

cURL request:

echo 
echo "============= Project and Partner last processed job details ===========" 
echo curl -i -k -u $USER_NAME:$PASSWORD -H "Accept:application/json" -X GET $BASE_URL/api/batch-query/jobs/partner/$PARTNER/project/$PROJECT

cURL response:

HTTP/1.1 200 OK 
Server: Apache-Coyote/1.1 
Content-Type: application/json 
Transfer-Encoding: chunked 
Date: Fri, 05 Sep 2014 11:45:36 GMT 
{ 
"batches" : [ { 
  "full" : true, 
  "name" : "AccountingPeriod", 
  "query" : "select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod", 
  "status" : "completed", 
  "recordCount" : 1, 
  "apiVersion" : "60.0", 
  "batchType" : "zoqlexport", 
  "batchId" : "402881824835bb2a01484577116e035e", 
  "segments" : [ "402881824835bb2a0148457711ae0361" ] 
} ], 
"project" : "00170000011K3Ub", 
"partner" : "salesforce", 
"name" : "Example", 
"id" : "402881824835bb2a01484577116c035d", 
"version" : "1.1", 
"format" : "CSV", 
"startTime" : "2014-09-05 03:58:24", 
"status" : "completed", 
"encrypted" : "none" 
}