Increase the number of records return by Usage API call

%3CLINGO-SUB%20id%3D%22lingo-sub-87600%22%20slang%3D%22en-US%22%3EIncrease%20the%20number%20of%20records%20return%20by%20Usage%20API%20call%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-87600%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22contentStandard%22%3ECurrently%2C%20the%20number%20of%20aggregations%20returned%20by%20a%20single%20Usage%20API%20call%20is%201000%3CFONT%20face%3D%22Segoe%20UI%2C%20Lucida%20Grande%2C%20Verdana%2C%20Arial%2C%20Helvetica%2C%20sans-serif%22%20color%3D%22%232a2a2a%22%3E%3CSPAN%3E.%20I%20am%20hitting%20an%20Usage%20API%20at%20hourly%20granularity%20and%20expecting%20more%20than%201000%20records%2C%20but%20It%20is%20returning%201000%20records%20only.%20Please%20suggest%20the%20possible%20solution%20to%20increase%20this%20limit.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%20class%3D%22contentStandard%22%3E%3CFONT%20face%3D%22Segoe%20UI%2C%20Lucida%20Grande%2C%20Verdana%2C%20Arial%2C%20Helvetica%2C%20sans-serif%22%20color%3D%22%232a2a2a%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%20class%3D%22contentStandard%22%3E%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fpartnercenter%2Fmt791774.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fpartnercenter%2Fmt791774.aspx%3C%2FA%3E%3CFONT%20face%3D%22Segoe%20UI%2C%20Lucida%20Grande%2C%20Verdana%2C%20Arial%2C%20Helvetica%2C%20sans-serif%22%20color%3D%22%232a2a2a%22%3E%3CSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%20class%3D%22contentStandard%22%3E%3CFONT%20face%3D%22Segoe%20UI%2C%20Lucida%20Grande%2C%20Verdana%2C%20Arial%2C%20Helvetica%2C%20sans-serif%22%20color%3D%22%232a2a2a%22%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%20class%3D%22contentStandard%22%3E%3CFONT%20face%3D%22Segoe%20UI%2C%20Lucida%20Grande%2C%20Verdana%2C%20Arial%2C%20Helvetica%2C%20sans-serif%22%20color%3D%22%232a2a2a%22%3E%3CSPAN%3EShruti%20Agnihotri%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-87600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%20Management%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsageAPI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Currently, the number of aggregations returned by a single Usage API call is 1000. I am hitting an Usage API at hourly granularity and expecting more than 1000 records, but It is returning 1000 records only. Please suggest the possible solution to increase this limit.

 

https://msdn.microsoft.com/en-us/library/partnercenter/mt791774.aspx

Regards,

Shruti Agnihotri

1 Reply

@Shruti Agnihotri 
I am looking for such similar scenario. Did you find any solution? 

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/query-data-web-api

above documentation says "Unless you specify a smaller page size, a maximum of 5000 entities will be returned for each request. "
Any idea how to achieve this?