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