Unable to pass Cost Managment pagination next link url .

[arjun-hareendran]

Package Name: azure-mgmt-costmanagement
Package Version: 4.0.1
Operating System: Windows 11 
Python Version: 3.9.12

Requirements.txt

azure-identity
azure-mgmt-resource==20.0.0
azure-mgmt-costmanagement==4.0.1
azure-mgmt-storage==20.0.0
python-dateutil

I am trying to extract some cost details from azure using cost management and since the granularity is at daily, I expect the system to return back couple of thousands of records. What I observed is, the call returns 5000 records, in order to get more records, I referred the documentation and could see the next_link value. I referred the documentation but couldn't find a way to pass this url back to fetch the next set. Is this something the SDK supports?

SUBSCRIPTION_ID = ""

    credential: DefaultAzureCredential = DefaultAzureCredential()
    cost_management_client = CostManagementClient(credential)

    scope = f"/subscriptions/{SUBSCRIPTION_ID}"

    today = datetime.now()
    start_date = datetime(2024, 6, 1)
    end_date = today.replace(
        day=calendar.monthrange(today.year, today.month)[1]
    ).strftime("%Y-%m-%dT23:59:59Z")

    query_definition = QueryDefinition(
        type="AmortizedCost",
        timeframe="Custom",
        time_period=QueryTimePeriod(
            from_property=start_date,
            to=end_date,
        ),
        dataset=QueryDataset(
            granularity="Daily",
            aggregation={
                "TotalCost": QueryAggregation(name="Cost", function="Sum")
            },
            grouping=[
                QueryGrouping(name="ResourceGroup", type="Dimension"),
                QueryGrouping(name="ResourceType", type="Dimension"),
            ],
        ),
    )

    cost_data_response = cost_management_client.query.usage(
        scope=f"/subscriptions/{SUBSCRIPTION_ID}/",
        parameters=query_definition,
    )
    print(len(cost_data_response.rows))
    print(cost_data_response.next_link)

[msyyc]

@ChenxiJiang333 Please help on this issue.

[ChenxiJiang333]

got it

[ChenxiJiang333]

Hi @jayati-tehri, it seems an issue similar with #18927 (comment), is that possible to provide a new operation Query_UsageNextLink in the swagger?

[koetjeengdjalanan]

Hi, I have a pretty similar use case to @arjun-hareendran, is there any update or work around you guys confident enough to share?

[ChenxiJiang333]

Hi @jayati-tehri, it seems an issue similar with #18927 (comment), is that possible to provide a new operation Query_UsageNextLink in the swagger?

Hi @msft-vbhatnagar @thramu, could you help take a look at this issue about providing a new operation for the service to make SDK be able to read a nextLink?

[koetjeengdjalanan]

Hi, has there been any update regarding this issue? or is there a work around yet?

[ChenxiJiang333]

has opened an issue for service attention: Azure/azure-rest-api-specs#32880. please follow it to get support.

[xiangyan99]

Please use Azure/azure-rest-api-specs#32880 to track the issue.