How call an API when values change in DataBase?

Question

Hello,
When I update data with an override "write" function, I do a post request for an external application with the id of changed record (cf: the code bellow). Then the app get the values in postgres but the values hasn't change at this time.

@api.multi
def write(self, values):
for record in self:
res = super(my_class_xxxx, self).write(values)
data = {"id": record.id}
requests.post("https://us-central1-xxxxxxxx.com", data=data)
return res

I think the record is update in Odoo but the value of

Ravi Gadhia · Accepted Answer

hmm you are right is not committed yet DB. it's committed when request return result
I think you need to explicitly commit the cursor to stored data forcefully in DB like
​@api.multi
def write(self, values):
for record in self:
res = super(my_class_xxxx, self).write(values)
data = {"id": record.id}
*​        record.env.cr.commit()*
requests.post("https://us-central1-xxxxxxxx.com", data=data)
return res

Paresh Wagh · Answer

Hi Theo:
You may want to consider using an Automated Action (*Settings > Technical > Automation*) to invoke the api on the *On Creation* trigger condition of the model.

Théo Da silva · Answer

Thank you both for your answers, the method of Ravi Gadhia works perfectly so I haven't tried your's ​Paresh Wagh ​but I think it can works too :)

İlgili Gönderiler	Cevaplar	Görünümler
Why doesn't fetchall() return the same thing as the SQL request? Çözüldü postgresql v7 api	18 Ağu 18	23686
External API update / write method problem Çözüldü external update api write	2 Mar 25	4621
Update product using REST API (JSON-RPC) ? update api write rest	6 Ara 23	51216
Integration of Third Party Digital Membership Card MembershipAnyWhere with Odoo CRM api	1 May 26	1476
API Integration: POST request succeeds but record not created in database api	0 May 26	6

Bu soru işaretlendi

Tartışma hoşunuza mı gidiyor? Sadece okumakla kalmayın, katılın!