Ohi
Ohi ETL connector for data replication
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 |
​ |
- 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
- 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
Purpose: This API is used to fetch all billable 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 |
Purpose: This API is used to fetch all deliveries
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 |
Purpose: This API is used to fetch all the inventories
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
|
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 |
Purpose: This API is used to get the list of all the notifications
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 |
Purpose: This API is used to get the list of all the Ohi shipments for the logged in user's client
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 |
Purpose: This API is used to get the list of all the orders
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 |
Purpose: This API is used to get the list of all the products
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 |
Purpose: This API is used to get the list of all the users
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
|---|---|
email | STRING |
password | STRING |
first_name | STRING |
last_name | STRING |
username | STRING |
Purpose: This API is used to get the list of all the warehouse addresses
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 |
Purpose: This API is used to get the list of all the warehouses
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 modified 9mo ago