Request Body Schema · Azure Cost · microsoft/azure-skills · Skills Docs

Request Body Schema · Azure Cost · microsoft/azure-skills · Skills Docs

{
  "type": "<report-type>",
  "timeframe": "<timeframe>",
  "timePeriod": { "from": "2024-01-01T00:00:00Z", "to": "2024-01-31T23:59:59Z" },
  "dataset": {
    "granularity": "<granularity>",
    "aggregation": { "<alias>": { "name": "<column>", "function": "<function>" } },
    "grouping": [{ "type": "<column-type>", "name": "<column-name>" }],
    "filter": { "<filter-expression>" },
    "sorting": [{ "direction": "<direction>", "name": "<column>" }]
  }
}

Field	Type	Required	Description
`type`	string	Yes	`ActualCost`, `AmortizedCost`, or `Usage`
`timeframe`	string	Yes	Predefined or `Custom` time window
`timePeriod`	object	Conditional	Required when `timeframe` is `Custom`. Contains `from`/`to` ISO 8601 dates.
`dataset`	object	Yes	Defines granularity, aggregation, grouping, filtering, sorting

"filter": {
  "and": [
    {
      "dimensions": {
        "name": "ResourceGroupName",
        "operator": "In",
        "values": ["rg-prod", "rg-staging"]
      }
    },
    {
      "not": {
        "tags": {
          "name": "Environment",
          "operator": "Equal",
          "values": ["dev"]
        }
      }
    }
  ]
}

Operator	Description	Children
`and`	All child expressions must match.	2 or more expressions.
`or`	Any child expression must match.	2 or more expressions.
`not`	Negates a single child expression.	Exactly 1 expression.

Operator	Description	Example
`In`	Value is in the provided list. Supports multiple values.	`"values": ["vm", "storage"]`
`Equal`	Exact match against a single value.	`"values": ["production"]`
`Contains`	String contains the specified substring.	`"values": ["prod"]`
`LessThan`	Numeric less-than comparison.	`"values": ["100"]`
`GreaterThan`	Numeric greater-than comparison.	`"values": ["0"]`
`NotEqual`	Value does not match the specified value.	`"values": ["dev"]`

{
  "id": "<query-id>",
  "name": "<query-name>",
  "type": "Microsoft.CostManagement/query",
  "properties": {
    "nextLink": "<url-for-next-page-or-null>",
    "columns": [
      { "name": "Cost", "type": "Number" },
      { "name": "ServiceName", "type": "String" },
      { "name": "UsageDate", "type": "Number" },
      { "name": "Currency", "type": "String" }
    ],
    "rows": [
      [123.45, "Virtual Machines", 20240115, "USD"],
      [67.89, "Storage", 20240115, "USD"]
    ]
  }
}

Field	Type	Description
`columns`	array	Array of column definitions with `name` and `type`.
`columns[].name`	string	Column name.
`columns[].type`	string	Data type: `Number` or `String`.
`rows`	array	Array of row arrays. Values ordered to match `columns`.
`nextLink`	string	URL for next page of results, or `null` if no more pages.