Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n\r\n \t- SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
- Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
- Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
- (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n
<\/a>Steps<\/h2>\n<\/a>Get the Swagger endpoints<\/h3>\nBefore connecting from SSIS, identify the endpoints you want to use. In this example, we will use the Petstore Swagger server <\/a>as a public API reference.<\/div>\n\n- Review the server\u2019s endpoint list. In this example, we will explore the\u00a0Pet<\/strong>\u00a0category.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\")
<\/a>Swagger – Pet category<\/p><\/div><\/li>\n
- From the list, we can see multiple endpoints and HTTP methods, including GET<\/strong>,\u00a0POST<\/strong>,\u00a0PUT<\/strong>, and\u00a0DELETE.<\/strong><\/li>\n
- Click on an endpoint to expand it. For this example, we will use Add a new pet to the store.
\n<\/strong><\/strong><\/p>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Create-a-new-pet.png\")
<\/a>Swagger – Create a new pet<\/p><\/div><\/li>\n
- Click\u00a0Try it out<\/strong>. Swagger will allow you to edit the request body and choose the content type (JSON or XML).<\/li>\n
- Click\u00a0Execute<\/strong>. Swagger will display\n
\n- The generated request in\u00a0cURL<\/strong>\u00a0format<\/li>\n
- The Request URL<\/li>\n
- The Response body<\/li>\n
- The HTTP status code<\/li>\n<\/ul>\n<\/li>\n
- In the Response JSON, we can see the new pet with status code 200, indicating success.<\/li>\n
- Now, with the CURL<\/strong> syntax, we can use that inside our tool.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Create-a-new-pet-CURL.png\")
<\/a>Swagger – Create a new pet CURL<\/p><\/div><\/li>\n<\/ol>\n
<\/a><\/h3>\nPOST request: Create Pet Request<\/h3>\n\n- Open Visual Studio and create a new\u00a0Integration Services Project<\/strong>.<\/li>\n
- After the project is created, locate the\u00a0SSIS Toolbox<\/strong>\u00a0on the left panel.<\/li>\n
- Drag and drop the\u00a0REST API Task<\/strong>\u00a0onto the Control Flow surface and double-click it to configure\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-Drop-REST-API-Task.png\")
<\/a>Drag and Drop REST API Task<\/p><\/div><\/li>\n
- Use the cURL generated from Swagger. For reference, you can review our article about converting\u00a0cURL to an SSIS API Task<\/a>.\n
curl -X 'POST' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: application\/json' \\\r\n -d '{\r\n \"id\": 123,\r\n \"category\": {\r\n \"id\": 456,\r\n \"name\": \"Friendly\"\r\n },\r\n \"name\": \"Zappy\",\r\n \"photoUrls\": [\r\n \"string\"\r\n ],\r\n \"tags\": [\r\n {\r\n \"id\": 0,\r\n \"name\": \"tech\"\r\n }\r\n ],\r\n \"status\": \"available\"\r\n}'<\/code><\/pre>\n<\/li>\n- -X POST<\/strong>\u00a0represents the HTTP method. Set the Request Method to\u00a0POST<\/strong>.<\/li>\n
- Enter the URL from the cURL command.<\/li>\n
- Each\u00a0-H<\/strong>\u00a0represents a Header. Add the corresponding headers inside the REST API Task.<\/li>\n
- The\u00a0-d<\/strong>\u00a0parameter represents the Body. Paste the JSON payload into the Body section.<\/li>\n
- Click\u00a0Test Request\/Response<\/strong> to validate the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/SSIS-Create-a-new-pet.png\")
<\/a>SSIS – Create a new pet<\/p><\/div><\/li>\n
- You can use additional components such as\u00a0JSON Source<\/strong>\u00a0or\u00a0XML Source,<\/strong>\u00a0depending on how you plan to process the response.<\/li>\n<\/ol>\n
POST request: Upload a file<\/h3>\n\n- Next, we will upload an image for the pet we created earlier\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-upload-image.png\")
<\/a>Swagger – upload image<\/p><\/div><\/li>\n
- Generate the CURL code.\n
curl -X 'POST' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/123\/uploadImage' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: multipart\/form-data' \\\r\n -F 'file=@new.jpg;type=image\/jpeg'<\/code><\/pre>\n<\/li>\n- Configure the REST API Task with:\n
\n- Request Method: POST<\/li>\n
- URL<\/li>\n
- Headers<\/li>\n
- File parameter<\/li>\n<\/ul>\n<\/li>\n
- Check the option File upload.<\/strong><\/li>\n
- Specify the full file path (e.g.,\u00a0file=@D:\\Zappysys\\new.jpg<\/em>).<\/li>\n
- Click Test Request to validate the upload.<\/li>\n
- You can find an article about uploading files here<\/a>.\n<\/div>\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/SSIS-upload-an-image.png\")
<\/a>SSIS – upload an image<\/p><\/div><\/li>\n<\/ol>\n
GET request: Get the Pet information<\/h3>\n\n- \u00a0Now we will get the pet we created earlier. This is the example\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-get-pet-by-id.png\")
<\/a>Swagger – get pet by id<\/p><\/div><\/li>\n
- We generate the CURL\n
curl -X 'GET' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/123' \\\r\n -H 'accept: application\/json'<\/code><\/pre>\n<\/li>\n- Inside the Visual Studio project, drag and drop the\u00a0SSIS Data Flow Task<\/strong> from the SSIS Toolbox.\u00a0Double-click on the\u00a0Data Flow Task<\/em>\u00a0to see the\u00a0Data Flow<\/em> designer.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/Drag-and-Drop-SSIS-Data-Flow-Task-from-SSIS-Toolbox.png\")
<\/a>Drag and Drop SSIS Data Flow Task from SSIS Toolbox<\/p><\/div><\/li>\n
- From the SSIS toolbox, drag and drop a JSON Source<\/a> onto the data flow designer surface, and double-click on it to edit it\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
- We use the method GET<\/strong><\/li>\n
- We enter the URL with the ID<\/strong> from the earlier response.<\/li>\n
- We can use the filter to get the object we need, and now we can check the data.<\/li>\n
- Preview the data, and you will see the Pet’s information\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/SSIS-get-a-pet.png\")
<\/a>SSIS – get a pet by ID<\/p><\/div><\/li>\n<\/ol>\n
PUT request: Update an existing pet<\/h3>\n\n- We go to the updated pet example and run the example\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-update-a-pet.png\")
<\/a>Swagger – update a pet<\/p><\/div><\/li>\n
- Generate the CURL\n
curl -X 'PUT' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: application\/json' \\\r\n -d '{\r\n \"id\": 0,\r\n \"category\": {\r\n \"id\": 0,\r\n \"name\": \"string\"\r\n },\r\n \"name\": \"doggie2\",\r\n \"photoUrls\": [\r\n \"string\"\r\n ],\r\n \"tags\": [\r\n {\r\n \"id\": 0,\r\n \"name\": \"string\"\r\n }\r\n ],\r\n \"status\": \"available\"\r\n}'<\/code><\/pre>\n<\/li>\n- Inside the JSON source, we configure the HTTP method to PUT.<\/strong><\/li>\n
- Change the url and the header.<\/li>\n
- Inside the Body we can change the values from the existing pet.<\/li>\n
- Test the connection and check the result.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/SSIS-update-a-pet.png\")
<\/a>SSIS – update a pet<\/p><\/div><\/li>\n<\/ol>\n
DELETE request: Remove an existing pet<\/h3>\n\n- Now we will delete the pet using this example.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-delete-a-pet.png\")
<\/a>Swagger – delete a pet<\/p><\/div><\/li>\n
- Generate the CURL to delete the pet\n
curl -X 'DELETE' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/1234' \\\r\n -H 'accept: application\/json' \\\r\n -H 'api_key: special-key'<\/code><\/pre>\n<\/li>\n- Inside the JSON source, configure the HTTP method to DELETE.<\/strong><\/li>\n
- Change the URL to include the pet’s ID.<\/li>\n
- Inside the header, we need to insert an API key.<\/li>\n
- Test the connection, and we will delete the pet.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/SSIS-delete-a-pet.png\")
<\/a>aSSIS – delete a pet<\/p><\/div><\/li>\n<\/ol>\n
Authentication method<\/h3>\n\n- Some APIs require authentication. You can configure authentication using an HTTP Connection Manager.<\/li>\n
- Enter the login URL if required.<\/li>\n
- Select the credential type (e.g., Basic \u2013 Username\/Password).<\/li>\n
- Enter the credentials.<\/li>\n
- Click OK to save the configuration.<\/li>\n
- This connection can be reused across multiple REST API Tasks or JSON Sources.<\/li>\n
- For more details on\u00a0basic authentication, click here.<\/a>\u00a0For\u00a0more details on the OAuth connection, click here<\/a>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-SSIS-basic-authentication.png\")
<\/a>Swagger – SSIS basic authentication<\/p><\/div><\/li>\n<\/ol>\n
<\/div>\n<\/a>Conclusion<\/h2>\nIntegrating Swagger-documented APIs with ZappySys SSIS becomes significantly easier when using the generated\u00a0cURL<\/strong>\u00a0command as a reference. Swagger provides a clear and interactive way to understand API endpoints, request structures, headers, and payload formats, while cURL offers a direct, executable representation of the HTTP request.<\/p>\nBy translating the cURL command into the REST API Task or JSON Source configuration, developers can confidently replicate API calls inside SSIS without guesswork. This approach ensures accuracy, reduces troubleshooting time, and provides a consistent workflow for handling GET, POST, PUT, DELETE operations, file uploads, and authentication scenarios.<\/p>\n
Download\u00a0SSIS PowerPack<\/a> today and see for yourself how easy it is to combine Swagger and ZappySys SSIS, enabling organizations to seamlessly integrate modern REST APIs into enterprise ETL processes and bridge the gap between cloud-based services and traditional SQL Server data platforms.<\/span><\/p>\n<\/a>Still need help?<\/strong><\/span><\/p>\nIf the issue persists, please get in touch with our support team:<\/p>\n
\n- Live Chat:<\/strong>\u00a0Open the chat widget\u00a0(bottom right of this page)<\/em><\/li>\n
- Email:<\/strong>\u00a0support@zappysys.com<\/a><\/li>\n
- Support Center<\/strong>:\u00a0Support | ZappySys<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Introduction In this article, we’ll learn how to integrate a documented API in Swagger with SQL Server Integration Services (SSIS) using ZappySys PowerPack. Swagger enables us to visualize and test REST endpoints, while ZappySys SSIS provides advanced components for consuming APIs and transforming data in ETL processes. Steps Get the Swagger endpoints Before connecting from […]<\/p>\n","protected":false},"author":5,"featured_media":11712,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,16,17,8,10,9],"tags":[],"yoast_head":"\r\n
SSIS tutorial: How to connect to Swagger | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS tutorial: How to connect to Swagger | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-02-20T00:11:27+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-03-02T15:16:22+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"594\" \/>\r\n\t<meta property=\"og:image:height\" content=\"547\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\",\"name\":\"SSIS tutorial: How to connect to Swagger | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"datePublished\":\"2026-02-20T00:11:27+00:00\",\"dateModified\":\"2026-03-02T15:16:22+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"width\":594,\"height\":547,\"caption\":\"Swagger - Pet category\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to connect to Swagger\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","og_description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","og_site_name":"ZappySys Blog","article_published_time":"2026-02-20T00:11:27+00:00","article_modified_time":"2026-03-02T15:16:22+00:00","og_image":[{"width":594,"height":547,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","name":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","datePublished":"2026-02-20T00:11:27+00:00","dateModified":"2026-03-02T15:16:22+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","width":594,"height":547,"caption":"Swagger - Pet category"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to connect to Swagger"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=11710"}],"version-history":[{"count":14,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710\/revisions"}],"predecessor-version":[{"id":11753,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710\/revisions\/11753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11712"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/a>Steps<\/h2>\n<\/a>Get the Swagger endpoints<\/h3>\nBefore connecting from SSIS, identify the endpoints you want to use. In this example, we will use the Petstore Swagger server <\/a>as a public API reference.<\/div>\n\n- Review the server\u2019s endpoint list. In this example, we will explore the\u00a0Pet<\/strong>\u00a0category.\n<\/a>
Swagger – Pet category<\/p><\/div><\/li>\n
- From the list, we can see multiple endpoints and HTTP methods, including GET<\/strong>,\u00a0POST<\/strong>,\u00a0PUT<\/strong>, and\u00a0DELETE.<\/strong><\/li>\n
- Click on an endpoint to expand it. For this example, we will use Add a new pet to the store.
\n<\/strong><\/strong><\/p>\n<\/a>Swagger – Create a new pet<\/p><\/div><\/li>\n
- Click\u00a0Try it out<\/strong>. Swagger will allow you to edit the request body and choose the content type (JSON or XML).<\/li>\n
- Click\u00a0Execute<\/strong>. Swagger will display\n
\n- The generated request in\u00a0cURL<\/strong>\u00a0format<\/li>\n
- The Request URL<\/li>\n
- The Response body<\/li>\n
- The HTTP status code<\/li>\n<\/ul>\n<\/li>\n
- In the Response JSON, we can see the new pet with status code 200, indicating success.<\/li>\n
- Now, with the CURL<\/strong> syntax, we can use that inside our tool.\n<\/a>
Swagger – Create a new pet CURL<\/p><\/div><\/li>\n<\/ol>\n
<\/a><\/h3>\nPOST request: Create Pet Request<\/h3>\n\n- Open Visual Studio and create a new\u00a0Integration Services Project<\/strong>.<\/li>\n
- After the project is created, locate the\u00a0SSIS Toolbox<\/strong>\u00a0on the left panel.<\/li>\n
- Drag and drop the\u00a0REST API Task<\/strong>\u00a0onto the Control Flow surface and double-click it to configure\n<\/a>
Drag and Drop REST API Task<\/p><\/div><\/li>\n
- Use the cURL generated from Swagger. For reference, you can review our article about converting\u00a0cURL to an SSIS API Task<\/a>.\n
curl -X 'POST' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: application\/json' \\\r\n -d '{\r\n \"id\": 123,\r\n \"category\": {\r\n \"id\": 456,\r\n \"name\": \"Friendly\"\r\n },\r\n \"name\": \"Zappy\",\r\n \"photoUrls\": [\r\n \"string\"\r\n ],\r\n \"tags\": [\r\n {\r\n \"id\": 0,\r\n \"name\": \"tech\"\r\n }\r\n ],\r\n \"status\": \"available\"\r\n}'<\/code><\/pre>\n<\/li>\n- -X POST<\/strong>\u00a0represents the HTTP method. Set the Request Method to\u00a0POST<\/strong>.<\/li>\n
- Enter the URL from the cURL command.<\/li>\n
- Each\u00a0-H<\/strong>\u00a0represents a Header. Add the corresponding headers inside the REST API Task.<\/li>\n
- The\u00a0-d<\/strong>\u00a0parameter represents the Body. Paste the JSON payload into the Body section.<\/li>\n
- Click\u00a0Test Request\/Response<\/strong> to validate the configuration.\n<\/a>
SSIS – Create a new pet<\/p><\/div><\/li>\n
- You can use additional components such as\u00a0JSON Source<\/strong>\u00a0or\u00a0XML Source,<\/strong>\u00a0depending on how you plan to process the response.<\/li>\n<\/ol>\n
POST request: Upload a file<\/h3>\n\n- Next, we will upload an image for the pet we created earlier\n<\/a>
Swagger – upload image<\/p><\/div><\/li>\n
- Generate the CURL code.\n
curl -X 'POST' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/123\/uploadImage' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: multipart\/form-data' \\\r\n -F 'file=@new.jpg;type=image\/jpeg'<\/code><\/pre>\n<\/li>\n- Configure the REST API Task with:\n
\n- Request Method: POST<\/li>\n
- URL<\/li>\n
- Headers<\/li>\n
- File parameter<\/li>\n<\/ul>\n<\/li>\n
- Check the option File upload.<\/strong><\/li>\n
- Specify the full file path (e.g.,\u00a0file=@D:\\Zappysys\\new.jpg<\/em>).<\/li>\n
- Click Test Request to validate the upload.<\/li>\n
- You can find an article about uploading files here<\/a>.\n<\/div>\n<\/a>
SSIS – upload an image<\/p><\/div><\/li>\n<\/ol>\n
GET request: Get the Pet information<\/h3>\n\n- \u00a0Now we will get the pet we created earlier. This is the example\n<\/a>
Swagger – get pet by id<\/p><\/div><\/li>\n
- We generate the CURL\n
curl -X 'GET' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/123' \\\r\n -H 'accept: application\/json'<\/code><\/pre>\n<\/li>\n- Inside the Visual Studio project, drag and drop the\u00a0SSIS Data Flow Task<\/strong> from the SSIS Toolbox.\u00a0Double-click on the\u00a0Data Flow Task<\/em>\u00a0to see the\u00a0Data Flow<\/em> designer.\n<\/a>
Drag and Drop SSIS Data Flow Task from SSIS Toolbox<\/p><\/div><\/li>\n
- From the SSIS toolbox, drag and drop a JSON Source<\/a> onto the data flow designer surface, and double-click on it to edit it\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- We use the method GET<\/strong><\/li>\n
- We enter the URL with the ID<\/strong> from the earlier response.<\/li>\n
- We can use the filter to get the object we need, and now we can check the data.<\/li>\n
- Preview the data, and you will see the Pet’s information\n<\/a>
SSIS – get a pet by ID<\/p><\/div><\/li>\n<\/ol>\n
PUT request: Update an existing pet<\/h3>\n\n- We go to the updated pet example and run the example\n<\/a>
Swagger – update a pet<\/p><\/div><\/li>\n
- Generate the CURL\n
curl -X 'PUT' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: application\/json' \\\r\n -d '{\r\n \"id\": 0,\r\n \"category\": {\r\n \"id\": 0,\r\n \"name\": \"string\"\r\n },\r\n \"name\": \"doggie2\",\r\n \"photoUrls\": [\r\n \"string\"\r\n ],\r\n \"tags\": [\r\n {\r\n \"id\": 0,\r\n \"name\": \"string\"\r\n }\r\n ],\r\n \"status\": \"available\"\r\n}'<\/code><\/pre>\n<\/li>\n- Inside the JSON source, we configure the HTTP method to PUT.<\/strong><\/li>\n
- Change the url and the header.<\/li>\n
- Inside the Body we can change the values from the existing pet.<\/li>\n
- Test the connection and check the result.\n<\/a>
SSIS – update a pet<\/p><\/div><\/li>\n<\/ol>\n
DELETE request: Remove an existing pet<\/h3>\n\n- Now we will delete the pet using this example.\n<\/a>
Swagger – delete a pet<\/p><\/div><\/li>\n
- Generate the CURL to delete the pet\n
curl -X 'DELETE' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/1234' \\\r\n -H 'accept: application\/json' \\\r\n -H 'api_key: special-key'<\/code><\/pre>\n<\/li>\n- Inside the JSON source, configure the HTTP method to DELETE.<\/strong><\/li>\n
- Change the URL to include the pet’s ID.<\/li>\n
- Inside the header, we need to insert an API key.<\/li>\n
- Test the connection, and we will delete the pet.\n<\/a>
aSSIS – delete a pet<\/p><\/div><\/li>\n<\/ol>\n
Authentication method<\/h3>\n\n- Some APIs require authentication. You can configure authentication using an HTTP Connection Manager.<\/li>\n
- Enter the login URL if required.<\/li>\n
- Select the credential type (e.g., Basic \u2013 Username\/Password).<\/li>\n
- Enter the credentials.<\/li>\n
- Click OK to save the configuration.<\/li>\n
- This connection can be reused across multiple REST API Tasks or JSON Sources.<\/li>\n
- For more details on\u00a0basic authentication, click here.<\/a>\u00a0For\u00a0more details on the OAuth connection, click here<\/a>.\n<\/a>
Swagger – SSIS basic authentication<\/p><\/div><\/li>\n<\/ol>\n
<\/div>\n<\/a>Conclusion<\/h2>\nIntegrating Swagger-documented APIs with ZappySys SSIS becomes significantly easier when using the generated\u00a0cURL<\/strong>\u00a0command as a reference. Swagger provides a clear and interactive way to understand API endpoints, request structures, headers, and payload formats, while cURL offers a direct, executable representation of the HTTP request.<\/p>\nBy translating the cURL command into the REST API Task or JSON Source configuration, developers can confidently replicate API calls inside SSIS without guesswork. This approach ensures accuracy, reduces troubleshooting time, and provides a consistent workflow for handling GET, POST, PUT, DELETE operations, file uploads, and authentication scenarios.<\/p>\n
Download\u00a0SSIS PowerPack<\/a> today and see for yourself how easy it is to combine Swagger and ZappySys SSIS, enabling organizations to seamlessly integrate modern REST APIs into enterprise ETL processes and bridge the gap between cloud-based services and traditional SQL Server data platforms.<\/span><\/p>\n<\/a>Still need help?<\/strong><\/span><\/p>\nIf the issue persists, please get in touch with our support team:<\/p>\n
\n- Live Chat:<\/strong>\u00a0Open the chat widget\u00a0(bottom right of this page)<\/em><\/li>\n
- Email:<\/strong>\u00a0support@zappysys.com<\/a><\/li>\n
- Support Center<\/strong>:\u00a0Support | ZappySys<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Introduction In this article, we’ll learn how to integrate a documented API in Swagger with SQL Server Integration Services (SSIS) using ZappySys PowerPack. Swagger enables us to visualize and test REST endpoints, while ZappySys SSIS provides advanced components for consuming APIs and transforming data in ETL processes. Steps Get the Swagger endpoints Before connecting from […]<\/p>\n","protected":false},"author":5,"featured_media":11712,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,16,17,8,10,9],"tags":[],"yoast_head":"\r\n
SSIS tutorial: How to connect to Swagger | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS tutorial: How to connect to Swagger | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-02-20T00:11:27+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-03-02T15:16:22+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"594\" \/>\r\n\t<meta property=\"og:image:height\" content=\"547\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\",\"name\":\"SSIS tutorial: How to connect to Swagger | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"datePublished\":\"2026-02-20T00:11:27+00:00\",\"dateModified\":\"2026-03-02T15:16:22+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"width\":594,\"height\":547,\"caption\":\"Swagger - Pet category\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to connect to Swagger\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","og_description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","og_site_name":"ZappySys Blog","article_published_time":"2026-02-20T00:11:27+00:00","article_modified_time":"2026-03-02T15:16:22+00:00","og_image":[{"width":594,"height":547,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","name":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","datePublished":"2026-02-20T00:11:27+00:00","dateModified":"2026-03-02T15:16:22+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","width":594,"height":547,"caption":"Swagger - Pet category"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to connect to Swagger"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=11710"}],"version-history":[{"count":14,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710\/revisions"}],"predecessor-version":[{"id":11753,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710\/revisions\/11753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11712"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n
- Review the server\u2019s endpoint list. In this example, we will explore the\u00a0Pet<\/strong>\u00a0category.\n<\/a>
Swagger – Pet category<\/p><\/div><\/li>\n
- From the list, we can see multiple endpoints and HTTP methods, including GET<\/strong>,\u00a0POST<\/strong>,\u00a0PUT<\/strong>, and\u00a0DELETE.<\/strong><\/li>\n
- Click on an endpoint to expand it. For this example, we will use Add a new pet to the store.
\n<\/strong><\/strong><\/p>\n<\/a>Swagger – Create a new pet<\/p><\/div><\/li>\n
- Click\u00a0Try it out<\/strong>. Swagger will allow you to edit the request body and choose the content type (JSON or XML).<\/li>\n
- Click\u00a0Execute<\/strong>. Swagger will display\n
- \n
- The generated request in\u00a0cURL<\/strong>\u00a0format<\/li>\n
- The Request URL<\/li>\n
- The Response body<\/li>\n
- The HTTP status code<\/li>\n<\/ul>\n<\/li>\n
- In the Response JSON, we can see the new pet with status code 200, indicating success.<\/li>\n
- Now, with the CURL<\/strong> syntax, we can use that inside our tool.\n
<\/a>Swagger – Create a new pet CURL<\/p><\/div><\/li>\n<\/ol>\n
<\/a><\/h3>\n
POST request: Create Pet Request<\/h3>\n
- \n
- Open Visual Studio and create a new\u00a0Integration Services Project<\/strong>.<\/li>\n
- After the project is created, locate the\u00a0SSIS Toolbox<\/strong>\u00a0on the left panel.<\/li>\n
- Drag and drop the\u00a0REST API Task<\/strong>\u00a0onto the Control Flow surface and double-click it to configure\n
<\/a>Drag and Drop REST API Task<\/p><\/div><\/li>\n
- Use the cURL generated from Swagger. For reference, you can review our article about converting\u00a0cURL to an SSIS API Task<\/a>.\n
curl -X 'POST' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: application\/json' \\\r\n -d '{\r\n \"id\": 123,\r\n \"category\": {\r\n \"id\": 456,\r\n \"name\": \"Friendly\"\r\n },\r\n \"name\": \"Zappy\",\r\n \"photoUrls\": [\r\n \"string\"\r\n ],\r\n \"tags\": [\r\n {\r\n \"id\": 0,\r\n \"name\": \"tech\"\r\n }\r\n ],\r\n \"status\": \"available\"\r\n}'<\/code><\/pre>\n<\/li>\n- -X POST<\/strong>\u00a0represents the HTTP method. Set the Request Method to\u00a0POST<\/strong>.<\/li>\n
- Enter the URL from the cURL command.<\/li>\n
- Each\u00a0-H<\/strong>\u00a0represents a Header. Add the corresponding headers inside the REST API Task.<\/li>\n
- The\u00a0-d<\/strong>\u00a0parameter represents the Body. Paste the JSON payload into the Body section.<\/li>\n
- Click\u00a0Test Request\/Response<\/strong> to validate the configuration.\n
<\/a>SSIS – Create a new pet<\/p><\/div><\/li>\n
- You can use additional components such as\u00a0JSON Source<\/strong>\u00a0or\u00a0XML Source,<\/strong>\u00a0depending on how you plan to process the response.<\/li>\n<\/ol>\n
POST request: Upload a file<\/h3>\n
- \n
- Next, we will upload an image for the pet we created earlier\n<\/a>
Swagger – upload image<\/p><\/div><\/li>\n
- Generate the CURL code.\n
curl -X 'POST' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/123\/uploadImage' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: multipart\/form-data' \\\r\n -F 'file=@new.jpg;type=image\/jpeg'<\/code><\/pre>\n<\/li>\n- Configure the REST API Task with:\n
- \n
- Request Method: POST<\/li>\n
- URL<\/li>\n
- Headers<\/li>\n
- File parameter<\/li>\n<\/ul>\n<\/li>\n
- Check the option File upload.<\/strong><\/li>\n
- Specify the full file path (e.g.,\u00a0file=@D:\\Zappysys\\new.jpg<\/em>).<\/li>\n
- Click Test Request to validate the upload.<\/li>\n
- You can find an article about uploading files here<\/a>.\n
<\/div>\n<\/a>SSIS – upload an image<\/p><\/div><\/li>\n<\/ol>\n
GET request: Get the Pet information<\/h3>\n
- \n
- \u00a0Now we will get the pet we created earlier. This is the example\n<\/a>
Swagger – get pet by id<\/p><\/div><\/li>\n
- We generate the CURL\n
curl -X 'GET' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/123' \\\r\n -H 'accept: application\/json'<\/code><\/pre>\n<\/li>\n- Inside the Visual Studio project, drag and drop the\u00a0SSIS Data Flow Task<\/strong> from the SSIS Toolbox.\u00a0Double-click on the\u00a0Data Flow Task<\/em>\u00a0to see the\u00a0Data Flow<\/em> designer.\n
<\/a>Drag and Drop SSIS Data Flow Task from SSIS Toolbox<\/p><\/div><\/li>\n
- From the SSIS toolbox, drag and drop a JSON Source<\/a> onto the data flow designer surface, and double-click on it to edit it\n
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- We use the method GET<\/strong><\/li>\n
- We enter the URL with the ID<\/strong> from the earlier response.<\/li>\n
- We can use the filter to get the object we need, and now we can check the data.<\/li>\n
- Preview the data, and you will see the Pet’s information\n
<\/a>SSIS – get a pet by ID<\/p><\/div><\/li>\n<\/ol>\n
PUT request: Update an existing pet<\/h3>\n
- \n
- We go to the updated pet example and run the example\n<\/a>
Swagger – update a pet<\/p><\/div><\/li>\n
- Generate the CURL\n
curl -X 'PUT' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet' \\\r\n -H 'accept: application\/json' \\\r\n -H 'Content-Type: application\/json' \\\r\n -d '{\r\n \"id\": 0,\r\n \"category\": {\r\n \"id\": 0,\r\n \"name\": \"string\"\r\n },\r\n \"name\": \"doggie2\",\r\n \"photoUrls\": [\r\n \"string\"\r\n ],\r\n \"tags\": [\r\n {\r\n \"id\": 0,\r\n \"name\": \"string\"\r\n }\r\n ],\r\n \"status\": \"available\"\r\n}'<\/code><\/pre>\n<\/li>\n- Inside the JSON source, we configure the HTTP method to PUT.<\/strong><\/li>\n
- Change the url and the header.<\/li>\n
- Inside the Body we can change the values from the existing pet.<\/li>\n
- Test the connection and check the result.\n
<\/a>SSIS – update a pet<\/p><\/div><\/li>\n<\/ol>\n
DELETE request: Remove an existing pet<\/h3>\n
- \n
- Now we will delete the pet using this example.\n<\/a>
Swagger – delete a pet<\/p><\/div><\/li>\n
- Generate the CURL to delete the pet\n
curl -X 'DELETE' \\\r\n 'https:\/\/petstore.swagger.io\/v2\/pet\/1234' \\\r\n -H 'accept: application\/json' \\\r\n -H 'api_key: special-key'<\/code><\/pre>\n<\/li>\n- Inside the JSON source, configure the HTTP method to DELETE.<\/strong><\/li>\n
- Change the URL to include the pet’s ID.<\/li>\n
- Inside the header, we need to insert an API key.<\/li>\n
- Test the connection, and we will delete the pet.\n
<\/a>aSSIS – delete a pet<\/p><\/div><\/li>\n<\/ol>\n
Authentication method<\/h3>\n
- \n
- Some APIs require authentication. You can configure authentication using an HTTP Connection Manager.<\/li>\n
- Enter the login URL if required.<\/li>\n
- Select the credential type (e.g., Basic \u2013 Username\/Password).<\/li>\n
- Enter the credentials.<\/li>\n
- Click OK to save the configuration.<\/li>\n
- This connection can be reused across multiple REST API Tasks or JSON Sources.<\/li>\n
- For more details on\u00a0basic authentication, click here.<\/a>\u00a0For\u00a0more details on the OAuth connection, click here<\/a>.\n<\/a>
Swagger – SSIS basic authentication<\/p><\/div><\/li>\n<\/ol>\n
<\/div>\n<\/a>Conclusion<\/h2>\n
Integrating Swagger-documented APIs with ZappySys SSIS becomes significantly easier when using the generated\u00a0cURL<\/strong>\u00a0command as a reference. Swagger provides a clear and interactive way to understand API endpoints, request structures, headers, and payload formats, while cURL offers a direct, executable representation of the HTTP request.<\/p>\n
By translating the cURL command into the REST API Task or JSON Source configuration, developers can confidently replicate API calls inside SSIS without guesswork. This approach ensures accuracy, reduces troubleshooting time, and provides a consistent workflow for handling GET, POST, PUT, DELETE operations, file uploads, and authentication scenarios.<\/p>\n
Download\u00a0SSIS PowerPack<\/a> today and see for yourself how easy it is to combine Swagger and ZappySys SSIS, enabling organizations to seamlessly integrate modern REST APIs into enterprise ETL processes and bridge the gap between cloud-based services and traditional SQL Server data platforms.<\/span><\/p>\n
<\/a>Still need help?<\/strong><\/span><\/p>\n
If the issue persists, please get in touch with our support team:<\/p>\n
- \n
- Live Chat:<\/strong>\u00a0Open the chat widget\u00a0(bottom right of this page)<\/em><\/li>\n
- Email:<\/strong>\u00a0support@zappysys.com<\/a><\/li>\n
- Support Center<\/strong>:\u00a0Support | ZappySys<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Introduction In this article, we’ll learn how to integrate a documented API in Swagger with SQL Server Integration Services (SSIS) using ZappySys PowerPack. Swagger enables us to visualize and test REST endpoints, while ZappySys SSIS provides advanced components for consuming APIs and transforming data in ETL processes. Steps Get the Swagger endpoints Before connecting from […]<\/p>\n","protected":false},"author":5,"featured_media":11712,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,16,17,8,10,9],"tags":[],"yoast_head":"\r\n
SSIS tutorial: How to connect to Swagger | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS tutorial: How to connect to Swagger | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-02-20T00:11:27+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-03-02T15:16:22+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"594\" \/>\r\n\t<meta property=\"og:image:height\" content=\"547\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\",\"name\":\"SSIS tutorial: How to connect to Swagger | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"datePublished\":\"2026-02-20T00:11:27+00:00\",\"dateModified\":\"2026-03-02T15:16:22+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to connect to Swagger - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png\",\"width\":594,\"height\":547,\"caption\":\"Swagger - Pet category\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to connect to Swagger\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","og_description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","og_site_name":"ZappySys Blog","article_published_time":"2026-02-20T00:11:27+00:00","article_modified_time":"2026-03-02T15:16:22+00:00","og_image":[{"width":594,"height":547,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/","name":"SSIS tutorial: How to connect to Swagger | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","datePublished":"2026-02-20T00:11:27+00:00","dateModified":"2026-03-02T15:16:22+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to connect to Swagger - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Swagger-Pet-category.png","width":594,"height":547,"caption":"Swagger - Pet category"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-to-swagger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to connect to Swagger"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=11710"}],"version-history":[{"count":14,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710\/revisions"}],"predecessor-version":[{"id":11753,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11710\/revisions\/11753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11712"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - Email:<\/strong>\u00a0support@zappysys.com<\/a><\/li>\n
- Live Chat:<\/strong>\u00a0Open the chat widget\u00a0(bottom right of this page)<\/em><\/li>\n
- Generate the CURL to delete the pet\n
- Generate the CURL\n
- We generate the CURL\n
- Specify the full file path (e.g.,\u00a0file=@D:\\Zappysys\\new.jpg<\/em>).<\/li>\n
- Generate the CURL code.\n
- After the project is created, locate the\u00a0SSIS Toolbox<\/strong>\u00a0on the left panel.<\/li>\n
- From the list, we can see multiple endpoints and HTTP methods, including GET<\/strong>,\u00a0POST<\/strong>,\u00a0PUT<\/strong>, and\u00a0DELETE.<\/strong><\/li>\n