Skip to main content

Hello Salesforce Labs Team, 

 

We identified an issue with the TSP Accelerator package that causes API record access counts to be understated when Salesforce queries return multiple batches.

Our investigation confirmed the following:

  • Salesforce Inspector exported 5,000 records through an initial Query request and two QueryMore requests (2,000 + 2,000 + 1,000).
  • Historical ApiEvent records show RowsProcessed = 5000 on the initial query, while Records.totalSize = 2000.
  • Transaction Security evaluates the initial Query request but not subsequent QueryMore requests. Please see this article that mentions this behavior.
  • The TrxSec_DetectTotalAccessAPI class uses LogMultipleRecordAccess.extractRecordCount(e.Records) for threshold evaluation and passes e.Records to the asynchronous logging process. Consequently, only 2,000 records are counted.

TSP Accelerator – API record access undercounted for paginated queries

 

Proposed correction: Use ApiEvent.RowsProcessed

for both threshold evaluation and record-access logging, with appropriate fallback handling when the value is unavailable or negative. 

 

Could you, please, let me know whether this is the appropriate way to log this issue and request this update? We are on v1.7.2.

 

Thank you in advance! 

 

#Salesforce Labs

1 个回答
  1. 10月29日 21:37

    The three ways to give feedback about a Salesforce Lab app are posting here, opening an issue in the GitHub repository for the app (if there is one), or providing feedback on the AppExchange to the creators. Thanks for providing feedback abou this app!

0/9000