Ohi

Ohi ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	V1
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Ohi Username Ohi Password
Replication Type	Full Replication Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	1 hour

Tables/APIs supported

Billable Items	Deliveries
Inventories	Inventory Adjustment
Notifications	Ohi Shipments
Orders	Products
Users	Warehouse Address
Warehouses

Integrate Ohi with Daton

1. Sign in to Daton

2. Select Ohi from the list of Integrations

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide Ohi username and password

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Ohi Data

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