{"id":6864,"date":"2019-04-26T23:03:36","date_gmt":"2019-04-26T23:03:36","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=6864"},"modified":"2021-01-15T13:48:25","modified_gmt":"2021-01-15T13:48:25","slug":"write-read-wordpress-data-using-ssis-rest-api","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/","title":{"rendered":"Write\/Read WordPress data using SSIS and REST API"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>In this new article, we will show how to read WordPress data using REST\u00a0API. REST API is a very popular software architectural style for Web Services.<br \/>\nSSIS is a very popular ETL software used to integrate almost any data (SQL\u00a0Server, Oracle,\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-excel-file-source\/\">Excel<\/a>, DB2,\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-csv-file-source-flat-file-web-api\/\">CSV files<\/a>, Big Data,\u00a0<a href=\"https:\/\/zappysys.com\/blog\/get-data-from-facebook-in-ssis-using-rest-api\/\">Facebook<\/a>,\u00a0<a href=\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/\">Gmail<\/a>, etc).<\/p>\n<h2>Requirements<\/h2>\n<p>For this example, we will use a popular plug-in. The name is ZappySys PowerPack for SSIS which includes some nice generic connectors to REST API. You\u00a0can download it here:<\/p>\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\">ZappySys PowerPack for SSIS Installer<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssdt\/download-sql-server-data-tools-ssdt?view=sql-server-2017\">SSDT for Business Intelligence<\/a><\/li>\n<\/ul>\n<h2>Getting started<\/h2>\n<p>We will be using this\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a>\u00a0component to make things work:<br \/>\n<div class=\"su-table su-table-alternate\">\n<table width=\"300\">\n<tbody>\n<tr style=\"line-height: 0px\">\n<td width=\"50px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3074\" src=\"https:\/\/zappysys.com\/images\/SSIS-PowerPack\/ssis-rest-api-web-service-task.png\" alt=\"SSIS REST API Web Service Task\" width=\"50\" height=\"50\" \/><\/a><\/td>\n<td style=\"vertical-align: middle\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\">SSIS REST API Web Service Task<br \/>\n<\/a><\/td>\n<\/tr>\n<tr style=\"line-height: 0px\">\n<td style=\"height: 58px\" width=\"50px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3074\" src=\"https:\/\/zappysys.com\/images\/SSIS-PowerPack\/SSIS-Json-Source-Adapter.png\" alt=\"JSON Source (File, REST API, OData Connector)\" width=\"50\" height=\"50\" \/><\/a><\/td>\n<td style=\"vertical-align: middle;height: 58px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\">SSIS JSON Source (File, REST API, OData Connector)<\/a><\/td>\n<\/tr>\n<tr style=\"line-height: 0px\">\n<td style=\"height: 58px\" width=\"50px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-destination-connector\/\" target=\"_blank\" rel=\"noopener\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3074\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/json-file-destination\/ssis-json-file-destination.png\" alt=\"SSIS JSON File Destination (Create JSON File)\" width=\"50\" height=\"50\" \/><\/a><\/td>\n<td style=\"vertical-align: middle;height: 58px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-destination-connector\/\" target=\"_blank\" rel=\"noopener\">SSIS JSON File Destination (Create JSON File)<br \/>\n<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2>Read WordPress data using SSIS with REST API<\/h2>\n<p>REST API is also the name of one of the ZappySys components. These tools can\u00a0connect to thousands of REST API Servers. In this example, we will connect to\u00a0WordPress.<\/p>\n<ol>\n<li>First, drag and drop the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\"><strong>REST API<\/strong><\/a> task to the design pane.<\/li>\n<li>Secondly, write the following URL in the REST API task URL:<a href=\"http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/pages\"><br \/>\n<\/a><\/p>\n<pre class=\"lang:default highlight:0 decode:true\">http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/pages<\/pre>\n<\/li>\n<li>After that, press <strong>Test Request\/Response.<\/strong><\/li>\n<li>That URL shows the page&#8217;s information in WordPress. This is a demo API.\u00a0For more information about the WordPress links, check\u00a0<a href=\"https:\/\/developer.wordpress.org\/rest-api\/reference\/\">here<\/a>.\n<div id=\"attachment_6874\" style=\"width: 696px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-rest-api-wordpress.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6874\" class=\"size-full wp-image-6874\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-rest-api-wordpress.png\" alt=\"ssis-wordpress\" width=\"686\" height=\"613\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-rest-api-wordpress.png 686w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-rest-api-wordpress-300x268.png 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/a><p id=\"caption-attachment-6874\" class=\"wp-caption-text\">Call WordPress in SSIS<\/p><\/div><\/li>\n<li>Next, you can also check the Tags, Comments, Categories, Posts,\u00a0Taxonomies, Media. Here you have some examples:\n<ul>\n<li>To get the tags in WordPress, use this URL:\n<pre class=\"lang:default highlight:0 decode:true\">http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/tags<\/pre>\n<\/li>\n<li>In order to read comments in WordPress using SSIS and REST API, use\u00a0this URL:\n<pre class=\"lang:default highlight:0 decode:true\">http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/comments<\/pre>\n<\/li>\n<li>For the categories, use this URL to read WordPress data using SSIS:\n<pre class=\"lang:default highlight:0 decode:true\">http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/categories<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li>In addition, for your blog, you need to add \/wp-json\/wp\/v2\/ and\u00a0pages, posts or tags in your WordPress URL.<\/li>\n<li>Finally, if you want to save the results, in Response Settings, enable\u00a0save response content and select the option save to file, and specify a file\u00a0path:\n<div id=\"attachment_6877\" style=\"width: 696px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-restp-api-wordpress-save-json.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6877\" class=\"wp-image-6877 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-restp-api-wordpress-save-json.png\" alt=\"Wordpress response into file\" width=\"686\" height=\"654\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-restp-api-wordpress-save-json.png 686w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-restp-api-wordpress-save-json-300x286.png 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/a><p id=\"caption-attachment-6877\" class=\"wp-caption-text\">Save response WordPress API<\/p><\/div><\/li>\n<\/ol>\n<h2>How to read WordPress data using SSIS and store it into a SQL Server database<\/h2>\n<p>In the next example, we will use the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\">JSON Source<\/a> component. This component is\u00a0similar to the REST API, but this is used in the Data Flow to save the REST\u00a0API results in any destination of your preference (SQL Server, PostgreSQL,\u00a0MongoDB, etc). Also, this example will read WordPress data using SSIS and store it into a SQL Server database.<\/p>\n<ol>\n<li>First of all, in the Control flow, drag and drop the Data Flow:\n<div style=\"width: 470px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/drag-and-drop-data-flow-task.png\" alt=\"Insert Data Flow\" width=\"460\" height=\"155\" \/><p class=\"wp-caption-text\">Data Flow Task<\/p><\/div><\/li>\n<li>Drag and drop the JSON Source in the Data flow with this configuration:\n<div id=\"attachment_6880\" style=\"width: 836px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-source-get-rest-api-wordpress.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6880\" class=\"size-full wp-image-6880\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-source-get-rest-api-wordpress.png\" alt=\"SSIS wordpress data\" width=\"826\" height=\"733\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-source-get-rest-api-wordpress.png 826w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-source-get-rest-api-wordpress-300x266.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-source-get-rest-api-wordpress-768x682.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><p id=\"caption-attachment-6880\" class=\"wp-caption-text\">JSON Source to WordPress API<\/p><\/div><\/li>\n<li>Finally, you can save to an OLEDB Destination to save into a SQL\u00a0Database:\n<div id=\"attachment_6882\" style=\"width: 834px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-to-sql-server.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6882\" class=\"size-full wp-image-6882\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-to-sql-server.png\" alt=\"From WordPress into SQL Server\" width=\"824\" height=\"718\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-to-sql-server.png 824w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-to-sql-server-300x261.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-to-sql-server-768x669.png 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/><\/a><p id=\"caption-attachment-6882\" class=\"wp-caption-text\">Store WordPress into SQL Server<\/p><\/div><\/li>\n<\/ol>\n<h2>How to read WordPress data using SSIS and modify the JSON structure<\/h2>\n<p>Sometimes we need to modify the WordPress JSON output to a custom output in\u00a0SSIS. We will now use the JSON Generator Transform this time, which is a very\u00a0powerful tool for this purpose.<\/p>\n<ol>\n<li>First of all, we will use the JSON Source connecting to the following\n<pre class=\"lang:default highlight:0 decode:true \">URL: http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/categories<\/pre>\n<\/li>\n<li>Secondly, we need to convert the JSON output to the following format:\n<pre class=\"lang:default highlight:0 decode:true \">{\r\n   \"id\" : \r\n     {\r\n         \"count\" : 1474359596826126768,\r\n         \"description\" : \r\n          {\r\n            \"link\" : \"xxx\"\r\n          }\r\n    }\r\n}<\/pre>\n<\/li>\n<li>Next, we will add an element first:\n<div id=\"attachment_6885\" style=\"width: 744px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-add-static-value.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6885\" class=\"size-full wp-image-6885\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-add-static-value.png\" alt=\"Add custom JSON in SSIS\" width=\"734\" height=\"326\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-add-static-value.png 734w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-add-static-value-300x133.png 300w\" sizes=\"(max-width: 734px) 100vw, 734px\" \/><\/a><p id=\"caption-attachment-6885\" class=\"wp-caption-text\">SSIS WordPress API<\/p><\/div><\/li>\n<li>Also, we will select the id attribute:\n<div id=\"attachment_6942\" style=\"width: 405px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-id-add-attribute.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6942\" class=\"size-full wp-image-6942\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-id-add-attribute.png\" alt=\"SSIS id JSON\" width=\"395\" height=\"438\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-id-add-attribute.png 395w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-id-add-attribute-271x300.png 271w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/a><p id=\"caption-attachment-6942\" class=\"wp-caption-text\">id attributes SSIS<\/p><\/div><\/li>\n<li>In addition, we will add a static element to the id:\n<div id=\"attachment_6944\" style=\"width: 743px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-mapping-add-element.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6944\" class=\"size-full wp-image-6944\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-mapping-add-element.png\" alt=\"Increment an element in JSON with SSIS\" width=\"733\" height=\"267\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-mapping-add-element.png 733w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-json-mapping-add-element-300x109.png 300w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/a><p id=\"caption-attachment-6944\" class=\"wp-caption-text\">Add JSON element<\/p><\/div><\/li>\n<li>Furthermore, we will add the count element.\n<div id=\"attachment_6943\" style=\"width: 405px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-count.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6943\" class=\"size-full wp-image-6943\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-count.png\" alt=\"SSIS generate JOSN\" width=\"395\" height=\"438\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-count.png 395w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-count-271x300.png 271w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/a><p id=\"caption-attachment-6943\" class=\"wp-caption-text\">Add element in JSON with SSIS<\/p><\/div><\/li>\n<li>Finally, repeat the same process for the description and link. The JSON\u00a0structure will be the following:<\/li>\n<\/ol>\n<h2>How to read WordPress data using SSIS and use pagination<\/h2>\n<p>If it is a lot of data in REST API, pagination allows showing the results in\u00a0pages. Let&#8217;s take a look at it.<\/p>\n<ol>\n<li>First of all, we will use page 2. To do it, we will use the\u00a0following URL in the JSON Source task in the data flow:\n<pre class=\"lang:default highlight:0 decode:true \">http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/posts?per_page=2<\/pre>\n<div id=\"attachment_6947\" style=\"width: 836px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-pagination.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6947\" class=\"size-full wp-image-6947\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-pagination.png\" alt=\"Wordpress Pagination SSIS\" width=\"826\" height=\"733\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-pagination.png 826w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-pagination-300x266.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-api-pagination-768x682.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><p id=\"caption-attachment-6947\" class=\"wp-caption-text\">SSIS URL pagination REST API<\/p><\/div><\/li>\n<li>Secondly, there is a pagination tab that can be used to get the data\u00a0using pagination. For more information about pagination, refer to our\u00a0ZappySys\u00a0<a href=\"https:\/\/zappysys.com\/blog\/ssis-rest-api-looping-until-no-more-pages-found\/\">Pagination article related<\/a>.\n<div id=\"attachment_6949\" style=\"width: 836px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-per-page-pagination-wordpress.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6949\" class=\"size-full wp-image-6949\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-per-page-pagination-wordpress.png\" alt=\"Pagination handled in SSIS for WordPress\" width=\"826\" height=\"733\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-per-page-pagination-wordpress.png 826w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-per-page-pagination-wordpress-300x266.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-per-page-pagination-wordpress-768x682.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><p id=\"caption-attachment-6949\" class=\"wp-caption-text\">SSIS pagination in SSIS<\/p><\/div><\/li>\n<\/ol>\n<h2>How to write WordPress data using SSIS<\/h2>\n<ol>\n<li>In order to write WordPress data using SSIS, we will use the REST API\u00a0task with the following URL:\n<pre class=\"lang:default highlight:0 decode:true \">POST http:\/\/demo.wp-api.org\/wp-json\/wp\/v2\/posts\/<\/pre>\n<\/li>\n<li>Secondly, we have the post with id equal to 2 and we will use the body\u00a0request as follows:<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-write-data.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6951\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-write-data.png\" alt=\"\" width=\"800\" height=\"654\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-write-data.png 800w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-write-data-300x245.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-wordpress-write-data-768x628.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/li>\n<\/ol>\n<h2>Conclusion<\/h2>\n<p>To conclude, in this article, we learned how to write and read WordPress data using SSIS. In addition, we learned also how to get pagination and how to change the format of the JSON\u00a0results. If you want to try it yourself, do not hesitate to\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\">download\u00a0ZappySys PowerPack<\/a>!<\/p>\n<h2>References<\/h2>\n<p>Finally, for more information about how to read WordPress Data using SSIS, refer to these links:<\/p>\n<ul>\n<li><a href=\"https:\/\/developer.wordpress.org\/rest-api\/reference\/\">REST API Handbook<\/a><\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=rGObWtjxGBc&amp;t=296s\">WordPress REST API Tutorial (Real Examples)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In this new article, we will show how to read WordPress data using REST\u00a0API. REST API is a very popular software architectural style for Web Services. SSIS is a very popular ETL software used to integrate almost any data (SQL\u00a0Server, Oracle,\u00a0Excel, DB2,\u00a0CSV files, Big Data,\u00a0Facebook,\u00a0Gmail, etc). Requirements For this example, we will use a [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":3074,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,131,17],"tags":[272,271,12,483],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Write\/Read Wordpress data using SSIS and REST API | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"This article shows how to write and read Wordpress data using SSIS with REST API. You will learn some components for this purpose.\" \/>\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\/write-read-wordpress-data-using-ssis-rest-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=\"Write\/Read Wordpress data using SSIS and REST API | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"This article shows how to write and read Wordpress data using SSIS with REST API. You will learn some components for this purpose.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-04-26T23:03:36+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2021-01-15T13:48:25+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"100\" \/>\r\n\t<meta property=\"og:image:height\" content=\"100\" \/>\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\/write-read-wordpress-data-using-ssis-rest-api\/\",\"url\":\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/\",\"name\":\"Write\/Read Wordpress data using SSIS and REST API | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\",\"datePublished\":\"2019-04-26T23:03:36+00:00\",\"dateModified\":\"2021-01-15T13:48:25+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"This article shows how to write and read Wordpress data using SSIS with REST API. You will learn some components for this purpose.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\",\"width\":100,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Write\/Read WordPress data using SSIS and REST 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\/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":"Write\/Read Wordpress data using SSIS and REST API | ZappySys Blog","description":"This article shows how to write and read Wordpress data using SSIS with REST API. You will learn some components for this purpose.","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\/write-read-wordpress-data-using-ssis-rest-api\/","og_locale":"en_US","og_type":"article","og_title":"Write\/Read Wordpress data using SSIS and REST API | ZappySys Blog","og_description":"This article shows how to write and read Wordpress data using SSIS with REST API. You will learn some components for this purpose.","og_url":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/","og_site_name":"ZappySys Blog","article_published_time":"2019-04-26T23:03:36+00:00","article_modified_time":"2021-01-15T13:48:25+00:00","og_image":[{"width":100,"height":100,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.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\/write-read-wordpress-data-using-ssis-rest-api\/","url":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/","name":"Write\/Read Wordpress data using SSIS and REST API | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","datePublished":"2019-04-26T23:03:36+00:00","dateModified":"2021-01-15T13:48:25+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"This article shows how to write and read Wordpress data using SSIS with REST API. You will learn some components for this purpose.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","width":100,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/write-read-wordpress-data-using-ssis-rest-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Write\/Read WordPress data using SSIS and REST 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\/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\/6864"}],"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=6864"}],"version-history":[{"count":21,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6864\/revisions"}],"predecessor-version":[{"id":9242,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6864\/revisions\/9242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/3074"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=6864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=6864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=6864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}