@Jyoti_Sinha Sorry for the late reply. Price update worked 🙂 Thank you for that.
My question on RatePlanChargeTier still exists and it is confusing me a lot.
I have created a Product with only one RatePlan.
I have executed the following queries to get the price.
Procedure-1: POST https://rest.apisandbox.zuora.com/v1/action/query
==========
ProductId - {"queryString":"SELECT id from Product where name='xxxxxx'"}
ProductRatePlanId - {"queryString":"SELECT id from ProductRatePlan where ProductId='xxxxxx'"}
ProductRatePlanChargeId - {"queryString":"SELECT id from ProductRatePlanCharge where ProductRatePlanId='xxxxxx'"}
ProductRatePlanChargeTierId - {"queryString":"SELECT id from ProductRatePlanChargeTier where ProductRatePlanChargeId='xxxxxx'"}
-- Here I have got only one Id in the response
Update the price:
{
"type": "ProductRatePlanChargeTier",
"objects": [{
"Price": 351.00,
"Id":"2c92c0f95ad9c24d015addf33b090b12"
}]
}
Procedure-2:
==========
Tried to get the ProductRatePlanChargeId using Datasource by using Product name as a query filter. I am attaching the export result file here. Wonder why I have 5 rows.
| Product Rate Plan Charge Tier: ID | Product Rate Plan Charge Tier: Price | Product Rate Plan Charge Tier: Starting Unit | Product Rate Plan Charge Tier: Tier | Product: ID | Product: Name | Product Rate Plan: ID | Product Rate Plan: Name | Product Rate Plan Charge: Bill Cycle Day | Product Rate Plan Charge: Bill Cycle Type | Product Rate Plan Charge: Billing Period | Product Rate Plan Charge: Billing Period Alignment | Product Rate Plan Charge: Billing Timing | Product Rate Plan Charge: Charge Model | Product Rate Plan Charge: Charge Type | Product Rate Plan Charge: ID | Product Rate Plan Charge: List Price Base | Product Rate Plan Charge: Name | Product Rate Plan Charge: Number Of Period | Product Rate Plan Charge: Revenue Recognition Trigger | Product Rate Plan Charge: Tax Code | Product Rate Plan Charge: Tax Mode | Product Rate Plan Charge: Taxable | Product Rate Plan Charge: Trigger Event |
| 2c92c0f85b4237e6015b441427d250af | 270 | | 1 | 2c92c0f95b424512015b4411c1c24812 | KIA Care Plus | 2c92c0f85b4237e6015b4412762a4a7f | Annual Plan | | subscription start day | Two Years | Align to Subscription Start | In Advance | Per Unit Pricing | Recurring | 2c92c0f85b4237e6015b441427d150ae | Billing Period | 2 Year Charge | | | Z-Tax Code | Tax Exclusive | TRUE | Upon Service Activation |
| 2c92c0f85b4237e6015b441427d250b0 | 0 | | 1 | 2c92c0f95b424512015b4411c1c24812 | KIA Care Plus | 2c92c0f85b4237e6015b4412762a4a7f | Annual Plan | | subscription start day | Two Years | Align to Subscription Start | In Advance | Per Unit Pricing | Recurring | 2c92c0f85b4237e6015b441427d150ae | Billing Period | 2 Year Charge | | | Z-Tax Code | Tax Exclusive | TRUE | Upon Service Activation |
| 2c92c0f85b4237e6015b441427d250b1 | 0 | | 1 | 2c92c0f95b424512015b4411c1c24812 | KIA Care Plus | 2c92c0f85b4237e6015b4412762a4a7f | Annual Plan | | subscription start day | Two Years | Align to Subscription Start | In Advance | Per Unit Pricing | Recurring | 2c92c0f85b4237e6015b441427d150ae | Billing Period | 2 Year Charge | | | Z-Tax Code | Tax Exclusive | TRUE | Upon Service Activation |
| 2c92c0f85b4237e6015b441427d250b2 | 0 | | 1 | 2c92c0f95b424512015b4411c1c24812 | KIA Care Plus | 2c92c0f85b4237e6015b4412762a4a7f | Annual Plan | | subscription start day | Two Years | Align to Subscription Start | In Advance | Per Unit Pricing | Recurring | 2c92c0f85b4237e6015b441427d150ae | Billing Period | 2 Year Charge | | | Z-Tax Code | Tax Exclusive | TRUE | Upon Service Activation |
| 2c92c0f85b4237e6015b441427d250b3 | 0 | | 1 | 2c92c0f95b424512015b4411c1c24812 | KIA Care Plus | 2c92c0f85b4237e6015b4412762a4a7f | Annual Plan | | subscription start day | Two Years | Align to Subscription Start | In Advance | Per Unit Pricing | Recurring | 2c92c0f85b4237e6015b441427d150ae | Billing Period | 2 Year Charge | | | Z-Tax Code | Tax Exclusive | TRUE | Upon Service Activation |
