![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Monday-logo.png\"){kind=logo}
<\/a>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.<\/p>\nBecause 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.<\/p>\n
<\/p>\n
<\/h2>\nPrerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is installed.<\/li>\n
- You have a monday.com account with permission to create API tokens and access boards.<\/li>\n
- ZappySys SSIS PowerPack<\/a> is installed.<\/li>\n<\/ol>\n
<\/p>\n
Steps<\/h2>\nGenerate a Monday.com API token<\/h3>\n\n- Sign in to your monday.com account<\/a>.<\/li>\n
- Open your profile menu and go to Admin<\/strong> (or Developers,<\/strong> based on your plan).<\/li>\n
- Navigate to Connection <\/b>and click Personal API token <\/b>settings.<\/li>\n
- Create a new API token (personal or app).<\/li>\n
- Copy the token and store it securely.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Monday-create-token.png\")
<\/a>Monday – create token<\/p><\/div><\/li>\n<\/ol>\n
Create an HTTP connection in SSIS<\/h3>\n\n- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and choose New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Create-a-new-HTTP-connection.png\")
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Enter the following URL:
https:\/\/api.monday.com\/v2<\/code><\/li>\n- Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
- Paste your monday.com API token in the token value field.<\/li>\n
- OAuth header Name<\/strong>:
Authorization<\/code><\/li>\n- OAuth Scheme<\/strong>:
none<\/code> (monday.com expects the raw token in the Authorisation header)<\/li>\n- Click \u00a0OK <\/strong>to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Monday-HTTP-connection.png\")
<\/a>Monday – HTTP connection<\/p><\/div><\/li>\n<\/ol>\n
Create and configure the ZS JSON Source for Monday.com GraphQL<\/h3>\n\n- Drag and drop a Data Flow Task<\/strong> into the Control Flow, then open it.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\")
<\/a>Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the monday.com HTTP connection you created earlier.<\/li>\n
- Set URL<\/strong> to:\n
https:\/\/api.monday.com\/v2<\/pre>\n<\/li>\n
- Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
- Use this GraphQL body to retrieve boards:\n
{\r\n \"query\": \"query { boards { id name } }\"\r\n}<\/pre>\n<\/li>\n - Set JSON Path Filter<\/strong> to:\n
$.data.boards[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK <\/strong>to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Monday-JSON-Source.png\")
<\/a>Monday – JSON Source<\/p><\/div><\/li>\n<\/ol>\n
Optional: Load board items instead of board metadata<\/h3>\n\n- Replace the body with a query that returns items from a board:\n\n
{\r\n\u00a0 \u00a0 \"query\": \"query { boards(ids: 1234567890) { id name items_page(limit: 100) { items { id name created_at updated_at } } } }\"\r\n}<\/pre>\n<\/div>\n<\/li>\n- Replace
1234567890<\/code> with your real board ID.<\/li>\n- Use JSON Path Filter:\n
$.data.boards[*].items_page.items[*]<\/pre>\n<\/li>\n<\/ol>\nConfigure the destination and run the package<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Monday data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- \n
- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is installed.<\/li>\n
- You have a monday.com account with permission to create API tokens and access boards.<\/li>\n
- ZappySys SSIS PowerPack<\/a> is installed.<\/li>\n<\/ol>\n
<\/p>\n
Steps<\/h2>\n
Generate a Monday.com API token<\/h3>\n
- \n
- Sign in to your monday.com account<\/a>.<\/li>\n
- Open your profile menu and go to Admin<\/strong> (or Developers,<\/strong> based on your plan).<\/li>\n
- Navigate to Connection <\/b>and click Personal API token <\/b>settings.<\/li>\n
- Create a new API token (personal or app).<\/li>\n
- Copy the token and store it securely.\n
<\/a>Monday – create token<\/p><\/div><\/li>\n<\/ol>\n
Create an HTTP connection in SSIS<\/h3>\n
- \n
- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and choose New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Enter the following URL:
https:\/\/api.monday.com\/v2<\/code><\/li>\n- Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
- Paste your monday.com API token in the token value field.<\/li>\n
- OAuth header Name<\/strong>:
Authorization<\/code><\/li>\n- OAuth Scheme<\/strong>:
none<\/code> (monday.com expects the raw token in the Authorisation header)<\/li>\n- Click \u00a0OK <\/strong>to save the configuration.\n
<\/a>Monday – HTTP connection<\/p><\/div><\/li>\n<\/ol>\n
Create and configure the ZS JSON Source for Monday.com GraphQL<\/h3>\n
- \n
- Drag and drop a Data Flow Task<\/strong> into the Control Flow, then open it.\n<\/a>
Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the monday.com HTTP connection you created earlier.<\/li>\n
- Set URL<\/strong> to:\n
https:\/\/api.monday.com\/v2<\/pre>\n<\/li>\n
- Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
- Use this GraphQL body to retrieve boards:\n
{\r\n \"query\": \"query { boards { id name } }\"\r\n}<\/pre>\n<\/li>\n- Set JSON Path Filter<\/strong> to:\n
$.data.boards[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK <\/strong>to save the configuration.\n
<\/a>Monday – JSON Source<\/p><\/div><\/li>\n<\/ol>\n
Optional: Load board items instead of board metadata<\/h3>\n
- \n
- Replace the body with a query that returns items from a board:\n\n
{\r\n\u00a0 \u00a0 \"query\": \"query { boards(ids: 1234567890) { id name items_page(limit: 100) { items { id name created_at updated_at } } } }\"\r\n}<\/pre>\n<\/div>\n<\/li>\n- Replace
1234567890<\/code> with your real board ID.<\/li>\n- Use JSON Path Filter:\n
$.data.boards[*].items_page.items[*]<\/pre>\n<\/li>\n<\/ol>\n
Configure the destination and run the package<\/h3>\n
- \n
- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Monday data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- Replace
- In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
- Open your profile menu and go to Admin<\/strong> (or Developers,<\/strong> based on your plan).<\/li>\n
- Sign in to your monday.com account<\/a>.<\/li>\n