{"id":233,"date":"2016-01-04T18:02:01","date_gmt":"2016-01-04T18:02:01","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=233"},"modified":"2025-03-18T13:48:11","modified_gmt":"2025-03-18T13:48:11","slug":"call-zendesk-rest-api-ssis-create-ticket-example","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/","title":{"rendered":"Call Zendesk REST API in SSIS – Create Ticket"},"content":{"rendered":"

Introduction<\/h2>\n
UPDATE:<\/strong>\u00a0ZappySys has released a brand new API Connector for Zendesk Online<\/a> which makes it much simpler to\u00a0Read\/Write Zendesk Data in SSIS<\/strong> compared to the steps listed in this article. You can still use steps from this article but if you are new to API or want to avoid learning curve with API then use newer approach.<\/p>\n

Please visit this page to see all<\/a>\u00a0Pre-Configured ready to use API connectors which you can use in SSIS API Source<\/a> \/ SSIS API Destination<\/a> OR\u00a0API ODBC Driver<\/a> (for non-SSIS Apps such as Excel, Power BI, Informatica).<\/p>\n<\/div><\/div>\n

Zendesk<\/a> is one the most popular customer service platforms available in the market today. Zendesk offers REST API<\/a> so you can interact with their cloud based service programmatically (manage or read data). The problem is not every one is programmer and not everyone has time to learn how to write C# or JAVA code to access REST API.<\/p>\n

In this article you will learn how to use SSIS REST API Task<\/a> to interact with Zendesk or similar type of services in few clicks. In this post we will show example of create new zendesk ticket(s) but you can any operation supported by Zendesk REST API.<\/p>\n

Also check our another article on How to extract Zendesk data in SSIS using REST API<\/a><\/p>\n

Different methods for Zendesk REST API Access<\/h2>\n

Zendesk allows you to access three different ways so you can access their data.<\/p>\n

    \n
  1. REST API access using Basic Authentication (Use userid (e.g. email) and password)<\/li>\n
  2. REST API access using API Token<\/li>\n
  3. REST API access using OAuth Access Token<\/li>\n<\/ol>\n

    Each method has pros and cons. First method is easy to use but requires to use your account password. Second method is also easy to use but requires additional step to create access token. Third method is most secure but it has several extra steps compared to first and second methods.<\/p>\n

    In this article we will only show you second and third method (Using API Access Token).<\/p>\n

    Zendesk API Access using OAuth<\/h2>\n

    To read about OAuth Method click here<\/a><\/p>\n

    Create API Access Token<\/h2>\n
      \n
    1. Login to your account https:\/\/{{your-subdomain}}.zendesk.com\/login and then click on setting icon<\/li>\n
    2. On the next page click on API link<\/li>\n
    3. On API page scroll to API Access Tokens section. Make sure Token Access<\/strong> method is checked.<\/li>\n
    4. Click on add new token hyper link. once prompted give some name to your token (this is just label)<\/li>\n
    5. Once above steps done token should be created and listed under your API Access page. This token will be used as your password to access REST API (Will show in the next section)<\/li>\n<\/ol>\n
      \"Create<\/a>

      Create new Zendesk REST API Access Token<\/p><\/div>\n

      \"Create<\/a>

      Create SSIS HTTP connection to access Zendesk REST API using Token method<\/p><\/div>\n

      \"Configure<\/a>

      Configure SSIS REST API Task to create new Zendesk ticket request using POST method<\/p><\/div>\n

      \"Run<\/a>

      Run SSIS Package – Call Zendesk REST API Example<\/p><\/div>\n

      \"Verify<\/a>

      Verify tickets created from SSIS using Zendesk REST API Call<\/p><\/div>\n

      Conclusion<\/h2>\n

      In this post you saw how easy it is to call Zendesk REST API using SSIS REST API Task. Click here to Download<\/a> and try it yourself.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Introduction Zendesk is one the most popular customer service platforms available in the market today. Zendesk offers REST API so you can interact with their cloud based service programmatically (manage or read data). The problem is not every one is programmer and not everyone has time to learn how to write C# or JAVA code […]<\/p>\n","protected":false},"author":1,"featured_media":239,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[6,60,3,12,4,50],"yoast_head":"\r\nCall Zendesk REST API in SSIS - Create Ticket | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to call Zendesk REST API in SSIS using drag and drop approach. Step by step example of creating new Zendesk Ticket using RESTful API approach.\" \/>\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\/call-zendesk-rest-api-ssis-create-ticket-example\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Call Zendesk REST API in SSIS - Create Ticket | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to call Zendesk REST API in SSIS using drag and drop approach. Step by step example of creating new Zendesk Ticket using RESTful API approach.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/\" \/>\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-01-04T18:02:01+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-03-18T13:48:11+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1060\" \/>\r\n\t<meta property=\"og:image:height\" content=\"531\" \/>\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=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/\",\"url\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/\",\"name\":\"Call Zendesk REST API in SSIS - Create Ticket | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png\",\"datePublished\":\"2016-01-04T18:02:01+00:00\",\"dateModified\":\"2025-03-18T13:48:11+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to call Zendesk REST API in SSIS using drag and drop approach. Step by step example of creating new Zendesk Ticket using RESTful API approach.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png\",\"width\":1060,\"height\":531,\"caption\":\"Create new Zendesk REST API Access Token\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Call Zendesk REST API in SSIS – Create Ticket\"}]},{\"@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":"Call Zendesk REST API in SSIS - Create Ticket | ZappySys Blog","description":"Learn how to call Zendesk REST API in SSIS using drag and drop approach. Step by step example of creating new Zendesk Ticket using RESTful API approach.","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\/call-zendesk-rest-api-ssis-create-ticket-example\/","og_locale":"en_US","og_type":"article","og_title":"Call Zendesk REST API in SSIS - Create Ticket | ZappySys Blog","og_description":"Learn how to call Zendesk REST API in SSIS using drag and drop approach. Step by step example of creating new Zendesk Ticket using RESTful API approach.","og_url":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-01-04T18:02:01+00:00","article_modified_time":"2025-03-18T13:48:11+00:00","og_image":[{"width":1060,"height":531,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/","url":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/","name":"Call Zendesk REST API in SSIS - Create Ticket | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png","datePublished":"2016-01-04T18:02:01+00:00","dateModified":"2025-03-18T13:48:11+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to call Zendesk REST API in SSIS using drag and drop approach. Step by step example of creating new Zendesk Ticket using RESTful API approach.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/create-zendesk-rest-api-access-token.png","width":1060,"height":531,"caption":"Create new Zendesk REST API Access Token"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/call-zendesk-rest-api-ssis-create-ticket-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Call Zendesk REST API in SSIS – Create Ticket"}]},{"@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\/233"}],"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=233"}],"version-history":[{"count":5,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/233\/revisions"}],"predecessor-version":[{"id":11237,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/233\/revisions\/11237"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/239"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}