{"id":12451,"date":"2026-09-10T21:58:24","date_gmt":"2026-09-10T21:58:24","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12451"},"modified":"2026-09-10T23:38:33","modified_gmt":"2026-09-10T23:38:33","slug":"ssis-tutorial-how-to-get-data-from-shipstation","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-shipstation\/","title":{"rendered":"SSIS Tutorial: How to get data from ShipStation"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>ShipStation is a leading shipping and order management platform used by eCommerce businesses to manage orders, shipments, and fulfillment across multiple sales channels. Many organizations need ShipStation data in SQL Server for reporting, logistics analytics, and fulfillment performance tracking.<\/p>\n

In this tutorial, you will learn how to connect to the ShipStation REST API using SQL Server Integration Services (SSIS) with the ZappySys SSIS PowerPack. This approach helps you build repeatable ETL pipelines without writing custom API integration code.<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, make sure the prerequisites are met:\r\n
    \r\n \t
  1. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  2. Make sure the SSIS designer<\/a> is installed.<\/li>\r\n \t
  3. Download and install ZappySys SSIS PowerPack<\/a>.<\/li>\r\n<\/ol>\r\nNOTE:<\/strong> If you are planning to deploy packages to a server and schedule their execution later, read this article<\/a>.<\/div>\n

    Steps<\/h2>\n

    Get ShipStation API Credentials<\/h3>\n
      \n
    1. Sign in to your ShipStation account.<\/li>\n
    2. Go to Account Settings \u2192 API Settings<\/strong>.\n
    3. Generate your API Key<\/strong> and API Secret<\/strong> \u2014 store both values securely.\n
      \"\"<\/a>

      ShipStation – Generate token<\/p><\/div>\n

      <\/pre>\n<\/li>\n<\/ol>\n
      Create an HTTP Connection in SSIS<\/h3>\n
        \n
      1. Create or open your SSIS project and package.<\/li>\n
      2. In Connection Managers<\/strong>, right-click and select New Connection…<\/strong>.<\/li>\n
      3. Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
      4. Set Credentials Type<\/strong> to Basic Auth<\/strong>.<\/li>\n
      5. Enter your API Key<\/strong> in the Username field and your API Secret<\/strong> in the Password field.<\/li>\n
      6. Click OK<\/strong> to save the connection.\n
        \"\"<\/a>
        ShipStation – HTTP connection<\/p><\/div><\/li>\n<\/ol>\n
        Create and Configure JSON Source<\/h3>\n
          \n
        1. Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n
        2. In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
        3. Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
        4. Select the ShipStation HTTP connection you created earlier.<\/li>\n
        5. Set the API URL. Example to extract orders:\n
          https:\/\/ssapi.shipstation.com\/orders<\/pre>\n<\/li>\n
        6. Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        7. Add the following HTTP Header<\/strong>:\n