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

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 !

Avatar
Discard
Best Answer

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

Avatar
Discard
Best Answer

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

Avatar
Discard