Event Log Monitoring from salesforce API

Question

Below is my requirement: I have to track the event(eg: URI event) from event log file without manually using workbench or REST explorer. It means I have to write a code where it queries the URI event from log file and gives me an output with csv formatted logfile. Here manually I should not use workbench to hit the webservice.everything should be automated in my code and I get the output with daily running batch job(example).

Please do suggest me an idea of how to overcome this.

Thanks In Advance Sravika

Answer 1

Assuming you are talking about this mechanism Using Event Monitoring then in general you will need to use some technology other than Salesforce/Apex to do the work e.g. one of the stacks available on Heroku. You will need to write code that makes the REST web service calls, parses the data and constructs the CSV output.

The problem is that the event monitoring data volumes are large and so it is easy to exceed the 6MB/12MB (for synchronous/asynchronous code) Apex heap limit as streaming IO is not supported. So using Apex - you can make REST calls from Apex - only makes sense if you are sure that the data returned by the API calls you need to use plus the output you want to generate all fit within the relatively small heap limits.