Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
2 Ответы
2755 Представления

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

Аватар
Отменить