Happy Business Starts Here

Savvy Scholar

Service Unavailable for few REST query requests

Request:
curl -X POST --data '{"queryString":"select BillingRunNumber, CreatedById, CreatedDate, EndDate, ErrorMessage, ExecutedDate, Id, InvoiceDate, NumberOfAccounts, NumberOfInvoices, StartDate, Status, TargetDate, TargetType, TotalTime, UpdatedById, UpdatedDate from BillingRun"}' -H 'Accept-Encoding: application/json' -H 'Authorization: Bearer b8851f19d306440596d4fec61bfdf810' -H 'Content-Type: application/json' -A 'Jersey/2.25.1' 'https://rest.apisandbox.zuora.com/v1/action/query'

Response:
The service is temporarily unavailable. Please try again later.

Request:
curl -X POST --data '{"queryString":"select Address1, Address2, City, Country, CreatedById, CreatedDate, CustomerNumber, Id, Name, Notes, ParentId, PostalCode, State, UpdatedById, UpdatedDate from Customer"}' -H 'Accept-Encoding: application/json' -H 'Authorization: Bearer b8851f19d306440596d4fec61bfdf810' -H 'Content-Type: application/json' -A 'Jersey/2.25.1' 'https://rest.apisandbox.zuora.com/v1/action/query'

Response:
The service is temporarily unavailable. Please try again later.

1 REPLY 1
Highlighted
Zuora Support Moderator

Re: Service Unavailable for few REST query requests

Hi vishalgarg,

The same issue can be reproduced in my sandbox too. I tried aqua exportzoql and it works fine. You can give it a try too. It is suggested to use aqua since it is more powerful. 

 

curl -X POST \
  https://rest.apisandbox.zuora.com/v1/batch-query/ \
  -H 'Content-Type: application/json' \
  -H 'Postman-Token: xx' \
  -H 'cache-control: no-cache' \
  -d '{
    "format": "csv",
    "version": "1.1",
    "name": "Example2",
    "encrypted": "none",
    "partner": "xx",
    "project": "July2018",

    "queries": [
        {
            "name": "RatePlanCharge",
            "query": "select BillingRunNumber, CreatedById, CreatedDate, EndDate, ErrorMessage, ExecutedDate, Id, InvoiceDate, NumberOfAccounts, NumberOfInvoices, StartDate, Status, TargetDate, TargetType, TotalTime, UpdatedById, UpdatedDate from BillingRun",
            "type": "zoqlexport",
            "apiVersion": "20.0",
            "deleted": {
                "column": "MyDeleted",
                "format": "Numeric"
            }
        }
    ]
}
'

 

Reference: https://knowledgecenter.zuora.com/DC_Developers/T_Aggregate_Query_API/BA_Stateless_and_Stateful_Mode...

 

Regards,
Yong Xiang | yxiang@zuora.com
Team Lead APAC Support | Zuora Inc.



SigNowBlue.png

 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √