日本語のコンテンツは機械翻訳されており、補助的な参照を目的としています。機械翻訳の精度は保証できません。英語版が正となります。また、現時点では検索機能は日本語での検索をサポートしていません。翻訳に関するフィードバックについては、docs@zuora.comに送信してください。

Get Job Results

Last updated

Jul 9, 2023
Save as PDF

Use the Retrieve an aggregate query job API operation to retrieve an aggregate query using the Job ID.

Note that 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 example to learn how to use this operation.

HTTP request:

GET https://rest.zuora.com/v1/batch-query/jobs/{id}

GET https://rest.apisandbox.zuora.com/v1/batch-query/jobs/{id}

JSON response:

01{
02    "batches": [
03        {
04            "full": true,
05            "name": "AccountingPeriod",
06            "message": "",
07            "query": "select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod",
08            "status": "completed",
09            "recordCount": 1,
10            "apiVersion": "60.0",
11            "fileId": "402881824835bb2a01483c19f8190259",
12            "batchType": "zoqlexport",
13            "batchId": "402881824835bb2a01483c19f7da0257"
14        }
15    ],
16    "project": "00170000011K3Ub",
17    "partner": "salesforce",
18    "name": "Example",
19    "id": "402881824835bb2a01483c19f7d70256",
20    "version": "1.1",
21    "format": "CSV",
22    "startTime": "2014-09-03 08:20:07",
23    "status": "completed",
24    "encrypted": "none"
25}

cURL Example

cURL request:

1echo 
2echo "============= Get Aqua Job Details ===========" 
3echo 
4curl -i -k -u $USER_NAME:$PASSWORD -H "Accept:application/json" -X GET $BASE_URL/api/batch-query/jobs/$JOBID

cURL response:

01HTTP/1.1 200 OK 
02Content-Type: application/json 
03Date: Fri, 05 Sep 2014 11:34:35 GMT 
04Transfer-Encoding: chunked 
05Connection: Keep-Alive 
06{ 
07  "batches" : [ { 
08    "full" : true, 
09    "name" : "AccountingPeriod", 
10    "query" : "select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod", 
11    "status" : "completed", 
12    "recordCount" : 132, 
13    "batchId" : "e20b07474841608a01484592147305d3", 
14    "apiVersion" : "59.0", 
15    "segments" : [ "e20b07474841608a01484592159c05d7" ], 
16    "batchType" : "zoqlexport" } ], 
17  "project" : "00170000011K3Ub", 
18  "partner" : "salesforce", 
19  "name" : "Example", "id" : "e20b07474841608a01484592147005d2", 
20  "version" : "1.1", 
21  "startTime" : "2014-09-05 04:27:54", 
22  "format" : "CSV", 
23  "status" : "completed", 
24  "encrypted" : "none" 
25  }