Schema Information

This topic provides a structured reference to assist you in working with Daton's Ohi connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Ohi connector:

Billable Items

Purpose: This API is used to fetch all billable items

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20billable-items

Replication: Key Based Incremental

Replication Key: updated_at_range_after, updated_at_range_before

Fields

Name	Data Type
uuid	STRING
order_tracking_id	STRING
item_type	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
source_datetime	TIMESTAMP
price_in_cents	NUMERIC
description	STRING

Deliveries

Purpose: This API is used to fetch all deliveries

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20deliveries

Replication: Key Based Incremental

Replication Key: created_at_range_after, created_at_range_before

Fields

Name	Data Type
pickup_eta	TIMESTAMP
dropoff_eta	TIMESTAMP
verbose_status	STRING
tracking_id	STRING
direction	STRING
last_status	STRING
next_action	STRING
action_eta	STRING
created_at	TIMESTAMP
pod_urls	RECORD
vendor	STRING
courier_information	RECORD
vendor_remote_id	STRING

Inventories

Purpose: This API is used to fetch all the inventories

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20inventories

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
id	NUMERIC
warehouse	RECORD
product	RECORD
unordered	NUMERIC
ordered	NUMERIC
fulfilled	NUMERIC
lot_code	RECORD
stock_out_eta	TIMESTAMP
available_inventory_trigger_threshold	NUMERIC
suggested_available_inventory_trigger_threshold	NUMERIC
available_inventory_warning_disabled	BOOLEAN
preordered	NUMERIC
location	RECORD

Inventory Adjustment

Purpose: This API is to fetch all the inventory adjustments

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20inventory-adjustment

Replication: Key Based Incremental

Replication Key: created_at_range_after, created_at_range_before

Fields

Name	Data Type
product_id	STRING
warehouse	STRING
product_title	STRING
product_sku	STRING
unordered_change	NUMERIC
ordered_change	NUMERIC
order_tracking_id	STRING
fulfilled_change	NUMERIC
reason	STRING
user	STRING
created_at	TIMESTAMP
comment	STRING

Notifications

Purpose: This API is used to get the list of all the notifications

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20notifications

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
uuid	STRING
display_text	STRING
display_type	STRING
display_data	RECORD
acknowledged_at	TIMESTAMP
created_at	TIMESTAMP
updated_at	TIMESTAMP
tag	STRING

Ohi Shipments

Purpose: This API is used to get the list of all the Ohi shipments for the logged-in user's client.

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20ohi-shipments

Replication: Key Based Incremental

Replication Key: updated_at_range_after, updated_at_range_before

Fields

Name	Data Type
appointment_options	RECORD
received_at	TIMESTAMP
palletized	BOOLEAN
carrier_name	STRING
pallets_description	STRING
updated_at	TIMESTAMP
carrier_phone_number	STRING
expedited_receiving	BOOLEAN
tracking_code	STRING
can_schedule	BOOLEAN
status	STRING
po_number	STRING
receiving_centre	RECORD
ohi_shipment_id	STRING
created_at	TIMESTAMP
requested_receiving_time	TIME
carrier_tracking_number	STRING
requested_receiving_date	DATE
carrier_email_address	STRING
pallet_count	NUMERIC
note_for_site_manager	STRING
line_items	RECORD

Orders

Purpose: This API is used to get the list of all the orders.

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20orders

Replication: Key Based Incremental

Replication Key: updated_at_range_after, updated_at_range_before

Fields

Name	Data Type
id	STRING
tracking_id	STRING
service_level_token	STRING
service_code	STRING
courier_last_mile	STRING
total_grams	STRING
shipping_address	RECORD
customer	RECORD
tracking	RECORD
line_items	RECORD
error_status	STRING
originator_order_id	STRING
target_customer_arrival_eta	TIMESTAMP
delivered_at	TIMESTAMP
created_at	TIMESTAMP
updated_at	TIMESTAMP
client_status	STRING
customer_arrival_eta	TIMESTAMP
tracking_urls	STRING
shipment_type	STRING
detailed_status	STRING
location	STRING
can_cancel	BOOLEAN
fulfilled_at	TIMESTAMP
picking_release_datetime	TIMESTAMP
warehouse_address	RECORD
is_reschedulable	BOOLEAN
can_split_shipment	BOOLEAN
processed	BOOLEAN
deliveries	RECORD

Products

Purpose: This API is used to get the list of all the products.

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20products

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
id	NUMERIC
sku	STRING
title	STRING
grams	NUMERIC
product_id	STRING
variant_id	STRING
image_url	STRING
disabled_at	TIMESTAMP
is_kit	BOOLEAN

Users

Purpose: This API is used to get the list of all the users.

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20users

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
email	STRING
password	STRING
first_name	STRING
last_name	STRING
username	STRING

Warehouse Address

Purpose: This API is used to get the list of all the warehouse addresses.

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20addresses

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
timezone	STRING
state	STRING
address_1	STRING
address_2	STRING
city	STRING
zip_code	STRING
latitude	STRING
longitude	STRING
short_code	STRING
location_type	STRING

Warehouses

Purpose: This API is used to get the list of all the warehouses

Source API Documentation: https://api.shipohi.com/api/v1/docs#operation/List%20warehouses

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
id	NUMERIC
name	STRING
description	STRING
city	STRING
address_1	STRING
state	STRING
zip_code	STRING
weekday_same_day_confirmed	STRING
weekday_rush_confirmed	STRING
weekday_service_confirmed	STRING
timezone	STRING
warehouse_services	RECORD
rush_orders_accepted_start_time_local	TIME
rush_orders_accepted_end_time_local	TIME
weekday_window_service_confirmed	STRING