Links

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

Integrate Ohi with Daton

  1. 1.
    Sign in to Daton
  2. 2.
    Select Ohi from the list of Integrations
  3. 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. 4.
    Provide Ohi username and password
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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
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
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
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
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
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
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
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
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
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
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