- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Question: How can I generate a report that shows the price of my product? The "Product Rate Plan" object doesn't have that field.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Answer: You should use the "Product Rate Plan Charge Tier" object. That object will have the price.
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
Answer: You should use the "Product Rate Plan Charge Tier" object. That object will have the price.
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: Can't find price for Product Rate Plan charge object
There doesn't appear to be a tier object for each ProductRatePlanCharge. For example, I have a "Discount-Fixed Amount" product rate plan charge that appears to have no pricing. I can see the value in the Zuora UI, but nothing from the API.
{ "queryString": "select Currency, Id, PriceFormat, Tier, Price, ProductRatePlanChargeId from ProductRatePlanChargeTier where ProductRatePlanChargeId = '...'" }
This query to the API returns no records when the same query returns records for other ProductRatePlanCharge ids. Thoughts on where the pricing information is?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Can't find price for Product Rate Plan charge object
This would be the "ProductRatePlanChargeTier" data source/object. Please see https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/ProductRateP...
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: Can't find price for Product Rate Plan charge object
Thanks for the response, Rolando. As indicated in my original question, when querying that object, I get no results. In response to that, one might suggest that perhaps I'm not querying the correct id. To assure that I am, I am using the ProductRatePlanCharge.Id that returns from a separate API call.
Any other thoughts?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Can't find price for Product Rate Plan charge object
We tested the "ProductRatePlanChargeTier." object and was able to get back pricing information via query. If you still can't get it to work, can you please create a ticket so that we can test it on your account?
Below is an actual SOAP query we did:
SOAP Query:
<SOAP-ENV:Envelope xmlns: SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns: ns2="http://object.api.zuora.com/" xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns: api="http://api.zuora.com/" xmlns: ns1="http://api.zuora.com/">
<SOAP-ENV:Header>
<ns1: SessionHeader>
<ns1:session></ns1:session>
</ns1: SessionHeader>
<ns1:QueryOptions>
<ns1:batchSize></ns1:batchSize>
</ns1:QueryOptions>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<ns1:query>
<ns1:queryString>Select Id, Price From ProductRatePlanChargeTier</ns1:queryString>
</ns1:query></SOAP-ENV:Body>
</SOAP-ENV:Envelope>
SOAP Response:
<soapenv:Envelope xmlns: soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<ns1:queryResponse xmlns: ns1="http://api.zuora.com/">
<ns1:result>
<ns1:done>true</ns1:done>
<ns1:queryLocator xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="1"></ns1:queryLocator>
<ns1:records xmlns: ns2="http://object.api.zuora.com/" xmlns : xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2: ProductRatePlanChargeTier">
<ns2:Id>2c92c0f856bc84c90156c41e64471a40</ns2:Id>
<ns2: Price>50</ns2: Price>
</ns1:records>
<ns1:records xmlns: ns2="http://object.api.zuora.com/" xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2: ProductRatePlanChargeTier">
<ns2:Id>2c92c0f956bc8fcb0156c419ee9c0507</ns2:Id>
<ns2: Price>100</ns2: Price>
</ns1:records>
<ns1:records xmlns: ns2="http://object.api.zuora.com/" xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2: ProductRatePlanChargeTier">
<ns2:Id>2c92c0f85721ffeb015726ccc9b24b4f</ns2:Id>
<ns2: Price>2500</ns2: Price>
</ns1:records>
<ns1:records xmlns: ns2="http://object.api.zuora.com/" xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2: ProductRatePlanChargeTier">
<ns2:Id>2c92c0f957220b6b01572966e06e4d1a</ns2:Id>
<ns2: Price>50</ns2: Price>
</ns1:records>
<ns1:records xmlns: ns2="http://object.api.zuora.com/" xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2: ProductRatePlanChargeTier">
<ns2:Id>2c92c0f85721ff7c015735562ad657f9</ns2:Id>
<ns2: Price>600</ns2: Price>
</ns1:records>
<ns1:size>132</ns1:size>
</ns1:result>
</ns1:queryResponse>
</soapenv:Body>
</soapenv:Envelope>
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: Can't find price for Product Rate Plan charge object
Was that associated with a Discount-Fixed Amount product rate plan charge?
I'll open up a ticket if I can't find a solution.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Can't find price for Product Rate Plan charge object
Did you ever figure a way to get this information? We're needing to do the same thing, and don't want to have to go and script a subscription preview generation for each item in our catalog.