Odoo External API | Create API's In Odoo | Odoo XMLRPC : Connect Odoo With External Applications

[@nehemiahmordecai]

I'm on the 4th video of this series and I came here finding to know how to migrate data btn odoo databases but I've learned way more than just that. so I thought it would be fair to atleast drop a coment. You are doing a grat job man.

[@august7791]

You're just amazing man. And it's really great to see you responding to feedbacks and most essentially to the doubts in the comment sections. Keep up your great work.👏👏👏

[@OdooMates]

Very happy to hear this and thanks for all the support and love

[@shadowcoder19]

Brilliant video @Odoo Mates

[@OdooMates]

Thanks brother ❤

[@charlie.aguilar.88]

This is a great video. I had some trouble understanding the documentation, but your explanation is wonderful. Thank you for sharing.

[@OdooMates]

Thanks for the feedback and for the support :)

[@asmatullahwazir3442]

Great job sir! Very well explained.

[@OdooMates]

Glad it was helpful!

[@thanshidhap.p4743]

Thanks odoo mate..it's really helpful

[@OdooMates]

welcome and thanks for the support

[@Nasirco2010]

great explanation .....

[@OdooMates]

Glad it was helpful!

[@dipendrathapa8591]

most awaited vdo

[@OdooMates]

Enjoy :) Also refer it to your odoo friends :)

[@nadeemkazi2092]

Thanks for providing very usefull info..🙏❤

[@OdooMates]

thanks for the love and support

[@kab9996]

thanks very much for your clear explication !

[@OdooMates]

welcome brother, thanks for the support

[@hassanantous143]

thanks for your great videos

[@OdooMates]

thanks for all the support

[@henishah4974]

Thank you so much for this amazing and helpfull video🙌

[@OdooMates]

thanks for the support :)

[@ВіталійГлапшун]

Great video as usual! Thanks a lot!

[@OdooMates]

thanks

[@leonardoporras4459]

Thanks for your videos

[@OdooMates]

So nice of you

[@mohamedmaher6398]

thanks brother for your help you doing a great job for us

[@OdooMates]

happy to hear it

[@nikhilsurendran7960]

Hi, Thanks for making this video. How we can retrieve sales order on daily base from database

[@OdooMates]

using search method by passing necessary domain, we get the data from the database

[@OdooMates]

kzbin.info/www/bejne/q6WrZKiOoM19nNE

[@nikhilsurendran7960]

@@OdooMates Thankyou very much

[@NMNaufaldo]

Great tutorial as always 👍

[@OdooMates]

thanks brother

[@developer49]

❤‍🔥

[@OdooMates]

[@billbuitrago4644]

Awesome help!

[@OdooMates]

Thanks :)

[@MuhammadAhmad-dg9id]

Thanks for making this extensive and well explanatory tutorial. I have a question related to the sales app. I am searching for the past few days regarding how to accept orders using Odoo external API in python. Can you please suggest a way because I need it urgently. Right now, I am creating a new entry in sales.order but I am struggling to fill the right quotation.

[@OdooMates]

using xmlrpc you can communicate with odoo instance and perform the various needs ? How you are planning to accept the orders ? from a mobile app ?

[@elblasym]

Always creative

[@OdooMates]

Thanks

[@noruwaizevbaye2030]

hello Great video, just want I have been looking for. HOwever I wanted to know which Terminal did you use to run the script ?

[@OdooMates]

This the terminal available in Ubuntu os

[@informatiqueparlapratique3103]

I don't really speak English but I followed your tutorials until the end. I have a little problem. The hr payroll module does not have a pivot view. How to add it by inheritance

[@OdooMates]

You can check this video explaining how to create pivot view in odoo: kzbin.info/www/bejne/joXdfX6wmZ6ca9U

[@OdooMates]

Also i think there is some free modules for the same in odoo app store, see: apps.odoo.com/apps/modules/12.0/hr_payslip_monthly_report/

[@mathieuneyret3108]

Hello ! I'm looking for a way to display with 'read' the many2many relations of a product, Odoo displays me only the id of the many2many field but I would like to display the name... any idea how to do it?

[@mathieuneyret3108]

Precision : I use PHP

[@vcfaiz]

Hi, excellent video! thankyou may i ask you question, where is 'customer' come from ?

[@OdooMates]

please let us know the time frame of the video you are referring to, so its easy for us to answer you

[@vcfaiz]

@@OdooMates at 13:21 you add 'customer', where is that word came from ?

[@evanlittle114]

Thank you

[@OdooMates]

welcome :)

[@sahardagher3127]

Thank you for sharing. It is possible to create soap/web service for odoo ??☹️

[@OdooMates]

odoo xmlrpc is not enough ?

[@sahardagher3127]

@@OdooMates I have to create web service In specific format and i have wsdl files. It is possible to do that with xmlrpc?

[@quickTravel]

All is good... but how to get these data from php website or any other website... please show that also

[@OdooMates]

www.odoo.com/documentation/15.0/developer/misc/api/odoo.html

[@nickhall6782]

Hello, thanks for making this video, it was helpful. I'm wondering if you could make a video about using the API to cause Odoo to perform an action? Like to make Odoo ship an order with the API instead using the UI to ship the order? I have not seen a video about this and it would be helpful. Thanks.

[@OdooMates]

Using this xmlrpc we can trigger any operation inside the odoo

[@nickhall6782]

@@OdooMates Could you make a video showing how to do that? It would be helpful, thanks.

[@wadhajable]

Hi sir, did you solve what you need, if you solve it please TELL me

[@avinashnk9849]

Good Work

[@OdooMates]

Thank you! Cheers!

[@alzaroughalzarough6153]

your explanation is wonderful, how to call the python file inside odoo??

[@abdullahmeaad8232]

Thank you for the video

[@samimasthan]

sir i have one doubt here i trying to importing some data from tally to odoo using xml rpc . for example if i importing the data in particular field how to avoid duplicates how do i mentioned in models.execute

[@OdooMates]

can you tell with an example ? adding a constrains at the odoo will help ?

[@hendrasaputra9014]

is it possible to download attachment from external api? if yes than how? can you give me an idea?

[@OdooMates]

Add an attachment in odoo, in the attachment record there will be a field named public url, you can get the attachment by calling this public url

[@ahmedharoon2740]

hi, i am trying to populate a PHP page with products in odoo (Odoo ver.14) using "product.template" but still failed how to get the Product IMAGE and return to page using xml-rpc ( i am using ripcord library as used in official documentation ), request you to please help on how to. be blessed :)

[@OdooMates]

when trying to get product image, you are getting binary data ?

hey, I wanted to do this with salesforce but the apex language doesnt have a xmlrpcclient. do you have experience with using a module that creates a REST API for Odoo?

[@ferdinandchristianfotie4608]

thank you , but I want to create an invoice using the API, then I have the function to create an invoice via the API ???

[@OdooMates]

yes, you can directly call the create method of invoice model

[@puriniraveendra8008]

How to connect with odoo connect to boomi using database connector

[@OdooMates]

boomi ?

[@ghazibenhalima780]

thanks for this great video..how can i connect mongodb with odoo ?

[@OdooMates]

to be honest, haven't tried this yet

[@dabhijaydeep]

Once again it's good. I want to make a connector so how to it? plz, suggest certain steps. So I can manage it.

[@OdooMates]

What connector you are trying to make ?

[@florent9555]

Hello I have this code in my client program: models.execute_kw( db, uid, password, 'function.registry', 'change_date_planned_start', ['2714', '12.12.2021'] ) then in my model I have this function: @api.multi def change_date_planned_start(self, production_id, date): self.function_name = 'change_date_planned_start' self.domain = ('id', '=', production_id) for function in self: production = self.env['mrp.production'].search([ function.domain ]) if production: production.date_planned_start = date It gives me the error: Typerror: change_date_planned_start() takes exactly 3 arguments (2 given) Why does this happen?

[@OdooMates]

it updates date in manufacturing order

[@sgshankar81]

how can we do this to handle incoming XML Http reqeust and create a sales order

[@fardinmardani7993]

thanks for this videos

[@OdooMates]

So nice of you

[@hapodaicarin1]

The code returns the following error to me when I try to do the search on a system with odoo 14. return res_users.check (db, uid, passwd) \ nTypeError: \ 'Boolean \' object is not callable \ n ¿Do you know any solution? please

[@OdooMates]

Might be something wrong in the written code ? can you verify by checking here in the odoo documentation ? www.odoo.com/documentation/15.0/developer/misc/api/odoo.html

[@franciscovies1787]

I have cors problem when i'm trying connection from ajax xmlrpc. This tutorial doesn't answer that question from many users

[@OdooMates]

may i know what issue you face

[@franciscovies1787]

@@OdooMates thank you for your time. When I want to connect Odoo 12 through xmlrpc jquery, odoo CORS block my requests. I've unlock CORS in Odoo 10, but in Odoo 12 I can't

[@jatinkant1711]

hello sir i need help in odoo as i need to put my records as leads in my crm lead through api, how can i do that please help

[@OdooMates]

you can use this external api or create custom controller for it

[@OdooMates]

kzbin.info/www/bejne/n6TNmaqBdrFpaa8

[@futhedude4848]

I thing this tutorial should have "how to write api in odoo by using xmlrpc" after this video.

[@OdooMates]

Updated the title, thanks for the suggestion brother

[@A076]

Is it possible to execute the browse method using XMLRPC?

[@OdooMates]

yes possible

[@alexcastan_]

Excelent video but i have a question, i make this file .py and i make a read customer but it run in my vps so how i can call this file outside in my app movil in c# for example or other aplications, thk

[@OdooMates]

You can run the file from anywhere, just correctly set the URL and db details correctly in file

[@PacoArronaC]

Hello what if I use sql instead of this api/xmlrpc? for example I need to write an invoice to odoo from an special app, I think it would be easier for my write directly to database using sql instead of this. Is this a right practice?

[@OdooMates]

There is no issue in it, using sql will bypass the access rights and if there is proper idea of the db, there is nothing wrong with this way

[@samimasthan]

how to update invoice_line_tax_ids (many to many realtion ) in xml rpc python

[@OdooMates]

there is an onchange that function, not remembering the function name correctly, but you just need to trigger the onchange only

[@ahmedshabaan9583]

when i write on terminal python3.6 -m web_external_api.py details.... {'server_version': '13.0', 'server_version_info': [13, 0, 0, 'final', 0, ''], 'server_serie': '13.0', 'protocol_version': 1} /home/ahmed/.environments/Odoo13/bin/python3.6: Error while finding module specification for 'web_external_api.py' (AttributeError: module 'web_external_api' has no attribute '__path__')

[@mudassarali9582]

in odoo by using numpy lib what things we can achieve

[@danielalvarado8838]

xmlrpc odoo 14 - creating invoice and payment with python

[@OdooMates]

sorry for delayed response, just need to use the create method of account.move model and pass the required values in the dictionary

[@wadhajable]

I ALSO WANT TO MAKE POS ORDER PAYMENT EXTERNALLY, CAN I?

[@fitwithease8678]

if i just want to show direclty the api data result to tree view , it should not be created in DB is there any solution

[@OdooMates]

you can create a transient model and show using this model

[@Akbarali-ik1sc]

How to download excel report through /web/report rpc call.

[@malluautotechy2393]

how can i integrate odoo with oracle database

[@OdooMates]

for this purpose we have to check and see the documents of oracle system, which database they are using ?

[@boualiyacine]

can I do it with wordpress

[@OdooMates]

yes

[@boualiyacine]

@@OdooMates please i need help

[@OdooMates]

@@boualiyacine let us know

[@DANHOBESAIE]

Please can you share this full source code ? thanks very much

[@OdooMates]

github.com/odoomates/odoosamples/blob/main/external_api.py

[@DANHOBESAIE]

@@OdooMates Thanks you very much !!!

[@uzairrashid7724]

could you please tell us how to install xmlrpc..

[@intenseCL]

pip install pypi-xmlrpc

[@OdooMates]

[@mazenmohamed7077]

How to work code in odoo 13 calculated in sales order discount

[@OdooMates]

Hi, Can you make it clear, what exactly you need

[@mazenmohamed7077]

@@OdooMates A simple code in Sale Order gives a discount on the product, for example 10%

[@3marelamin]

@@mazenmohamed7077 this feature already exists, you don't need to code it. Go to Sales > Configuration > Settings and under pricing sector enable "Discounts" A field name Dis.% will be added to sale order line and you can specify the percentage as you want.

[@monicasomaiya20]

Pdf report how to generate

[@monicasomaiya20]

Jawab bhi dijiye sir..... ❤

[@rmimez2878]

How to create with all fields exists???

[@OdooMates]

Read all value from first db, and pass the dictionary to create method of next db, its not always possible if there is difference in fields between versions

[@samimasthan]

hi sir thanks for your video in invoice creation how to create a field in invoice_ine_ids here im getting error please sort me out kid=models.execute_kw(db, uid, password, 'account.invoice', 'create', [{'partner_id':233,'date_invoice':'2014-05-29','date_due':'2021-05-29','invoice_line_ids': [[0, 0, {'product_id':109,'account_analytic_id':31,'quantity':1.000,'journal_id':408}]}])

[@OdooMates]

sample: env['account.move'].create({ 'move_type': 'out_invoice', 'partner_id': cls.partner_a.id, 'currency_id': cls.env.ref('base.CHF').id, 'partner_bank_id': cls.swiss_iban.id, 'company_id': cls.company_data['company'].id, 'payment_reference': "Papa a vu le fifi de lolo", 'invoice_line_ids': [ (0, 0, {'quantity': 1, 'price_unit': 100}) ], })

[@samimasthan]

@@OdooMates kid=models.execute_kw(db, uid, password, 'account.move', 'create', [{'partner_id':233,'date_invoice':'2014-05-29','date_due':'2021-05-29','invoice_line_ids': [(0, 0, {'product_id':109,'account_analytic_id':31,'quantity':1.000,'journal_id':408})]}]) raise ValidationError(msg) odoo.exceptions.ValidationError: (\'The operation cannot be completed:\ - Create/update: a mandatory field is not set.\ - Delete: another model requires the record being deleted. If possible, archive it instead.\ \ Model: Journal Entries (account.move), Field: Journal (journal_id)\', None) '>

[@OdooMates]

@@samimasthan seems value for a required field is not passed

[@OdooMates]

@@samimasthan kzbin.info/www/bejne/mIGVeqZ_nN-bnLc

[@samimasthan]

@@OdooMates thanks i got the answer its working fine

[@imrantechexpert]

thank you

[@OdooMates]

You're welcome