{"id":884,"date":"2016-11-10T19:35:43","date_gmt":"2016-11-10T19:35:43","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=884"},"modified":"2025-11-06T21:21:16","modified_gmt":"2025-11-06T21:21:16","slug":"using-ssis-curl-syntax-to-ssis-api-task","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/","title":{"rendered":"Convert CURL to SSIS PowerPack \/ ODBC for API Call"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>Often, REST API documentation uses example syntax for the curl<\/strong><\/a> command-line tool<\/a> because it’s one of the most popular tools for making API calls.<\/span>\u00a0However, suppose you are an SSIS developer using ZappySys API Drivers<\/strong>\/Connectors from either the SSIS PowerPack or the ODBC PowerPack.<\/span>\u00a0In that case,<\/span> this blog post will help you translate the\u00a0curl command line<\/strong> syntax to similar options available in the ZappySys Product.<\/span> For SSIS PowerPack products, you can refer to Connectors\/Tasks such as ZappySys REST API Task<\/a> \/ JSON Source Connector<\/a> \/ XML Source<\/a>. To make this article short and simple, we will show many screenshots from SSIS PowerPack UI, but the concepts are the same when you use other products, such as ODBC PowerPack JSON Driver \/ REST<\/a>\u00a0 or\u00a0XML Driver<\/a>.<\/p>\n

 <\/p>\n

If you are using Postman<\/strong><\/a> to call the API, then refer to this article<\/a><\/p>\n

If you are using Fiddler<\/strong><\/a> to call an API, then refer to this article<\/a><\/p>\n

<\/h2>\n

CheatSheet – Curl to SSIS PowerPack \/ ODBC PowerPack<\/h2>\n

Before we dig down more. Let’s look at how each command-line parameter from CURL<\/a> maps to SSIS PowerPack settings.<\/p>\n

\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n
CURL Parameter (Short \/ Long)<\/th>\nPurpose<\/th>\nSSIS PowerPack Setting<\/th>\n<\/tr>\n
method<\/em><\/td>\nPass HTTP method (e.g., GET, POST, PUT, DELETE)<\/td>\nSelect Method<\/strong> from Request Method Dropdown on\u00a0 ZappySys REST API Task<\/a> or JSON Source Connector<\/a>, or XML Source<\/a>, like this<\/a><\/td>\n<\/tr>\n
-u<\/strong>\u00a0userid:password,\u00a0<\/em>–user<\/strong><\/a>\u00a0userid:password\u00a0<\/em><\/td>\nAuthenticate using Basic Authentication using UserID and Password<\/td>\nUse the HTTP Connection Manager to enable Basic Auth,\u00a0the<\/a>n supply the username\u00a0and password.<\/span><\/td>\n<\/tr>\n
-H<\/strong> “name: value”,\u00a0<\/em>–header<\/strong><\/a>\u00a0“name: value”\u00a0<\/em><\/td>\nSupply HTTP Header(s)<\/td>\nClick on the Raw Edit option or enter key-value pairs of HTTP headers in the Headers grid\u00a0 like this<\/a><\/td>\n<\/tr>\n
-d<\/strong>\u00a0“key=value”,\u00a0\u00a0<\/em>–data<\/strong><\/a>\u00a0“key=value”
\n<\/em><\/td>\n		Supply BODY parameters using\u00a0www-form-urlencoded Content Type<\/td>\nClick Edit next to the Request Data text box and supply Body. If you need to pass content in JSON \/ XML, then select the Request ContentType dropdown like this<\/a><\/td>\n<\/tr>\n
-d<\/strong>\u00a0“some data”,<\/em> \u00a0<\/em>–data<\/strong><\/a>\u00a0“some data”
\n<\/em>-d<\/strong>\u00a0@filepath,<\/em> \u00a0<\/em>–data<\/strong><\/a>\u00a0@filepath
\n<\/em><\/td>\n		Supply BODY parameters using Content-Type other than www-form-urlencoded. You can also supply content from a file.<\/td>\nClick Edit next to the Request Data text box and supply Body. If you need to pass content in JSON \/ XML, select the Request ContentType dropdown as shown.\u00a0To upload content stored from a local file,\u00a0use this option<\/a>.<\/td>\n<\/tr>\n
-F<\/strong> key=value<\/em>, –form<\/strong><\/a> key=value<\/td>\nSupply Content-Type multipart\/form-data according to\u00a0RFC 2388<\/a><\/td>\nEnable the Multipart option for Request on the ZappySys UI, like this<\/a><\/td>\n<\/tr>\n
-k<\/strong>, –insecure<\/strong><\/a><\/td>\nIgnore SSL Certificate-related errors (e.g., allow expired certificate or untrusted certificate)<\/td>\nGo to the Advanced Tab and check the ” ignore SSL Related Errors option\u00a0like this<\/a>.<\/span><\/td>\n<\/tr>\n
-x<\/strong>, –proxy<\/strong><\/a> [protocol:\/\/]host[:port]<\/em><\/td>\nSpecify Proxy Settings<\/td>\nYou can enable System default proxy or a custom proxy using the Proxy Tab in the OAuth \/ HTTP Connection Manager. Check this<\/a>.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Convert Curl Syntax to SSIS PowerPack – REST API Task \/\u00a0JSON \/ XML Connector<\/h2>\n

Take a look at the following example of CURL <\/strong>syntax<\/p>\n

curl POST -u myusername:mypassword -H \"Accept: application\/json\" -H \"AppVersion:1.0\" \"https:\/\/mysite\/v1\/api\/customers\/\" -d \"customerid=AAA&OrderDate=2016-01-01\"<\/pre>\n
Where :<\/strong><\/p>\n
-u<\/span>\u00a0 or –user<\/span>\u00a0 = UserID and Password for server (This option sends credentials in BASIC Authentication mode)
\n-H<\/span>\u00a0 or –header<\/span>\u00a0 = HTTP Header (e.g. Key: Value)
\n-d<\/span>\u00a0 or –data<\/span>\u00a0 = Data for POST<\/p>\n
For step-by-step information, check Article Learn how to POST data to a URL using SSIS<\/a><\/p>\n
Here is the screenshot of HTTP POST in JSON format using the ZappySys REST API Task<\/a><\/p>\n
\"\"<\/a>
Convert CURL Command Line Syntax to SSIS – Perform HTTP POST operation using SSIS REST API Task – Send data in JSON content type<\/p><\/div>\n
If you wish to POST data and parse the JSON response into rows, you can use the SSIS JSON Source<\/a>. JSON Source has a powerful JSON Parser that parses large JSON (stored in a file, an API URL, or a Direct string) into Rows and Columns. This is useful if you wish to save the response into a target such as SQL Server or a CSV file.<\/p>\n
\"\"<\/a>
JSON Source example<\/p><\/div>\n
HTTP Headers – Convert Curl Syntax to SSIS<\/h3>\n
Set up HTTP headers in ZappySys Task\/Connect, or click on Raw Edit or Add\/Edit items in Grid.<\/p>\n
HTTP Credentials – Convert Curl Syntax to SSIS<\/h3>\n
Here is how you pass credentials in the curl command line.<\/p>\n
curl.exe https:\/\/myserver.com\/api -u myusername:mypassword<\/pre>\n
To setup HTTP credentials in SSIS for Basic \/ NTFS or Kerberos use HTTP Connection Manager (Access Mode must be changed to Url from Connection on ZappySys REST API Task<\/a>\u00a0and for JSON Source Connector<\/a> or XML Source<\/a>\u00a0 check Use Connection Option)<\/p>\n
If you have OAuth 2.0 Credentials (Application ID, Application Secret) then use SSIS OAuth Connection Manager<\/a> rather than HTTP Connection<\/a><\/p>\n
Check this article to\u00a0learn about how to pass HTTP Basic Credentials in SSIS PowerPack<\/a><\/p>\n
Proxy Setting – Convert Curl Syntax to SSIS<\/h3>\n
Here is how you pass Proxy server info in cUrl command line (-x<\/span>\u00a0 along with Proxy Server Host\/IP and Port)<\/p>\n
curl.exe -x 192.168.2.1:8888 https:\/\/myserver.com\/api<\/pre>\n
Convert Curl Syntax to SSIS –\u00a0Client Certificate Settings<\/h2>\n
\n
HTTP Connection Manager UI<\/h3>\n
\"HTTP<\/p>\n<\/div>\n
\n
Passing client certificate along with Web request (i.e. pfx\/pkcs12\/p12)<\/h3>\n
\"Passing<\/p>\n<\/div>\n
\n
Passing client certificate from file path (i.e. pfx\/pkcs12\/p12)<\/h3>\n
\"\"<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Introduction Often, REST API documentation uses example syntax for the curl command-line tool because it’s one of the most popular tools for making API calls.\u00a0However, suppose you are an SSIS developer using ZappySys API Drivers\/Connectors from either the SSIS PowerPack or the ODBC PowerPack.\u00a0In that case, this blog post will help you translate the\u00a0curl command […]<\/p>\n","protected":false},"author":1,"featured_media":1897,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[124,123,562,12,148,4,144,140],"yoast_head":"\r\nConvert CURL to SSIS PowerPack \/ ODBC for API Call | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to use curl like functionality in SSIS without coding. Convert curl syntax to SSIS for REST API, SOAP, OAuth and OData using JSON \/ XML Source\" \/>\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\/using-ssis-curl-syntax-to-ssis-api-task\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Convert CURL to SSIS PowerPack \/ ODBC for API Call | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to use curl like functionality in SSIS without coding. Convert curl syntax to SSIS for REST API, SOAP, OAuth and OData using JSON \/ XML Source\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-11-10T19:35:43+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-11-06T21:21:16+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"180\" \/>\r\n\t<meta property=\"og:image:height\" content=\"180\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/\",\"url\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/\",\"name\":\"Convert CURL to SSIS PowerPack \/ ODBC for API Call | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png\",\"datePublished\":\"2016-11-10T19:35:43+00:00\",\"dateModified\":\"2025-11-06T21:21:16+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to use curl like functionality in SSIS without coding. Convert curl syntax to SSIS for REST API, SOAP, OAuth and OData using JSON \/ XML Source\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png\",\"width\":180,\"height\":180},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert CURL to SSIS PowerPack \/ ODBC for API Call\"}]},{\"@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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert CURL to SSIS PowerPack \/ ODBC for API Call | ZappySys Blog","description":"Learn how to use curl like functionality in SSIS without coding. Convert curl syntax to SSIS for REST API, SOAP, OAuth and OData using JSON \/ XML Source","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\/using-ssis-curl-syntax-to-ssis-api-task\/","og_locale":"en_US","og_type":"article","og_title":"Convert CURL to SSIS PowerPack \/ ODBC for API Call | ZappySys Blog","og_description":"Learn how to use curl like functionality in SSIS without coding. Convert curl syntax to SSIS for REST API, SOAP, OAuth and OData using JSON \/ XML Source","og_url":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-11-10T19:35:43+00:00","article_modified_time":"2025-11-06T21:21:16+00:00","og_image":[{"width":180,"height":180,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/","url":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/","name":"Convert CURL to SSIS PowerPack \/ ODBC for API Call | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png","datePublished":"2016-11-10T19:35:43+00:00","dateModified":"2025-11-06T21:21:16+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to use curl like functionality in SSIS without coding. Convert curl syntax to SSIS for REST API, SOAP, OAuth and OData using JSON \/ XML Source","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-tip.png","width":180,"height":180},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/using-ssis-curl-syntax-to-ssis-api-task\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Convert CURL to SSIS PowerPack \/ ODBC for API Call"}]},{"@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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/884"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=884"}],"version-history":[{"count":23,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":11609,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions\/11609"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1897"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}