How to prepare daily report of bot execution and send via mail

I would like to prepare daily report and send vial mail.
The mail should have the details like Total number of bots, no of bot successful, no of failed, no of in progress, no of exceptions like no of business exception, no of system exception)

@bijeeshjanardh You can do that by using orchestrator http request “get” function. Just get the API calls, filter them and output your variables in the E-Mail.

The following youtube series (part 1-8) are helpful to set it up:
UiPath Orchestrator API Using Orchestrator HTTP Request Activity | Part 2 | Configuration - YouTube

Swagger UI (
UiPath Connector Guide