Skip to main content

Post Query with API Version

Zuora

Post Query with API Version

Use the Submit an aggregate query job API operation with the apiVersion query parameter to submit an aggregate query with a specified API version.

For integration purposes, specify the apiVersion to ensure consistent and reliable query performance. For many other reporting purposes you do not have to specify the apiVersion and by default AQuA uses the latest Zuora API version to execute the query.

The following sections provides JSON examples to use this API operation.

Example 1

This example shows submitting a JSON request with the apiVersion = 58.0.

HTTP request:

POST https://www.zuora.com/apps/api/batch-query/

POST https://apisandbox.zuora.com/apps/api/batch-query/

JSON request:

{
    "format": "csv",
    "version": "1.1",
    "name": "Example",
    "encrypted": "none",
    "partner": "salesforce",
    "project": "00170000011K3Ub",
    "queries": [
        {
            "name": "Account",
            "query": "select UpdatedDate from ProductRatePlanCharge",
            "type": "zoqlexport",
            "apiVersion": "58.0",
            "deleted": {
                "column": "Deleted",
                "format": "Boolean"
            }
        }
    ]
}

Successful JSON response:

{
    "batches": [
        {
            "deleted": {
                "column": "Deleted",
                "format": "Boolean"
            },
            "full": true,
            "name": "Account",
            "query": "select UpdatedDate from ProductRatePlanCharge",
            "status": "pending",
            "recordCount": 0,
            "apiVersion": "58.0",
            "batchType": "zoqlexport",
            "batchId": "402881824835bb2a0148463a2c3804d0"
        }
    ],
    "project": "00170000011K3Ub",
    "partner": "salesforce",
    "name": "Example",
    "id": "402881824835bb2a0148463a2c3704cf",
    "version": "1.1",
    "format": "CSV",
    "status": "submitted",
    "encrypted": "none"
}

Example 2

This example shows submitting a JSON request with the apiVersion= 19.0.

HTTP request:

POST https://www.zuora.com/apps/api/batch-query/

POST https://apisandbox.zuora.com/apps/api/batch-query/

{
    "format": "csv",
    "version": "1.1",
    "name": "Example",
    "encrypted": "none",
    "partner": "salesforce",
    "project": "00170000011K3Ub",
    "notifyUrl" : "http://requestb.in/1ju8vhu1",
    "queries": [
        {
            "name": "Account",
            "query": "select Id,ProductRatePlan.Id,BillCycleDay,AccountingCode,ChargeModel,ChargeType,Description,Name,UpdatedDate from ProductRatePlanCharge",
            "type": "zoqlexport",
            "apiVersion": "19.0",
            "deleted": {
                "column": "Deleted",
                "format": "Boolean"
            }
        }
    ]
}

JSON response with error:

Error.zoql.noSuchFieldId\n