How to connect Zapier to an Odoo.sh database?

Question

[CONTEXT] Zapier is a freemium service that is  able  to "Connect your apps and automate workflows". A zap is already created in Zapier that enables you to create new leads coming from an infinite  types of sources (e.g. ninjaform / facebook / google spreadsheet / etc.)
Connecting Zapier with an OdooSaas database is easy. Just follow the steps Zapier  is  giving  you.
However - connecting Zapier with an Odoo.sh database is complexier.
It often gives you this error "Fault (code AccessDenied) occu

Valentin Gailly (vag) · Accepted Answer

We need here to add a specific custom allias domain to enable Zapier understand the actual name of the database.

More concretely - follow these steps :
1/ Odoo.sh -> Select the production branch -> go in the shell 2/ Copy the name of the database "mydatabase-main-XXXXXXX" 3/ Go in the  "setting"  tab.  Create  a  new  domain  allias  by pasting  this database name e.g. " mydatabase-main-XXXXXXX.odoo.com" 4/ In the zapier settings (for connection) - please use this new database domain to get con

JumpWish sarl · Answer

Hi Valentin,
Just trying your tips to connect zapier and to my odoo sh database but still not working.
Does we need to use API key instead of my traditional password ?
With both passeword and allias database name still “AccessDenied“ return.
Thank you for your return.
Gauthier

相关帖文	回复	查看
Create Leads in Odoo CRM by Connecting to Zapier zapier quickstart Quickstart	0 1月 25	2515
Odoo.sh Basics terms explained 已解决 technical functional quickstart Odoo.sh	1 6月 22	4043
Set a color change in a lead/opportunity based on a time condition - v15 crm leads colors quickstart v15	0 4月 22	3080
Link attachments with wanted record and model 已解决 quickstart	1 4月 25	7395
Odoo.SH Github account ownership transfer, trying to change the repository Odoo.sh	2 3月 25	6191

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！