IBM Cloudability

 View Only

 Pagination not working with enqueued reports

Jump to  Best Answer
John Waters's profile image
John Waters posted Sat February 22, 2025 09:58 AM

Hello Pagination does not seem to be be applied  when calling the below API, even though the number of results indicates that pagination should be required. The documentation says that pagination should occur with more than 64,000 rows if the limit is set to 0, but instead a single response with total_results=70227 is returned, and the pagination object is null. This apparently has led to reports staying in the running state indefinitely when large result sets need to be returned.

Also, when trying to force pagination by including limit=10000 in the API call, the response object indicates limit=0, which is unexpected.

I've tried this with the following two API calls to the enqueue reporting  endpoint.  Any pointers would be appreciated, thank you in advance.

 https://api.cloudability.com/v3/reporting/cost/enqueue?dimensions=vendor,vendor_account_name,vendor_account_identifier,group_name5,tag18,usage_family,usage_type,lease_type,tag11,enhanced_service_name,tag6&metrics=unblended_cost,total_amortized_cost&start_date=2023-06-01&end_date=2023-06-30&view_id=12345&filters=vendor%3D%3DAmazon

https://api.cloudability.com/v3/reporting/cost/enqueue?dimensions=vendor,vendor_account_name,vendor_account_identifier,group_name5,tag18,usage_family,usage_type,lease_type,tag11,enhanced_service_name,tag6&metrics=unblended_cost,total_amortized_cost&start_date=2023-06-01&end_date=2023-06-30&limit=10000&view_id=12345&filters=vendor%3D%3DAmazon

Varad Rajeev Muthal's profile image
Varad Rajeev Muthal  Best Answer

Hello @John Waters, if still facing an issue with Pagination - you can reach out your Customer Success Manager for further technical help.

Rakesh R's profile image
Rakesh R

Hi John,
Could you provide responses for the query?

John Waters's profile image
John Waters

Hi, it's a 35 MB file with sensitive information in it, but I believe this is what you are interested in:

  "offset": 0,
  "pagination": {},
  "limit": 0,
  "total_results": 70227
}
Varad Rajeev Muthal's profile image
Varad Rajeev Muthal

Hello @John Waters, just checking in - Is the query resolved? if not kindly let me know.