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

Delete a Running Job

Last updated

Jul 9, 2023
Save as PDF

Use the Cancel a running aggregate query job API operation to delete the current job, only if the job is not complete. If the job is complete, an error is thrown.

The following section provides JSON and cURL examples to use this API operation.

HTTP request:

DELETE https://www.zuora.com/apps/api/batch-query/jobs/e20b07474688ad5001468daf10e501de

DELETE https://apisandbox.zuora.com/apps/api/batch-query/jobs/ e20b07474688ad5001468daf10e501de

JSON response:

01{
02 
03    "name": "June10",
04 
05    "id": "e20b07474688ad5001468daf10e501de",
06 
07    "version": "1.1",
08 
09    "format": "CSV",
10 
11    "status": "cancelled",
12 
13    "batches": [
14 
15        {
16 
17            "name": "InvoiceItemAdjustment",
18 
19            "message": "",
20 
21            "query": "select AccountingCode,CancelledDate,CreatedDate,Id,InvoiceId,InvoiceItemName,
22 
23            InvoiceNumber,SourceType,AdjustmentNumber,ServiceStartDate,ServiceEndDate,AdjustmentDate,
24 
25            Amount,Status,AccountId,SourceId,Type,ReasonCode, UpdatedDate  from  InvoiceItemAdjustment",
26 
27            "status": "completed",
28 
29            "recordCount": 1580,
30 
31            "fileId": "e20b07474688ad5001468daf155f01f5",
32 
33            "batchId": "e20b07474688ad5001468daf10ea01df",
34 
35            "batchType": "zoqlexport"
36 
37        },
38 
39        {
40 
41            "name": "InvoiceAdjustment",
42 
43            "message": "",
44 
45            "query": "select AccountingCode,CancelledOn,CreatedDate,Id,ImpactAmount,Invoice.Id,
46 
47            InvoiceNumber,AdjustmentNumber,AdjustmentDate,Amount,Status,Account.Id,Type,ReasonCode,
48 
49            UpdatedDate  from  InvoiceAdjustment",
50 
51            "status": "completed",
52 
53            "recordCount": 411,
54 
55            "fileId": "e20b07474688ad5001468daf166601f6",
56 
57            "batchId": "e20b07474688ad5001468daf10ec01e0",
58 
59            "batchType": "zoqlexport"
60 
61        }
62 
63    ],
64 
65    "encrypted": "none"
66 
67}

Curl Example

Curl request:

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

Curl response:

01HTTP/1.1 200 OK 
02Server: Apache-Coyote/1.1 
03Content-Type: application/json 
04Transfer-Encoding: chunked 
05Date: Fri, 05 Sep 2014 11:52:30 GMT 
06{ 
07 "name": "DSEXPORT", 
08 "id": "2c90839d46f936820146fd4ef77a1eb6", 
09 "version": "1.1", 
10 "format": "CSV", 
11 "status": "cancelled", 
12 "encrypted": "none", 
13 "batches": [ 
14     { 
15       "name": "Account", 
16       "query": "select AccountNumber,Id,CreditBalance,Name,Balance,TaxExemptStatus,AutoPay,Currency,PaymentGateway,PaymentTerm,SalesRepName,TaxExemptIssuingJurisdiction,TaxExemptEffectiveDate,TaxExemptExpirationDate,TaxExemptCertificateType,LastInvoiceDate,Status,TotalInvoiceBalance,CreatedDate,UpdatedDate, ParentId, CustomerServiceRepName, BillToContact.Id, SoldToContact.Id from Account", 
17       "status": "completed", 
18       "recordCount": 1322, 
19       "batchType": "zoqlexport", 
20       "batchId": "2c90839d46f936820146fd4ef77f1eb7", 
21       "segments": [ 
22          "2c90839d46f936820146fd4ef8c71ece", 
23          "2c90839d46f936820146fd4ef8d21ecf", 
24          "2c90839d46f936820146fd4ef8dd1ed0", 
25          "2c90839d46f936820146fd4ef8e91ed1", 
26          "2c90839d46f936820146fd4ef8f31ed3", 
27          "2c90839d46f936820146fd4ef9021ed5", 
28          "2c90839d46f936820146fd4ef90d1ed8", 
29          "2c90839d46f936820146fd4ef9161edb", 
30          "2c90839d46f936820146fd4ef9201ede", 
31          "2c90839d46f936820146fd4ef9291ee2", 
32          "2c90839d46f936820146fd4ef9311ee5", 
33          "2c90839d46f936820146fd4ef93a1ee8", 
34          "2c90839d46f936820146fd4ef9431eec", 
35          "2c90839d46f936820146fd4ef94d1eef", 
36          "2c90839d46f936820146fd4ef9561ef2", 
37          "2c90839d46f936820146fd4ef9601ef6", 
38          "2c90839d46f936820146fd4ef96a1efb", 
39          "2c90839d46f936820146fd4ef9751efe", 
40          "2c90839d46f936820146fd4ef97d1f03", 
41          "2c90839d46f936820146fd4ef9861f0c", 
42          "2c90839d46f936820146fd4ef9991f15", 
43          "2c90839d46f936820146fd4ef9a11f1d", 
44          "2c90839d46f936820146fd4ef9ab1f1e", 
45          "2c90839d46f936820146fd4ef9bf1f21", 
46          "2c90839d46f936820146fd4ef9c91f23", 
47          "2c90839d46f936820146fd4ef9d31f26", 
48          "2c90839d46f936820146fd4ef9da1f2e" 
49       ] 
50    }, 
51 { 
52     "name": "AccountingPeriod", 
53     "query": "select Id,StartDate,EndDate,FiscalYear,Name,Status,UpdatedDate from AccountingPeriod", 
54     "status": "submitted", 
55     "recordCount": 0, 
56     "batchType": "zoqlexport", 
57     "batchId": "2c90839d46f936820146fd4ef7951ecc", 
58     "segments": [ "2c90839d46f936820146fd4f061e23cf" 
59      ] 
60    } 
61  ]  
62 }