SSIS tutorial: How to get data from Monday.com

Introduction

Monday.com is a work operating system that provides a powerful GraphQL API for accessing boards, items, users, groups, and activity data. In this tutorial, you will learn how to connect monday.com to SQL Server Integration Services (SSIS) using Zappysys connectors and extract data without writing custom code.

Because monday.com API uses GraphQL over HTTP, we will configure a token-based HTTP connection and send POST requests from the ZS JSON Source. This approach gives you a repeatable ETL pattern for loading monday.com data into SQL Server tables for reporting, analytics, and automation.

Prerequisites

1. SQL Server Integration Services (SSIS) is installed.
2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is installed.
3. You have a monday.com account with permission to create API tokens and access boards.
4. ZappySys SSIS PowerPack is installed.

Steps

Generate a Monday.com API token

1. Sign in to your monday.com account.
2. Open your profile menu and go to Admin (or Developers, based on your plan).
3. Navigate to Connection and click Personal API token settings.
4. Create a new API token (personal or app).
5. Copy the token and store it securely.
   

   Monday – create token

Create an HTTP connection in SSIS

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

   Create a new HTTP connection

4. Enter the following URL: https://api.monday.com/v2
5. Set Credentials Type to Static token/API key.
6. Paste your monday.com API token in the token value field.
7. OAuth header Name: Authorization
8. OAuth Scheme: none (monday.com expects the raw token in the Authorisation header)
9. Click  OK to save the configuration.
   

   Monday – HTTP connection

Create and configure the ZS JSON Source for Monday.com GraphQL

1. Drag and drop a Data Flow Task into the Control Flow, then 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 monday.com HTTP connection you created earlier.
5. Set URL to:
   
   https://api.monday.com/v2

   1	https://api.monday.com/v2

6. Set HTTP Request Method to POST.
7. Set Body content type to JSON (application/json).
8. Use this GraphQL body to retrieve boards:
   
   { "query": "query { boards { id name } }" }

   1 2 3

   {   "query": "query { boards { id name } }" }

9. Set JSON Path Filter to:
   
   $.data.boards[*]

   1	$.data.boards[*]

10. Click Preview to confirm rows are returned, then click OK to save the configuration.
    

    Monday – JSON Source

Optional: Load board items instead of board metadata

1. Replace the body with a query that returns items from a board:
   {     "query": "query { boards(ids: 1234567890) { id name items_page(limit: 100) { items { id name created_at updated_at } } } }" }

   1 2 3

   {     "query": "query { boards(ids: 1234567890) { id name items_page(limit: 100) { items { id name created_at updated_at } } } }" }

2. Replace 1234567890 with your real board ID.
3. Use JSON Path Filter:
   
   $.data.boards[*].items_page.items[*]

   1	$.data.boards[*].items_page.items[*]

Configure the destination and run the package

1. Drag and drop a destination component (such as OLE DB Destination, Flat File Destination, or Trash Destination) into the Data Flow.
2. Connect the output arrow from the JSON Source component to the destination component.
3. Double-click the destination component to open its configuration dialogue.
4. Configure the destination to point to your target table or file where Monday data will be stored.
5. In the Mappings section, map the columns from the JSON response to the corresponding destination columns.
6. Click OK to save the destination configuration.
7. Execute the package and verify that the data extraction is working correctly.
   

   Monday – Final Result

Conclusion

You now have a working SSIS integration pattern for monday.com using Zappysys HTTP + JSON Source components. By sending GraphQL POST requests to the monday.com API endpoint, you can extract boards, items, users, and more into SQL Server without writing custom scripts.

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 additional 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