Clay's Blog

MQTT (message queuing telemetry transport) is a protocol for communication with devices (IoT – internet of things). MQTT integration is available in the coming release of Calem R2024g (Jan. 2025).  Asset meter readings are taken by Calem via MQTT. The readings from MQTT can be viewed at Integration | Open | MQTT Queue 1. MQTT Brokers...

Upsert REST API will be available in the coming release of Calem R2024a. It is more intuitive than current data update APIs. A user may use the API to add or update a record in Calem, similar to the data upload utility (see this blog). A record data is provided to add to database.Calem will perform a database insertion first.If there are&...

API Logs are introduced in the coming release of Calem R2023d. They record errors and the data involved in APIs. For instance, a user is receiving a PO. The receipt is sent to a third party application (such as an ERP app). An error occurred from the third party app. The user contacted support. The support team can view the error and data invo...

This is the second installment of the best practices in Calem. It focuses on the integration support of Calem including data upload via excel and data dictionary for admin and integrators.  1. Bulk Create/Update in Excel Bulk data create and update can be done through excel for efficiency. See this blog: https://calemeam.com/calemcus...

Data integration can be enabled to exchange transactions between Calem and a third party application. For instance, an ERP integration is done for the following transactions. We will use the ERP as an example to discuss ways to pause integration and perform data maintenance in Calem. Integration Direction Transaction Calem to ERP Inventory Sto...

In the coming release of R21a, the Calem API has been extended to support the implementation of ERP (Enterprise Resource Planning solution) integration. Inventory integration is used as an example in this blog. Here is the data flow of the integration. Direction Object Calem to ERPRequisitions for spare parts created, and approv...

​In the coming release of R20d one can embed data fields in the service request emails. This feature may be used by 3rd party apps to integrate with Calem. It is an alternative to integration with Calem via REST API. The following is an email sample reporting an issue with an asset. // Email Subject: Routing device malfunction Ref#3359// Email Body...

​This is a summary of integration options available in Calem. They are organized into the following parts: API Integration - a third party application uses Calem REST API to integrate with CalemEvent Subscription - a third party application uses REST API to receive Calem data change eventsEmail Integration - Calem reads inbound emails to ...