{"id":4747,"date":"2018-09-05T21:30:16","date_gmt":"2018-09-05T21:30:16","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4747"},"modified":"2024-06-30T20:14:48","modified_gmt":"2024-06-30T20:14:48","slug":"read-salesforce-marketing-cloud-data-ssis-exacttarget-api","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/","title":{"rendered":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API)"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In this post we will learn how to call Salesforce Marketing Cloud API using SSIS and load into SQL Server.\u00a0We will show you use case of\u00a0SSIS REST API Task<\/a>\u00a0 and\u00a0SSIS JSON Source<\/a><\/p>\n

Basically there are two steps to call Salesforce Marketing Cloud API<\/p>\n

    \n
  1. Obtain ClientID and ClientSecret (\u00a0Check these steps<\/a>\u00a0)<\/li>\n
  2. Get Access Token by calling\u00a0requestToken API call<\/a><\/li>\n
  3. Once you have token you can call any other API endpoints to read \/ edit \/ update Marketing Cloud data. You must supply Token inside Authorization Header along with each call.<\/li>\n<\/ol>\n
    NOTE: Salesforce Marketing Cloud is formally known as\u00a0ExactTarget<\/div><\/div>\n

    Requirements<\/span><\/h2>\n

    Before we look into Step-By-Step section to call Salesforce Marketing API (Exacttarget) make sure you met the\u00a0following requirements.<\/p>\n

      \n
    1. SSIS designer installed.\u00a0Sometimes it is referred as BIDS or SSDT (download it from Microsoft site<\/a>).<\/li>\n
    2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
    3. ZappySys SSIS PowerPack\u00a0installed<\/a>. Click on the link to download a FREE trial.<\/li>\n
    4. You have access to Salesforce Marketing Cloud and you have correct permission to create access key (or just ask Salesforce Admin to generate it for you\u00a0Check these steps<\/a>\u00a0)<\/li>\n<\/ol>\n

      Getting Started<\/h2>\n

      Now let’s look at step by step approach on how to read salesforce marketing data in SSIS.<\/p>\n

      Step-1 : Get Access Token for Salesforce Marketing Cloud API call<\/h3>\n

      First step is to get token for Marketing Cloud API calls. We have to\u00a0call this API<\/a>\u00a0to obtain token. This token typically lasts for one hour or so (3600 seconds).<\/p>\n

      Before we call below steps make sure you have obtained ClientID and ClientSecret (\u00a0Check these steps<\/a>\u00a0).<\/p>\n

        \n
      1. Download and\u00a0install SSIS PowerPack<\/a><\/li>\n
      2. Open SSIS Package<\/li>\n
      3. Drag\u00a0ZS REST API Task<\/a>\u00a0from the SSIS Toolbox on Control Flow designer.<\/li>\n
      4. Rename task to call it\u00a0Get Token<\/strong><\/li>\n
      5. Double click to edit as below.
        \nProduction URL:<\/strong><\/p>\n
        https:\/\/auth.exacttargetapis.com\/v1\/requestToken<\/code><\/pre>\n
        Sandbox URL:<\/p>\n
        https:\/\/auth-test.exacttargetapis.com\/v1\/requestToken<\/code><\/pre>\n
        \"Get
        Get API Token for Salesforce Marketing Cloud API calls<\/p><\/div><\/li>\n
      6. Go to response setting tab and change Response Type to JSON and set expression as\u00a0$.accessToken\u00a0<\/strong>, Check Save response and Select Variable\u00a0<New Variable><\/strong>\u00a0(e.g.\u00a0vToken<\/strong>)\n
        \"Configure
        Configure Response Tab – Extract API Token for Salesforce Marketing Cloud API calls<\/p><\/div><\/li>\n
      7. \u00a0Now Click Test Request\/Response to confirm you get token. Copy Token from Bottom panel and click OK to save UI<\/li>\n
      8. Now right click in designer and click “Variables” and paste Token we got in previous step in the Value (This token is good for one hour only so update if it expires). This manual update is only needed while you designing page… and testing data Preview \/ get metadata (see Next Section).\u00a0 When you run full package it will get fresh token each time and ignore Hardcoded token from Variable.<\/li>\n<\/ol>\n
        Step-2 : Read data from Salesforce Marketing Cloud API (SSIS JSON Source)<\/h3>\n
        Now once we have token extract step done. We can move to next step which is to read actual data from\u00a0Exacttarget API<\/strong>\u00a0(i.e. Salesforce Marketing Cloud API)<\/p>\n
        We will us\u00a0SSIS JSON Source<\/a>\u00a0to read data (JSON format) and save to SQL Server.<\/p>\n
          \n
        1. Drag data flow task from SSIS Toolbox and drop to control flow surface.<\/li>\n
        2. Rename Data flow to\u00a0Get Data\u00a0<\/strong>or\u00a0Call Data<\/strong><\/li>\n
        3. Connect first step (Get Token) to data flow<\/li>\n
        4. Double click task and from data flow toolbox drag \u00a0ZS JSON Source<\/a>\u00a0on the surface<\/li>\n
        5. Double click JSON Source and configure as below.<\/li>\n
        6. Click ON\u00a0Select Filter<\/strong>\u00a0Button and Select Correct filter… (Make sure select only Array Node icon to extract correct data)<\/li>\n
        7. Click Preview to confirm<\/li>\n
        8. Click OK to save<\/li>\n
        9. Connect JSON source to some target (e.g. OLEDB Destination for SQL Server)<\/li>\n
        10. Run your package<\/li>\n<\/ol>\n
          \"Read
          Read Salesforce Marketing Cloud data in SSIS and load into SQL Server (Using SSIS JSON Source)<\/p><\/div>\n
          Using HTTP Connection (New version – Single Step)<\/h2>\n
          If you are using a new version (with HTTP – Dynamic Token Support), then you can try the following option.<\/p>\n
            \n
          1. On JSON Source Check Use Credentials and choose HTTP connection.\n
          2. On the HTTP Connection, choose the following settings\n
              \n
            1. For URL enter https:\/\/auth.exacttargetapis.com\/hub\/v1\/campaigns\/<\/span><\/li>\n
            2. Choose Dynamic Token Auth<\/li>\n
            3. Enter Client ID (same as the previous section)<\/li>\n
            4. Enter Client Secret\u00a0 (same as the previous section)<\/li>\n
            5. Click the Configure Dynamic Token link\n
            6. \u00a0Now on the Dynamic Token Tab configure like below (Request Settings Tab<\/strong>)\n
                \n
              1. Make sure you are on Request Settings Tab<\/li>\n
              2. Enter token endpoint URL\n
                https:\/\/auth.exacttargetapis.com\/v1\/requestToken<\/pre>\n<\/li>\n
              3. Set Request Method (POST<\/strong>)<\/li>\n
              4. Select Content Type (application\/json<\/strong>)<\/li>\n
              5. Enter Body like below\n
                { clientId: \"[$userid$]\",clientSecret: \"<<[$password$],FUN_JSONENC>>\" }<\/pre>\n<\/li>\n
              6. Click on Response Settings Tab\n
              7. On the Response Settings Tab<\/strong> configure like below\n
                  \n
                1. Select Extract From Body<\/strong><\/li>\n
                2. Expression Type as Json<\/strong><\/li>\n
                3. Enter expression $.accessToken
                  \n<\/span><\/span><\/p>\n
                4. Click OK and you can preview your API data on JSON Source
                  \nExample: https:\/\/auth.exacttargetapis.com\/hub\/v1\/campaigns\/<\/li>\n
                5. If you use HTTP COnnection with Dynamic Token you do not need two step approach we did in the previous section<\/li>\n<\/ol>\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","protected":false},"excerpt":{"rendered":"
                    Introduction In this post we will learn how to call Salesforce Marketing Cloud API using SSIS and load into SQL Server.\u00a0We will show you use case of\u00a0SSIS REST API Task\u00a0 and\u00a0SSIS JSON Source Basically there are two steps to call Salesforce Marketing Cloud API Obtain ClientID and ClientSecret (\u00a0Check these steps\u00a0) Get Access Token by […]<\/p>\n","protected":false},"author":1,"featured_media":1764,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,17,10],"tags":[379,6,3,210,12],"yoast_head":"\r\nRead Salesforce Marketing Cloud data in SSIS (ExactTarget API) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) - 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\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/\" \/>\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-09-05T21:30:16+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2024-06-30T20:14:48+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.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=\"6 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/\",\"url\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/\",\"name\":\"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.png\",\"datePublished\":\"2018-09-05T21:30:16+00:00\",\"dateModified\":\"2024-06-30T20:14:48+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.png\",\"width\":180,\"height\":180},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API)\"}]},{\"@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":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) | ZappySys Blog","description":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) - 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\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/","og_locale":"en_US","og_type":"article","og_title":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) | ZappySys Blog","og_description":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-09-05T21:30:16+00:00","article_modified_time":"2024-06-30T20:14:48+00:00","og_image":[{"width":180,"height":180,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/","url":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/","name":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.png","datePublished":"2018-09-05T21:30:16+00:00","dateModified":"2024-06-30T20:14:48+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API) - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/09\/salesforce-logo-180x180.png","width":180,"height":180},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/read-salesforce-marketing-cloud-data-ssis-exacttarget-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Read Salesforce Marketing Cloud data in SSIS (ExactTarget API)"}]},{"@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\/4747"}],"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=4747"}],"version-history":[{"count":8,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4747\/revisions"}],"predecessor-version":[{"id":11122,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4747\/revisions\/11122"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1764"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=4747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=4747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=4747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}