{"id":2515,"date":"2018-01-24T18:57:41","date_gmt":"2018-01-24T18:57:41","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2515"},"modified":"2025-04-07T13:05:01","modified_gmt":"2025-04-07T13:05:01","slug":"how-to-import-export-data-zuora-api-using-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/","title":{"rendered":"How to Import \/ Export data from Zuora API using SSIS"},"content":{"rendered":"

\"zuora-api-integration-logo\"<\/p>\n

Introduction<\/h2>\n

In this post, we will learn how to call Zuora API using SSIS.\u00a0 We will go through steps to read data from Zuora and load into SQL Server using \u00a0SSIS REST API Task<\/a>\u00a0 and\u00a0\u00a0SSIS JSON Source<\/a>\u00a0. At the end of this article, you will find a complete sample (dtsx file).<\/p>\n

 <\/p>\n

Tasks\/Components in SSIS\u00a0for Consuming RESTful API \/ WebService<\/span><\/h2>\n

Below are few components you can use to read\/write data using REST API for any web service.<\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n
\"Custom<\/td>\nJSON Source<\/a>\u00a0(Read from REST API, JSON File or OData Service): Use this dataflow component when you have to\u00a0fetch data from REST API webservice like a table<\/strong>. This component allows you to extract JSON data from webservice and de-normalize nested structure so you can save to Relational database such as SQL Server or any other target (Oracle, FlatFile, Excel, MySQL). This component also supports reading local JSON files or direct JSON string (Wildcard pattern supported too e.g. c:\\data\\file*.json).<\/td>\n<\/tr>\n
\"SSIS<\/td>\nWeb API Destination<\/a>\u00a0(POST data to API URL) : Use this dataflow component when you have to load data into target system via API calls (POST to URL<\/a>). E.g. Loading Contacts into Marketing System like\u00a0MailChimp<\/a>\u00a0for email campaign. Loading documents into CRM or document storage systems e.g. Couchbase or\u00a0ElasticSearch<\/a>.<\/td>\n<\/tr>\n
\"Custom<\/td>\nREST API Task<\/a>\u00a0: Use this task when you don\u2019t want to pull REST API data in tabular format but want to call\u00a0rest API for POST data to server, DELETE data from server or things like download HTML page, extract Authentication tokens etc where you not necessarily dealing data in tabular format. This task also allows you many other options such as saving RAW response into variable or file.<\/td>\n<\/tr>\n
\"Custom<\/td>\nXML\u00a0Source<\/a>\u00a0(SOAP, File, REST) : Use this dataflow component when you have to fetch data from XML or SOAP webservice and consume data like a table. This component allows you to extract data from webservice and save to SQL Server or any other target (Oracle, FlatFile, Excel, MySQL).\u00a0This component also supports reading local XML files or direct XML string.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

 <\/p>\n

Screenshot of Complete SSIS Package (Zuora to SQL Server)<\/span><\/h2>\n

Here is screenshot of our full process (we going to outline in next sections)<\/p>\n

\"SSIS<\/a>

SSIS Zuora API Integration – Read\/Write Data (Load Zuora Data to SQL Server Table)<\/p><\/div>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    Step-By-Step : Using SSIS JSON Source \/ REST API Task to read Zuora API\u00a0<\/span><\/h2>\n

    Zuora API is somewhat different than other APIs we documented here<\/a>\u00a0because Zuora API uses very different Pagination Technique. Some common pagination techniques listed\u00a0here<\/a>\u00a0but it’s not used by Zuora API so we have to do few extra steps.<\/p>\n

    Let’s look at step by step.<\/p>\n

    NOTE: Zuora API requires TLS 1.1 or Higher so make sure on all tasks \/ components \/ connection manager for zuora API is set to use TLS 1.1 or Higher<\/strong> (This setting is usually found on Advanced tab<\/strong> of OAuth Connection Manager \/ REST API Task \/ Web API Destination \/ JSON Source \/ XML Source. Click Here for more information<\/a>.<\/div><\/div>\n

    Configure Zuora OAuth Connection<\/h3>\n

    The first step to connect to Zuora API is to configure\u00a0 the OAuth App (Ask your Zuora Admin or Follow Steps listed here<\/a>). Once you create Oauth App get ClientId and ClientSecret.<\/p>\n

    Now let’s create new SSIS<\/p>\n

      \n
    1. Right click in the Connection Manager Panel > Click New Connection…<\/li>\n
    2. Select ZS-OAUTH from the list<\/li>\n
    3. Configure OAuth Connection as below\n
        \n
      1. Set OAuth Version OAuth2<\/span><\/li>\n
      2. Set OAuth Grant Type to Client Credentials Grant<\/span><\/li>\n
      3. Enter Client ID and Client Secret<\/li>\n
      4. For Token URL enter URL https:\/\/rest.zuora.com\/oauth\/token<\/span><\/li>\n
      5. Goto Advanced Tab. Select SSL\/TLS Protocol v3.0 or Higher<\/span><\/li>\n<\/ol>\n<\/li>\n
      6. Click Test (Confirm Green Checkmark)<\/li>\n
      7. Click OK to Save<\/li>\n<\/ol>\n
        \"SSIS<\/a>

        SSIS OAuth Connection For Zuora API<\/p><\/div>\n

         <\/p>\n

        Configure Variables<\/h3>\n

        Now lets configure few SSIS variables.<\/p>\n

        \"SSIS<\/a>

        SSIS Variables for Zuora API Integration<\/p><\/div>\n

        \n\n\n\n\n\n\n\n\n\n\n
        Name<\/th>\nValue<\/th>\nExpression<\/th>\n<\/tr>\n
        url\u00a0 (String) Expression<\/strong><\/td>\n— blank —<\/td>\n\n
        @counter > 0 \r\n   ? \"https:\/\/rest.zuora.com\/v1\/action\/queryMore\" \r\n   : \"https:\/\/rest.zuora.com\/v1\/action\/query\"<\/pre>\n<\/td>\n<\/tr>\n
        bodyString\u00a0 (String)<\/td>\n\n
        {\"queryString\": \"SELECT Id,Name,AccountNumber,Status FROM Account\"}<\/pre>\n
         <\/td>\n
        		<\/td>\n<\/tr>\n
        continue (Boolean)<\/td>\nTrue<\/td>\n<\/td>\n<\/tr>\n
        doneFlag (Boolean)<\/td>\nFalse<\/td>\n<\/td>\n<\/tr>\n
        queryLocator (String)<\/td>\n— blank —<\/td>\n<\/td>\n<\/tr>\n
        responseFile (String)<\/td>\nc:\\ssis\\dump.json<\/td>\n<\/td>\n<\/tr>\n
        counter (Int32)<\/td>\n0<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

         <\/p>\n

        Configure API Pagination<\/h3>\n

        Now let’s configure For Loop such a way that it keeps looping until @continue flag is True<\/p>\n

          \n
        1. Drag For Loop Task from SSIS Toolbox<\/li>\n
        2. Configure as below\n
            \n
          1. Enter EvalExpression as @continue==true<\/span><\/li>\n
          2. Enter AssignExpression as @counter=@counter+1<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
            \"Configure<\/a>

            Configure API Pagination using For Loop Task<\/p><\/div>\n

            Configure API Call using SSIS REST API Task<\/h3>\n

            Now let’s configure REST API Task to make a call to get data from Zuora API and save JSON response into File (which we will parse in next step)<\/p>\n

            So if we making the first request will call API via https:\/\/rest.zuora.com\/v1\/action\/query<\/span>\u00a0 \u00a0and any call after that (2nd response or Higher) we will call https:\/\/rest.zuora.com\/v1\/action\/queryMore<\/span>\u00a0. This API uses SQL like query language ZOQL. Click here to learn more about ZOQL<\/a><\/p>\n

            This is controlled by Expression we defined in URL variable.<\/p>\n

            \"Configure<\/a>

            Configure SSIS REST API Task – Call Zuora Query API (ZOQL – SQL Query)<\/p><\/div>\n

            \"Configure<\/a>

            Configure SSIS REST API Response Settings – Save Zuora Query to JSON File<\/p><\/div>\n

            Configure Data Flow (Read Zuora Data and Load into SQL Server Table)<\/h3>\n

            We will skip this configuration on how to read JSON file and Save to SQL Server. Because it will be covered in next section.<\/p>\n

            Inside Data Flow when you configure ZS JSON Source<\/p>\n

            Make sure to set Filter to\u00a0$.records[*]\n

            Parse Pagination Attributes (done flag, queryLocator for next page)<\/h3>\n

            Once that done you can parse the response from saved File. We need to check for 2 attributes (done and queryLocator ). Parse JSON as below.<\/p>\n

            \"SSIS<\/a>

            SSIS JSON Parser Task –
            Parse Multiple Fields from JSON FIle and Save to Variable<\/p><\/div>\n

            Detect Last Page (Set Variables)<\/h3>\n

            Drag two Set Expression Tasks from SSIS Toolbox.<\/p>\n

            For First Task [Set Continue Flag] Enter Expression as\u00a0@continue=!@doneFlag<\/span><\/p>\n

            For First Task [Set Query Locator ] Enter Expression as\u00a0@[User::bodyString]=”{ \\”queryLocator\\” : \\”” + @[User::queryLocator] + “\\” }”<\/span><\/p>\n

            Save and execute Package<\/h3>\n

            That’s all now you can save package and execute. Check Progress.<\/p>\n

            Debug Web API call using Fiddler<\/span><\/h2>\r\nTo test how things looking behind the scene we strongly suggest to use\u00a0tool like\u00a0 fiddler<\/a>.\r\n\r\nYou can double click the URL entry (Right side) to see Request and Response Panels. Top panel is Request (URL, Headers, Body) and Bottom Panel is Response.\r\n
            \r\n\r\n\"Debugging<\/a>\r\n

            Debugging Web API call using Fiddler in SSIS<\/p>\r\n\r\n<\/div>\r\n

            Loading\u00a0data from\u00a0<\/span>REST API to SQL Server<\/span><\/h2>\r\nOnce you setup HTTP \/ OAUTH connection we can use JSON Source<\/strong> or XML Source<\/strong> to extract data from API and\u00a0 load into SQL Server. If you are API is XML based API then use XML Source in below examples else use JSON Source.\r\n\r\nFor example purpose we will load data into SQL Server but you can load into any Target (e.g. Flat file, Oracle, Excel) using Microsoft or ZappySys Destination connectors\r\n\r\nTo load REST API data into SQL Server perform the following steps (Screenshots are generic<\/strong> and used for demonstration for purpose, your values can be different<\/strong> than below)\r\n
              \r\n \t
            1. Go to SSIS Data Flow tab<\/li>\r\n \t
            2. Drag ZS JSON Source<\/a> from the SSIS Toolbox (Use ZS XML Source<\/a> if your API is XML based API)<\/li>\r\n \t
            3. Double click to edit Source<\/li>\r\n \t
            4. Set API URL you like to call, Check Use Credentials if you need to use HTTP or OAuth connection<\/li>\r\n \t
            5. Set Method \/ Body if its other than GET. For method other than GET make sure you select correct Content-Type<\/strong> from Dropdown (e.g. application\/json<\/strong>). This indicate input data format in Body.<\/li>\r\n \t
            6. Set HTTP Headers<\/strong> if needed (in Most cases you won't need to set this)<\/li>\r\n \t
            7. Select Filter (many times this is not needed). If your API response has array node then select it here. For example if your response looks like this { rows: [ {...}, {...}, {...} ] }<\/strong> then filter would be $.rows[*]<\/strong>. Select Array node you like to extract in the Filter selection UI.\r\n\r\n\"\"<\/a><\/li>\r\n \t
            8. Configure Pagination<\/a> if needed on the pagination tab. Check your API documentation see it supports pagination.<\/li>\r\n \t
            9. Click OK to Save component settings and generate desired metadata \/ columns for the output<\/a>.<\/li>\r\n \t
            10. Now drag OLEDB destination<\/strong>\u00a0from the SSIS toolbox and drop on the Data Flow surface (technically you can use any valid Destination but for demo we will use OLEDB Destination)<\/li>\r\n \t
            11. Connect Source to Destination Component<\/li>\r\n \t
            12. On OLEDB destination select \/ create new SQL Connection and then Click \"New Table<\/strong>\"<\/li>\r\n \t
            13. Click on Mappings tab<\/strong>\u00a0to map columns by names and click OK to save<\/li>\r\n \t
            14. Execute the Package<\/li>\r\n<\/ol>\r\n
              \r\n\r\n\"Configure<\/a>\r\n

              Configure SSIS OLEDB Destination \u2013 Loading REST API Data into SQL Server Table<\/p>\r\n\r\n<\/div>\r\n

              \r\n\r\n\"Xero<\/a>\r\n

              REST API to SQL Server Column Mappings for OLEDB Destination<\/p>\r\n\r\n<\/div>\r\n

              \r\n\r\n\"Loading<\/a>\r\n

              Loading REST API to SQL Server in SSIS<\/p>\r\n\r\n<\/div>\r\n

              POST \/ Write Data to API (Insert, Update or Delete)<\/span><\/h2>\r\nThere will be a time you like to automate POST actions (e.g. create new incident via API call).\u00a0Check this article<\/a>\u00a0to learn more on how to POST , DELETE, PUT data using API calls\r\n

              Common Errors<\/span><\/h2>\r\nThere are many error can occur during runtime. Here are most common errors you may face at runtime.\r\n
              \r\n

              Truncation related error<\/span><\/h3>\r\nThe most common error you may face when you run a SSIS package is truncation error. During the design time only 300 rows are scanned from a source (a file or a REST API call response) to detect datatypes but at runtime it is likely you will retrieve far more records. So it is possible that you will get longer strings than initially expected.\u00a0For detailed instructions how to fix common metadata related errors read an article \"How to handle SSIS errors (truncation, metadata issues)<\/a>\".\r\n

              Authentication related error<\/span><\/h3>\r\nAnother frequent error you may get is authentication error, which happens when you deploy\/copy a package to another machine and run it there. Check\u00a0Deployment to Production<\/a>\u00a0below to see why it happens and how to solve this problem.\r\n\r\n<\/div>\r\n

              Deployment to Production<\/span><\/h2>\r\n
              In SSIS package\u00a0sensitive data such as tokens and passwords are by default encrypted by SSIS<\/a>\u00a0with your Windows account which you use to create a package.\u00a0So SSIS will fail to decrypt tokens\/passwords, when you run it from another machine using another Windows account. To circumvent this when you are creating a SSIS package which uses authentication components (e.g. an\u00a0OAuth Connection Manager<\/a>\u00a0or an\u00a0HTTP Connection Manager<\/a>\u00a0with credentials, etc.), consider using parameters\/variables to pass tokens\/passwords. In this way you won\u2019t face authentication related errors when package is deployed to a production server. Check our article on\u00a0how to configure packages with sensitive data on your production or development server<\/a>.<\/div><\/div>\n

               <\/p>\n

              Download Sample SSIS Package\u00a0(2012 or Higher Version)<\/h2>\n

              Click here to download SSIS Sample Package – ZuoraApiPagination.dtsx<\/a><\/p>\n

              Conclusion.\u00a0What\u2019s next?<\/span><\/h2>\n

              In this article, we have learned how to load data from Zuora and load into SQL Server using SSIS ( drag and drop approach without coding). We used\u00a0SSIS JSON Source\/REST API<\/a>\u00a0to extract data from Zuora REST API using OAuth. JSON Source makes it super simple to parsing complex \/ large JSON Files or any Web API Response into rows and column so you can load into a database like SQL Server.\u00a0Download SSIS PowerPack<\/a>\u00a0to try many other automation scenarios not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"

              Introduction In this post, we will learn how to call Zuora API using SSIS.\u00a0 We will go through steps to read data from Zuora and load into SQL Server using \u00a0SSIS REST API Task\u00a0 and\u00a0\u00a0SSIS JSON Source\u00a0. At the end of this article, you will find a complete sample (dtsx file).   Tasks\/Components in SSIS\u00a0for […]<\/p>\n","protected":false},"author":1,"featured_media":2520,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,265,17,205,10],"tags":[60,160,3,12,72],"yoast_head":"\r\nHow to Import \/ Export data from Zuora API using SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to Import \/ Export data from Zuora API using SSIS - 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\/how-to-import-export-data-zuora-api-using-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Import \/ Export data from Zuora API using SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to Import \/ Export data from Zuora API using SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/\" \/>\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=\"2018-01-24T18:57:41+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-04-07T13:05:01+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"180\" \/>\r\n\t<meta property=\"og:image:height\" content=\"180\" \/>\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=\"8 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/\",\"name\":\"How to Import \/ Export data from Zuora API using SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png\",\"datePublished\":\"2018-01-24T18:57:41+00:00\",\"dateModified\":\"2025-04-07T13:05:01+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"How to Import \/ Export data from Zuora API using SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png\",\"width\":180,\"height\":180,\"caption\":\"zuora-api-integration-logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import \/ Export data from Zuora API using SSIS\"}]},{\"@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":"How to Import \/ Export data from Zuora API using SSIS | ZappySys Blog","description":"How to Import \/ Export data from Zuora API using SSIS - 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\/how-to-import-export-data-zuora-api-using-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to Import \/ Export data from Zuora API using SSIS | ZappySys Blog","og_description":"How to Import \/ Export data from Zuora API using SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-01-24T18:57:41+00:00","article_modified_time":"2025-04-07T13:05:01+00:00","og_image":[{"width":180,"height":180,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/","url":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/","name":"How to Import \/ Export data from Zuora API using SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png","datePublished":"2018-01-24T18:57:41+00:00","dateModified":"2025-04-07T13:05:01+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"How to Import \/ Export data from Zuora API using SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/01\/zuora-api-integration-logo.png","width":180,"height":180,"caption":"zuora-api-integration-logo"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-import-export-data-zuora-api-using-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Import \/ Export data from Zuora API using SSIS"}]},{"@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\/2515"}],"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=2515"}],"version-history":[{"count":13,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2515\/revisions"}],"predecessor-version":[{"id":11343,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2515\/revisions\/11343"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2520"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=2515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=2515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=2515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}