Skip to Content
Menu
This question has been flagged
2 Replies
2698 Views

Hello All,


I need some help finding the best solution.


In my local server there are some Excel and CSV files that are updated/changed on different moments in time. 

I want to create a two-way communication. I want to be able to create a CSV file from within Odoo sh and save it on my local server. And I want to be able to read in the data from the CSV or Excel file on my local server.


I like to find the best solution for this challenge. (for example, using XMLRPC or RESTful API)


Thanks!

Avatar
Discard
Author Best Answer

Hello Cybrosys,

Thank you very much for your answer.

The reason why I asked this question is because, we want to connect multiple other software systems, so the frequency of exchanging data between Odoo sh and our local server is relative high. Is this a reason to switch to Odoo on premise?

If I chose RESTful API to make a connection, what is the best way to make a connection to my local server (e.g. VPN)? 

Thank you!


Avatar
Discard
Best Answer

Hi

Go through the following,

RESTful API and XML-RPC are two ways to communicate between Odoo and your local server. RESTful API is more modern and standardized, while XML-RPC is older but still functional. RESTful API is also easier to use and has more language and tooling support. It typically offers better performance than XML-RPC.

In most cases, RESTful API is the preferred choice for two-way communication. However, if you have existing infrastructure or specific requirements that necessitate XML-RPC, it can still be a viable option.

Here is a table that summarizes the key differences between RESTful API and XML-RPC:

Feature

RESTful API

XML-RPC

Standardization

Modern web standards

Older protocol

Ease of use

Easier to work with

Steeper learning curve

Language support

Wide range of languages

More limited language support

Tooling support

Extensive tooling and libraries are available

Fewer tooling options

Performance

Better performance

May introduce additional overhead

Scalability

More scalable

Less scalable

The best choice for you will depend on your specific needs and requirements.

Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
7
Jul 25
50725
1
Jul 25
1985
4
Apr 25
12451
1
Feb 25
3775
1
Jan 25
1552