{"id":12409,"date":"2026-08-20T22:10:44","date_gmt":"2026-08-20T22:10:44","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12409"},"modified":"2026-08-20T22:10:44","modified_gmt":"2026-08-20T22:10:44","slug":"ssis-tutorial-how-to-get-data-from-spotify","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/","title":{"rendered":"SSIS Tutorial: How to get data from Spotify"},"content":{"rendered":"<p><!-- Introduction --><\/p>\n<h2>Introduction<\/h2>\n<p class=\"intro-text\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12416  alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-150x150.png\" alt=\"\" width=\"106\" height=\"106\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-300x300.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo-768x769.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png 939w\" sizes=\"(max-width: 106px) 100vw, 106px\" \/><\/a>Spotify provides rich music and podcast metadata through its Web API, including artists, albums, tracks, playlists, and categories. Many data teams need this data in SQL Server for analytics, trend reporting, and catalog enrichment.<\/p>\n<p class=\"intro-text\">In this tutorial, you will learn how to connect Spotify API data to SQL Server Integration Services (SSIS) by using ZappySys SSIS PowerPack. This approach helps you automate extraction and loading without building a custom API client.<\/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>Create a Spotify Developer App<\/h3>\n<ol>\n<li>Go to the <a href=\"https:\/\/developer.spotify.com\/dashboard\" target=\"_blank\" rel=\"noopener\">Spotify Developer Dashboard<\/a> and sign in with any free or premium Spotify account.\n<div id=\"attachment_12414\" style=\"width: 1688px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12414\" class=\"size-full wp-image-12414\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app.png\" alt=\"\" width=\"1678\" height=\"599\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app.png 1678w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-300x107.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-1024x366.png 1024w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-768x274.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-Create-app-1536x548.png 1536w\" sizes=\"(max-width: 1678px) 100vw, 1678px\" \/><\/a><p id=\"caption-attachment-12414\" class=\"wp-caption-text\">Spotify &#8211; Create app<\/p><\/div><\/li>\n<li>Click <strong>Create app<\/strong>, give it a name, description, and a Redirect URI (for example <code>http:\/\/127.0.0.1:3000<\/code>).<\/li>\n<li>Go to the app <strong>Settings<\/strong> page and copy your <strong>Client ID<\/strong> and <strong>Client Secret<\/strong>.<\/li>\n<li>Store both values securely and avoid hard-coding secrets directly in package components.<\/li>\n<\/ol>\n<h3>Create an OAuth2 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 choose <strong>New Connection&#8230;<\/strong>.<\/li>\n<li>Select <strong>ZS-OAUTH<\/strong> from the SSIS connectors list.\n<div id=\"attachment_11825\" style=\"width: 959px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11825\" class=\"size-full wp-image-11825\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\" alt=\"\" width=\"949\" height=\"447\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png 949w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-300x141.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-768x362.png 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/a><p id=\"caption-attachment-11825\" class=\"wp-caption-text\">Create a new SSIS OAuth API Connection Manager<\/p><\/div><\/li>\n<li>Set the following values:\n<ul>\n<li><strong>OAuth Provider:<\/strong> Custom<\/li>\n<li><strong>OAuth Version:<\/strong> OAuth2<\/li>\n<li><strong>OAuth Grant Type:<\/strong> Client Credentials Grant<\/li>\n<li><strong>Client ID:<\/strong> Your Spotify Client ID<\/li>\n<li><strong>Client Secret:<\/strong> Your Spotify Client Secret<\/li>\n<li><strong>Access Token URL:<\/strong> <code>https:\/\/accounts.spotify.com\/api\/token<\/code><\/li>\n<li><strong>Scopes\/Permissions:<\/strong> (leave empty)<\/li>\n<\/ul>\n<\/li>\n<li>Click <strong>Test Connection<\/strong> to confirm a token is issued successfully, then click <strong>OK<\/strong>.\n<div id=\"attachment_12417\" style=\"width: 713px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-OAuth-connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12417\" class=\"size-full wp-image-12417\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-OAuth-connection.png\" alt=\"\" width=\"703\" height=\"765\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-OAuth-connection.png 703w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-OAuth-connection-276x300.png 276w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><p id=\"caption-attachment-12417\" class=\"wp-caption-text\">Spotify &#8211; OAuth connection<\/p><\/div><\/li>\n<\/ol>\n<h3>Create and Configure JSON Source<\/h3>\n<ol>\n<li>Add a <strong>Data Flow Task<\/strong> in <strong>Control Flow<\/strong> and open it.\n<div id=\"attachment_11784\" style=\"width: 485px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11784\" class=\"size-full wp-image-11784\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\" alt=\"\" width=\"475\" height=\"178\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png 475w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow-300x112.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/a><p id=\"caption-attachment-11784\" class=\"wp-caption-text\">Drag and drop Data flow<\/p><\/div><\/li>\n<li>In <strong>Data Flow<\/strong>, drag and drop <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\"><strong>ZS JSON Source<\/strong><\/a>.\n<div id=\"attachment_11533\" style=\"width: 553px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11533\" class=\"size-full wp-image-11533\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\" alt=\"\" width=\"543\" height=\"146\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png 543w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag-300x81.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><p id=\"caption-attachment-11533\" class=\"wp-caption-text\">SSIS JSON Source &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Open the JSON Source editor and enable <strong>Use credentials<\/strong>.<\/li>\n<li>Select the Spotify OAuth2 connection you created.<\/li>\n<li>Set the API URL to a Spotify endpoint. Example to search artists by genre:\n<pre class=\"lang:default decode:true\">https:\/\/api.spotify.com\/v1\/search?q=genre:pop&amp;type=artist&amp;limit=50<\/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<ul>\n<li><strong>Accept:<\/strong> application\/json<\/li>\n<\/ul>\n<\/li>\n<li>Set <strong>JSON Path Filter<\/strong> based on the endpoint. For the search artists endpoint:\n<pre class=\"lang:default decode:true\">$.artists.items[*]<\/pre>\n<\/li>\n<li>Click <strong>Preview<\/strong> to confirm rows are returned, then click <strong>OK<\/strong>.\n<div id=\"attachment_12415\" style=\"width: 1004px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-JSON-source.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12415\" class=\"size-full wp-image-12415\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-JSON-source.png\" alt=\"\" width=\"994\" height=\"824\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-JSON-source.png 994w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-JSON-source-300x249.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-JSON-source-768x637.png 768w\" sizes=\"(max-width: 994px) 100vw, 994px\" \/><\/a><p id=\"caption-attachment-12415\" class=\"wp-caption-text\">Spotify &#8211; JSON source<\/p><\/div><\/li>\n<\/ol>\n<h3>Configure Destination and Load into SQL Server<\/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\">Spotify &#8211; Upsert destination<\/p><\/div><\/li>\n<li>Click <strong>OK<\/strong> and execute the package.<\/li>\n<li>Validate that Spotify 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\">Spotify &#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 practical SSIS pattern to extract Spotify Web API data and load it into SQL Server by using ZappySys SSIS PowerPack. With OAuth2 Client Credentials authentication, pagination handling, and proper column mapping, you can operationalize Spotify catalog data for BI and reporting use cases.<\/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 extend this pipeline with transformations, audits, error handling, and SQL Server Agent scheduling.<\/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 Spotify provides rich music and podcast metadata through its Web API, including artists, albums, tracks, playlists, and categories. Many data teams need this data in SQL Server for analytics, trend reporting, and catalog enrichment. In this tutorial, you will learn how to connect Spotify API data to SQL Server Integration Services (SSIS) by using [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":12416,"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 Spotify | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS Tutorial: How to get data from Spotify - 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-spotify\/\" \/>\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 Spotify | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS Tutorial: How to get data from Spotify - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-08-20T22:10:44+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"939\" \/>\r\n\t<meta property=\"og:image:height\" content=\"940\" \/>\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=\"5 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-spotify\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/\",\"name\":\"SSIS Tutorial: How to get data from Spotify | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\",\"datePublished\":\"2026-08-20T22:10:44+00:00\",\"dateModified\":\"2026-08-20T22:10:44+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS Tutorial: How to get data from Spotify - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png\",\"width\":939,\"height\":940},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#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 Spotify\"}]},{\"@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 Spotify | ZappySys Blog","description":"SSIS Tutorial: How to get data from Spotify - 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-spotify\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Tutorial: How to get data from Spotify | ZappySys Blog","og_description":"SSIS Tutorial: How to get data from Spotify - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/","og_site_name":"ZappySys Blog","article_published_time":"2026-08-20T22:10:44+00:00","og_image":[{"width":939,"height":940,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/","name":"SSIS Tutorial: How to get data from Spotify | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","datePublished":"2026-08-20T22:10:44+00:00","dateModified":"2026-08-20T22:10:44+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS Tutorial: How to get data from Spotify - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Spoify-logo.png","width":939,"height":940},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-spotify\/#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 Spotify"}]},{"@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\/12409"}],"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=12409"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12409\/revisions"}],"predecessor-version":[{"id":12419,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12409\/revisions\/12419"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12416"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}