Schema Information of Shiprocket Connector
This topic provides a structured reference to assist you in working with Daton's Shiprocket connector and the associated fields and tables.
Schema Information of Shiprocket Connector
This topic provides a structured reference to assist you in working with Daton's Shiprocket connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Shiprocket connector:
- Orders
- ReturnOrders
- Shipments
- PickupAddresses
- Products
- Listings
- ChannelDetails
- InventoryDetails
- CountryCodes
- DiscrepancyData
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#9bfbe7a1-0f96-4456-861f-e059165868e4
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.
Source API Documentation: https://apidocs.shiprocket.in/?version=latest#4bf0f6ee-68bd-4629-9e42-9ca09b134dbb
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#b3460616-eec8-47b6-8192-1fd172ccdd52
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
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.
Source API Documentation https://apidocs.shiprocket.in/?version=latest#7805703f-4750-4f1e-9c59-f745853c9937
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
status |
NUMERIC |
data |
STRING |
upper_fold_text |
STRING |
lower_fild_text |
STRING |