{"id":823,"date":"2016-10-15T02:00:27","date_gmt":"2016-10-15T02:00:27","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=823"},"modified":"2025-04-07T12:55:56","modified_gmt":"2025-04-07T12:55:56","slug":"call-semantics3-rest-api-in-ssis-use-oauth1","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/","title":{"rendered":"Call Semantics3 REST API in SSIS use OAuth1"},"content":{"rendered":"

Introduction<\/h2>\n

In this post you will learn how to call\u00a0Sementics3<\/a> REST API<\/em> using SSIS PowerPack<\/a>.<\/p>\n

Using drag and drop approach you can consume data from\u00a0Semantics3 REST API service.<\/em> In this post we will use\u00a0ZappySys\u00a0JSON Source<\/a> to read data from Amazon MWS API and load into SQL Server. We will also use REST API Task<\/a> to call any API from Marketplace Web service and save output into Variable.<\/p>\n

Assumption<\/h2>\n

This post assumes following things<\/p>\n

    \n
  1. You have basic knowledge of SSIS and\u00a0JSON format.<\/li>\n
  2. You have registered for Semantics3 API Access. If not then it takes\u00a0less than 5 minutes to register for free here<\/a>\u00a0to get started.<\/li>\n
  3. You have tested few API calls using Semantics3 REST API Playground<\/a>\u00a0this will give you idea about various API you can call and parameters you need to pass.<\/li>\n<\/ol>\n

    Step-By-Step – Call\u00a0Semantics3 REST API using SSIS<\/h2>\n

    To consume data from any\u00a0JSON Source (File or REST API) you can use \u00a0ZappySys\u00a0JSON Source.<\/a>\u00a0or REST API Task.<\/a>\u00a0In below example you will see how to call\u00a0Semantics3 REST API and save output into SSIS Variable.\u00a0With this approach you can call any API\u00a0(GET \/ POST \/ DELETE \/ PUT)<\/p>\n

      \n
    1. Download and Install SSIS PowerPack<\/li>\n
    2. Create test package<\/li>\n
    3. From SSIS toolbox drag ZS REST API Task<\/a>\u00a0 and double click on the task to configure it<\/li>\n
    4. Select Request URL Access Mode = [Url from Connection]<\/li>\n
    5. Enter URL as below\n
      https:\/\/api.semantics3.com\/v1\/products?q=%7b%22search%22%3a%22iphone%22%7d<\/pre>\n
      In above URL
      \n**\u00a0q=%7b%22search%22%3a%22iphone%22%7d => This is your search query in URL encoded format.\u00a0Data without URL encode may look like this q={“search” : “iphone” }
      \n** If you have stored query in plain text (not encoded) in SSIS variable then you can use URLENC format specifier like this q={{User::varQ,URLENC}} . This will automatically encode data for you.<\/li>\n
    6. In Select Url Connection dropdown select New OAUTH connection option.<\/li>\n
    7. When prompted on OAuth connection UI select Provider=Custom, Enter ApiKey (i.e. Client ID) and Secret (i.e. Client Secret). If you not sure what is this then check your Developer console > Applications Tab. Select OAuth1 from Version dropdown.\n
    8. Click OK to save UI. Do not click test because it may not work yet.<\/li>\n
    9. Now click Test and see content in the Preview window.\n
    10. If you wish to save response data into SSIS variable then goto response Tab and check save option and select variable name.<\/li>\n<\/ol>\n
      Load\u00a0Semantics3 data into SQL Server using SSIS (REST API Call)<\/h2>\n
      In this section we will see how to use ZappySys\u00a0JSON Source<\/a>\u00a0to read data from Semantics3\u00a0REST API\u00a0and load into SQL Server<\/p>\n
      For making things simple we are calling<\/p>\n
        \n
      1. Download and Install SSIS PowerPack<\/li>\n
      2. Create test package<\/li>\n
      3. From SSIS toolbox drag Data Flow task and double click task to go to Data Flow designer<\/li>\n
      4. Drag ZS\u00a0JSON Source<\/a> from SSIS Toolbox<\/li>\n
      5. Configure\u00a0JSON Source as below. You can use Select Filter option to select hierarchy (JSON Array). Then click Preview to see data.\n
      6. Drag OLEDB destination from SSIS Toolbox.<\/li>\n
      7. Connect\u00a0JSON Source to OLEDB Destination and map input column to target table<\/li>\n
      8. Execute dataflow to load Semantics3 Data into SQL Server (or any destination such as File, Oracle, MySQL)\n
        \"Read<\/a>
        Read from Semantics3 REST API Call – Load into SQL Server using SSIS<\/p><\/div><\/li>\n<\/ol>\n
        Conclusion<\/h2>\n
        Semantics3 API provides great way to automate many functionality for searching and ordering millions of products into your custom App. Using ZappySys SSIS PowerPack<\/a> you can consume data\u00a0from any REST API or Web service without replying on SDK \/ coding approach (e.g. C#, Java, Python, Ruby).<\/p>\n","protected":false},"excerpt":{"rendered":"
        Introduction In this post you will learn how to call\u00a0Sementics3 REST API using SSIS PowerPack. Using drag and drop approach you can consume data from\u00a0Semantics3 REST API service. In this post we will use\u00a0ZappySys\u00a0JSON Source to read data from Amazon MWS API and load into SQL Server. We will also use REST API Task to […]<\/p>\n","protected":false},"author":1,"featured_media":840,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,10],"tags":[6,60,153,3,152,12,148,4,144],"yoast_head":"\r\nCall Semantics3 REST API in SSIS use OAuth1 | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to get data from Semantics3 REST API. Call Semantics3 REST API using SSIS REST API Task and JSON Source. Load data into SQL Server in few clicks.\" \/>\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-semantics3-rest-api-in-ssis-use-oauth1\/\" \/>\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 Semantics3 REST API in SSIS use OAuth1 | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to get data from Semantics3 REST API. Call Semantics3 REST API using SSIS REST API Task and JSON Source. Load data into SQL Server in few clicks.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/\" \/>\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-10-15T02:00:27+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-04-07T12:55:56+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"675\" \/>\r\n\t<meta property=\"og:image:height\" content=\"491\" \/>\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-semantics3-rest-api-in-ssis-use-oauth1\/\",\"url\":\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/\",\"name\":\"Call Semantics3 REST API in SSIS use OAuth1 | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png\",\"datePublished\":\"2016-10-15T02:00:27+00:00\",\"dateModified\":\"2025-04-07T12:55:56+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to get data from Semantics3 REST API. Call Semantics3 REST API using SSIS REST API Task and JSON Source. Load data into SQL Server in few clicks.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png\",\"width\":675,\"height\":491,\"caption\":\"Semantics3 API Call using SSIS OAuth1 Connection Manager\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Call Semantics3 REST API in SSIS use OAuth1\"}]},{\"@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 Semantics3 REST API in SSIS use OAuth1 | ZappySys Blog","description":"Learn how to get data from Semantics3 REST API. Call Semantics3 REST API using SSIS REST API Task and JSON Source. Load data into SQL Server in few clicks.","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-semantics3-rest-api-in-ssis-use-oauth1\/","og_locale":"en_US","og_type":"article","og_title":"Call Semantics3 REST API in SSIS use OAuth1 | ZappySys Blog","og_description":"Learn how to get data from Semantics3 REST API. Call Semantics3 REST API using SSIS REST API Task and JSON Source. Load data into SQL Server in few clicks.","og_url":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-10-15T02:00:27+00:00","article_modified_time":"2025-04-07T12:55:56+00:00","og_image":[{"width":675,"height":491,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.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-semantics3-rest-api-in-ssis-use-oauth1\/","url":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/","name":"Call Semantics3 REST API in SSIS use OAuth1 | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png","datePublished":"2016-10-15T02:00:27+00:00","dateModified":"2025-04-07T12:55:56+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to get data from Semantics3 REST API. Call Semantics3 REST API using SSIS REST API Task and JSON Source. Load data into SQL Server in few clicks.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/ssis-oauth-1-connection-manager-semantics3-rest-api-call.png","width":675,"height":491,"caption":"Semantics3 API Call using SSIS OAuth1 Connection Manager"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/call-semantics3-rest-api-in-ssis-use-oauth1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Call Semantics3 REST API in SSIS use OAuth1"}]},{"@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\/823"}],"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=823"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/823\/revisions"}],"predecessor-version":[{"id":11338,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/823\/revisions\/11338"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/840"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}