{"id":12284,"date":"2026-06-25T21:43:49","date_gmt":"2026-06-25T21:43:49","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12284"},"modified":"2026-06-25T21:50:08","modified_gmt":"2026-06-25T21:50:08","slug":"ssis-tutorial-how-to-get-data-from-birdeye","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-birdeye\/","title":{"rendered":"SSIS Tutorial: How to get data from Birdeye"},"content":{"rendered":"

<\/p>\n

Introduction<\/h2>\n

\"\"<\/a>Birdeye is a customer experience and reputation management platform that helps businesses manage reviews, listings, messages, and customer interactions across channels. Many organisations need Birdeye data in SQL Server for reporting, sentiment tracking, location performance analysis, and operational dashboards.<\/p>\n

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

<\/p>\n

<\/h2>\n

Prerequisites<\/h2>\n
    \n
  1. SQL Server Integration Services (SSIS) is installed.<\/li>\n
  2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is available.<\/li>\n
  3. A Birdeye account with API access enabled.<\/li>\n
  4. A valid Birdeye API key.<\/li>\n
  5. ZappySys SSIS PowerPack<\/a> is installed on your machine.<\/li>\n<\/ol>\n

    <\/p>\n

    Steps<\/h2>\n

    Get Birdeye API Key<\/h3>\n
      \n
    1. Sign in to your Birdeye account<\/a>.<\/li>\n
    2. Open API settings in your Birdeye admin portal.<\/li>\n
    3. Generate or copy your API key.\n
    4. Store the API key securely and do not expose it in logs or shared files.<\/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 Static token\/API key<\/strong>.<\/li>\n
      5. Paste your token in the token value field.<\/li>\n
      6. Use x-api-key<\/strong> in the Auth header name.<\/strong><\/li>\n
      7. In Auth Scheme<\/strong>, select {none}<\/strong><\/li>\n
      8. Click OK<\/strong> to save the connection.\n
        \"\"<\/a>

        Birdeye – HTTP connection<\/p><\/div>\n

        <\/div>\n<\/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 Birdeye HTTP connection you created earlier.<\/li>\n
        5. Set the API URL. Example to extract reviews:\n
          https:\/\/api.birdeye.com\/resources\/v1\/business\/{{User::businnessID}}<\/pre>\n<\/li>\n
        6. Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        7. Set the following values in HTTP headers<\/strong>:\n
            \n
          1. Accept: application\/json<\/li>\n
          2. Content-Type: application\/json<\/li>\n<\/ol>\n<\/li>\n
          3. Set JSON Path Filter<\/strong> based on response shape (for example, $.hoursOfOperations[*]<\/code> or $.serviceAreas[*]<\/code>).<\/li>\n
          4. Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
            \"\"<\/a>
            Birdeye – the JSON source configuration<\/p><\/div><\/li>\n<\/ol>\n
            Use Other Birdeye Endpoints (Optional)<\/h3>\n
            You can reuse the same SSIS package pattern with other Birdeye endpoints<\/a>:<\/p>\n