There is nothing more aggravating than hitting your Salesforce API usage limit.
Your company grinds to a halt. Apps stop talking to each other. Data is blocked from being added to your CRM. Maybe certain pieces of your sales software stack stop working altogether.
Then you’re forced to buy more and increase your API limit, just to keep the wheels turning. Or sit around and wait for the 24-hour window to expire, losing valuable time and tanking your productivity — who wants to deal with that?
For many organizations — and especially those who use a lot of apps that make many API calls — this can be a huge source of aggravation. Your Salesforce API limit can severely hold your organization back.
So naturally, you’ll try to take steps to monitor and manage API calls. You have to. The cost of hitting that ceiling is just too much for any company to stomach.
Now you have to estimate (often this means taking wild guesses) at which apps and integrations are using the most API calls. Then, you can remove the integration and cut back on Salesforce API usage and stay within the API limit.
Unfortunately there is no easy way to determine what apps and integrations are costing you, in terms of Salesforce API allocation. These are critical components in your business. You want to make a data-driven, informed choice here.
Any app on the Salesforce AppExchange is going to make API calls. After installing an app , it could run through tens of thousands of API calls in minutes without you knowing, and therefore you need the ability to review API usage by each app.
There is a way to generate a Salesforce API usage report with a full app-by-app breakdown of your API usage. It’s not the simplest solution, but following this guide we'll show you how to accomplish that.
Make smarter, data-driven decisions about your Salesforce API usage and management and stay within the API limit.
Salesforce make some API usage reports available through its main reporting system.
In Salesforce Lightning, navigate to Setup -> System Overview for a quick snapshot of API requests made in the last 24 hours.
For this report you'd need to switch to Salesforce Classic mode as it is not available in Lightning at the moment.
Navigate to Reports -> Administrative Reports. Find the “API Usage in the Last 7 Days” report. This will generate a list of API requests generated in the last week.
This report shows the API usage and API requests by users for the last 7-days, including the current day. This is useful for staying within your API limit and monitoring usage.
These reports represent a good start and provide a way to monitor overall usage, but they don’t really provide the full breakdown that you need to make smart business decisions.
Salesforce does not offer a standard, out-of-the-box report that allows you to see an app-by-app breakdown of your Salesforce API usage and API request numbers from each app.
But, there is a workaround and it’s not too difficult. The benefits of being able to see this kind of breakdown vastly outweigh the alternatives and give you detailed breakdown of API requests per app, including both SOAP API and REST API usage.
To do this, we’ll use event logging data, which records each event and API request. You’ll need access to Salesforce Workbench.
1. Log into Salesforce Workbench:
Here is the Workbench login URL: https://workbench.developerforce.com/login.php
2. Navigate to Queries -> SOQL Query
This is where we will query the event logging data and API request data on a per-app basis.
3. Run A Query
Now we are going to ask Workbench to pull data about API request usage on a per-app basis.
In the Object dropdown select "EventLogFile" and then paste the query below into the "Enter or modify a SOQL query below:" text area. No need to select or change anything else in this screen.
SELECT ApiVersion,CreatedById,CreatedDate,EventType,Id,IsDeleted,LastModifiedById,LastModifiedDate,LogDate,LogFile,LogFileContentType,LogFileFieldNames,LogFileFieldTypes,LogFileLength,SystemModstamp FROM EventLogFile
4. Scroll right to the "LogFile" column, double-click on the very long string to copy it to the clipboard.
5. Paste that String into Base64 Decoder, and click “Decode.”
Paste the long string into your Base64 Decoder. Code Beauty is an excellent and free web-based Base64 decoder.
Once you click “Decode,” the app will translate the string into a standard plain-text CSV format. Copy and paste the CSV into a file log.csv
6. Open log.csv in Excel or similar, look at the last column named “SOURCE_IP.”
The “SOURCE_IP” column tells you the IP of the app that made the API call. Once you connect your IPs to apps, you have a full breakdown of which apps and integrations made what API calls and when.
Using that data, you can create all sorts of reports to analyze and manage your API data. For instance, you could aggregate and analyze your Salesforce API calls by date, time, and IP.
Learn more about Salesforce Salesforce API limits and allocations. When needed you can use Salesforce Checkout to buy additional APIs online.
Insycle is a customer data management tool for Salesforce. Using Insycle, you can deduplicate contacts, accounts, and leads, and then cleanse and standardize your Salesforce CRM data. It can also help you solve common problems with Salesforce and HubSpot integration, import from CSVs, and make routine bulk updates.
Insycle delivers deep API monitoring for any app that is connected to the platform.
Control API Call Usage Globally and Per-App
Insycle features two options for managing API call usage in real-time with these controls:
Audit API Calls
Insycle automatically meters and logs all API calls made through the system providing a complete audit trail so that you can see what calls happened, when they happened, and why they happened.
Monitor API Usage By App
Insycle shows a breakdown of API call usage for all apps connected to your Insycle account.
The “API Usage” screen shows you real-time API usage data across all of your apps. Data shown includes:
How can I reduce usage of API calls in Salesforce?
There are multiple ways that you can reduce the number of Salesforce API calls that your organization is making. These include:
How can I increase my API calls limits?
You can purchase extra Salesforce API calls either at checkout or by contacting your account representative. Additionally, you can increase API calls by buying additional user licenses.
How Can I View My Organizations API Calls?
You can view your company's API calls on the System Overview Page.
Monitoring and managing your Salesforce API usage across all of your apps is critical. You have to make sure that your most critical apps and integrations continue running at all times, or you risk big losses.
Using this simple guide, combined with Insycle’s advanced API management features, you can gain a top-down view of your Salesforce API usage and save yourself from API-related shutdowns.
If you’d like to improve your Salesforce data management, you can try Insycle on a 7-day trial by filling out the form below.