- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi,
Right now I can only get results for RatePlans associated to NewProduct or UpdateProduct amendments (I'm querying RatePlans by AmendmentId), it would be nice if we can have the ability to know what products were removed from a subscription through a RemoveProduct amendment.
Thanks!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi try this query
select Id, AmendmentId, AmendmentSubscriptionRatePlanId, AmendmentType, CreatedById, CreatedDate, Name, ProductRatePlanId, SubscriptionId, UpdatedById, UpdatedDate from RatePlan where SubscriptionId = '2c92c0f859686c7d01598b268ea3044e' and amendmenttype !=null
of course make sure your subscription id is correct
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Get RatePlans related to a RemoveProduct amendment
To get the report you need, you can use Rate Plan datasouce, select RatePlan.Name, RatePlan.ID, Subscription.Name, Subscription.ID, Amendment.ID, Amendment.Name, then set filter as RatePlan.AmendmentType = 'RemoveProduct'.
In the exported file, you can use Excel Remove Duplicates function to remove the duplicate items caused by more subscription versions created after the rate plan has been removed.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Get RatePlans related to a RemoveProduct amendment
Hi Yvonne,
Sorry, I didn't mentioned that I was talking about the SOAP API, for instance, I'm using the following query which works fine (return results) for NewProduct or UpdateProduct amendments:
<env:Body> <ins0:query> <ins0:queryString>select Id, AmendmentId, AmendmentSubscriptionRatePlanId, AmendmentType, CreatedById, CreatedDate, Name, ProductRatePlanId, SubscriptionId, UpdatedById, UpdatedDate from RatePlan where AmendmentId = '2c92c0f9592a694001596298d1fd2dbf'</ins0:queryString> </ins0:query> </env:Body>
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Get RatePlans related to a RemoveProduct amendment
For your query response, what is the AmendmentType when the product has been removed?
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Get RatePlans related to a RemoveProduct amendment
The response from the endpoint is empty, that's the main problem.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi try this query
select Id, AmendmentId, AmendmentSubscriptionRatePlanId, AmendmentType, CreatedById, CreatedDate, Name, ProductRatePlanId, SubscriptionId, UpdatedById, UpdatedDate from RatePlan where SubscriptionId = '2c92c0f859686c7d01598b268ea3044e' and amendmenttype !=null
of course make sure your subscription id is correct
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √