Request: Ability to Use $select to Reduce Payload in APIM Reports – byRequest API

Question

Request: Ability to Use $select to Reduce Payload in APIM Reports – byRequest API

Ashish Gupta 20

We are using the APIM Reports – byRequest API, which returns a large JSON payload containing many fields (apiId, operationId, productId, userId, url, ipAddress, cache, apiTime, serviceTime, etc.).

To reduce payload size and avoid timeout issues, we need only two fields:

responseCode
backendResponseCode

Is there a way to use $select or any other query parameter in the APIM Reports API to return only these specific fields, instead of the full response object?

Pravallika KV 2,845 Reputation points Microsoft External Staff Moderator

2025-12-04T18:47:26.0966667+00:00
Hi Ashish Gupta

Unfortunately, based on the information provided in MSDOC, it appears that APIM Reports APIs might not currently support the $select parameter for directly limiting the fields in the response to just the ones you're interested in.

However, to manage the payload size and potentially avoid timeout issues, you might consider:

Implementation of Pagination: Use $top and $skip parameters to control the number of results returned, which can help in managing large responses.

Filtering by Date Range: Narrowing down the time range of the reported data could also reduce the volume of information returned.

Post-Processing: If the above parameters don’t help you retrieve only the necessary fields, you could always process the JSON response on your end to extract just the data you need.
Pravallika KV 2,845 Reputation points Microsoft External Staff Moderator

2025-12-05T16:41:08.3533333+00:00

Hi Ashish Gupta, following up to see if you had a chance to check the above response and if it was helpful. Please do let me know if you have any further queries.

Your answer

Pravallika KV 2,845 Reputation points Microsoft External Staff Moderator

2025-12-04T18:47:26.0966667+00:00

Hi Ashish Gupta

Unfortunately, based on the information provided in MSDOC, it appears that APIM Reports APIs might not currently support the $select parameter for directly limiting the fields in the response to just the ones you're interested in.

However, to manage the payload size and potentially avoid timeout issues, you might consider:

Implementation of Pagination: Use $top and $skip parameters to control the number of results returned, which can help in managing large responses.

Filtering by Date Range: Narrowing down the time range of the reported data could also reduce the volume of information returned.

Post-Processing: If the above parameters don’t help you retrieve only the necessary fields, you could always process the JSON response on your end to extract just the data you need.
Pravallika KV 2,845 Reputation points Microsoft External Staff Moderator

2025-12-05T16:41:08.3533333+00:00

Hi Ashish Gupta, following up to see if you had a chance to check the above response and if it was helpful. Please do let me know if you have any further queries.

Share via

Request: Ability to Use $select to Reduce Payload in APIM Reports – byRequest API

Your answer