Consumption list API returns unexpected service period date

Question

Consumption list API returns unexpected service period date

y-watanabe 1

I've asked in stack overflow but couldn't get any help so I would also like to ask in this community .

I am using python sdk to consume billing information , however, I am getting invalid service_period_start_date and service_period_end_date .
This was not happening in our environment before Nov 14, 2023 .

   "servicePeriodEndDate": "0001-01-01T00:00:00Z",  
   "servicePeriodStartDate": "0001-01-01T00:00:00Z",

In what situations does Consumption API return such date ? Any help is appreciated !

Thanks,
Yu

y-watanabe 1 Reputation point

2022-12-29T03:11:24.747+00:00
Hello.

Thank you for the reply.

However, this symptom is STILL happening. ALL dates but "date" attribute is invalid.

Gist for below result.

Querying Microsoft REST API. Started on Thu Dec 29 03:00:37 2022 +0000 billing_period_end_date: 0001-01-01 00:00:00+00:00 billing_period_start_date: 0001-01-01 00:00:00+00:00 date: 2022-12-20 00:00:00+00:00 exchange_rate_date: 2022-12-01 00:00:00+00:00 service_period_end_date: 0001-01-01 00:00:00+00:00 service_period_start_date: 0001-01-01 00:00:00+00:00

I need the detail about the cloud resource which Usage Detail is the perfect API for me. Specifically, cost by product .
Any idea why Azure is returning such date ?
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2022-12-29T07:01:08.66+00:00

Try using the Cost Details API: https://learn.microsoft.com/en-us/rest/api/cost-management/generate-cost-details-report see if that yields results.

1 answer

Your answer

y-watanabe 1 Reputation point

2022-12-29T03:11:24.747+00:00

Hello.

Thank you for the reply.

However, this symptom is STILL happening. ALL dates but "date" attribute is invalid.

Gist for below result.

Querying Microsoft REST API. Started on Thu Dec 29 03:00:37 2022 +0000 billing_period_end_date: 0001-01-01 00:00:00+00:00 billing_period_start_date: 0001-01-01 00:00:00+00:00 date: 2022-12-20 00:00:00+00:00 exchange_rate_date: 2022-12-01 00:00:00+00:00 service_period_end_date: 0001-01-01 00:00:00+00:00 service_period_start_date: 0001-01-01 00:00:00+00:00

I need the detail about the cloud resource which Usage Detail is the perfect API for me. Specifically, cost by product .
Any idea why Azure is returning such date ?
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2022-12-29T07:01:08.66+00:00

Try using the Cost Details API: https://learn.microsoft.com/en-us/rest/api/cost-management/generate-cost-details-report see if that yields results.

Answer 1

Hello @y-watanabe Thank you for contacting us!

The call by Billing Account Balances - Get By Billing Account - REST API (Azure Consumption) | Microsoft Learn gives current month data only.

To get data for other billing periods, please use this API Balances - Get For Billing Period By Billing Account - REST API (Azure Consumption) | Microsoft Learn
Also, try using the Cost Details API: https://learn.microsoft.com/en-us/rest/api/cost-management/generate-cost-details-report see if that yields results. Hope this helps!
----------------------------------------------------------------------------------------------------------------------

If the response helped, do "Accept Answer" and up-vote it

Share via

Consumption list API returns unexpected service period date

1 answer

Your answer