SSIS Tutorial: How to get data from Birdeye

Introduction

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.

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.

Prerequisites

1. SQL Server Integration Services (SSIS) is installed.
2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is available.
3. A Birdeye account with API access enabled.
4. A valid Birdeye API key.
5. ZappySys SSIS PowerPack is installed on your machine.

Steps

Get Birdeye API Key

1. Sign in to your Birdeye account.
2. Open API settings in your Birdeye admin portal.
3. Generate or copy your API key.
   

   Birdeye – Generate token

4. Store the API key securely and do not expose it in logs or shared files.

Create an HTTP Connection in SSIS

1. Create or open your SSIS project and package.
2. In Connection Managers, right-click and select New Connection….
3. Select ZS-HTTP from the SSIS connectors list.
   

   Create a new HTTP connection

4. Set Credentials Type to Static token/API key.
5. Paste your token in the token value field.
6. Use x-api-key in the Auth header name.
7. In Auth Scheme, select {none}
8. Click OK to save the connection.
   

   Birdeye – HTTP connection

Create and Configure JSON Source

1. Drag a Data Flow Task into Control Flow and open it.
   

   Drag and drop Data flow

2. In Data Flow, drag and drop the ZS JSON Source.
   

   SSIS JSON Source – Drag and Drop

3. Open the JSON Source editor and enable Use credentials.
4. Select the Birdeye HTTP connection you created earlier.
5. Set the API URL. Example to extract reviews:
   
   https://api.birdeye.com/resources/v1/business/{{User::businnessID}}

   1	https://api.birdeye.com/resources/v1/business/{{User::businnessID}}

6. Set HTTP Request Method to GET.
7. Set the following values in HTTP headers:
   1. Accept: application/json
   2. Content-Type: application/json
8. Set JSON Path Filter based on response shape (for example, $.hoursOfOperations[*] or $.serviceAreas[*]).
9. Click Preview to confirm rows are returned, then click OK.
   

   Birdeye – the JSON source configuration

Use Other Birdeye Endpoints (Optional)

You can reuse the same SSIS package pattern with other Birdeye endpoints:

• Businesses: https://api.birdeye.com/v1/businesses
• Locations: https://api.birdeye.com/v1/locations
• Reviews: https://api.birdeye.com/v1/review/businessid/{business_id}
• Messages: https://api.birdeye.com/v1/messages

Configure Destination Component

1. Add an Upsert destination (or another destination of your choice, such as a Trash destination or a JSON/CSV/XML destination).
2. Connect the output arrow from JSON Source to the destination component.
3. Configure your SQL Server connection and target table.
4. Check the options you want to use: Insert or/and Update
5. Map the source columns to destination columns in the Mappings section.
   

   Birdeye – Upsert destination

6. Click OK and execute the package.
7. Validate that Birdeye rows have been loaded into your SQL Server table.
   

   Birdeye – Upsert Destination example

Conclusion

You now have a working SSIS integration to extract Birdeye data using ZappySys SSIS PowerPack and Birdeye APIs. With this pattern, you can automate the extraction of reviews, location data, and customer interaction metrics into SQL Server for reporting and analytics.

Explore the full capabilities of the ZappySys SSIS PowerPack to optimise your data integration tasks. By applying this pattern, you can extend your solution to include transformations, data validation, error handling, and scheduling through SQL Server Agent.

Need Help?

If you encounter any issues, our support team is here to help:

1. Live Chat – Use the chat widget (bottom-right corner of this page)
2. Email – support@zappysys.com
3. Support center – Visit the ZappySys Support Portal