Usage Report Records

4min

One of the most powerful features of Amberflo is Usage Analytics. Amberflo extends this feature to its Salesforce managed app.
Sync job
The application includes a sync job AFLO.UsageRecordDownloadScheduler which can be scheduled to import usage records from Amberflo. These usage records can be leveraged for reporting purposes in Salesforce. For each customer, usage is loaded by aggregating the values of the meter into a daily bucket.
The sync job can be scheduled to run daily. Every time the job runs, it fetches usage records from Amberflo with start date greater than the latest end date value in Salesforce. This way only the delta is synced between the two systems instead of bringing in all usage records.
Data schema
Usage report records are maintained as a custom object: UsageRecord. These records are related to the Amberflo customer object.
Text
AFLO__UsageRecord__c
AFLO__UsageRecord__c
﻿
﻿
﻿
Scheduling instructions
Go to Setup 
Type "Apex" 
Select Apex Classes 
Click on the button Schedule Apex 
Enter the Job Name 
Select "UsageRecordDownloadScheduler" as Apex Class 
Set your schedule - we recommend to run daily at UTC midnight + 6 hrs
﻿
Text
(new AFLO.UsageRecordDownloadScheduler()).execute(null);
(new AFLO.UsageRecordDownloadScheduler()).execute(null);
﻿
﻿

Updated 31 Jul 2024

Did this page help you?

Backfilling data into Salesforce

CRM - HubSpot