Can't find price for Product Rate Plan charge object

[Robert]

Question: How can I generate a report that shows the price of my product?  The "Product Rate Plan" object doesn't have that field.

[Robert · Accepted solution]

Answer: You should use the "Product Rate Plan Charge Tier" object.  That object will have the price.

[philthathril]

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.

[Rolando]

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...

[philthathril]

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.

[Robert]

@philthathril,

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>

[philthathril]

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!

[mrichmond]

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.