{"id":12327,"date":"2026-07-09T15:34:25","date_gmt":"2026-07-09T15:34:25","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12327"},"modified":"2026-07-22T14:05:19","modified_gmt":"2026-07-22T14:05:19","slug":"ssis-tutorial-how-to-get-data-from-airtable","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/","title":{"rendered":"SSIS Tutorial: How to get data from Airtable"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>Airtable is a cloud-based platform that combines spreadsheet simplicity with database capabilities. Teams use Airtable to manage projects, operations, CRM workflows, and content pipelines. Many organisations need Airtable data in SQL Server for reporting, analytics, and downstream data integration.<\/p>\n

In this tutorial, you will learn how to connect to Airtable 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

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, make sure the prerequisites are met:\r\n
    \r\n \t
  1. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  2. Make sure the SSIS designer<\/a> is installed.<\/li>\r\n \t
  3. Download and install ZappySys SSIS PowerPack<\/a>.<\/li>\r\n<\/ol>\r\nNOTE:<\/strong> If you are planning to deploy packages to a server and schedule their execution later, read this article<\/a>.<\/div>\n

    <\/p>\n

    Steps<\/h2>\n

    Get Airtable Personal Access Token<\/h3>\n
      \n
    1. Sign in to your Airtable account<\/a>.<\/li>\n
    2. Go to your developer hub<\/a>\u00a0and create a Personal Access Token<\/strong>.<\/li>\n
    3. Grant scopes required for reading records (for example, data.records:read<\/code> and schema.bases:read<\/code> based on your use case).<\/li>\n
    4. Allow access to the target base(s) and securely copy the token.\n
      \"\"<\/a>

      Airtable – Create a token<\/p><\/div><\/li>\n<\/ol>\n

      Get Airtable Base ID and Table ID<\/h3>\n
        \n
      1. Open the target table in Airtable.<\/li>\n
      2. Copy the Base ID and Table ID from the URL or API documentation page<\/a>.<\/li>\n
      3. Keep these IDs handy because you will use them in the API URL, for example:
        \nhttps:\/\/api.airtable.com\/v0\/{BASE_ID}\/{TABLE_ID}<\/code><\/li>\n<\/ol>\n

        Create an HTTP Connection in SSIS<\/h3>\n
          \n
        1. Create or open your SSIS project and package.<\/li>\n
        2. In Connection Managers<\/strong>, right-click and select New Connection…<\/strong>.<\/li>\n
        3. Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
        4. Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
        5. Paste your Airtable token in the token value field.<\/li>\n
        6. Click OK<\/strong> to save the connection.\n
          \"\"<\/a>

          Airtable –\u00a0 Connection configuration<\/p><\/div><\/li>\n<\/ol>\n

          Create and Configure JSON Source<\/h3>\n
            \n
          1. In your SSIS package, navigate to the Variables section and create the following variables:\n
              \n
            1. BaseID<\/strong>(String) \u2014 Enter the Base ID.<\/li>\n
            2. TableID<\/strong> (String) \u2014 Enter the Table ID.<\/li>\n<\/ol>\n<\/li>\n
            3. Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n
            4. In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
            5. Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
            6. Select the Airtable HTTP connection you created earlier.<\/li>\n
            7. Set the API URL. Example to extract records from a table:\n
              https:\/\/api.airtable.com\/v0\/{{User::BaseID}}\/{{User::TableID}}<\/pre>\n<\/li>\n
            8. Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
            9. Set JSON Path Filter<\/strong> to:\n
              $.records[*]<\/pre>\n<\/li>\n
            10. Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
              \"\"<\/a>
              Airtable – JSON Source configuration<\/p><\/div><\/li>\n<\/ol>\n
              Configure Destination Component<\/h3>\n
                \n
              1. Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
              2. Connect the output arrow from JSON Source to the destination component.<\/li>\n
              3. Configure your SQL Server connection and target table.<\/li>\n
              4. Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
              5. Map the source columns to destination columns in the Mappings<\/strong> section.\n
              6. Click OK<\/strong> and execute the package.<\/li>\n
              7. Validate that Airtable rows have been loaded into your SQL Server table.\n
                \"\"<\/a>
                Airtable – Upsert Destination example<\/p><\/div><\/li>\n<\/ol>\n
                <\/p>\n
                Conclusion<\/h2>\n
                You now have a working SSIS integration to extract Airtable data using ZappySys SSIS PowerPack and Airtable APIs. With this pattern, you can automate extraction of operational records into SQL Server for reporting and analytics.<\/p>\n
                Explore the full capabilities of the 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
                Need Help?<\/h3>
                If you encounter any issues, our support team is here to help:<\/p>\r\n\r\n
                  \r\n \t
                1. Live Chat:<\/strong>\u00a0Open the chat widget\u00a0(bottom right of this page)<\/em><\/li>\r\n \t
                2. Email:<\/strong>\u00a0support@zappysys.com<\/a><\/li>\r\n \t
                3. Support Center:<\/strong>\u00a0Support | ZappySys<\/a><\/li>\r\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"
                  Introduction Airtable is a cloud-based platform that combines spreadsheet simplicity with database capabilities. Teams use Airtable to manage projects, operations, CRM workflows, and content pipelines. Many organisations need Airtable data in SQL Server for reporting, analytics, and downstream data integration. In this tutorial, you will learn how to connect to Airtable APIs using SQL Server […]<\/p>\n","protected":false},"author":5,"featured_media":12328,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,444],"tags":[637,3,12],"yoast_head":"\r\nSSIS Tutorial: How to get data from Airtable | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS Tutorial: How to get data from Airtable - 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-airtable\/\" \/>\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 Airtable | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS Tutorial: How to get data from Airtable - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-07-09T15:34:25+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-07-22T14:05:19+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"447\" \/>\r\n\t<meta property=\"og:image:height\" content=\"447\" \/>\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-airtable\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/\",\"name\":\"SSIS Tutorial: How to get data from Airtable | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\",\"datePublished\":\"2026-07-09T15:34:25+00:00\",\"dateModified\":\"2026-07-22T14:05:19+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS Tutorial: How to get data from Airtable - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png\",\"width\":447,\"height\":447},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#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 Airtable\"}]},{\"@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 Airtable | ZappySys Blog","description":"SSIS Tutorial: How to get data from Airtable - 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-airtable\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Tutorial: How to get data from Airtable | ZappySys Blog","og_description":"SSIS Tutorial: How to get data from Airtable - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/","og_site_name":"ZappySys Blog","article_published_time":"2026-07-09T15:34:25+00:00","article_modified_time":"2026-07-22T14:05:19+00:00","og_image":[{"width":447,"height":447,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-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-airtable\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/","name":"SSIS Tutorial: How to get data from Airtable | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","datePublished":"2026-07-09T15:34:25+00:00","dateModified":"2026-07-22T14:05:19+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS Tutorial: How to get data from Airtable - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Airtable-logo.png","width":447,"height":447},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-airtable\/#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 Airtable"}]},{"@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\/12327"}],"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=12327"}],"version-history":[{"count":10,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12327\/revisions"}],"predecessor-version":[{"id":12371,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12327\/revisions\/12371"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12328"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}