{"id":12482,"date":"2026-09-17T22:47:31","date_gmt":"2026-09-17T22:47:31","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12482"},"modified":"2026-09-18T01:00:33","modified_gmt":"2026-09-18T01:00:33","slug":"ssis-tutorial-how-to-get-data-from-bluebeam","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-bluebeam\/","title":{"rendered":"SSIS Tutorial: How to get data from Bluebeam"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>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.<\/p>\n

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.<\/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 Bluebeam API credentials<\/h3>\n
      \n
    1. Sign in to the Bluebeam Developer Portal<\/a> with your BBID credentials.<\/li>\n
    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.\n
    3. Open the App details page and generate your Client ID<\/strong> and Client Secret<\/strong> \u2014 store both values securely. You will need the Client ID again later for a required request header.\n
      \"\"<\/a>

      Bluebeam – Generate client ID and secret<\/p><\/div><\/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-OAUTH<\/strong> from the SSIS connectors list.\n
      4. Set OAuth version<\/strong> to OAuth2<\/strong><\/li>\n
      5. Set OAuth Grant type <\/strong>to Authorization Code Grant<\/strong>.<\/li>\n
      6. Enter your Client ID<\/strong> and Client Secret<\/strong> from the previous step.<\/li>\n
      7. Set the Authorization URL<\/strong> to https:\/\/api.bluebeam.com\/oauth2\/authorize<\/span> and the Access Token URL<\/strong> to https:\/\/api.bluebeam.com\/oauth2\/token<\/span> using your region’s host.<\/li>\n
      8. Set Scope<\/strong> to:\n
        full_user \r\njobs \r\noffline_access<\/pre>\n<\/li>\n
      9. Click Generate Token<\/strong> and click OK<\/strong> to save the connection.\n
        \"\"<\/a>
        Bluebeam – OAuth 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.<\/li>\n
        2. In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.<\/li>\n
        3. Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
        4. Select the Bluebeam HTTP connection you created earlier.<\/li>\n
        5. Set the API URL using your region’s base URL. Example to list Studio Sessions:\n
          https:\/\/api.bluebeam.com\/publicapi\/v1\/sessions<\/pre>\n<\/li>\n
        6. Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        7. Add the following HTTP Headers<\/strong>:\n