Overview
This node interacts with the Odoo API to perform operations on various resources, specifically supporting a 'custom' resource with a 'Get All' operation. It allows users to retrieve multiple records from a specified Odoo model, with options to return all results or limit the number of results. Users can also apply filters to refine the data retrieved and specify which fields to include in the response. This node is useful for scenarios where bulk data retrieval from Odoo is needed, such as syncing data with other systems, reporting, or data analysis.
Use Case Examples
- Retrieve all records from a custom Odoo model without limit.
- Retrieve up to a specified number of records from a custom Odoo model.
- Apply filters to get records matching specific criteria from a custom Odoo model.
- Select specific fields to include in the output for optimized data handling.
Properties
| Name | Meaning |
|---|---|
| customResource | The specific Odoo model (resource) to operate on, loaded dynamically from available models. |
| returnAll | Whether to return all results or only up to a given limit. |
| limit | Maximum number of results to return when 'Return All' is false. |
| options.fieldsList | List of specific fields to include in the returned data, loaded dynamically based on the selected resource. |
| filterRequest.filter | Filters to apply to the request, each filter includes a field name, an operator, and a value for comparison to refine the data retrieved. |
Output
JSON
id- Unique identifier of each retrieved record.fieldName- Fields of the retrieved records as specified in the fieldsList or all fields if none specified.
Dependencies
- Requires Odoo API credentials including URL, username, password, and database name.
Troubleshooting
- Common issues include invalid credentials leading to authentication errors. Verify API credentials and connection details.
- Incorrect resource or field names may cause errors or empty results. Ensure the resource and fields exist in the Odoo instance.
- Invalid filter syntax or unsupported operators can cause request failures. Use valid JSON and supported operators.
- Exceeding API limits or large data requests may cause timeouts or performance issues. Use 'Return All' judiciously or apply limits.
Links
- Odoo Official Documentation - Comprehensive resource for understanding Odoo models, API usage, and available fields.