| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 3174 |
| Technical Name |
flex_excel_integration |
| License | LGPL-3 |
| Website | https://flex-ops.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 3174 |
| Technical Name |
flex_excel_integration |
| License | LGPL-3 |
| Website | https://flex-ops.com |
Flex Excel Integration
Secure Odoo 18 API bridge for Excel and Power Query. Control allowed models and fields, generate API URLs and Power Query scripts from UI, and monitor everything from a clean OWL dashboard.
What This Module Does
Build secure Excel reporting directly from Odoo data without custom endpoint coding per model. Define what is allowed, then query safely with domains, limits, sorting, and auditable logs.
Allowed Models Registry
Expose only approved Odoo models. Optional whitelist limits which top-level fields can be queried.
Relational Field Paths
Supports many2one, one2many, and many2many dotted paths such as partner_id.name.
Token Authentication
API key validation with support for header or query parameter, with masked tokens in logs.
URL + Power Query Helper
Generate API URL and copy ready-to-use Power Query script from the same helper screen.
Operational OWL Dashboard
Focused health and usage view with failures, trends, and distribution panels.
Full API Audit Trail
Save request URL, query, status, response code, row count, and duration for each call.
How It Works
1. Configure
Set API token, execution user, limits, and integration toggle from Settings.
2. Allow Models
Register allowed models and optional field whitelist policy.
3. Build Query
Use API URL Helper to select fields, domain, ordering, and generate URL / M script.
4. Consume in Excel
Paste Power Query script in Excel and refresh anytime for live Odoo data.
API Example
Endpoint:
/flex_excel_integration/api/data
GET /flex_excel_integration/api/data?model=sale.order&fields=name,partner_id,amount_total,state,date_order&domain=[('state','=','sale')]&limit=100&order=date_order%20desc&api_key=YOUR_API_KEY
How To Put Power Query In Excel
Inside Odoo
- Open Excel Integration > API URL Helper.
- Select model and fields (including relational fields if needed).
- Set domain, limit, offset, and order.
- Click Copy Power Query.
Inside Excel
- Go to Data > Get Data > From Other Sources > Blank Query.
- Open Advanced Editor.
- Paste the copied script and click Done.
- Choose Close & Load then use Refresh All when needed.
Screenshots
Walkthrough from menu access to settings, dashboard, helper, and logs.
Main Menu
Dashboard
Settings
Allowed Models
API URL Helper
API Logs
Ready to Connect Odoo Data to Excel?
Install once, define allowed models, and start building controlled live reports in Excel and Power Query.
Secure Token Access Power Query Ready Operational Dashboard Full API Logs
Flex Excel Integration v18.0.2.0.0 | LGPL-3 | Built by Abdalrahman Shahrour
Please log in to comment on this module