Shiprocket
Shiprocket ETL connector for data replication

Snapshot

Features
Details
Release Status
Released
Source API Version
v2
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Shiprocket api user email Shiprocket api user password
Replication Type
Key Based Incremental Full Replication
Replication Key
NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
orders
return_orders
shipments
pickup_addresses
products
listings
channel_details
inventory_details
country_codes
discrepancy_data

Integrate Shiprocket with Daton

    1.
    Signin to Daton
    2.
    Select Shiprocket from Integrations page
    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 your shiprocket api user email and password to authorize Daton to periodically extract data from shiprocket.
    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

SHIPROCKET Data

Orders
Purpose: This API call will display a list of all created and available orders in your Shiprocket account. The product and shipment details are displayed as sub-arrays within each order detail.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
id
NUMERIC
channel_id
NUMERIC
channel_name
STRING
base_channel_code
STRING
channel_order_id
STRING
customer_name
STRING
customer_email
STRING
customer_phone
STRING
pickup_location
STRING
payment_status
STRING
total
STRING
tax
STRING
sla
STRING
shipping_method
STRING
expedited
NUMERIC
status
STRING
status_code
NUMERIC
payment_method
STRING
is_international
NUMERIC
purpose_of_shipment
NUMERIC
channel_created_at
STRING
created_at
STRING
products
RECORD
shipments
RECORD
activities
STRING
allow_return
NUMERIC
is_incomplete
NUMERIC
errors
STRING
show_escalation_btn
STRING
escalation_status
STRING
escalation_history
STRING
ReturnOrders
Purpose: Using this API you can get a list of all created return orders in your Shiprocket account along with their details.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
id
NUMERIC
channel_id
NUMERIC
channel_name
STRING
base_channel_code
STRING
channel_order_id
STRING
customer_name
STRING
customer_email
STRING
customer_phone
STRING
customer_pincode
STRING
pickup_code
STRING
pickup_location
STRING
payment_status
STRING
total
STRING
expedited
NUMERIC
sla
STRING
shipping_method
STRING
status
STRING
status_code
NUMERIC
payment_method
STRING
is_international
NUMERIC
purpose_of_shipment
NUMERIC
channel_created_at
STRING
created_at
STRING
products
RECORD
delivery_code
STRING
cod
NUMERIC
shipment_id
NUMERIC
in_queue
NUMERIC
shipments
RECORD
Shipments
Purpose:Use this APi to get the shipment details of all the shipments in your Shiprocket account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
number
STRING
code
STRING
id
NUMERIC
order_id
NUMERIC
products
RECORD
awb
STRING
status
STRING
created_at
STRING
channel_id
NUMERIC
channel_name
STRING
base_channel_code
STRING
payment_method
STRING
PickupAddresses
Purpose:Get a list of all pickup locations that have been added to your Shiprocket account through this API.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
pickup_location
STRING
address
STRING
address_2
STRING
city
STRING
state
STRING
country
STRING
pin_code
STRING
email
STRING
phone
STRING
name
STRING
company_id
NUMERIC
status
NUMERIC
phone_verified
NUMERIC
Products
Purpose:This API can be used to display a detailed list of all the products that you have in your Shiprocket account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
sku
STRING
hsn
STRING
name
STRING
description
STRING
category_code
STRING
category_name
STRING
category_tax_code
STRING
image
STRING
weight
STRING
size
STRING
cost_price
STRING
mrp
STRING
tax_code
STRING
low_stock
NUMERIC
ean
STRING
upc
STRING
isbn
STRING
created_at
STRING
updated_at
STRING
quantity
NUMERIC
color
STRING
brand
STRING
dimensions
STRING
status
STRING
type
STRING
Listings
Purpose:Using this API get a JSON representation of all the product listings in your Shiprocket account i.e all the products associated to a specific channel.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
title
STRING
image
STRING
price
STRING
quantity
NUMERIC
sku
STRING
channel_sku
STRING
channel_id
NUMERIC
channel_name
STRING
base_channel_code
STRING
channel_product_id
STRING
inventory
NUMERIC
synced_on
STRING
product
RECORD
category_name
STRING
ChannelDetails
Purpose:This API shows a list of all the channels that have already been integrated in your Shiprocket account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
name
STRING
status
STRING
connection_response
STRING
channel_updated_at
STRING
status_code
NUMERIC
settings
RECORD
auth
STRING
connection
NUMERIC
orders_sync
NUMERIC
inventory_sync
NUMERIC
catalog_sync
STRING
orders_synced_on
STRING
inventory_synced_on
STRING
base_channel_code
STRING
base_channel
RECORD
catalog_synced_on
STRING
order_status_mapper
STRING
payment_status_mapper
STRING
brand_name
STRING
brand_logo
STRING
InventoryDetails
Purpose:This API can be used to check the inventory details of a product sku. There are no required parameters for this API but further parameters can be defined to sort and filter the data.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
sku
STRING
category_name
STRING
is_combo
NUMERIC
name
STRING
type
STRING
color
STRING
brand
STRING
total_quantity
NUMERIC
available_quantity
NUMERIC
blocked_quantity
NUMERIC
updated_on
STRING
CountryCodes
Purpose:Shows the list of all the countries which are present in the Shiprocket database along with the respective country ids ISO 2 and ISO 3 codes. There are a total of 44 available countries in the database. You can use these codes to check the serviceability and use them in your own dropdown menu.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
name
STRING
iso_code_2
STRING
iso_code_3
STRING
isd_code
STRING
address_format
STRING
postcode_required
NUMERIC
status
NUMERIC
DiscrepancyData
Purpose:Use this API to get the account statement details of your Shiprocket account. No parameters are required to access this API.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
status
NUMERIC
data
STRING
upper_fold_text
STRING
lower_fild_text
STRING
Last modified 1yr ago