​
Description

ZestIOT is an IoT and AI-enabled aviation platform that integrates passenger, baggage, aircraft, ground, and airport operations.

​
Connector Details

NameValue
PlatformOdoo
Auth TypeAPI Keys
DirectionBidirectional

​
Supported Data

See the table below for the list of data you can read with the Odoo connector.

Table NameFields
customers
name, display_name, date, title, parent_id, parent_name, child_ids, ref, lang, active_lang_count, tz, tz_offset, vat, same_vat_partner_id, bank_ids, website, comment, category_id, active, employee, function, type, street, street2, zip, city, state_id, country_id, partner_latitude, partner_longitude, email_formatted, mobile, is_company, industry_id, company_type, company_id, color, user_ids, partner_share, contact_address, commercial_partner_id, commercial_company_name, company_name, barcode, self, im_status, activity_ids, activity_state, activity_user_id, activity_type_id, activity_type_icon, activity_date_deadline, my_activity_date_deadline, activity_summary, activity_exception_decoration, activity_exception_icon, message_is_follower, message_follower_ids, message_partner_ids, message_channel_ids, message_ids, message_unread, message_unread_counter, message_needaction, message_needaction_counter, message_has_error, message_has_error_counter, message_attachment_count, message_main_attachment_id, email_normalized, is_blacklisted, message_bounce, email, phone, channel_ids, user_id, contact_address_complete, signup_token, signup_type, signup_expiration, signup_valid, signup_url, calendar_last_notif_ack, phone_sanitized, phone_sanitized_blacklisted, phone_blacklisted, mobile_blacklisted, property_product_pricelist, team_id, ocn_token, partner_gid, additional_info, website_message_ids, message_has_sms_error, password_reset_attempt_count, last_password_reset_attempt, last_password_reset, credit, debit, debit_limit, total_invoiced, currency_id, journal_item_count, property_account_payable_id, property_account_receivable_id, property_account_position_id, property_payment_term_id, property_supplier_payment_term_id, ref_company_ids, has_unreconciled_entries, last_time_entries_checked, invoice_ids, contract_ids, bank_account_count, trust, invoice_warn, invoice_warn_msg, supplier_rank, customer_rank, property_stock_customer, property_stock_supplier, picking_warn, picking_warn_msg, website_id, is_published, can_publish, website_url, website_published, visitor_ids, property_payment_method_id, online_partner_vendor_name, online_partner_bank_account, payment_token_ids, payment_token_count, property_purchase_currency_id, purchase_order_count, supplier_invoice_count, purchase_warn, purchase_warn_msg, receipt_reminder_email, reminder_date_before_receipt, status, sign_fields_required, contact_type, partner_code, customer_information, bounced_check, failed_payments_count, online_partner_information, purchase_line_ids, on_time_rate, sale_order_count, sale_order_ids, sale_warn, sale_warn_msg, payment_next_action_date, unreconciled_aml_ids, unpaid_invoices, total_due, total_overdue, followup_status, followup_level, payment_responsible_id, credit_limit, id, create_uid, create_date, write_uid, write_date, __last_update
location
name, complete_name, active, usage, location_id, child_ids, comment, posx, posy, posz, parent_path, company_id, scrap_location, return_location, removal_strategy_id, putaway_rule_ids, barcode, quant_ids, valuation_in_account_id, valuation_out_account_id, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
products
price, price_extra, lst_price, default_code, code, partner_ref, active, product_tmpl_id, barcode, product_template_attribute_value_ids, combination_indices, is_product_variant, standard_price, volume, weight, pricelist_item_count, packaging_ids, can_image_variant_1024_be_zoomed, can_image_1024_be_zoomed, stock_quant_ids, stock_move_ids, qty_available, virtual_available, free_qty, incoming_qty, outgoing_qty, orderpoint_ids, nbr_reordering_rules, reordering_min_qty, reordering_max_qty, putaway_rule_ids, date_from, date_to, invoice_state, sale_avg_price, purchase_avg_price, sale_num_invoiced, purchase_num_invoiced, sales_gap, purchase_gap, turnover, total_cost, sale_expected, normal_cost, total_margin, expected_margin, total_margin_rate, expected_margin_rate, purchased_product_qty, value_svl, quantity_svl, stock_valuation_layer_ids, valuation, cost_method, purchase_order_line_ids, sales_count, last_purchase_price, external_barcode, activity_ids, activity_state, activity_user_id, activity_type_id, activity_type_icon, activity_date_deadline, my_activity_date_deadline, activity_summary, activity_exception_decoration, activity_exception_icon, message_is_follower, message_follower_ids, message_partner_ids, message_channel_ids, message_ids, message_unread, message_unread_counter, message_needaction, message_needaction_counter, message_has_error, message_has_error_counter, message_attachment_count, message_main_attachment_id, website_message_ids, message_has_sms_error, id, display_name, create_uid, create_date, write_uid, write_date, __last_update, name, sequence, description, description_purchase, description_sale, categ_id, currency_id, cost_currency_id, list_price, volume_uom_name, weight_uom_name, sale_ok, purchase_ok, pricelist_id, uom_id, uom_name, uom_po_id, company_id, seller_ids, variant_seller_ids, color, attribute_line_ids, valid_product_template_attribute_line_ids, product_variant_ids, product_variant_id, product_variant_count, has_configurable_attributes, taxes_id, supplier_taxes_id, property_account_income_id, property_account_expense_id, responsible_id, type, property_stock_production, property_stock_inventory, sale_delay, tracking, description_picking, description_pickingout, description_pickingin, location_id, warehouse_id, has_available_route_ids, route_from_categ_ids, property_account_creditor_price_difference, purchase_method, purchase_line_warn, purchase_line_warn_msg, route_ids, service_type, sale_line_warn, sale_line_warn_msg, expense_policy, visible_expense_policy, visible_qty_configurator, invoice_policy, service_to_purchase, landed_cost_ok, split_method_landed_cost, santos_uom_ids, uom_sale_id
products_uom
name, category_id, factor, factor_inv, rounding, active, uom_type, product_template_id, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
purchase_order_lines
name, sequence, product_qty, product_uom_qty, date_planned, taxes_id, product_uom, product_uom_category_id, product_id, product_type, price_unit, price_subtotal, price_total, price_tax, order_id, account_analytic_id, analytic_tag_ids, company_id, state, invoice_lines, qty_invoiced, qty_received, qty_received_manual, qty_to_invoice, partner_id, currency_id, date_order, display_type, qty_received_method, move_ids, orderpoint_id, move_dest_ids, product_description_variants, propagate_cancel, price_ratio_percent, last_purchase_price, sale_order_id, sale_line_id, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
purchase_orders
name, priority, origin, partner_ref, date_order, date_approve, partner_id, dest_address_id, currency_id, state, order_line, notes, invoice_count, invoice_ids, invoice_status, date_planned, date_calendar_start, amount_untaxed, amount_tax, amount_total, fiscal_position_id, payment_term_id, product_id, user_id, company_id, currency_rate, mail_reminder_confirmed, mail_reception_confirmed, receipt_reminder_email, reminder_date_before_receipt, incoterm_id, picking_count, picking_ids, picking_type_id, default_location_dest_id_usage, group_id, is_shipped, effective_date, on_time_rate, supplier_instruction, receiving_status, sale_order_count, product_ids, activity_ids, activity_state, activity_user_id, activity_type_id, activity_type_icon, activity_date_deadline, my_activity_date_deadline, activity_summary, activity_exception_decoration, activity_exception_icon, message_is_follower, message_follower_ids, message_partner_ids, message_channel_ids, message_ids, message_unread, message_unread_counter, message_needaction, message_needaction_counter, message_has_error, message_has_error_counter, message_attachment_count, message_main_attachment_id, website_message_ids, message_has_sms_error, access_url, access_token, access_warning, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
sale_order_line
order_id, name, sequence, invoice_lines, invoice_status, price_unit, price_subtotal, price_tax, price_total, price_reduce, tax_id, price_reduce_taxinc, price_reduce_taxexcl, discount, product_id, product_template_id, product_updatable, product_uom_qty, product_uom, product_uom_category_id, product_uom_readonly, product_custom_attribute_value_ids, product_no_variant_attribute_value_ids, qty_delivered, qty_delivered_manual, qty_to_invoice, qty_invoiced, untaxed_amount_invoiced, untaxed_amount_to_invoice, salesman_id, currency_id, company_id, order_partner_id, analytic_tag_ids, analytic_line_ids, is_expense, is_downpayment, state, customer_lead, display_type, is_reward_line, sale_order_option_ids, purchase_line_ids, purchase_line_count, qty_delivered_method, product_packaging, route_id, move_ids, product_type, virtual_available_at_date, scheduled_date, forecast_expected_date, free_qty_today, qty_available_today, warehouse_id, qty_to_deliver, is_mto, display_qty_widget, version, changed, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
sale_orders
name, origin, client_order_ref, reference, state, date_order, validity_date, is_expired, require_signature, require_payment, create_date, user_id, partner_id, partner_invoice_id, partner_shipping_id, pricelist_id, currency_id, analytic_account_id, order_line, invoice_count, invoice_ids, invoice_status, note, amount_untaxed, amount_tax, amount_total, currency_rate, payment_term_id, fiscal_position_id, company_id, team_id, signed_by, signed_on, commitment_date, amount_undiscounted, type_name, transaction_ids, authorized_transaction_ids, show_update_pricelist, tag_ids, applied_coupon_ids, generated_coupon_ids, reward_amount, no_code_promo_program_ids, code_promo_program_id, promo_code, sale_order_template_id, sale_order_option_ids, purchase_order_count, incoterm, picking_policy, warehouse_id, picking_ids, delivery_count, procurement_group_id, effective_date, expected_date, json_popover, show_json_popover, product_ids, remarks, version, customer_information, bounced_check, twilio_number, full_portal_url, campaign_id, source_id, medium_id, activity_ids, activity_state, activity_user_id, activity_type_id, activity_type_icon, activity_date_deadline, my_activity_date_deadline, activity_summary, activity_exception_decoration, activity_exception_icon, message_is_follower, message_follower_ids, message_partner_ids, message_channel_ids, message_ids, message_unread, message_unread_counter, message_needaction, message_needaction_counter, message_has_error, message_has_error_counter, message_attachment_count, message_main_attachment_id, website_message_ids, message_has_sms_error, access_url, access_token, access_warning, id, display_name, create_uid, write_uid, write_date, __last_update
stock
product_id, product_tmpl_id, product_uom_id, company_id, location_id, lot_id, package_id, owner_id, quantity, inventory_quantity, reserved_quantity, available_quantity, in_date, tracking, on_hand, value, currency_id, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
suppliers
name, product_name, product_code, sequence, product_uom, min_qty, price, company_id, currency_id, date_start, date_end, product_id, product_tmpl_id, product_variant_count, delay, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
warehouse
name, active, company_id, partner_id, view_location_id, lot_stock_id, code, route_ids, reception_steps, delivery_steps, wh_input_stock_loc_id, wh_qc_stock_loc_id, wh_output_stock_loc_id, wh_pack_stock_loc_id, mto_pull_id, pick_type_id, pack_type_id, out_type_id, in_type_id, int_type_id, crossdock_route_id, reception_route_id, delivery_route_id, warehouse_count, resupply_wh_ids, resupply_route_ids, show_resupply, sequence, buy_to_resupply, buy_pull_id, id, display_name, create_uid, create_date, write_uid, write_date, __last_update
NotionOmnisend