Need Rateplan name and id from a particular SKU?
The query contains two tables that are combined, rate plan name and ID comes under the "Rateplan" table and SKU comes under the "Product" table.
In ZOQL we cannot run the join query for both the tables as there is a limitation on the same instead, we can use DataQuery to fetch the data,
below is the Query for the same:
select rp.id,rp.name from rateplan rp join productrateplan prp on prp.id = rp.productrateplanid join product p on p.id = prp.productid where p.sku = 'SAL-00000027'
... View more
How do you import usage file via rest API?
Below are the steps we need to follow to upload a usage file:
We need to download the usage template file from the below KC article:
Post downloading and fill all the mandatory columns which are required as per the above link, it can be a single line and Many lines in a single file, We recommend that you use the following CSV format for better upload.
Then we need to use the postman tool to upload the usage file in the tenant and follow the endpoint URL from the https://www.zuora.com/developer/api-reference/#tag/Usage
Below is the configuration which we need to set in the postman tool:
Key = Content-Type and Value= multipart/form-data
Upload the file(CSV format is recommended for better upload) in the value option, then execute it, then the response will get check import status result:
Then the status of the upload can be viewed:
... View more