Hey everyone! I’m new to n8n and I’m trying to set up a daily contact import from Odoo to Revo. The Odoo node is working fine, but I’m stuck on how to filter the contacts before importing them.
I’ve heard about using a ‘domain’ filter, but I can’t find clear instructions on how to do this. Both n8n and Odoo are running in SaaS mode, if that matters.
Has anyone done something similar? I’d really appreciate any tips on how to set up this filtering. It would save me a ton of time not having to import all contacts every day.
Thanks for any help you can offer! I’m excited to get this workflow up and running smoothly.
I’ve implemented a similar workflow for Odoo-to-CRM imports using n8n. The domain filter is indeed the way to go. In the Odoo node configuration, look for the ‘Additional Fields’ section. There, you can add a ‘domain’ parameter.
For daily imports, you might use something like:
[[‘write_date’, ‘>’, ‘${new Date(Date.now() - 86400000).toISOString()}’]].
This filters contacts modified in the last 24 hours. Adjust the time range as needed. Remember to properly format the date string for Odoo.
Also, consider using n8n’s built-in scheduling to automate the daily run. It’s under the ‘Trigger’ section when editing your workflow.
Hope this helps streamline your import process!
hey there! i’ve done similar stuff with odoo and n8n. for filtering, try using the domain parameter in the odoo node. something like [[‘create_date’, ‘>’, ‘YYYY-MM-DD’]] should work for getting recent contacts. you might need to play around with the date format a bit. good luck with your workflow!