Hello
I will share here some good stuff with my n8n apps connected to my differents Axelor instance (production, testing …)
But what are you talking about?
n8n.io is « The workflow automation platform that doesn’t box you in, that you never outgrow ».
I talked about API connection, the best way to take information, update data, …
If you now about Zapier, n8n is very similar.
But why are you telling us about this?
For me, it’s THE apps for connect everything. My way to send the order from Magento2, a solution for connect my Qonto bank, an automatic connection from Akeneo (Product information Management) and everything else to Axelor (or other apps).
ok but another apps…why?
Open-source is awesome, but we need to manage data between apps, and each application has its own way of using the data. API is the best way to communication between app. n8n can help you a lot.
We can write data to csv file and read it on a other workflow! you want it on a database like mysql ? No problem ! send data to hubspot, take data from MailChimp, Stripe, Paypal …
n8n and Axelor
This is a workflow with 4 node
The first one is a « Start » node simple. But you can take a « cron start » for starting this worklow every day at 4am.
The Second and the third node are a generic node « HTTP Request ». I use it here for make request to my dev instance Axelor. « Cookies » ask token to my axelor instance for the rest of the workflow. « Liste models » GET model of my axelor instance.
The fourth node split the data received. I export 575 domain models from my dev instance Axelor
You can build a lot of possibilities.
Workflow : Organization of Axelor
Between version, you have different structure of Axelor.
This workflow can give you all domain model and all column of each domain model in a folder on your computer (csv file)
Results :
How to do it ?
Install n8n by yourself, I can’t explain here how to do this part (n8n have this own forum for this).
I use docker.
How to connect to Axelor ?
You need a HTTP Request node just for cookie.
You have to specify « Full response » for having the token in the header.
Complete URL for my instance :
http ://IP/axelor-erp-v6.1.8/login.jsp
In body parameters :
{ « username »: « admin », « password »: « admin » }
The next node HTTP Requet
Here a simple GET resquest for ask domain model as you can find here the API doc
URL :
http ://IP/axelor-erp-v6.1.8/ws/meta/models
Headers :
{ « Content-Type »: « application/json », « Cookie »: "[{{$node["Cookies "].json[« headers »][« set-cookie »][2]}}; {{$node["Cookies « ].json[« headers »][« set-cookie »][0]}}] » }
Give us some workflow you did
I ask to Axelor all invoice per customer (list of 5 big customer) for the month past.
1 CSV file is create per customer - resume : date, order number, invoice number, total exclude tax, include tax.
1 folder ZIP with all invoice per customer.
This workflow below gives me the unpaid invoices to date, write them on a CSV file, and notify me on RocketChat
So much to do…