Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

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.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      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
      connector information shiprocket schema

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Essential Attributes and Supported Tables
      • How to Integrate Shiprocket with Daton

      Table of Contents

      Tables/APIs SHIPROCKET Data

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand