SSIS Tutorial: How to get data from Bluebeam

Introduction

Bluebeam Studio is a cloud collaboration platform that construction and design teams use to run drawing reviews, markups, and document handoffs through Bluebeam Revu. Many organizations need Studio Sessions, Projects, and Jobs data in SQL Server for reporting, audit trails, and project tracking.

In this tutorial, you will learn how to connect to the Bluebeam Studio API using SQL Server Integration Services (SSIS) with the ZappySys SSIS PowerPack. This approach helps you build repeatable ETL pipelines without writing custom OAuth or API integration code.

Steps

Get Bluebeam API credentials

1. Sign in to the Bluebeam Developer Portal with your BBID credentials.
2. Register a new App and note the region it is registered under (US, DE, AU, UK, or SE), since this determines the base URL you will use later.
   

   Bluebeam – Create an Application

3. Open the App details page and generate your Client ID and Client Secret — store both values securely. You will need the Client ID again later for a required request header.
   

   Bluebeam – Generate client ID and secret

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-OAUTH from the SSIS connectors list.
   

   Create a new SSIS OAuth API Connection Manager

4. Set OAuth version to OAuth2
5. Set OAuth Grant type to Authorization Code Grant.
6. Enter your Client ID and Client Secret from the previous step.
7. Set the Authorization URL to https://api.bluebeam.com/oauth2/authorize and the Access Token URL to https://api.bluebeam.com/oauth2/token using your region’s host.
8. Set Scope to:
   
   full_user jobs offline_access

   1 2 3

   full_user jobs offline_access

9. Click Generate Token and click OK to save the connection.
   

   Bluebeam – OAuth connection

Create and configure JSON Source

1. Drag a Data Flow Task into Control Flow and open it.
2. In Data Flow, drag and drop the ZS JSON Source.
3. Open the JSON Source editor and enable Use credentials.
4. Select the Bluebeam HTTP connection you created earlier.
5. Set the API URL using your region’s base URL. Example to list Studio Sessions:
   
   https://api.bluebeam.com/publicapi/v1/sessions

   1	https://api.bluebeam.com/publicapi/v1/sessions

6. Set the HTTP Request Method to GET.
7. Add the following HTTP Headers:
   • Content-Type: application/json
   • client_id: your Bluebeam Client ID

   Bluebeam rejects the request with only the Bearer token from the OAuth connection; the client_id header must be added manually here, since it identifies the App making the call.

8. Set the JSON Path Filter based on the response shape; example: $.Sessions[*]
9. Click Preview to confirm rows are returned, then click OK to save the configuration.
   

   Bluebeam – the JSON Source configuration

Configure Destination component

1. Add an Upsert Destination (or another destination of your choice, such as a Trash destination or 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. Select the options you want to use: Insert and/or Update.
5. Map the source columns to destination columns in the Mappings section.
   

   Bluebeam – Upsert destination

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

   Bluebeam – Upsert Destination example

Conclusion

You now have a working SSIS integration to extract Bluebeam Studio data using ZappySys SSIS PowerPack and the Bluebeam Studio API. With this pattern, you can automate extraction of Sessions, Projects, and Jobs data into SQL Server for reporting and project tracking, since the OAuth2 refresh token keeps the connection authenticated without repeated manual logins.

Explore the full capabilities of the ZappySys SSIS PowerPack to optimize 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.