跳至內容
選單
此問題已被標幟
2 回覆
2768 瀏覽次數

Hello,


I'm trying to retrieve date from Odoo to Google Sheets using the oe_browse function.

It is working well with a very simple query (example as follows):

=oe_browse("product.product"; "default_code"; "[]"; "default_code asc"; 5)

This succesfully results the 5 first values of the table.

However as soon as I add another field like this:

=oe_browse("product.product"; "default_code, name"; "[]"; "default_code asc"; 5)

I get the following error:

Unable to fetch data due to session expired exception (line 364).


Moreover, when I try to add a domain in the formule (e.g. "['default_code','=','123']") it doesn't seem to work as I still get the 5 same values as before.


Could you please help ?

Thanks a lot !

頭像
捨棄
最佳答案

Hi Arthur, maybe you already solved the problem.

In Google Sheets to the right of "Settings" there is a button called "Odoo".

Click on it and then click on "Settings". It will ask you to input your data base and user.

Also remember that the user that owns the Google Sheets needs to be the same as the validated user in Odoo.

If you encounter more problems, don't hesitate to reach out: genaro@promty.com.mx

頭像
捨棄
最佳答案

I can help u to get all data from google sheet to in the module your specification wise set the data taken from google sheet 

kevalrk18@gmail.com

頭像
捨棄