# Schema Information

## Tables/APIs 

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

* [Orders](#orders)
* [Listings](#listings)
* [NDR](#ndr)
* [Products](#products)
* [Inventory\_Details](#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](https://apidocs.shiprocket.in/#fe000ead-c32f-47d2-a4ef-2a23e7ef5461). 

Replication: Key-Based Replication

Replication Key: lastRunDate

**Fields**

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

#### 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](https://apidocs.shiprocket.in/#8e302e63-cbe7-40ee-bd2d-b37b3905c300).

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>image</td><td>STRING</td></tr><tr><td>price</td><td>STRING</td></tr><tr><td>quantity</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>channel_sku</td><td>STRING</td></tr><tr><td>channel_id</td><td>NUMERIC</td></tr><tr><td>channel_name</td><td>STRING</td></tr><tr><td>base_channel_code</td><td>STRING</td></tr><tr><td>channel_product_id</td><td>STRING</td></tr><tr><td>inventory</td><td>NUMERIC</td></tr><tr><td>synced_on</td><td>STRING</td></tr><tr><td>product</td><td>RECORD</td></tr><tr><td>category_name</td><td>STRING</td></tr><tr><td>hsn_code</td><td>DATE</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### 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](https://apidocs.shiprocket.in/#dd312b8d-92d8-4f93-a3dc-88700b061e8b).

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>shipment_id</td><td>NUMERIC</td></tr><tr><td>channel_order_id</td><td>STRING</td></tr><tr><td>channel_name</td><td>STRING</td></tr><tr><td>customer_name</td><td>STRING</td></tr><tr><td>customer_email</td><td>STRING</td></tr><tr><td>customer_phone</td><td>STRING</td></tr><tr><td>customer_address</td><td>STRING</td></tr><tr><td>customer_address_2</td><td>STRING</td></tr><tr><td>customer_city</td><td>STRING</td></tr><tr><td>customer_state</td><td>STRING</td></tr><tr><td>customer_pincode</td><td>STRING</td></tr><tr><td>payment_status</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>status_code</td><td>NUMERIC</td></tr><tr><td>payment_method</td><td>STRING</td></tr><tr><td>created_at</td><td>STRING</td></tr><tr><td>reason</td><td>STRING</td></tr><tr><td>attempts</td><td>NUMERIC</td></tr><tr><td>ndr_raised_at</td><td>DATETIME</td></tr><tr><td>courier</td><td>STRING</td></tr><tr><td>awb_code</td><td>STRING</td></tr><tr><td>channel_sku</td><td>STRING</td></tr><tr><td>master_sku</td><td>STRING</td></tr><tr><td>product_qty</td><td>STRING</td></tr><tr><td>escalation_status</td><td>STRING</td></tr><tr><td>product_name</td><td>STRING</td></tr><tr><td>product_price</td><td>STRING</td></tr><tr><td>shipment_channel_id</td><td>NUMERIC</td></tr><tr><td>history</td><td>RECORD</td></tr><tr><td>delivered_date</td><td>STRING</td></tr><tr><td>cancellation_reason</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Products

Retrieves a list of all the products in your Shiprocket account. For more information on the API, see [Shiprocket - Products](https://apidocs.shiprocket.in/#5046ae90-2014-4453-90d5-2ce776567f47).

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>hsn</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>category_code</td><td>STRING</td></tr><tr><td>category_name</td><td>STRING</td></tr><tr><td>category_tax_code</td><td>STRING</td></tr><tr><td>image</td><td>STRING</td></tr><tr><td>weight</td><td>STRING</td></tr><tr><td>size</td><td>STRING</td></tr><tr><td>cost_price</td><td>STRING</td></tr><tr><td>mrp</td><td>STRING</td></tr><tr><td>tax_code</td><td>NUMERIC</td></tr><tr><td>low_stock</td><td>NUMERIC</td></tr><tr><td>ean</td><td>STRING</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>isbn</td><td>STRING</td></tr><tr><td>created_at</td><td>STRING</td></tr><tr><td>updated_at</td><td>STRING</td></tr><tr><td>quantity</td><td>NUMERIC</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>brand</td><td>STRING</td></tr><tr><td>dimensions</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### 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](https://apidocs.shiprocket.in/#a11e837a-176c-4889-905d-7c01c81d401c).

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>total_quantity</td><td>NUMERIC</td></tr><tr><td>available_quantity</td><td>NUMERIC</td></tr><tr><td>blocked_quantity</td><td>NUMERIC</td></tr><tr><td>category_name</td><td>STRING</td></tr><tr><td>updated_on</td><td>STRING</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>is_combo</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>brand</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>