Sending Details to ERP Service
Let us consider a scenario where a customer is monitoring energy consumption in a building by implementing the Zoho IoT's Energy monitoring solution. At the start of every month, the customer wants to calculate the energy consumed in the previous month and send it to the ERP system used by the customer for billing purposes.
This implementation is achieved using the functionality Schedules and Custom Function action as the requirement is to perform the same operation every month.
Prerequisites
First, ensure that the following prerequisites including the necessary licenses, permissions, setups, and configurations are in place.
- Have a valid Zoho IoT account with the required licenses and authenticated ERP credentials.
- Ensure the user has permissions for Schedules and Custom Functions.
- A Zoho IoT application must be set up to monitor and manage building energy consumption.
- Configure an energy meter instance (e.g., Energy Meter 1) as the parent meter to consolidate data from all building assets.
Implementation
The following outlines the high-level steps involved in the implementation.
- Configuring Connections - To execute the APIs call inside the custom function when it is triggered i.e. every month, configure connections as authentication for respective APIs.
- Creating a Schedule - To execute at start of every month and execute the associated custom function.
- Creating a Custom Function - To include the business logic to get the needed data and send to the ERP application.
Procedure
The following provides a step-by-step procedure of the implementation.
Step 1: Configure Connections
We will be creating two connections in the step.
- Connection named IoT Connection using Zoho IoT Service (if available) or Custom Service to authenticate when calling the Zoho IoT API.
- Connection named ERP Connection using Custom Service to authenticate the ERP APIs.
To create the Zoho IoT connection,
- Access the End Application. Click on the Setup icon.
- Click Connections under the INTEGRATIONS section.
The below page is displayed if there are no connections configured.
Image: Sample connections home page
Else,The available connections (if any) are displayed on the right.
Image: Sample connections home page with configured connections3. Click Create Connection button at the center of the screen or at the top right corner of the screen.
Note: As the scope ZohoIOT.settings.cirrus.data.READ scope that is used to fetch data from the application is not available in any default service, you need to create a Custom Service connection. Refer to the Creating Custom Services document for complete details.
4. Select the Custom Services tab.
5. In the Custom Service tab, click Create New Service.To create a custom connection for this implementation:
- Provide the service details for the connection as in the screenshot below.
- The Oauth details such as Client ID and Client Secret can be obtained by registering the client (application).
- Provide the scope as ZohoIOT.settings.cirrus.data.READ. The ZohoIOT.settings.cirrus.data.READ scope is used to fetch data from the application.
- Click Create Service.
Image: Sample connections configuration screen
5. The Service is created. Click Create Connection in the resultant page.6. Provide the Connection Name and Connection Link Name.
7. Click Create and Connect.
Image: Sample connections configuration screen9. Click Connect.Image: Connections Connect screen10. Once connected, the below screen will be displayed with the sample code.11. The entries from the highlighted code below is used in the deluge custom function code.Important: You will be using the url, type, parameter, and connection entries when writing your logic in the custom function.
Image: Deluge code
Similarly, create a second connection ERP Connection using Custom Service for accessing the ERP service securely using OAuth 2.0 or API Key. Refer to the Creating Custom Services document for complete details.
To create the ERP Service connection,1. Select the Custom Services tab.
5. In the Custom Services tab, click Create New Service.To create a custom connection for this implementation:
- Provide the service details as in the screenshot.
- Click Create Service. The service ERP_Service is created.
Image: Sample Custom Service creation screen for ERP Connection
3. In the resultant screen, click Create Connection to create a connection using the ERP_Service.
4. Provide the Connection Name and Connection Link Name.5. Click Create and Connect. This connection allows Zoho IoT to send or receive data from the ERP system without re-entering credentials each time.
Image: Sample Custom Service creation screen5. The Sample codes are displayed in the resultant connection screen. The highlighted code below is used in the custom function code.Important: You need to modify the url, type, and parameter entries with your values when writing your logic in the custom function.
.
Image: Connection screen with deluge script
Step 2: Create a Schedule
Configure a schedule to run at the start of every month.
To create a new schedule,
To create a new schedule,
- Access the End Application.
- Click on the Setup icon.
- Click Schedules under the AUTOMATION section. The schedules available (if any) are displayed in the right.
Image: Schedule home page - Click the Add Schedule button in the top right corner. The New Schedule addition form is displayed.
- Provide the name for the schedule, and provide the required details.
Image: Sample Schedule configuration screen - In Configuring Actions, click Add Action.
- Select Custom Function. The available custom functions (if any) are displayed.
- Select the custom function from here, and it will be associated to the schedule.
Else,
If you have not yet created the custom function, Click the Custom Function button to create a new custom function for the schedule.
Step 3: Create a Custom Function
In the custom function's editor, provide code to implement the business logic to:
- Connect to the IoT application.
- Retrieve the datapoints for each energy meter in Zoho IoT.
- Compute the total energy consumed by summing up all readings.
Image: Sample Custom Function code in deluge editor
Important: In the sample business logic for the implementation provided below, include your own custom values.
DpName = "Energy"; DpSource = "Energy Meter 1"; Period = "lastmonth"; // ============================= // Step 2: Define Zoho IoT API and ERP API endpoints // ============================= // Zoho IoT API endpoint to fetch energy readings from the Zoho IoT application iot_api_url = "https://app15414XXXX.zohoiot.in/iot/v1/datapoints/data?datapoint_name=" + DpName + "&source=" + DpSource + "&period=" + Period; info iot_api_url; // (Update to actual API endpoint in your Zoho IoT setup) // ERP API endpoint to send consumption summary erp_api_url = "https://erp.example.com/api/energy/monthly"; // Replace with actual ERP URL // ============================= // Step 3: Fetch device list from IoT // ============================= // Use Zoho Connection for authentication (example connection name: 'zoho_iot_conn') device_response = invokeurl [ url :iot_api_url type :GET connection:"iotconnection" ]; info device_response; erp_url = "https://erp.example.com/receive_data"; device_response = invokeurl [ url :erp_url type :POST connection:"erp_conn" ]; info device_response; |
Conclusion
This implementation showcases how Zoho IoT’s Energy Monitoring solution can automate monthly energy data processing and integration with ERP systems. By leveraging secure connections and scheduled actions, the customer ensures accurate energy consumption data is shared seamlessly for billing and analysis reducing manual effort and improving operational efficiency.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Sending Details from Zoho Creator
This sample implementation helps to understand sending data to the Zoho IoT Application from Zoho Creator with step-by-step procedures. Scenario Zylker Generators, a leading manufacturer of diesel generators, uses two connected Zoho applications ...Integrating Zoho IoT with External Applications
Zoho IoT enables secure data exchange between your application and other Zoho applications or third-party services. This data exchange can be performed using Zoho IoT’s built-in functionalities or through its REST APIs. All such data access occurs ...Editing asset model details
After an asset model is created, you can change its name and the allowed profiles for the asset. All asset operations require necessary permissions. Refer user profiles document for more details. To edit an asset model, Access the Developer ...Editing asset details
After an Asset is added to the application, you can edit it to change some of the details, such as Name, Description, Connected Gateway, Located at, etc. All asset operations require necessary permissions. Refer User Profiles document for more ...Editing Device Details
After a device is added to the application, you can edit it to change some of the details such as Name, Description, Data interval, Edge Key, etc. All Device operations require necessary permissions. Refer User Profiles document for more details. To ...
New to Zoho LandingPage?
Zoho LandingPage Resources