Introduction
This article outlines how the integration of your ERP data via REST API works.
💡 As a long-term and scalable solution, we recommend you connect your ERP via the REST API. However, if you are interested in learning about the .csv import, check out this article instead.
It offers more flexibility, is easier to test and certain features (like Customer Part Numbers) are not supported via the .csv import.
What is an API?
API is short for ‘Application Programming Interface’. An API is a set of rules that lets programs talk to each other, exposing data and functionality across the Internet in a consistent format.
How do I get started?
Read the documentation for the available API endpoints to understand what data can be synced to and from the ERP. You can find it under this link.
Most of our clients start by importing their internal part numbers (and how they are matched to manufacturers and MPNs) and their inventory.
You can find the documentation for the internal part number endpoint under this link.
You can find the documentation for the inventory endpoint under this link.
Export the relevant data from your ERP
Write a script that transforms the data into the needed JSON format for the API call and uploads the data via the REST API
Add a task (usually in-built in the ERP or via Windows Task Manager) to run the export and upload script once per day
We recommend choosing a time between 10pm and 2am CET for the nightly export.
Do you need support in setting up the API? Do you have general questions related to your ERP integration?
Email us at [email protected] and we will do our best to support you. If your ERP consultant cannot support, we also offer doing the ERP integration for a small extra fee.
Using PowerShell and have access to the database of your ERP?
We have an example PowerShell script that will help you speed up building the integration. Reach out to [email protected] to get access to the script.