Happy Business Starts Here

API - AQUA - POST query with notification url >> notification url never called

Highlighted
Honor Student

API - AQUA - POST query with notification url >> notification url never called

Hello, I used Postman to make the request. Postman returned with a response, but the notification URL is never called.

 

Please advise.

 

 

API:

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

 

Request Body:

{
"queries": [
{
"name": "q1",
"query": "select Name, BillToContact.Firstname, BillToContact.Lastname, Lastinvoicedate, Balance, Status from Account where Lastinvoicedate = '24/01/2016'",
"type": "zoqlexport"
},
{
"name": "q2",
"query": "select * from Account",
"type": "zoqlexport"
}
],
"name": "j-2b",
"version": "1.2",
"format": "csv",
"encrypted": "none",
"partner": "********",
"project":"********",
"notifyUrl":"http://zuora-test.stg.tech/completed.php?jobId=${JOBID}&status=${STATUS}"
}

 

Response Body:

{
"batches": [
{
"recordCount": 0,
"batchId": "2c92c0f953131e1f015332b5ddb13e20",
"apiVersion": "75.0",
"batchType": "zoqlexport",
"full": false,
"status": "pending",
"name": "q1",
"query": "select Name, BillToContact.Firstname, BillToContact.Lastname, Lastinvoicedate, Balance, Status from Account where Lastinvoicedate = '24/01/2016'"
},
{
"recordCount": 0,
"batchId": "2c92c0f953131e1f015332b5ddb33e21",
"apiVersion": "75.0",
"batchType": "zoqlexport",
"full": false,
"status": "pending",
"name": "q2",
"query": "select * from Account"
},
],
"encrypted": "none",
"partner": "********",
"project": "********",
"useLastCompletedJobQueries": false,
"notifyUrl": "http://zuora-test.stg.tech/completed.php?jobId=${JOBID}&status=${STATUS}",
"status": "submitted",
"format": "CSV",
"version": "1.2",
"name": "j-2b",
"id": "2c92c0f953131e1f015332b5ddad3e1e"
}

 

8 REPLIES 8
Highlighted
Support SME

Re: API - AQUA - POST query with notification url >> notification url never called

Hi @jack ,

 

We are experiencing degraded callout / notification / email performance at the moment, these events are currently being delayed - but will be sent out eventually.

 

Please subscribe to http://trust.zuora.com/ to receive timely updates about this.



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

Highlighted
Honor Student

Re: API - AQUA - POST query with notification url >> notification url never called

Hi, 

made the same API call thru Postman (which ran to sucessfull completion), still no indication that a notification was sent. (Notifications should of course be emitted even on recordCount(s) = 0 ... yes?)

Highlighted
Honor Student

Re: API - AQUA - POST query with notification url >> notification url never called

The server hosting the notification page requires a username and password.

 

Does the Zuora API support basic authorization of the form:

"notifyUrl":"http://username:password@zuora-test.stg.tech/completed.php?jobId=${JOBID}&status=${STATUS}" ?

 

Would it collide with the basic authorization set in the head for API call itself?

Highlighted
Support SME

Re: API - AQUA - POST query with notification url >> notification url never called

I am taking a closer look at this, @jack . Could you send me your tenant ID in a private message please, so I could also check if your tenant is configured correctly? Thanks!



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

Highlighted
Support SME

Re: API - AQUA - POST query with notification url >> notification url never called

Thank you for confirming the tenant ID.

 

I will review if there are any problems with this NotifyUrl format.

 

In the mean time, please review the alternative solution for sending Aqua notifications described on our Knowledge Center to see if it helps: https://knowledgecenter.zuora.com/DC_Developers/Aggregate_Query_API/B_Submit_Query/d_Configure_Notif...



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

Highlighted
Honor Student

Re: API - AQUA - POST query with notification url >> notification url never called

Vikor - thank you for the alternate solution, however, our project is purely server-side.

 

I await your response.

 

Thank you,

Jack

Highlighted
Support SME

Re: API - AQUA - POST query with notification url >> notification url never called

Hi @jack,

 

Just wanted to let you know I am still looking into what could be the problem with the notifyUrl parameter.



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

Highlighted
Support SME

Re: API - AQUA - POST query with notification url >> notification url never called

Hello @jack, Thanks for your patience on this query so far.

 

I have done a number of tests, but unfortunately my test callout endpoint is not perfect.

 

The format username:password@host certainly gets accepted (meaning, the API call itself won't fail), but in my case I was not able to confirm for 100% if the callout actually goes through.

 

Could you test your query by using the proposed format, and let me know if it pops up in your callout history on the UI? (available via Settings > Z-Billing Settings > Setup Profiles, Notifications and Email Templates > Notification History > Callout history)



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