Happy Business Starts Here

Highlighted
Support SME

How to list ALL amendments for a Subscription via API?

How can we get all amendments for a specific Subscription in Zuora using the API?

We have tried already using the REST API call to get all amendments given the subscription ID, but realized we do not get all amendments because each amendment has its own subscription ID.

And what we need to do is get all amendments tied to the original subscription ID in one call. 






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

1 REPLY 1
Support SME

Re: How to list ALL amendments for a Subscription via API?

Unfortunately, we cannot query out all of the amendments associated to one particular subscription number in one REST API call.
However, you can work around this by doing the following two steps in the query method:

 

1) Query the subscription based on the subscription number to get all of the subscription ID's:

{
    "queryString": "SELECT Id from Subscription where Name='A-S00000066'"
}

2) Use those subscription ID's which are returned, to query out the amendments.

{
"queryString": "SELECT Id, Name,Code, SubscriptionId FROM Amendment WHERE 
SubscriptionId='2c92c0f85a6b134e015aa38f155d2cd4' OR 
SubscriptionId='2c92c0855613a2020156175785e420a9' OR 
SubscriptionId='2c92c08556b0def70156b71182247f2a' OR 
SubscriptionId='2c92c08557e95e4b0157f1601e377e27' OR 
SubscriptionId='2c92c085589084ea01589215f9436979'"
}

Otherwise, the only other way is to run a Data Source Export on the Subscription Object.






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