Each report syncs once an hour if set on Automatic sync, and every 2,000 rows in a report will count as one execution (so a 10,000 row report will count as five executions.) This is a Salesforce-imposed API limitation, but you can work around it by setting some syncs to update manually. The main reporting API used is the synchronous API, which is limited to 500 report executions per hour across all products using the API - not just Airtable. Automatically import Salesforce report data into Airtable. To reduce the incidence of this error, you can consider setting more syncs in your organization to update manually instead of automatically.įor context, Airtable uses the Salesforce’s reporting APIs to access data from your Salesforce instance. The Airtable and Salesforce integration allows you to sync data between both platforms through Zapier, Airtable Sync, and Airtable Automations. However, you may continue to encounter this error intermittently if you have many separate synced tables that connect to your Salesforce instance. This table will resume syncing automatically again after a manually triggered sync completes successfully. To get this table syncing again, you can manually trigger a sync using the Sync Now button. This error message can appear if you have too many Salesforce synced tables querying the same Salesforce instance. If the user who connected a Salesforce sync leaves the company and their Salesforce account gets deactivated, the sync will stop working. Additionally, the user must have both the View and Run Report permissions on any reports that they wish to sync. The OAuth consent screen will look something like this:Īirtable will only have access to the reports that the user who connected the Salesforce sync has access to. Unfortunately, Salesforce does not have very granular OAuth scopes, and API is the minimal scope required to view and run reports. The most important scope listed here is API. If the report has groupings, those groupings will also be automatically added to the main grid view of the synced table. The sync operation will retrieve rows from the selected Salesforce report and generate Airtable records. Once you’ve selected your desired settings, click the Create table button. By default, deleted rows will be removed. Whether or not deleted records (rows from the Salesforce report) should be removed from the Airtable table. Right now, the options are manual syncing and automatic syncing which happens around every hour for this particular Salesforce sync feature. Before creating your synced table, there are Settings options that allow you choose how often you want to sync, and how to handle records deleted or hidden in the source (Salesforce).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |