[Forum Admin]AliBaba BOA Service

I was trying to get some data by using one of the api call QueryInstanceBill
The resulted JSON seems to be long and there is no date column to filter on how i got those many records.
Could someone here help me out

QueryInstanceBill API returns data for billing cycle which is usually for a month (YYYY-MM)

If you want data for a particular date then in request parameter provide the value for field "BillingDate" in format: YYYY-MM-DD
and the value for field "Granularity" should be "DAILY"

Check out the documentation:
https://www.alibabacloud.com/help/doc-detail/100400.htm

Also, you can use OpenAPI Explorer, I have provided BillingCycle as "2019-10", BillingDate as "2019-10-15" and Granularity as "DAILY":
https://api.aliyun.com/#/?product=BssOpenApi&version=2017-12-14&api=QueryInstanceBill&params={%22RegionId%22:%22cn-hangzhou%22,%22Granularity%22:%22DAILY%22,%22BillingCycle%22:%222019-10%22,%22BillingDate%22:%222019-10-15%22}&tab=DEMO&lang=JAVA

Thanks for the reply @kcloud. I was able to get the records. Here are few thing that i need to clarify.

1.  I pulled records using  below parameters
      

                 var queryBillOverviewRequest = new QueryInstanceBillRequest();
                    queryBillOverviewRequest.BillingCycle = "2020-01";
                    queryBillOverviewRequest.BillingDate = "2020-01-01";
                    queryBillOverviewRequest.Granularity = "DAILY";
                    queryBillOverviewRequest.IsBillingItem = true;

 but the report count and amount genererated from the portal is mismatching.

In Portal below is the path from where i am getting data.

BillManagement - > Bill - > Details  Tab

under that i have selected Billing Cycle as 2020-01, Statistic Item: Billing Item , Statistic Period: By Day.