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 something about using a ‘domain’ filter, but I can’t find any clear info on how to do this. Both n8n and Odoo are running in SaaS mode, if that matters.
Has anyone done this before? How can I set up a filter to choose specific contacts for import? Any tips or examples would be super helpful!
Thanks a bunch for any advice you can give. I’m really excited to get this working!
I’ve actually tackled a similar challenge with Odoo and n8n integration recently. For filtering contacts in the Odoo node, you’re on the right track with the ‘domain’ filter. It’s a powerful tool, but can be tricky to get right.
In the Odoo node configuration, look for the ‘Additional Options’ section. There should be a field called ‘Search Criteria’ or ‘Domain’. This is where you’ll input your filter.
The syntax is a bit peculiar. It uses a list of tuples. For example, to filter contacts created today, you might use something like:
[[“create_date”, “>”, “2023-11-15 00:00:00”]]
Replace the date with today’s date, of course. You can combine multiple conditions too.
One gotcha: make sure to escape the quotes properly. n8n can be picky about that.
Hope this helps get you started. Let me know if you need more specifics!
I’ve been working with Odoo and n8n integration for a while now, and filtering contacts can indeed be tricky. The ‘domain’ filter is your best bet here. In the Odoo node configuration, look for the ‘Additional Options’ section and find the ‘Search Criteria’ or ‘Domain’ field.
The syntax for the domain filter is a bit unique. It uses a list of lists, each representing a condition. For a daily import, you might want to use something like this:
[[‘write_date’, ‘>’, ‘2023-11-15 00:00:00’]]
This will filter contacts modified after the specified date. You’ll need to update the date dynamically for each run. You can achieve this by using n8n’s expressions to generate the current date.
Remember, you can combine multiple conditions in the domain filter for more complex queries. It may take some trial and error to get it just right, but once set up, it’s quite powerful for managing your imports.
hey scarlettturner, i’ve used odoo with n8n before. for filtering, try the ‘domain’ option in additional settings. it uses a weird syntax like [[‘field’, ‘operator’, ‘value’]]. for daily imports, maybe filter by create_date? might need to play around with it. good luck!