This question has been flagged
1 Reply
5674 Views

I created record from c# to odoo successfully one by one, but very slow process.

Now, I want to insert bulk record to Odoo by calling Odoo API ? if it's possible let me know How ? 

Avatar
Discard
Best Answer

Hi Ghanshyam,

To dealing with bulk data using ORM create isn't good practice at all, usual SQL query would give you fastest result.
Create one custom method inside write SQL query, call this method through API & pass values to be insert. 

Avatar
Discard
Author

So you mean using Odoo API we can run query and insert data right ?

Please Sushma let me know how to run sql query using Odoo API. your help would be appreciated.

Author

And you said for creating Custom Method inside, but i don't know where to need to create in Odoo ?

create any/custom method on odoo which would be having SQL query insert, and while calling this method through API, pass all insert values.