Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Shiprocket v2 connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Shiprocket v2 connector:

• Orders

• Listings

• NDR

• Products

• Inventory_Details

Orders

Retrieves the list of all created and available orders in the Shiprocket account. The product and shipment details are displayed as sub-arrays within each order detail. For more information on the API, see Shiprocket - Orders.

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Field Name	Data Type
id	NUMERIC
channel_name	STRING
base_channel_code	STRING
channel_order_id	STRING
customer_name	STRING
customer_email	STRING
customer_phone	STRING
customer_address	STRING
customer_address_2	STRING
customer_city	STRING
customer_state	STRING
customer_pincode	STRING
customer_country	STRING
customer_alternate_phone	STRING
pickup_location	STRING
order_type	NUMERIC
payment_status	STRING
total	STRING
tax	STRING
sla	STRING
shipping_method	STRING
expedited	NUMERIC
status	STRING
status_code	NUMERIC
master_status	STRING
payment_method	STRING
change_payment_mode	BOOLEAN
is_international	NUMERIC
purpose_of_shipment	NUMERIC
channel_created_at	STRING
created_at	STRING
updated_at	STRING
updated_on	STRING
pickup_boy_name	STRING
pickup_boy_contact_no	STRING
products	RECORD
shipments	RECORD
cod	NUMERIC
activities	STRING
allow_return	NUMERIC
is_incomplete	NUMERIC
pickup_exception_reason	STRING
rto_prediction	STRING
show_escalation_btn	NUMERIC
escalation_status	STRING
pii_removed	NUMERIC
allow_multiship	BOOLEAN
others	RECORD

Listings

Retrieves the list of all the product listings in your Shiprocket account, that is, all the products associated with a specific channel. For more information on the API, see Shiprocket - Listings.

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Data Type
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
hsn_code	DATE
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

NDR

Retrieve information and manage shipments that are in Non-Delivery Report (NDR) status in your Shiprocket account. For more information on the API, see Shiprocket - NDR.

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Data Type
id	NUMERIC
shipment_id	NUMERIC
channel_order_id	STRING
channel_name	STRING
customer_name	STRING
customer_email	STRING
customer_phone	STRING
customer_address	STRING
customer_address_2	STRING
customer_city	STRING
customer_state	STRING
customer_pincode	STRING
payment_status	STRING
status	STRING
status_code	NUMERIC
payment_method	STRING
created_at	STRING
reason	STRING
attempts	NUMERIC
ndr_raised_at	DATETIME
courier	STRING
awb_code	STRING
channel_sku	STRING
master_sku	STRING
product_qty	STRING
escalation_status	STRING
product_name	STRING
product_price	STRING
shipment_channel_id	NUMERIC
history	RECORD
delivered_date	STRING
cancellation_reason	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Products

Retrieves a list of all the products in your Shiprocket account. For more information on the API, see Shiprocket - Products.

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Data Type
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	NUMERIC
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
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Inventory_Details

Check the inventory details of a product. This API has no required parameters, but further parameters can be defined to sort and filter the data. For more information on the API, see Shiprocket - Inventory_Details.

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Data Type
id	NUMERIC
total_quantity	NUMERIC
available_quantity	NUMERIC
blocked_quantity	NUMERIC
category_name	STRING
updated_on	STRING
sku	STRING
is_combo	NUMERIC
name	STRING
type	STRING
color	STRING
brand	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC