{"version":"1.0","provider_name":"ZappySys Blog","provider_url":"https:\/\/zappysys.com\/blog","author_name":"ZappySys","author_url":"https:\/\/zappysys.com\/blog\/author\/hshah\/","title":"Create Excel File in SSIS (Read from JSON \/ XML) | ZappySys Blog","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"IEwoiHcNcE\"><a href=\"https:\/\/zappysys.com\/blog\/create-excel-file-in-ssis-json-xml\/\">Create Excel File in SSIS (Read from JSON \/ XML)<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/zappysys.com\/blog\/create-excel-file-in-ssis-json-xml\/embed\/#?secret=IEwoiHcNcE\" width=\"600\" height=\"338\" title=\"&#8220;Create Excel File in SSIS (Read from JSON \/ XML)&#8221; &#8212; ZappySys Blog\" data-secret=\"IEwoiHcNcE\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","thumbnail_url":"https:\/\/cdn.zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/json-to-excel-import-export.png","thumbnail_width":343,"thumbnail_height":343,"description":"How to Load JSON or XML Data in Excel File, Using JSON Source read json data from rest API or file. Using XML Source read xml data from rest API or file."}