{"id":2588,"date":"2018-02-07T23:27:38","date_gmt":"2018-02-07T23:27:38","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2588"},"modified":"2022-09-16T22:20:14","modified_gmt":"2022-09-16T22:20:14","slug":"read-write-smartsheet-data-using-ssis-rest-api-call","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/","title":{"rendered":"Read \/ Write Smartsheet data using SSIS REST API Call"},"content":{"rendered":"

Introduction<\/h2>\n

\"Smartsheet<\/a>In this post you will learn how to Read \/ write Smartsheet data using SSIS (Drag and drop approach without any coding).\u00a0 We will use SSIS JSON\/ REST API Source<\/a> to extract data from Smartsheet API and use SSIS Web API Destination<\/a> to write data to Smartsheet. This approach is similar to our previous blog where we described how to read and write Google sheet using SSIS<\/a><\/p>\n

Now let’s look at step by step approach to call Smartsheet REST API.<\/p>\n

 <\/p>\n

Prerequisites<\/span><\/h2>\n

Before we perform the steps listed in this article, you will need to make sure the following prerequisites are met:<\/p>\n

    \n
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven’t already).<\/li>\n
  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>\n<\/ol>\n<\/div>\n

    Create Token to access Smartsheet REST API<\/h2>\n

    First step to access smartsheet API in SSIS is create API Token. We will use this API token later on to read data from Smartsheet Sheet.<\/p>\n

      \n
    1. Login to your Smartsheet account<\/li>\n
    2. Click on Account > Apps & Integrations > Click API Access > Click Generate Token\n
    3. Once Token is generated copy that for later use (Make sure you treat this token as password and do not share with unauthorized user.<\/li>\n<\/ol>\n

       <\/p>\n

       <\/p>\n

      Getting started with Smartsheet API<\/h2>\n

      In this article we will use few out of many API provided by Smartsheet. To get started with Smartsheet API concepts click here<\/a>. To read full details about each Smartsheet API click here<\/a>.<\/p>\n

      Step-By-Step – Import\/Export Smartsheet data in SSIS<\/h2>\n

      Now lets see how to read and write smartsheet data using SSIS.<\/p>\n

      Read data from Smartsheet using SSIS JSON \/ REST API Source (Load Smartsheet to SQL Server)<\/h3>\n

      To read data from smartsheet you need to perform following steps.<\/p>\n

      Find Sheet ID for Smartsheet API access<\/strong><\/p>\n

        \n
      1. First you need to know how to find Sheet ID. Perform below steps to find Sheet ID.<\/li>\n
      2. Goto your portal and open sheet you like to read. Right click on the Sheet Tab > Click Properties and Copy Sheet ID\n
        \"Find<\/a>

        Find Sheet ID for Smartsheet API call<\/p><\/div><\/li>\n<\/ol>\n

        Once you know Sheet ID. Now lets create SSIS package to extract data from Smartsheet and load into SQL Server.<\/p>\n

          \n
        1. Create new SSIS Package or Open existing one.<\/li>\n
        2. From control flow SSIS toolbox drag Data Flow task<\/li>\n
        3. Double click Data flow<\/li>\n
        4. From SSIS Toolbox drag and drop ZS JSON Source (for REST API \/ File)<\/a><\/li>\n
        5. Double click JSON Source and configure following properties\n
            \n
          1. Enter Shartsheet API Access URL as below (Change last part with your own sheet id)\n
            https:\/\/api.smartsheet.com\/2.0\/sheets\/YOUR-SHEET-ID-GOES-HERE<\/pre>\n<\/li>\n
          2. Check use credentials and then create a new HTTP connection. Select Static Token \/ API Key and enter enter your token we got in previous section
            \n<\/li>\n
          3. Click on Select Filter and pick Rows node or just type below text in the Filter textbox\n
            $.rows[*]<\/pre>\n
            <\/li>\n
          4. Now goto 2D Array Transformation Tab and set following settings\n
              \n
            1. Set Transformation Type to Complex 2-dimensional array<\/strong><\/li>\n
            2. Column Name Filter to\u00a0$.columns[*].title<\/strong><\/li>\n
            3. Row Value Filter to\u00a0$.cells[*].value
              \n<\/strong><\/p>\n
            4. Once everything is configured Click Preview. Click OK to save.<\/li>\n
            5. Drag OLEDB Destination from SSIS Toolbox.<\/li>\n
            6. Connect JSON SOurce to OLEDB Destination<\/li>\n
            7. Double click OLEDB Destination and configure connection (e.g. Select SQL Server connection) and select Target Table or click New to Create new Table based on Source columns.<\/li>\n
            8. Click on Mappings to map source columns to target<\/li>\n
            9. Click OK to save<\/li>\n
            10. Execute Package\n
              \"SSIS<\/a>
              SSIS Example : Loading Smartsheet data into SQL Server (REST API Call)<\/p><\/div><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
               <\/p>\n
              Read Smartsheet data with Pagination option<\/h3>\n
              Smartsheet API support options to read large amount of data in small chunks by using pagination options<\/a>. ZappySys offers many ways to paginate<\/a>\u00a0for various API.<\/p>\n
              Disable Smartsheet Pagination<\/h4>\n
              Many API endpoints in Smartsheet by default send you paginated response. Pagination requires some extra configuration so try to disable it if possible by using\u00a0includeAll=true<\/strong>\u00a0option in your URL as below. If you cannot includeAll for some reason then perform steps listed in next section.<\/p>\n
              https:\/\/api.smartsheet.com\/2.0\/sheets?includeAll=true<\/pre>\n
              Smartsheet Pagination in SSIS<\/h4>\n
              To paginate Smartsheet response in SSIS JSON Source perform the following steps. Below steps assume that you trying to get all sheets by calling https:\/\/api.smartsheet.com\/2.0\/sheets<\/span>\u00a0\u00a0URL in JSON Source (Just like we explained in previous section). Before dataflow we have to add one step to enable pagination. Lets check.<\/p>\n
                \n
              1. Go to Control Flow designer right click > Select Variables<\/li>\n
              2. Create new string datatype<\/strong> variable called name it TotalPages<\/strong>. Set default value to 0<\/strong><\/li>\n
              3. Now drag ZS REST API Task<\/a> from SSIS Toolbox<\/li>\n
              4. Enter Following URL (we don’t need many rows to so reduced default page size to just 10)\n
                https:\/\/api.smartsheet.com\/2.0\/sheets?pageSize=10<\/pre>\n<\/li>\n
              5. Now click on Raw Edit (Above Headers grid)<\/li>\n
              6. Enter following header (Replace Token with your own token we obtained in the previous section)\n
                Authorization: Bearer YOUR-TOKEN-GOES-HERE<\/pre>\n<\/li>\n
              7. Go to Response Settings Tab<\/li>\n
              8. Select Content Type Json and enter filter as\u00a0$.totalPages<\/strong><\/li>\n
              9. Check Save response to Variable. Select Variable we created in Previous step (Only string datatype variables are visible)\n
              10. Click Test Request\/Response to confirm it works<\/li>\n
              11. Click OK to save<\/li>\n
              12. Now let’s use this variable to configure MaxPageNumber<\/strong> setting in JSON Source. Using following way you can make any Data flow component property dynamic.\n
              13. Now connect your REST API Task to Data flow<\/li>\n
              14. On the JSON Source go to Pagination Tab and enter following settings.\n
              15. That’s it. Now if you run it you will see all records will be pulled.<\/li>\n<\/ol>\n
                You can configure delay after each request [on Throttling Tab] if you want to slow down requests. This is usually helpful if you are getting too many API requests error at runtime.<\/div><\/div>\n
                Write data to Smartsheet using SSIS Web API Destination (SQL Server to Smartsheet Import)<\/h3>\n
                Now lets see how to write some data to Smartsheet Sheet. We will read records from SQL Server and write to SmartSheet using ZS Web API Destination<\/p>\n
                For inserting multiple rows we can call this Smartsheet API Endpoint<\/a><\/p>\n
                Basically High level steps are.<\/p>\n
                  \n
                1. Find out Smartsheet Column ID to use along with API call<\/li>\n
                2. Read Records from SQL Server using OLEDB Source<\/li>\n
                3. Construct desired JSON for Add New Row API Call<\/li>\n
                4. Send JSON to Smartsheet Add Row API<\/a>\u00a0 (Configure Bulk Options )<\/li>\n<\/ol>\n
                  Find out Smartsheet Column ID<\/h4>\n
                  Very first step you have to perform is get Column ID which correspond to certain title. You can use following URL endpoint to get list of all columns (Change your Sheet ID). Make sure you append\u00a0includeAll=true<\/strong>\u00a0else it may only fetch 100 columns. You can save Column result to some database table to File to copy ID. Preview Grid also allows to copy cell.<\/p>\n
                  https:\/\/api.smartsheet.com\/2.0\/sheets\/YOUR-SHEET-ID\/columns?includeAll=true<\/pre>\n
                  \"Get<\/a>
                  Get Smartsheet Column ID using API call in SSIS JSON Source<\/p><\/div>\n
                  Configure SQL Server Source (OLEDB Source)<\/h4>\n
                  Once you have column ID you can drag OLEDB Source from SSIS Toolbox and configure to read from SQL Server. Below is sample source query to extract data from SQL Server.<\/p>\n
                  Select OrderID,CustomerID,EmployeeID,OrderDate from Orders<\/pre>\n
                  Configure SSIS Template Transform<\/h4>\n
                  Once SQL Source is configure we are ready for next step. SSIS PowerPack v2.6.4 and later introduced new SSIS transform called\u00a0Template Transform<\/strong>. This transform allows you to produce desired JSON \/XML from single input record by using Column name as placeholder anywhere in your text. This is much simpler method than constructing JSON using JSON Generator Transform<\/p>\n
                  Here is the sample JSON we want to produce to insert into Sheet which contains 4 columns OrderID, CustomerID, EmployeeID and OrderDate.<\/p>\n
                  {\r\n  \"toTop\": true,\r\n  \"cells\": [\r\n    {\r\n      \"columnId\": 8146714579232644,\r\n      \"value\": 10548\r\n    },\r\n    {\r\n      \"columnId\": 828365184755588,\r\n      \"value\": \"TOMSP\"\r\n    },\r\n    {\r\n      \"columnId\": 5331964812126084,\r\n      \"value\": 3\r\n    },\r\n    {\r\n      \"columnId\": 3080164998440836,\r\n      \"value\": \"1997-05-26T00:00:00\"\r\n    }\r\n  ]\r\n}<\/pre>\n
                   <\/p>\n
                  Now lets configure SSIS Template Transform to create desired JSON Request for API call.<\/p>\n
                    \n
                  1. Drag ZS Template Transform from the SSIS toolbox<\/li>\n
                  2. Connect OLEDB Source to ZS Template Transform<\/li>\n
                  3. Double click Template Transform. Paste above sample request in the Template Text<\/li>\n
                  4. Now highlight sample value you wish to replace from upstream by some input column.<\/li>\n
                  5. Click on Insert Placeholders<\/strong> > Columns<\/strong> >\u00a0 Your Column<\/li>\n
                  6. Perform above steps for each value you wish to replace. You can also add use placeholder functions<\/a> such as\u00a0JSONENC<\/strong>\u00a0after column name (useful if you expecting new line or special characters such as tab or double quotes in your input text ). Date formatting (e.g. yyyy-MM-dd\u00a0<\/strong>) also allowed. See below example after placeholders added.\n
                    {\r\n  \"toTop\": true,\r\n  \"cells\": [\r\n    {\r\n      \"columnId\": 8146714579232644,\r\n      \"value\": <%OrderID%>\r\n    },\r\n    {\r\n      \"columnId\": 828365184755588,\r\n      \"value\": \"<%CustomerID,JSONENC%>\"\r\n    },\r\n    {\r\n      \"columnId\": 5331964812126084,\r\n      \"value\": <%EmployeeID%>\r\n    },\r\n    {\r\n      \"columnId\": 3080164998440836,\r\n      \"value\": \"<%OrderDate,yyyy-MM-ddTHH:mm:ss%>\"\r\n    }\r\n  ]\r\n}<\/pre>\n<\/li>\n
                  7. Here is final configuration of Template Transform\n
                    \"Create<\/a>
                    Create JSON for API Request (POST) using SSIS Template Transform<\/p><\/div><\/li>\n<\/ol>\n
                    Configure SSIS Web API Destination (POST New Rows to Smartsheet)<\/h4>\n
                    Now lets configure last step. This will POST API request to insert multiple rows to Smartsheet. Previous template transform crafts request for one new row but later in this section we will enable Batch mode so we can JOIN multiple JSON and created Bulk requests in one go so we avoid many API call. Always use Bulk mode if API endpoint supports it.<\/p>\n
                      \n
                    1. Drag and drop ZS Web API destination<\/a> from SSIS Toolbox<\/li>\n
                    2. Connect previous Template Transform to your Web API Destination.<\/li>\n
                    3. Select new HTTP connection. When Prompted enter following URL on HTTP Connection UI (Replace your Sheet ID)\n
                      https:\/\/api.smartsheet.com\/2.0\/sheets\/YOUR-SHEET-ID\/rows<\/pre>\n<\/li>\n
                    4. In the input column for Body select TemplateOutput<\/strong><\/li>\n
                    5. For Body you can enter Sample Body if you wish to Test at design time else leave it blank<\/li>\n
                    6. Select Body Content Type as application\/json<\/strong><\/li>\n
                    7. In the Headers enter Authorization Header like we did in previous section (Read from Smartsheet)\n
                      Authorization: Bearer YOUR-TOKEN-GOES-HERE<\/pre>\n
                      \"Configure<\/a>
                      Configure SSIS Web API Destination – Add \/ Insert Rows to Smartsheet (Bulk API call)<\/p><\/div><\/li>\n
                    8. Go to Batch Setting mode. Change following settings\n
                        \n
                      1. Check on Enable submitting multiple records<\/li>\n
                      2. For Body Header enter [<\/strong><\/li>\n
                      3. For Body Footer enter\u00a0 ]<\/strong><\/li>\n
                      4. For Body Row separator enter ,<\/strong> (i.e comma)<\/li>\n
                      5. You can change Body Batch Size to desired value (100 is recommended)\n
                      6. That’s it run your package to test the entire flow.\n
                        \"Loading<\/a>
                        Loading data from SQL Server to Smartsheet using SSIS (Web API POST Example – Bulk Mode)<\/p><\/div><\/li>\n<\/ol>\n
                         <\/p>\n
                        Truncation related error<\/h3>\n
                        The most common error you may face when you run an 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 on how to fix common metadata related errors read an article “How to handle SSIS errors (truncation, metadata issues)<\/a>“.<\/p>\n
                        Authentication related error<\/h3>\n
                        Another frequent error you may get is an authentication error, which happens when you deploy\/copy a package to another machine and run it there. Check the paragraph below<\/a>\u00a0to see why it happens and how to solve this problem.<\/p>\n<\/div>\n
                        Things have gone bad: Error handling & debugging<\/h2>\n
                        Incidentally, bad things can happen. <\/i>A remote server may go offline or your server may go out of memory. In any case, you may want to know when that happens and take actions accordingly. For that purpose, you have to redirect bad rows to some other destination. For this example, we will take and use Web API Destination<\/em>, but basically, you can use any SSIS component:<\/p>\n
                        Handling errors<\/h3>\n
                          \n
                        1. Add a Derived Column<\/em>\u00a0above Web API Destination<\/em> with expression\u00a0“(DT_WSTR,4000)ZS_JSON_OUT”<\/strong>\u00a0and name it “JsonAsString”<\/strong>. This will let you see what JSON you are actually passing.<\/li>\n
                        2. Then add a database or file destination or use another\u00a0Trash Destination<\/em>\u00a0for debugging purposes and redirect the bad rows (red arrow<\/span>) from Web API Destination <\/em><\/em>into it. <\/em><\/em>Don’t forget to set Redirect row<\/span>\u00a0option for both, Error<\/em> and Truncation<\/em> columns:
                          \n<\/em><\/em><\/p>\n
                          \n
                          \"Redirect<\/a><\/p>\n
                          Redirected failed requests from Web API Destination<\/em> to a desired destination when loading from SQL Server to REST API Service is failing. Derived Column JsonAsString<\/em> added to be able to read JSON which was passed to Elasticsearch<\/p>\n<\/div>\n<\/li>\n
                        3. Finally, add a\u00a0Data Viewer<\/em><\/a> for the red path, if you want to debug the flow. You will be able to see URL, JSON and the error message for each record. You may want to copy-paste ErrorMessage<\/em>\u00a0to Notepad <\/em>if you want it to be more readable:\n
                          \n
                          \"Use<\/a><\/p>\n
                          Use Data Viewer to view HTTP requests that failed to be fulfilled.<\/p>\n<\/div>\n<\/li>\n<\/ol>\n
                          \n
                          NOTE<\/strong>: You can read more about redirecting rows in SSIS Error Handling (Redirect bad rows)<\/a> article.<\/div>\n<\/div>\n
                          Debugging HTTP requests<\/h3>\n
                          A common thing you have to do when working with HTTP requests is to debug those requests; e.g. to check what headers, body or URL was passed.\u00a0<\/span>To test how things look behind the scenes we strongly suggest to use Fiddler<\/a>\u00a0– a popular web debugging tool.<\/p>\n
                          Inside it, you can double-click the URL entry (Right side) to see Request and Response Panels. The top panel is Request (URL, Headers, Body) and Bottom Panel is Response. For https:\/\/ (secure URL) make sure you enable HTTPS option in Fiddler (Tools > Options > HTTPS > Check Decrypt https request):<\/p>\n
                          \n
                          \"Debugging<\/a><\/p>\n
                          Debugging Web API call using Fiddler in SSIS<\/p>\n<\/div>\n<\/div>\n
                          Conclusion<\/h2>\n
                          Smartsheet API provides great way to automate data read\/write. However to call Smartsheet API \u00a0you have to use SDK \/ coding approach (e.g. C#, Java, Python, Ruby). Luckily ZappySys\u00a0SSIS PowerPack<\/a>\u00a0provides great way to integrate any Smartsheet API call via simple drag and drop approach without coding. Try \u00a0SSIS PowerPack<\/a>\u00a0for free and call virtually any REST API in few clicks.<\/p>\n
                          Keywords:<\/strong> Import smartsheet into sql server | export smartsheet to sql server | ssis smartsheet read | ssis smartsheet write | reading smartsheet data using API call | write to smartsheet<\/p>\n","protected":false},"excerpt":{"rendered":"
                          Introduction In this post you will learn how to Read \/ write Smartsheet data using SSIS (Drag and drop approach without any coding).\u00a0 We will use SSIS JSON\/ REST API Source to extract data from Smartsheet API and use SSIS Web API Destination to write data to Smartsheet. This approach is similar to our previous […]<\/p>\n","protected":false},"author":1,"featured_media":2606,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,17,10,267,200],"tags":[6,3,268,12],"yoast_head":"\r\nRead \/ Write Smartsheet data using SSIS REST API Call | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Read \/ Write Smartsheet data using SSIS REST API Call - 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-write-smartsheet-data-using-ssis-rest-api-call\/\" \/>\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 \/ Write Smartsheet data using SSIS REST API Call | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Read \/ Write Smartsheet data using SSIS REST API Call - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/\" \/>\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-02-07T23:27:38+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2022-09-16T22:20:14+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"280\" \/>\r\n\t<meta property=\"og:image:height\" content=\"280\" \/>\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=\"10 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-write-smartsheet-data-using-ssis-rest-api-call\/\",\"url\":\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/\",\"name\":\"Read \/ Write Smartsheet data using SSIS REST API Call | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png\",\"datePublished\":\"2018-02-07T23:27:38+00:00\",\"dateModified\":\"2022-09-16T22:20:14+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Read \/ Write Smartsheet data using SSIS REST API Call - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png\",\"width\":280,\"height\":280,\"caption\":\"smartsheet-api-integration-logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Read \/ Write Smartsheet data using SSIS REST API Call\"}]},{\"@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 \/ Write Smartsheet data using SSIS REST API Call | ZappySys Blog","description":"Read \/ Write Smartsheet data using SSIS REST API Call - 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-write-smartsheet-data-using-ssis-rest-api-call\/","og_locale":"en_US","og_type":"article","og_title":"Read \/ Write Smartsheet data using SSIS REST API Call | ZappySys Blog","og_description":"Read \/ Write Smartsheet data using SSIS REST API Call - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-02-07T23:27:38+00:00","article_modified_time":"2022-09-16T22:20:14+00:00","og_image":[{"width":280,"height":280,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-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":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/","url":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/","name":"Read \/ Write Smartsheet data using SSIS REST API Call | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png","datePublished":"2018-02-07T23:27:38+00:00","dateModified":"2022-09-16T22:20:14+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Read \/ Write Smartsheet data using SSIS REST API Call - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/02\/smartsheet-api-integration-logo.png","width":280,"height":280,"caption":"smartsheet-api-integration-logo"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/read-write-smartsheet-data-using-ssis-rest-api-call\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Read \/ Write Smartsheet data using SSIS REST API Call"}]},{"@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\/2588"}],"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=2588"}],"version-history":[{"count":10,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2588\/revisions"}],"predecessor-version":[{"id":9827,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2588\/revisions\/9827"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2606"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=2588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=2588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=2588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}