Your shop floor contains many valuable assets that must be tracked and maintained. Most companies use an ERP system to manage assets, and push important data to other systems, keeping all systems in sync. Essentially, the ERP is the "Master" record and all other systems are "Slave" records.
Keeping important asset information in sync with L2L is simple. Using the APIs documented below, you can create and update asset data in L2L. We recommend updating records when the master asset record is created or updated. It may also be prudent to update synchronize all assets once or twice a year, just to maintain data integrity across all systems.
If you are a new customer, or you don't have a dedicated IT resource, don't worry! Your L2L account representative can help you synchronize your Machines and Tooling using a spreadsheet upload tool. Just send us an email and we can guide you through the process.
There are two types of assets in L2L: Machines and Tooling. Machines are typically bolted to the floor, but can be a mobile unit, such as a welder. Tooling are attached to Machines, like dies or molds. Each can be managed through their individual APIs:
Adding and Updating Machines
Use this API to create new Machines in L2L or update existing machines.
Objective: Machine records are synchronized between ERP system and L2L
Suggested Interval: Once every quarter
Suggested Trigger: When a machine is updated in ERP system
Process Outline:
- Query ERP for new or updated Assets.
- Create new Asset records in L2L.
POST https://[customer].leading2lean.com/api/1.0/machines/?auth=[api key]&site=[site id]
- POST Parameters:
code=[ERP Asset code]
- use the ERP Asset code as the Machine Code. This will make it possible to synchronize in the future.
- consult the API documentation on your Leading2Lean system for additional parameters.
- POST Parameters:
- Update existing Asset records in L2L
- Retrieve the existing Asset record in L2L
GET https://[customer].leading2lean.com/api/1.0/machines/?auth=[api key]&site=[site id]&code=[ERP Asset Code]
- This API call will return a JSON object of the L2L Machine.
- Replace all values with values from the ERP
- Perform the update
POST https://[customer].leading2lean.com/api/1.0/machines/?auth=[api key]&site=[site id]
- Post Parameters: taken from the modified JSON object from step 3.3. The Machine
id
field is required to update the L2L Machine record.
- Post Parameters: taken from the modified JSON object from step 3.3. The Machine
- Retrieve the existing Asset record in L2L
Adding and Updating Tooling
Use this API to create new Tooling records in L2L or update existing Tooling records.
Objective: Tooling records in L2L are in sync with ERP Tooling records.
Suggested Interval: Once per month
Suggested Trigger: When a Tooling is updated
Process Outline:
- Query ERP for new or updated Tooling
- Create new Tooling records in L2L.
POST https://[customer].leading2lean.com/api/1.0/tooling/?auth=[api key]&site=[site id]
- POST Parameters:
code=[ERP Tooling code]
- use the ERP Tooling code as the Tooling Code. This will make it possible to synchronize in the future.
- consult the API documentation on your Leading2Lean system for all of the required parameters.
- POST Parameters:
- Update existing Tooling records in L2L
- Retrieve the existing Tooling record in L2L
GET https://[customer].leading2lean.com/api/1.0/tooling/?auth=[api key]&site=[site id]&code=[ERP Tooling Code]
- This API call will return a JSON object of the L2L Tooling records.
- Replace all values with values from the ERP
- Perform the update
POST https://[customer].leading2lean.com/api/1.0/tooling/?auth=[api key]&site=[site id]
- Post Parameters: taken from the modified JSON object from step 3.3. The Tooling
id
field is required to update the L2L Tooling record.
- Post Parameters: taken from the modified JSON object from step 3.3. The Tooling
- Retrieve the existing Tooling record in L2L