Only 100 results returned from the FlexReports API

Products

• CloudHealth

Issue/Introduction

The FlexReport API defaults to 100 results.

Resolution

This can be overridden in the API call by adding a limit parameter set to -1 as shown:

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS \"SUM(lineItem_UnblendedCost)\" FROM AWS_CUR GROUP BY timeInterval_Month",
  "dataGranularity": "MONTHLY",
  "needBackLinkingForTags": true,
  "limit": -1,
  "timeRange": {
    "from": "2021-03",
    "to": "2021-04"
  }
}