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
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
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
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
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
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
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
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
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
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
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
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
Last updated