{"id":12350,"date":"2026-07-24T12:01:10","date_gmt":"2026-07-24T12:01:10","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12350"},"modified":"2026-07-24T12:10:36","modified_gmt":"2026-07-24T12:10:36","slug":"ssis-tutorial-how-to-get-data-from-cin7","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/","title":{"rendered":"SSIS Tutorial: How to get data from Cin7"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p class=\"intro-text\"><a href=\"https:\/\/www.cin7.com\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/cin7-logo.png\" alt=\"Cin7\" width=\"110\" height=\"110\" \/><\/a>Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across multiple sales channels. Many organisations need Cin7 data in SQL Server for reporting, demand planning, fulfilment tracking, and analytics.<\/p>\n<p class=\"intro-text\">In this tutorial, you will learn how to connect to Cin7 REST APIs using SQL Server Integration Services (SSIS) with the ZappySys SSIS PowerPack. This approach helps you build repeatable ETL pipelines without writing custom API integration code.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-2523\"><h2><span id=\"Prerequisites\">Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, make sure the prerequisites are met:\r\n<ol style=\"margin-left: 1.5em;\">\r\n \t<li>Basic knowledge of SSIS package\u00a0development using\u00a0<em>Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t<li>Make sure the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssdt\/download-sql-server-data-tools-ssdt\">SSIS designer<\/a> is installed.<\/li>\r\n \t<li>Download and install <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\">ZappySys SSIS PowerPack<\/a>.<\/li>\r\n<\/ol>\r\n<strong>NOTE:<\/strong> If you are planning to deploy packages to a server and schedule their execution later, <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/360035974593\" target=\"_blank\" rel=\"noopener\">read this article<\/a>.<\/div>\n<p><!-- Steps --><\/p>\n<h2>Steps<\/h2>\n<h3>Get Cin7 API Credentials<\/h3>\n<ol>\n<li>Sign in to your <a href=\"https:\/\/go.cin7.com\/cloud\/apiSetup\">Cin7 account<\/a>.<\/li>\n<li>Open <strong>Settings \u2192 Integrations &amp; API \u2192 API v1<\/strong> in your Cin7 admin portal.\n<ul>\n<li>Note your <strong>API Username<\/strong> shown on the page.<\/li>\n<li>Click <strong>Add New API Connection<\/strong>, give it a name (e.g. ZappySys), and copy the generated <strong>API Key<\/strong>.<\/li>\n<\/ul>\n<div id=\"attachment_12374\" style=\"width: 1002px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12374\" class=\"size-full wp-image-12374\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token.png\" alt=\"\" width=\"992\" height=\"436\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token.png 992w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token-300x132.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token-768x338.png 768w\" sizes=\"(max-width: 992px) 100vw, 992px\" \/><\/a><p id=\"caption-attachment-12374\" class=\"wp-caption-text\">Cin7 &#8211; Generate new API connection<\/p><\/div><\/li>\n<li>Store both values securely \u2014 the <strong>API Username<\/strong> and <strong>API Key<\/strong> together act as your login credentials.\n<div id=\"attachment_12375\" style=\"width: 685px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12375\" class=\"size-full wp-image-12375\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token.png\" alt=\"\" width=\"675\" height=\"327\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token.png 675w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token-300x145.png 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/a><p id=\"caption-attachment-12375\" class=\"wp-caption-text\">Cin7 &#8211; API credentials<\/p><\/div><\/li>\n<\/ol>\n<h3>Get Cin7 Base URL and Endpoint Path<\/h3>\n<ol>\n<li>Identify the REST endpoint you want to query (for example, products, customers, or sales orders).<\/li>\n<li>Keep your API base URL and endpoint path ready for SSIS configuration.<\/li>\n<li>Example:<br \/>\n<code>https:\/\/api.cin7.com\/api\/v1\/Products<\/code><\/li>\n<\/ol>\n<h3>Create an HTTP Connection in SSIS<\/h3>\n<ol>\n<li>Create or open your SSIS project and package.<\/li>\n<li>In <strong>Connection Managers<\/strong>, right-click and select <strong>New Connection&#8230;<\/strong>.<\/li>\n<li>Select <strong>ZS-HTTP<\/strong> from the SSIS connectors list.<\/li>\n<li>Set <strong>Credentials Type<\/strong> to <strong>Basic Auth<\/strong>.<\/li>\n<li>Enter your <strong>API Username<\/strong> in the Username field and your <strong>API Key<\/strong> in the Password field<\/li>\n<li>Click <strong>OK<\/strong> to save the connection.\n<div id=\"attachment_12376\" style=\"width: 738px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-HTTP-connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12376\" class=\"size-full wp-image-12376\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-HTTP-connection.png\" alt=\"\" width=\"728\" height=\"555\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-HTTP-connection.png 728w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-HTTP-connection-300x229.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><p id=\"caption-attachment-12376\" class=\"wp-caption-text\">Cin7-HTTP connection<\/p><\/div><\/li>\n<\/ol>\n<h3>Create and Configure JSON Source<\/h3>\n<ol>\n<li>Drag a <strong>Data Flow Task<\/strong> into <strong>Control Flow<\/strong> and open it.<\/li>\n<li>In <strong>Data Flow<\/strong>, drag and drop the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\"><strong>ZS JSON Source<\/strong><\/a>.<\/li>\n<li>Open the JSON Source editor and enable <strong>Use credentials<\/strong>.<\/li>\n<li>Select the Cin7 HTTP connection you created earlier.<\/li>\n<li>Set the API URL. Example to extract products:\n<pre class=\"lang:default decode:true\">https:\/\/api.cin7.com\/api\/v1\/products<\/pre>\n<\/li>\n<li>Set <strong>HTTP Request Method<\/strong> to <strong>GET<\/strong>.<\/li>\n<li>Add the following <strong>HTTP Header<\/strong>:\n<ol style=\"list-style-type: lower-alpha;\">\n<li><strong>Accept:<\/strong> application\/json<\/li>\n<\/ol>\n<\/li>\n<li>Set <strong>JSON Path Filter<\/strong> based on the endpoint (for example, <code>$.Products[*]<\/code> for the Products endpoint).<\/li>\n<li>Click <strong>Preview<\/strong> to confirm rows are returned, then click <strong>OK<\/strong>.\n<div id=\"attachment_12377\" style=\"width: 1013px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Source-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12377\" class=\"size-full wp-image-12377\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Source-configuration.png\" alt=\"\" width=\"1003\" height=\"873\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Source-configuration.png 1003w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Source-configuration-300x261.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Source-configuration-768x668.png 768w\" sizes=\"(max-width: 1003px) 100vw, 1003px\" \/><\/a><p id=\"caption-attachment-12377\" class=\"wp-caption-text\">Cin7 &#8211; JSON Source configuration<\/p><\/div>\n<div class=\"mceTemp\"><\/div>\n<\/li>\n<\/ol>\n<h3>Configure Destination Component<\/h3>\n<ol>\n<li>Add an <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-upsert-destination\/\" target=\"_blank\" rel=\"noopener\"><strong>Upsert destination<\/strong><\/a> (or another destination of your choice, such as a <strong>Trash destination<\/strong> or <strong>JSON\/CSV\/XML destination<\/strong>).<\/li>\n<li>Connect the output arrow from JSON Source to the destination component.<\/li>\n<li>Configure your SQL Server connection and target table.<\/li>\n<li>Check the options you want to use: <strong>Insert<\/strong> or\/and <strong>Update<\/strong>.<\/li>\n<li>Map the source columns to destination columns in the <strong>Mappings<\/strong> section.\n<div id=\"attachment_11912\" style=\"width: 968px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11912\" class=\"wp-image-11912 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\" alt=\"\" width=\"958\" height=\"645\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png 958w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-300x202.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-768x517.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-272x182.png 272w\" sizes=\"(max-width: 958px) 100vw, 958px\" \/><\/a><p id=\"caption-attachment-11912\" class=\"wp-caption-text\">Cin7 &#8211; Upsert destination<\/p><\/div><\/li>\n<li>Click <strong>OK<\/strong> and execute the package.<\/li>\n<li>Validate that Cin7 rows have been loaded into your SQL Server table.\n<div id=\"attachment_12241\" style=\"width: 345px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12241\" class=\"size-full wp-image-12241\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example.png\" alt=\"\" width=\"335\" height=\"236\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example.png 335w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example-300x211.png 300w\" sizes=\"(max-width: 335px) 100vw, 335px\" \/><\/a><p id=\"caption-attachment-12241\" class=\"wp-caption-text\">Cin7 &#8211; Upsert Destination example<\/p><\/div><\/li>\n<\/ol>\n<p><!-- Conclusion --><\/p>\n<h2>Conclusion<\/h2>\n<p class=\"intro-text\">You now have a working SSIS integration to extract Cin7 data using ZappySys SSIS PowerPack and Cin7 REST APIs. With this pattern, you can automate extraction of inventory, product, and order data into SQL Server for reporting and analytics.<\/p>\n<p class=\"intro-text\">Explore the full capabilities of the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a> to optimise your data integration tasks. By applying this pattern, you can extend your solution to include transformations, data validation, error handling, and scheduling through SQL Server Agent.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-12354\"><h3>Need Help?<\/h3><p class=\"section-intro\">If you encounter any issues, our support team is here to help:<\/p>\r\n\r\n<ol>\r\n \t<li><strong>Live Chat:<\/strong>\u00a0Open the chat widget\u00a0<em>(bottom right of this page)<\/em><\/li>\r\n \t<li><strong>Email:<\/strong>\u00a0<a href=\"mailto:support@zappysys.com\">support@zappysys.com<\/a><\/li>\r\n \t<li><strong>Support Center:<\/strong>\u00a0<a href=\"https:\/\/zappysys.com\/support\/\">Support | ZappySys<\/a><\/li>\r\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across multiple sales channels. Many organisations need Cin7 data in SQL Server for reporting, demand planning, fulfilment tracking, and analytics. In this tutorial, you will learn how to connect to Cin7 REST APIs [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":12372,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS Tutorial: How to get data from Cin7 | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS Tutorial: How to get data from Cin7 - 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-get-data-from-cin7\/\" \/>\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 get data from Cin7 | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS Tutorial: How to get data from Cin7 - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-07-24T12:01:10+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-07-24T12:10:36+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"225\" \/>\r\n\t<meta property=\"og:image:height\" content=\"225\" \/>\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=\"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\/ssis-tutorial-how-to-get-data-from-cin7\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/\",\"name\":\"SSIS Tutorial: How to get data from Cin7 | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\",\"datePublished\":\"2026-07-24T12:01:10+00:00\",\"dateModified\":\"2026-07-24T12:10:36+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS Tutorial: How to get data from Cin7 - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\",\"width\":225,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Tutorial: How to get data from Cin7\"}]},{\"@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 get data from Cin7 | ZappySys Blog","description":"SSIS Tutorial: How to get data from Cin7 - 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-get-data-from-cin7\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Tutorial: How to get data from Cin7 | ZappySys Blog","og_description":"SSIS Tutorial: How to get data from Cin7 - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/","og_site_name":"ZappySys Blog","article_published_time":"2026-07-24T12:01:10+00:00","article_modified_time":"2026-07-24T12:10:36+00:00","og_image":[{"width":225,"height":225,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/","name":"SSIS Tutorial: How to get data from Cin7 | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","datePublished":"2026-07-24T12:01:10+00:00","dateModified":"2026-07-24T12:10:36+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS Tutorial: How to get data from Cin7 - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","width":225,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-cin7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Tutorial: How to get data from Cin7"}]},{"@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\/12350"}],"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=12350"}],"version-history":[{"count":4,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12350\/revisions"}],"predecessor-version":[{"id":12383,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12350\/revisions\/12383"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12372"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}