Hi,

As part of the development of a Data Warehouse solution, we are using Azure billing API and store billing details into a relational database. To avoid redundancy in the database while inserting same data again, we have to identify  primary key (or group of keys which is unique for a row) in the Azure billing reports. (Azure Summary Report, Azure Detailed Report).

Could you please help me to identify the primary key of each Azure reports which is extracted using Azure billing API. Also requested to give me the details of each fields in the Reports to get idea about what it represents. 

Thanks,

Ansar

Hi Ansar O365,

As EA portal is beyond the purview of forum support.

For sample code to use Billing API's see this link: https://automaticbillingspec.blob.core.windows.net/spec/UsageDownloadRestfulSampleClient.zip

https://automaticbillingspec.blob.core.windows.net/spec/MicrosoftAzureEABilling&UsageAPI.docx

I suggest you to open a Billing Support Case  for further assistance in this matter.

Hope this helps you.

Girish Prajwal

• Proposed as answer by Nithin.RathnakarMicrosoft contingent staff, Moderator 12 hours 52 minutes ago

Hi Ansar O365,

As EA portal is beyond the purview of forum support.

For sample code to use Billing API's see this link: https://automaticbillingspec.blob.core.windows.net/spec/UsageDownloadRestfulSampleClient.zip

https://automaticbillingspec.blob.core.windows.net/spec/MicrosoftAzureEABilling&UsageAPI.docx

I suggest you to open a Billing Support Case  for further assistance in this matter.

Hope this helps you.

Girish Prajwal

• Proposed as answer by Nithin.RathnakarMicrosoft contingent staff, Moderator Monday, July 20, 2015 6:28 PM
• Marked as answer by Nithin.RathnakarMicrosoft contingent staff, Moderator 11 hours 26 minutes ago