Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

object has no attribute id when execute external API

Subscribe

Get notified when there's activity on this post

This question has been flagged
xmlrpcodoo16featuresExternalAPIv17
2 Replies
3180 Views
Avatar
Admaja

It appears that I'm encountering an issue while transferring data from Odoo 16 to Odoo 17. Specifically, when I use the search_read method to retrieve data from all fields like this res = models.execute_kw(db, uid, password, the_class, 'search_read', [domain], {'limit': 1})​, I encounter an error stating "unknown object has no attribute id." However, when I specify the fields I want to retrieve, such as the name like this res = models.execute_kw(db, uid, password, the_class, 'search_read', [domain], {'fields': ['name'], 'limit': 1})​, the operation executes successfully.


this is the error message:

return value.id\nAttributeError: \'_unknown\' object has no attribute \'id\'\n'>




0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Refer to the below documentation.https://www.odoo.com/documentation/17.0/developer/reference/external_api.html


Hope it helps


0
Avatar
Discard
Avatar
S.A. Methsiri Madusanka Sooriyaarachchi
Best Answer

The error you're encountering, '_unknown' object has no attribute 'id', typically arises when trying to access a field (in this case, id) from a record that doesn't exist or isn't properly recognized by Odoo. This might be due to a few reasons, especially when transferring data between different versions of Odoo (from v16 to v17). Here's a breakdown of how to troubleshoot and resolve this issue:

1. Field Differences Between Versions

  • Check Field Names: Ensure that the fields you're trying to retrieve exist in both Odoo v16 and v17. Sometimes, field names or their definitions might change between versions.
  • Check for Deprecated Fields: Fields that were available in Odoo 16 may have been deprecated or replaced in Odoo 17.

2. Search Domain and Filters

  • Refine the Domain: Ensure that the domain used in the search_read method correctly filters records that actually exist. If the domain is too broad or incorrect, it might return an empty recordset, leading to the error.
  • Test with a Simplified Domain: Try simplifying the domain to ensure it returns valid records. For instance, use [] to fetch all records and check if the issue persists.

3. Retrieving All Fields

  • Explicitly Specify Fields: While it's common to use search_read without specifying fields (to get all fields), Odoo might have issues if certain fields are missing or not initialized. You can try retrieving a broader but explicit list of fields:
    pythonCopy coderes = models.execute_kw(db, uid, password, the_class, 'search_read', [domain], {'fields': ['id', 'name', 'other_field_1', 'other_field_2'], 'limit': 1})
    
  • Check search_read Defaults: Ensure that the search_read method is not missing any required fields that Odoo expects by default.

4. Inspect the Record Data

  • Print the Response: Before attempting to access id, print or log the entire response (res) to see what is actually being returned:
    pythonCopy coderes = models.execute_kw(db, uid, password, the_class, 'search_read', [domain], {'limit': 1})
    print(res)
    
  • Check Record Structure: Ensure that the response is a list of dictionaries and each dictionary has the required fields.

5. Handle Empty Responses

  • Check for Empty Results: Implement a check to see if res is empty before accessing id:
    pythonCopy codeif res and 'id' in res[0]:
        record_id = res[0]['id']
    else:
        print("No record found or id field missing.")
    
  • Default Value Handling: Provide a default value or handle the scenario where id might not be present.

6. Odoo API Version Compatibility

  • Review API Changes: Double-check the Odoo 17 API documentation to ensure that there haven't been any changes in the search_read method or in how data should be retrieved and processed compared to Odoo 16.

7. Update or Recreate the Environment

  • Environment Updates: If you're testing in a migration scenario, make sure your Odoo environments (both v16 and v17) are up-to-date and correctly configured.
  • Recreate the Database Schema: Sometimes, discrepancies in the database schema between versions might cause issues. Ensure that the Odoo v17 database schema is correctly migrated.

By following these troubleshooting steps, you should be able to identify the root cause of the error and resolve the issue when transferring data between Odoo versions.

4o

-1
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
odoo 16 & odoo 17: change default message?
odoo16features v17
Avatar
Avatar
1
Apr 25
4048
Payroll UK
odoo16features v17
Avatar
Avatar
1
Mar 25
3379
Twilio Voip with odoo 16
odoo16features v17
Avatar
Avatar
Avatar
Avatar
Avatar
4
Aug 24
4904
Domain filtering doesn't work on datetime attributes in Odoo External API
odoo16features ExternalAPI
Avatar
Avatar
2
May 24
3268
text field value to Link in message to redirect to form
odoo16features v17
Avatar
Avatar
1
Jan 24
4751
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now