2d:null 2e:["$","title",null,{"children":"SharePoint Data Visualization | Rafael Rocha | Observable"}] 33:Te9f,chart = { const root = d3.hierarchy(contentTypeTree); root.x0 = dy / 2; root.y0 = 0; root.descendants().forEach((d, i) => { d.id = i; d._children = d.children; if (d.depth && d.data.name.length !== 7) d.children = null; }); const svg = d3.create("svg") .attr("viewBox", [-margin.left, -margin.top, width, dx]) .style("font", "10px sans-serif") .style("user-select", "none"); const gLink = svg.append("g") .attr("fill", "none") .attr("stroke", "#555") .attr("stroke-opacity", 0.4) .attr("stroke-width", 1.5); const gNode = svg.append("g") .attr("cursor", "pointer") .attr("pointer-events", "all"); function update(source) { const duration = d3.event && d3.event.altKey ? 2500 : 250; const nodes = root.descendants().reverse(); const links = root.links(); // Compute the new tree layout. treeView(root); let left = root; let right = root; root.eachBefore(node => { if (node.x < left.x) left = node; if (node.x > right.x) right = node; }); const height = right.x - left.x + margin.top + margin.bottom; const transition = svg.transition() .duration(duration) .attr("viewBox", [-margin.left, left.x - margin.top, width, height]) .tween("resize", window.ResizeObserver ? null : () => () => svg.dispatch("toggle")); // Update the nodes… const node = gNode.selectAll("g") .data(nodes, d => d.id); // Enter any new nodes at the parent's previous position. const nodeEnter = node.enter().append("g") .attr("transform", d => `translate(${source.y0},${source.x0})`) .attr("fill-opacity", 0) .attr("stroke-opacity", 0) .on("click", d => { d.children = d.children ? null : d._children; update(d); }); nodeEnter.append("circle") .attr("r", 2.5) .attr("fill", d => d._children ? "#555" : "#999") .attr("stroke-width", 10); nodeEnter.append("text") .attr("dy", "0.31em") .attr("x", d => d._children ? -6 : 6) .attr("text-anchor", d => d._children ? "end" : "start") .text(d => d.data.name) .clone(true).lower() .attr("stroke-linejoin", "round") .attr("stroke-width", 3) .attr("stroke", "white"); // Transition nodes to their new position. const nodeUpdate = node.merge(nodeEnter).transition(transition) .attr("transform", d => `translate(${d.y},${d.x})`) .attr("fill-opacity", 1) .attr("stroke-opacity", 1); // Transition exiting nodes to the parent's new position. const nodeExit = node.exit().transition(transition).remove() .attr("transform", d => `translate(${source.y},${source.x})`) .attr("fill-opacity", 0) .attr("stroke-opacity", 0); // Update the links… const link = gLink.selectAll("path") .data(links, d => d.target.id); // Enter any new links at the parent's previous position. const linkEnter = link.enter().append("path") .attr("d", d => { const o = {x: source.x0, y: source.y0}; return diagonal({source: o, target: o}); }); // Transition links to their new position. link.merge(linkEnter).transition(transition) .attr("d", diagonal); // Transition exiting nodes to the parent's new position. link.exit().transition(transition).remove() .attr("d", d => { const o = {x: source.x, y: source.y}; return diagonal({source: o, target: o}); }); // Stash the old positions for transition. root.eachBefore(d => { d.x0 = d.x; d.y0 = d.y; }); } update(root); return svg.node(); }34:T5db,cp = { const root = pack(contentTypeTree); const svg = d3.create("svg") .attr("viewBox", [0, 0, cp_width, cp_height]) .style("font", "10px sans-serif") .attr("text-anchor", "middle"); const shadow = DOM.uid("shadow"); svg.append("filter") .attr("id", shadow.id) .append("feDropShadow") .attr("flood-opacity", 0.3) .attr("dx", 0) .attr("dy", 1); const node = svg.selectAll("g") .data(d3.nest().key(d => d.height).entries(root.descendants())) .join("g") .attr("filter", shadow) .selectAll("g") .data(d => d.values) .join("g") .attr("transform", d => `translate(${d.x + 1},${d.y + 1})`); node.append("circle") .attr("r", d => d.r) .attr("fill", d => cp_color(d.height)); const leaf = node.filter(d => !d.children); leaf.select("circle") .attr("id", d => (d.leafUid = DOM.uid("leaf")).id); leaf.append("clipPath") .attr("id", d => (d.clipUid = DOM.uid("clip")).id) .append("use") .attr("xlink:href", d => d.leafUid.href); leaf.append("text") .attr("clip-path", d => d.clipUid) .selectAll("tspan") .data(d => d.data.name.split(/(?=[A-Z][^A-Z])/g)) .join("tspan") .attr("x", 0) .attr("y", (d, i, nodes) => `${i - nodes.length / 2 + 0.8}em`) .text(d => d); node.append("title") .text(d => `${d.data.name}: ${d.ancestors().map(d => d.data.name).reverse().join("/")}\n${cp_format(d.value)}`); return svg.node(); }35:Tc7e,sunburst = { const root = zs_partition(contentTypeTree); let zs_color = d3.scaleOrdinal(d3.quantize(d3.interpolateRainbow, root.height)) root.each(d => d.current = d); const svg = d3.create("svg") .attr("viewBox", [0, 0, zs_width, zs_width]) .style("font", "10px sans-serif"); const g = svg.append("g") .attr("transform", `translate(${zs_width / 2},${zs_width / 2})`); const path = g.append("g") .selectAll("path") .data(root.descendants().slice(1)) .join("path") .attr("fill", d => zs_color(d.depth)) .attr("fill-opacity", d => zs_arcVisible(d.current) ? (d.children ? 0.6 : 0.4) : 0) .attr("d", d => zs_arc(d.current)); path.filter(d => d.children) .style("cursor", "pointer") .on("click", clicked); path.append("title") .text(d => `${d.ancestors().map(d => d.data.name).reverse().join("/")}\n${zs_format(d.value)}`); const label = g.append("g") .attr("pointer-events", "none") .attr("text-anchor", "middle") .style("user-select", "none") .selectAll("text") .data(root.descendants().slice(1)) .join("text") .attr("dy", "0.35em") .attr("fill-opacity", d => +labelVisible(d.current)) .attr("transform", d => labelTransform(d.current)) .text(d => d.data.name); const parent = g.append("circle") .datum(root) .attr("r", zs_radius) .attr("fill", "none") .attr("pointer-events", "all") .on("click", clicked); function clicked(p) { parent.datum(p.parent || root); root.each(d => d.target = { x0: Math.max(0, Math.min(1, (d.x0 - p.x0) / (p.x1 - p.x0))) * 2 * Math.PI, x1: Math.max(0, Math.min(1, (d.x1 - p.x0) / (p.x1 - p.x0))) * 2 * Math.PI, y0: Math.max(0, d.y0 - p.depth), y1: Math.max(0, d.y1 - p.depth) }); const t = g.transition().duration(750); // Transition the data on all zs_arcs, even the ones that aren’t visible, // so that if this transition is interrupted, entering zs_arcs will start // the next transition from the desired position. path.transition(t) .tween("data", d => { const i = d3.interpolate(d.current, d.target); return t => d.current = i(t); }) .filter(function(d) { return +this.getAttribute("fill-opacity") || zs_arcVisible(d.target); }) .attr("fill-opacity", d => zs_arcVisible(d.target) ? (d.children ? 0.6 : 0.4) : 0) .attrTween("d", d => () => zs_arc(d.current)); label.filter(function(d) { return +this.getAttribute("fill-opacity") || labelVisible(d.target); }).transition(t) .attr("fill-opacity", d => +labelVisible(d.target)) .attrTween("transform", d => () => labelTransform(d.current)); } function zs_arcVisible(d) { return d.y1 <= 3 && d.y0 >= 1 && d.x1 > d.x0; } function labelVisible(d) { return d.y1 <= 3 && d.y0 >= 1 && (d.y1 - d.y0) * (d.x1 - d.x0) > 0.03; } function labelTransform(d) { const x = (d.x0 + d.x1) / 2 * 180 / Math.PI; const y = (d.y0 + d.y1) / 2 * zs_radius; return `rotate(${x - 90}) translate(${y},0) rotate(${x < 180 ? 0 : 180})`; } return svg.node(); }36:T7a4,nestedTree = { const root = zi_partition(contentTypeTree); let focus = root; let zi_color = d3.scaleOrdinal(d3.quantize(d3.interpolateRainbow, root.height + 1)) const svg = d3.create("svg") .attr("viewBox", [0, 0, zi_width, zi_height]) .style("font", "10px sans-serif"); const cell = svg .selectAll("g") .data(root.descendants()) .join("g") .attr("transform", d => `translate(${d.y0},${d.x0})`); const rect = cell.append("rect") .attr("width", d => d.y1 - d.y0 - 1) .attr("height", d => rectHeight(d)) .attr("fill-opacity", d => d.children ? 0.6 : 0.4) .attr("fill", d => zi_color(d.depth)) .style("cursor", "pointer") .on("click", clicked); const text = cell.append("text") .style("user-select", "none") .attr("pointer-events", "none") .attr("x", 4) .attr("y", 13) .attr("fill-opacity", d => +labelVisible(d)); text.append("tspan") .text(d => d.data.name); const tspan = text.append("tspan") .attr("fill-opacity", d => labelVisible(d) * 0.7); cell.append("title") .text(d => `${d.ancestors().map(d => d.data.name).reverse().join("/")}\n${zi_format(treeMapValue(d))}`); function clicked(p) { focus = focus === p ? p = p.parent : p; root.each(d => d.target = { x0: (d.x0 - p.x0) / (p.x1 - p.x0) * zi_height, x1: (d.x1 - p.x0) / (p.x1 - p.x0) * zi_height, y0: d.y0 - p.y0, y1: d.y1 - p.y0 }); const t = cell.transition().duration(750) .attr("transform", d => `translate(${d.target.y0},${d.target.x0})`); rect.transition(t).attr("height", d => rectHeight(d.target)); text.transition(t).attr("fill-opacity", d => +labelVisible(d.target)); tspan.transition(t).attr("fill-opacity", d => labelVisible(d.target) * 0.7); } function rectHeight(d) { return d.x1 - d.x0 - Math.min(1, (d.x1 - d.x0) / 2); } function labelVisible(d) { return d.y1 <= zi_width && d.y0 >= 0 && d.x1 - d.x0 > 16; } return svg.node(); }37:T97ab,state = ({ "web": { "Created": "2019-07-09T19:45:11.843", "Description": "Sandbox team site template.", "Id": "3896fed9-f117-428b-a7e3-e20473817e4e", "LastItemModifiedDate": "2019-07-10T03:35:53Z", "LastItemUserModifiedDate": "2019-07-09T20:45:33Z", "Title": "Sandbox", "Url": "https://tenant.sharepoint.com/sites/Sandbox", "WelcomePage": "SitePages/Home.aspx" }, "lists": [ { "BaseTemplate": 125, "BaseType": 0, "DefaultViewUrl": "/sites/Sandbox/_catalogs/appdata", "Description": "", "Hidden": true, "Id": "e9c223df-0cf8-4c63-bcd5-96e12d550bf2", "ItemCount": 0, "LastItemDeletedDate": "2019-06-30T08:37:03Z", "LastItemModifiedDate": "2019-06-30T08:37:03Z", "LastItemUserModifiedDate": "2019-06-30T08:37:03Z", "ParentWebUrl": "/sites/Sandbox", "Title": "appdata", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/appdata" }, { "BaseTemplate": 126, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/_catalogs/appfiles", "Description": "", "Hidden": true, "Id": "3ace50c5-3cca-4011-b034-06a8d5302144", "ItemCount": 0, "LastItemDeletedDate": "2019-06-30T08:37:03Z", "LastItemModifiedDate": "2019-06-30T08:37:03Z", "LastItemUserModifiedDate": "2019-06-30T08:37:03Z", "ParentWebUrl": "/sites/Sandbox", "Title": "appfiles", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/appfiles" }, { "BaseTemplate": 124, "BaseType": 0, "DefaultViewUrl": "/sites/Sandbox/_catalogs/design/AllItems.aspx", "Description": "Use this list to store composed looks. These looks can be applied to this site by navigating to Site Settings and choosing Change the look.", "Hidden": true, "Id": "6126632f-912a-4bc3-893e-acef4d432e39", "ItemCount": 18, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-06-30T08:37:03Z", "LastItemUserModifiedDate": "2019-06-30T08:37:02Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Composed Looks", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/design/AllItems.aspx" }, { "BaseTemplate": 10102, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/IWConvertedForms/Forms/AllItems.aspx", "Description": "List of user browser-enabled form templates on this site collection.", "Hidden": true, "Id": "01638aa4-7f1e-4d66-af2b-aeb120dac521", "ItemCount": 0, "LastItemDeletedDate": "2019-07-09T19:45:55Z", "LastItemModifiedDate": "2019-07-09T19:45:57Z", "LastItemUserModifiedDate": "2019-07-09T19:45:55Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Converted Forms", "Url": "https://tenant.sharepoint.com/sites/Sandbox/IWConvertedForms/Forms/AllItems.aspx" }, { "BaseTemplate": 101, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/Shared Documents/Forms/AllItems.aspx", "Description": "", "Hidden": false, "Id": "cc9c0029-a634-41d2-950f-2546455baeb0", "ItemCount": 0, "LastItemDeletedDate": "2019-06-30T08:37:06Z", "LastItemModifiedDate": "2019-06-30T08:37:06Z", "LastItemUserModifiedDate": "2019-06-30T08:37:06Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Documents", "Url": "https://tenant.sharepoint.com/sites/Sandbox/Shared Documents/Forms/AllItems.aspx" }, { "BaseTemplate": 101, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/FormServerTemplates/Forms/All Forms.aspx", "Description": "This library contains administrator-approved form templates that were activated to this site collection.", "Hidden": false, "Id": "3a753fa6-2b0d-4545-9a7e-2b093f83e72d", "ItemCount": 0, "LastItemDeletedDate": "2019-07-09T19:45:56Z", "LastItemModifiedDate": "2019-07-09T19:45:56Z", "LastItemUserModifiedDate": "2019-07-09T19:45:55Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Form Templates", "Url": "https://tenant.sharepoint.com/sites/Sandbox/FormServerTemplates/Forms/All Forms.aspx" }, { "BaseTemplate": 114, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/_catalogs/lt/Forms/AllItems.aspx", "Description": "Make a template available for use in list creation by adding it to this gallery. The templates in this gallery are available to this site and all sites under it. Default list templates are not shown.", "Hidden": true, "Id": "da06e48c-048e-43b2-a963-17f88d33689c", "ItemCount": 0, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-06-30T08:37:02Z", "LastItemUserModifiedDate": "2019-06-30T08:37:02Z", "ParentWebUrl": "/sites/Sandbox", "Title": "List Template Gallery", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/lt/Forms/AllItems.aspx" }, { "BaseTemplate": 116, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/_catalogs/masterpage/Forms/AllItems.aspx", "Description": "Use the master page gallery to store master pages. The master pages in this gallery are available to this site and any sites underneath it.", "Hidden": true, "Id": "4a8cf0b4-bc01-4b1b-86ca-6dc5ab3e302b", "ItemCount": 175, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-07-10T03:35:53Z", "LastItemUserModifiedDate": "2019-07-09T19:45:54Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Master Page Gallery", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/masterpage/Forms/AllItems.aspx" }, { "BaseTemplate": 101, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/SiteAssets/Forms/AllItems.aspx", "Description": "Use this library to store files which are included on pages within this site, such as images on Wiki pages.", "Hidden": false, "Id": "aa958ba2-f458-42dc-8028-dce705333450", "ItemCount": 2, "LastItemDeletedDate": "2019-07-09T20:45:33Z", "LastItemModifiedDate": "2019-07-10T03:35:00Z", "LastItemUserModifiedDate": "2019-07-09T20:45:33Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Site Assets", "Url": "https://tenant.sharepoint.com/sites/Sandbox/SiteAssets/Forms/AllItems.aspx" }, { "BaseTemplate": 119, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/SitePages/Forms/ByAuthor.aspx", "Description": "", "Hidden": false, "Id": "630fcfc7-ddec-439e-8ec2-ed8afd6861c2", "ItemCount": 1, "LastItemDeletedDate": "2019-06-30T08:37:07Z", "LastItemModifiedDate": "2019-07-10T02:08:47Z", "LastItemUserModifiedDate": "2019-06-30T08:37:09Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Site Pages", "Url": "https://tenant.sharepoint.com/sites/Sandbox/SitePages/Forms/ByAuthor.aspx" }, { "BaseTemplate": 121, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/_catalogs/solutions/Forms/AllItems.aspx", "Description": "Use the Solution Gallery to track user solutions.", "Hidden": true, "Id": "4ae7586b-24dc-4875-aac0-f2727b950df9", "ItemCount": 0, "LastItemDeletedDate": "2019-06-30T08:37:01Z", "LastItemModifiedDate": "2019-06-30T08:37:01Z", "LastItemUserModifiedDate": "2019-06-30T08:37:01Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Solution Gallery", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/solutions/Forms/AllItems.aspx" }, { "BaseTemplate": 101, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/Style Library/Forms/AllItems.aspx", "Description": "Use the style library to store style sheets, such as CSS or XSL files. The style sheets in this gallery can be used by this site or any of its subsites.", "Hidden": false, "Id": "3c9c3aaf-902d-4e81-a4e5-1ba7f508d13d", "ItemCount": 0, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-06-30T08:37:02Z", "LastItemUserModifiedDate": "2019-06-30T08:37:02Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Style Library", "Url": "https://tenant.sharepoint.com/sites/Sandbox/Style Library/Forms/AllItems.aspx" }, { "BaseTemplate": 100, "BaseType": 0, "DefaultViewUrl": "/sites/Sandbox/Lists/TaxonomyHiddenList/AllItems.aspx", "Description": "The description for the hidden list for the taxonomy feature.", "Hidden": true, "Id": "bbbf9f13-bc23-4251-a805-94888155275b", "ItemCount": 0, "LastItemDeletedDate": "2019-07-09T19:45:59Z", "LastItemModifiedDate": "2019-07-09T19:46:03Z", "LastItemUserModifiedDate": "2019-07-09T19:45:59Z", "ParentWebUrl": "/sites/Sandbox", "Title": "TaxonomyHiddenList", "Url": "https://tenant.sharepoint.com/sites/Sandbox/Lists/TaxonomyHiddenList/AllItems.aspx" }, { "BaseTemplate": 123, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/_catalogs/theme/Forms/AllItems.aspx", "Description": "Use the theme gallery to store themes. The themes in this gallery can be used by this site or any of its subsites.", "Hidden": true, "Id": "30c52cd3-9dd3-4fb7-bd18-f18ddc719a60", "ItemCount": 41, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-06-30T08:37:06Z", "LastItemUserModifiedDate": "2019-06-30T08:37:06Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Theme Gallery", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/theme/Forms/AllItems.aspx" }, { "BaseTemplate": 112, "BaseType": 0, "DefaultViewUrl": "/sites/Sandbox/_catalogs/users/detail.aspx", "Description": "All people.", "Hidden": true, "Id": "3289db56-b343-49e3-a6b9-a3410b0e5126", "ItemCount": 12, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-07-10T00:01:55Z", "LastItemUserModifiedDate": "2019-06-30T08:37:02Z", "ParentWebUrl": "/sites/Sandbox", "Title": "User Information List", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/users/detail.aspx" }, { "BaseTemplate": 113, "BaseType": 1, "DefaultViewUrl": "/sites/Sandbox/_catalogs/wp/Forms/AllItems.aspx", "Description": "Use this Web Part Gallery to store and retrieve Web Parts. The Web Parts in this gallery are available to this site and all sites under it. To preview a Web Part, click its title.", "Hidden": true, "Id": "60807922-e087-4079-a4b4-4415a153c1bc", "ItemCount": 23, "LastItemDeletedDate": "2019-06-30T08:37:02Z", "LastItemModifiedDate": "2019-07-09T19:45:59Z", "LastItemUserModifiedDate": "2019-07-09T19:45:59Z", "ParentWebUrl": "/sites/Sandbox", "Title": "Web Part Gallery", "Url": "https://tenant.sharepoint.com/sites/Sandbox/_catalogs/wp/Forms/AllItems.aspx" } ], "contentTypes": [ { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x')", "odata.editLink": "Web/ContentTypes('0x')", "Description": "", "Group": "_Hidden", "Hidden": false, "Name": "System", "ReadOnly": false, "StringId": "0x" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01')", "odata.editLink": "Web/ContentTypes('0x01')", "Description": "Create a new list item.", "Group": "List Content Types", "Hidden": false, "Name": "Item", "ReadOnly": false, "StringId": "0x01" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01000F389E14C9CE4CE486270B9D4713A5D6')", "odata.editLink": "Web/ContentTypes('0x01000F389E14C9CE4CE486270B9D4713A5D6')", "Description": "Add a new Circulation.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Circulation", "ReadOnly": false, "StringId": "0x01000F389E14C9CE4CE486270B9D4713A5D6" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010018F21907ED4E401CB4F14422ABC65304')", "odata.editLink": "Web/ContentTypes('0x010018F21907ED4E401CB4F14422ABC65304')", "Description": "Add a New Word to this list.", "Group": "Group Work Content Types", "Hidden": false, "Name": "New Word", "ReadOnly": false, "StringId": "0x010018F21907ED4E401CB4F14422ABC65304" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01002A2479FF33DD4BC3B1533A012B653717')", "odata.editLink": "Web/ContentTypes('0x01002A2479FF33DD4BC3B1533A012B653717')", "Description": "WorkflowServiceDefinition", "Group": "_Hidden", "Hidden": false, "Name": "WorkflowServiceDefinition", "ReadOnly": false, "StringId": "0x01002A2479FF33DD4BC3B1533A012B653717" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01003A8AA7A4F53046158C5ABD98036A01D5')", "odata.editLink": "Web/ContentTypes('0x01003A8AA7A4F53046158C5ABD98036A01D5')", "Description": "Create a New Health Analyzer Rule", "Group": "_Hidden", "Hidden": false, "Name": "Health Analyzer Rule Definition", "ReadOnly": false, "StringId": "0x01003A8AA7A4F53046158C5ABD98036A01D5" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01004C9F4486FBF54864A7B0A33D02AD19B1')", "odata.editLink": "Web/ContentTypes('0x01004C9F4486FBF54864A7B0A33D02AD19B1')", "Description": "Add a new resource.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Resource", "ReadOnly": false, "StringId": "0x01004C9F4486FBF54864A7B0A33D02AD19B1" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01007CE30DD1206047728BAFD1C39A850120')", "odata.editLink": "Web/ContentTypes('0x01007CE30DD1206047728BAFD1C39A850120')", "Description": "Add a new Official Notice.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Official Notice", "ReadOnly": false, "StringId": "0x01007CE30DD1206047728BAFD1C39A850120" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100807FBAC5EB8A4653B8D24775195B5463')", "odata.editLink": "Web/ContentTypes('0x0100807FBAC5EB8A4653B8D24775195B5463')", "Description": "Add a new Phone Call Memo.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Phone Call Memo", "ReadOnly": false, "StringId": "0x0100807FBAC5EB8A4653B8D24775195B5463" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01009BE2AB5291BF4C1A986910BD278E4F18')", "odata.editLink": "Web/ContentTypes('0x01009BE2AB5291BF4C1A986910BD278E4F18')", "Description": "Add a new holiday.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Holiday", "ReadOnly": false, "StringId": "0x01009BE2AB5291BF4C1A986910BD278E4F18" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100A2CA87FF01B442AD93F37CD7DD0943EB')", "odata.editLink": "Web/ContentTypes('0x0100A2CA87FF01B442AD93F37CD7DD0943EB')", "Description": "Add a new What's New notification.", "Group": "Group Work Content Types", "Hidden": false, "Name": "What's New Notification", "ReadOnly": false, "StringId": "0x0100A2CA87FF01B442AD93F37CD7DD0943EB" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100AA27A923036E459D9EF0D18BBD0B9587')", "odata.editLink": "Web/ContentTypes('0x0100AA27A923036E459D9EF0D18BBD0B9587')", "Description": "WorkflowServiceSubscription", "Group": "_Hidden", "Hidden": false, "Name": "WorkflowServiceSubscription", "ReadOnly": false, "StringId": "0x0100AA27A923036E459D9EF0D18BBD0B9587" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100C30DDA8EDB2E434EA22D793D9EE42058')", "odata.editLink": "Web/ContentTypes('0x0100C30DDA8EDB2E434EA22D793D9EE42058')", "Description": "Add a new timecard data.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Timecard", "ReadOnly": false, "StringId": "0x0100C30DDA8EDB2E434EA22D793D9EE42058" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100CA13F2F8D61541B180952DFB25E3E8E4')", "odata.editLink": "Web/ContentTypes('0x0100CA13F2F8D61541B180952DFB25E3E8E4')", "Description": "Add a new resource group.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Resource Group", "ReadOnly": false, "StringId": "0x0100CA13F2F8D61541B180952DFB25E3E8E4" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100F95DB3A97E8046B58C6A54FB31F2BD46')", "odata.editLink": "Web/ContentTypes('0x0100F95DB3A97E8046B58C6A54FB31F2BD46')", "Description": "A report from the health analyzer", "Group": "_Hidden", "Hidden": false, "Name": "Health Analyzer Report", "ReadOnly": false, "StringId": "0x0100F95DB3A97E8046B58C6A54FB31F2BD46" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0100FBEEE6F0C500489B99CDA6BB16C398F7')", "odata.editLink": "Web/ContentTypes('0x0100FBEEE6F0C500489B99CDA6BB16C398F7')", "Description": "Add new users to this list.", "Group": "Group Work Content Types", "Hidden": false, "Name": "Users", "ReadOnly": false, "StringId": "0x0100FBEEE6F0C500489B99CDA6BB16C398F7" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101')", "odata.editLink": "Web/ContentTypes('0x0101')", "Description": "Create a new document.", "Group": "Document Content Types", "Hidden": false, "Name": "Document", "ReadOnly": false, "StringId": "0x0101" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101002039C03B61C64EC4A04F5361F3851066')", "odata.editLink": "Web/ContentTypes('0x0101002039C03B61C64EC4A04F5361F3851066')", "Description": "Base Content Type containing common Display Template columns. Use one of Control, Group, Item or Filter Display Template content types to create a display type. ", "Group": "_Hidden", "Hidden": false, "Name": "Display Template", "ReadOnly": false, "StringId": "0x0101002039C03B61C64EC4A04F5361F3851066" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101002039C03B61C64EC4A04F5361F385106605')", "odata.editLink": "Web/ContentTypes('0x0101002039C03B61C64EC4A04F5361F385106605')", "Description": "Display Template Code javascript that registers and executes Display Template rendering logic.", "Group": "_Hidden", "Hidden": false, "Name": "Display Template Code", "ReadOnly": false, "StringId": "0x0101002039C03B61C64EC4A04F5361F385106605" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101002039C03B61C64EC4A04F5361F3851068')", "odata.editLink": "Web/ContentTypes('0x0101002039C03B61C64EC4A04F5361F3851068')", "Description": "Create a new custom CSR JavaScript Display Template.", "Group": "Display Template Content Types", "Hidden": false, "Name": "JavaScript Display Template", "ReadOnly": false, "StringId": "0x0101002039C03B61C64EC4A04F5361F3851068" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010100629D00608F814DD6AC8A86903AEE72AA')", "odata.editLink": "Web/ContentTypes('0x010100629D00608F814DD6AC8A86903AEE72AA')", "Description": "", "Group": "_Hidden", "Hidden": false, "Name": "Office Data Connection File", "ReadOnly": true, "StringId": "0x010100629D00608F814DD6AC8A86903AEE72AA" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010100734778F2B7DF462491FC91844AE431CF')", "odata.editLink": "Web/ContentTypes('0x010100734778F2B7DF462491FC91844AE431CF')", "Description": "Create a new List View Style", "Group": "Document Content Types", "Hidden": false, "Name": "List View Style", "ReadOnly": false, "StringId": "0x010100734778F2B7DF462491FC91844AE431CF" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101009D1CB255DA76424F860D91F20E6C4118')", "odata.editLink": "Web/ContentTypes('0x0101009D1CB255DA76424F860D91F20E6C4118')", "Description": "Create a new site page.", "Group": "Document Content Types", "Hidden": false, "Name": "Site Page", "ReadOnly": false, "StringId": "0x0101009D1CB255DA76424F860D91F20E6C4118" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101009D1CB255DA76424F860D91F20E6C4118002A50BFCFB7614729B56886FADA02339B')", "odata.editLink": "Web/ContentTypes('0x0101009D1CB255DA76424F860D91F20E6C4118002A50BFCFB7614729B56886FADA02339B')", "Description": "Used to create a News link post. If deleted, the News link option will be disabled for users.", "Group": "Document Content Types", "Hidden": false, "Name": "Repost Page", "ReadOnly": false, "StringId": "0x0101009D1CB255DA76424F860D91F20E6C4118002A50BFCFB7614729B56886FADA02339B" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0101009D1CB255DA76424F860D91F20E6C411800C57E7DC123744954AACC08D1D5260154')", "odata.editLink": "Web/ContentTypes('0x0101009D1CB255DA76424F860D91F20E6C411800C57E7DC123744954AACC08D1D5260154')", "Description": "Used to create a dynamic page related to contentfreshness.", "Group": "Document Content Types", "Hidden": false, "Name": "Content Freshness", "ReadOnly": false, "StringId": "0x0101009D1CB255DA76424F860D91F20E6C411800C57E7DC123744954AACC08D1D5260154" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010100B4CBD48E029A4AD8B62CB0E41868F2B0')", "odata.editLink": "Web/ContentTypes('0x010100B4CBD48E029A4AD8B62CB0E41868F2B0')", "Description": "Provide a standard place for applications, such as Microsoft InfoPath, to store data connection information.", "Group": "_Hidden", "Hidden": false, "Name": "Universal Data Connection File", "ReadOnly": true, "StringId": "0x010100B4CBD48E029A4AD8B62CB0E41868F2B0" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010100C5033D6CFB8447359FB795C8A73A2B19')", "odata.editLink": "Web/ContentTypes('0x010100C5033D6CFB8447359FB795C8A73A2B19')", "Description": "HTML, JavaScript, CSS, images, and other supporting files in the Master Page Gallery used by HTML Master Pages, HTML Page Layouts, and Display Templates.", "Group": "_Hidden", "Hidden": false, "Name": "Design File", "ReadOnly": false, "StringId": "0x010100C5033D6CFB8447359FB795C8A73A2B19" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010100F8EF98760CBA4A94994F13BA881038FA')", "odata.editLink": "Web/ContentTypes('0x010100F8EF98760CBA4A94994F13BA881038FA')", "Description": "A Microsoft InfoPath Form Template.", "Group": "_Hidden", "Hidden": true, "Name": "InfoPath Form Template", "ReadOnly": false, "StringId": "0x010100F8EF98760CBA4A94994F13BA881038FA" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010101')", "odata.editLink": "Web/ContentTypes('0x010101')", "Description": "Fill out this form.", "Group": "Document Content Types", "Hidden": false, "Name": "Form", "ReadOnly": false, "StringId": "0x010101" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010102')", "odata.editLink": "Web/ContentTypes('0x010102')", "Description": "Upload an image or a photograph.", "Group": "Document Content Types", "Hidden": false, "Name": "Picture", "ReadOnly": false, "StringId": "0x010102" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010104')", "odata.editLink": "Web/ContentTypes('0x010104')", "Description": "Allows users to upload documents of any content type to a library. Unknown documents will be treated as their original content type in client applications.", "Group": "Special Content Types", "Hidden": false, "Name": "Unknown Document Type", "ReadOnly": true, "StringId": "0x010104" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010105')", "odata.editLink": "Web/ContentTypes('0x010105')", "Description": "Create a new master page.", "Group": "Document Content Types", "Hidden": false, "Name": "Master Page", "ReadOnly": false, "StringId": "0x010105" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010106')", "odata.editLink": "Web/ContentTypes('0x010106')", "Description": "Create a new master page preview.", "Group": "Document Content Types", "Hidden": false, "Name": "Master Page Preview", "ReadOnly": false, "StringId": "0x010106" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010107')", "odata.editLink": "Web/ContentTypes('0x010107')", "Description": "Items for use in user defined workflows.", "Group": "_Hidden", "Hidden": false, "Name": "User Workflow Document", "ReadOnly": false, "StringId": "0x010107" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010108')", "odata.editLink": "Web/ContentTypes('0x010108')", "Description": "Create a new wiki page.", "Group": "Document Content Types", "Hidden": false, "Name": "Wiki Page", "ReadOnly": false, "StringId": "0x010108" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010109')", "odata.editLink": "Web/ContentTypes('0x010109')", "Description": "Create a new basic page.", "Group": "Document Content Types", "Hidden": false, "Name": "Basic Page", "ReadOnly": false, "StringId": "0x010109" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01010901')", "odata.editLink": "Web/ContentTypes('0x01010901')", "Description": "Create a new Web Part page.", "Group": "Document Content Types", "Hidden": false, "Name": "Web Part Page", "ReadOnly": false, "StringId": "0x01010901" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01010A')", "odata.editLink": "Web/ContentTypes('0x01010A')", "Description": "Create a link to a document in a different location.", "Group": "Document Content Types", "Hidden": false, "Name": "Link to a Document", "ReadOnly": false, "StringId": "0x01010A" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01010B')", "odata.editLink": "Web/ContentTypes('0x01010B')", "Description": "The Dublin Core metadata element set.", "Group": "Document Content Types", "Hidden": false, "Name": "Dublin Core Columns", "ReadOnly": false, "StringId": "0x01010B" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0102')", "odata.editLink": "Web/ContentTypes('0x0102')", "Description": "Create a new meeting, deadline or other event.", "Group": "List Content Types", "Hidden": false, "Name": "Event", "ReadOnly": false, "StringId": "0x0102" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0102004F51EFDEA49C49668EF9C6744C8CF87D')", "odata.editLink": "Web/ContentTypes('0x0102004F51EFDEA49C49668EF9C6744C8CF87D')", "Description": "Reserve resource.", "Group": "List Content Types", "Hidden": false, "Name": "Reservations", "ReadOnly": false, "StringId": "0x0102004F51EFDEA49C49668EF9C6744C8CF87D" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x01020072BB2A38F0DB49C3A96CF4FA85529956')", "odata.editLink": "Web/ContentTypes('0x01020072BB2A38F0DB49C3A96CF4FA85529956')", "Description": "Create a new appointment and reserve a resource.", "Group": "List Content Types", "Hidden": false, "Name": "Schedule and Reservations", "ReadOnly": false, "StringId": "0x01020072BB2A38F0DB49C3A96CF4FA85529956" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0102007DBDC1392EAF4EBBBF99E41D8922B264')", "odata.editLink": "Web/ContentTypes('0x0102007DBDC1392EAF4EBBBF99E41D8922B264')", "Description": "Create new appointment.", "Group": "List Content Types", "Hidden": false, "Name": "Schedule", "ReadOnly": false, "StringId": "0x0102007DBDC1392EAF4EBBBF99E41D8922B264" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0103')", "odata.editLink": "Web/ContentTypes('0x0103')", "Description": "Track an issue or problem.", "Group": "List Content Types", "Hidden": false, "Name": "Issue", "ReadOnly": false, "StringId": "0x0103" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0104')", "odata.editLink": "Web/ContentTypes('0x0104')", "Description": "Create a new news item, status or other short piece of information.", "Group": "List Content Types", "Hidden": false, "Name": "Announcement", "ReadOnly": false, "StringId": "0x0104" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0105')", "odata.editLink": "Web/ContentTypes('0x0105')", "Description": "Create a new link to a Web page or other resource.", "Group": "List Content Types", "Hidden": false, "Name": "Link", "ReadOnly": false, "StringId": "0x0105" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0106')", "odata.editLink": "Web/ContentTypes('0x0106')", "Description": "Store information about a business or personal contact.", "Group": "List Content Types", "Hidden": false, "Name": "Contact", "ReadOnly": false, "StringId": "0x0106" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0107')", "odata.editLink": "Web/ContentTypes('0x0107')", "Description": "Create a new message.", "Group": "List Content Types", "Hidden": false, "Name": "Message", "ReadOnly": false, "StringId": "0x0107" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0108')", "odata.editLink": "Web/ContentTypes('0x0108')", "Description": "Track a work item that you or your team needs to complete.", "Group": "List Content Types", "Hidden": false, "Name": "Task", "ReadOnly": false, "StringId": "0x0108" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0108003365C4474CAE8C42BCE396314E88E51F')", "odata.editLink": "Web/ContentTypes('0x0108003365C4474CAE8C42BCE396314E88E51F')", "Description": "Create a SharePoint 2013 Workflow Task", "Group": "List Content Types", "Hidden": true, "Name": "Workflow Task (SharePoint 2013)", "ReadOnly": false, "StringId": "0x0108003365C4474CAE8C42BCE396314E88E51F" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010801')", "odata.editLink": "Web/ContentTypes('0x010801')", "Description": "A work item created by a workflow that you or your team needs to complete.", "Group": "_Hidden", "Hidden": true, "Name": "Workflow Task", "ReadOnly": false, "StringId": "0x010801" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010802')", "odata.editLink": "Web/ContentTypes('0x010802')", "Description": "An administrative work item that an administrator needs to complete.", "Group": "_Hidden", "Hidden": true, "Name": "Administrative Task", "ReadOnly": false, "StringId": "0x010802" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0109')", "odata.editLink": "Web/ContentTypes('0x0109')", "Description": "The history of a workflow.", "Group": "_Hidden", "Hidden": false, "Name": "Workflow History", "ReadOnly": false, "StringId": "0x0109" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010A')", "odata.editLink": "Web/ContentTypes('0x010A')", "Description": "", "Group": "_Hidden", "Hidden": false, "Name": "Person", "ReadOnly": false, "StringId": "0x010A" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010B')", "odata.editLink": "Web/ContentTypes('0x010B')", "Description": "", "Group": "_Hidden", "Hidden": false, "Name": "SharePointGroup", "ReadOnly": false, "StringId": "0x010B" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x010C')", "odata.editLink": "Web/ContentTypes('0x010C')", "Description": "", "Group": "_Hidden", "Hidden": false, "Name": "DomainGroup", "ReadOnly": false, "StringId": "0x010C" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0110')", "odata.editLink": "Web/ContentTypes('0x0110')", "Description": "Create a new blog post.", "Group": "List Content Types", "Hidden": false, "Name": "Post", "ReadOnly": false, "StringId": "0x0110" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0111')", "odata.editLink": "Web/ContentTypes('0x0111')", "Description": "Create a new blog comment.", "Group": "List Content Types", "Hidden": false, "Name": "Comment", "ReadOnly": false, "StringId": "0x0111" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0116')", "odata.editLink": "Web/ContentTypes('0x0116')", "Description": "Store information about a business or personal contact.", "Group": "List Content Types", "Hidden": false, "Name": "East Asia Contact", "ReadOnly": false, "StringId": "0x0116" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0120')", "odata.editLink": "Web/ContentTypes('0x0120')", "Description": "Create a new folder.", "Group": "Folder Content Types", "Hidden": false, "Name": "Folder", "ReadOnly": false, "StringId": "0x0120" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x012001')", "odata.editLink": "Web/ContentTypes('0x012001')", "Description": "", "Group": "_Hidden", "Hidden": false, "Name": "RootOfList", "ReadOnly": false, "StringId": "0x012001" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x012002')", "odata.editLink": "Web/ContentTypes('0x012002')", "Description": "Create a new discussion topic.", "Group": "Folder Content Types", "Hidden": false, "Name": "Discussion", "ReadOnly": false, "StringId": "0x012002" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x012004')", "odata.editLink": "Web/ContentTypes('0x012004')", "Description": "Group and describe related tasks that you or your team needs to complete.", "Group": "Folder Content Types", "Hidden": false, "Name": "Summary Task", "ReadOnly": false, "StringId": "0x012004" }, { "odata.type": "SP.ContentType", "odata.id": "https://zw07q.sharepoint.com/sites/DEV/_api/Web/ContentTypes('0x0120D5')", "odata.editLink": "Web/ContentTypes('0x0120D5')", "Description": "Create a new Document Collection Folder", "Group": "_Hidden", "Hidden": false, "Name": "Document Collection Folder", "ReadOnly": false, "StringId": "0x0120D5" } ] })38:[] 31:{"id":"549288dc1a292f64","slug":"sharepoint-data-visualization","title":"SharePoint Data Visualization","thumbnail":"95848bb15d96f891a01f29263da3bfd5d972133820931f76bf62b3eaff1fd794","access_level":"public","create_time":"$D2019-07-10T16:34:14.153Z","update_time":"$D2025-03-15T03:31:13.874Z","view_time":null,"first_public_time":"$D2019-07-10T16:37:17.584Z","has_unpublished_edits":null,"fork":true,"stars":2,"starred":false,"owner":{"type":"team","id":"4a0a18b2837e32ce","login":"rrocham","name":"Rafael Rocha","avatar_url":"https://avatars-next.observableusercontent.com/f2b3dd21b982b565b9aff256581df7b7e5db97ab6d2143d02c8a53535cdb23d4","tier":"starter_2024"},"version":825,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fce7d2527ab60a33","login":"rrocham","name":"Rafael Rocha","avatar_url":"https://avatars-next.observableusercontent.com/f2b3dd21b982b565b9aff256581df7b7e5db97ab6d2143d02c8a53535cdb23d4","tier":null}],"members":[{"type":"individual","id":"fce7d2527ab60a33","login":"rrocham","name":"Rafael Rocha","avatar_url":"https://avatars-next.observableusercontent.com/f2b3dd21b982b565b9aff256581df7b7e5db97ab6d2143d02c8a53535cdb23d4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"SharePoint Data Visualization","cells":[{"id":650,"value":"md`# SharePoint Data Visualization\n\nThis version of the notebook uses a static sample of SharePoint data. To connect to your SharePoint environment see the [Companion backend](https://github.com/rrocham/observablesp) code.\n\nThe backend code exposes SharePoint data using Azure Functions.\n\nThe Github repository contains the instructions on how to register the app.\n\nWhen registered and configured the dynamic data will be displayed below.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"html`

Content Types

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"md`This section provides different ways of visualizing your Content Types hierarchy.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"md`### Tree`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":513,"value":"md`This visualization of **Content Types** was inspired by the [Collapsible Tree](https://observablehq.com/@d3/collapsible-tree) notebook.\n\nTry clicking the **Item** Content Type node below.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":763,"value":"md`### Circle Packing`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":806,"value":"md`This visualization of **Content Types** was inspired by the [Circle Packing](https://observablehq.com/@d3/circle-packing) notebook.\n\nMouse over the circles to see the Content Type's name and path.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":769,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":478,"value":"md`### Zoomable Sunburst`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"md`This visualization of **Content Types** was inspired by the [Zoomable Sunburst](https://observablehq.com/@d3/zoomable-sunburst?collection=@d3/d3-hierarchy) notebook.\n\nTry clicking the **Document** Content Type to see its children. Click in the middle to go back a level.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":645,"value":"md`### Zoomable Icicle`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"md`This visualization of **Content Types** was inspired by the [Zoomable Icicle](https://observablehq.com/@d3/zoomable-icicle) notebook.\n\nTry clicking the **Document** Content Type to see its children. Click in the left side to go back a level.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"html`

Search for a Content Type

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":674,"value":"viewof contentTypeSearch = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"md`### Content Types`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"html`\n

${ct}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"html`\n

Lists

\n ${l.Title} [${l.ItemCount}]\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"md`# # Data\n\n> This version of the notebook uses a static object to represent SharePoint data. To connect to your environment, first replace the host variable to match your Azure Functions App. Then set the state object by calling the load() function.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"host = 'https://yourfunctionapp.azurewebsites.net'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":818,"value":"JSON.stringify(contentTypeTree)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"contentTypeTree = createContentTypeTree();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"md`# # Functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":689,"value":"stringContains = (a, b) => a.toLowerCase().indexOf(b.toLowerCase()) >= 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"stringIsEqual = (a, b) => a.toLowerCase() === b.toLowerCase()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"sort = (sorter, order = 1) => (a, b) => {\n var nameA = sorter(a);\n var nameB = sorter(b);\n if (nameA < nameB) {\n return -1 * order;\n }\n if (nameA > nameB) {\n return 1 * order;\n }\n\n // names must be equal\n return 0;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"createContentTypeTree = () => {\n\n const reducer = ([head, ...tail]) => {\n const parent = tail.find(parent => isChildOf(head.id, parent.id))\n if(!parent) return head;\n\n parent.children = parent.children || [];\n parent.children.push(head);\n \n return reducer(tail);\n }\n\n const desc = state.contentTypes.map(c => ({ name: c.Name, id: c.StringId, data: {...c} })).sort(sort(i => i.id.length, -1))\n return reducer(desc);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"isChildOf = (contentTypeId, parentId) => {\n\n if(contentTypeId.length < parentId.length) {\n return false;\n }\n\n for (let i = 0; i < parentId.length; i++) {\n if (parentId[i] !== contentTypeId[i]) {\n return false;\n }\n }\n\n return true;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"function fetchData(path = '/', query = '') {\n return fetch(`${host}/api${path}?code=${Secret('AZURE_FUNCTION')}${query && '&' + query}`)\n .then(res => res.json())\n .then(res => res.data);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"function load() {\n const ct = fetchData('/GetContentTypes');\n const ls = fetchData('/GetLists');\n const wb = fetchData(\"/GetWebInfo\");\n return Promise.all([wb, ls, ct]).then(([web, lists, contentTypes]) => {\n web = web;\n lists = lists.map(list => ({...list, Url: getListUrl(web, list)}));\n contentTypes = contentTypes;\n return { web, lists, contentTypes };\n }).catch(error => {\n return { error };\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"function getListUrl(web, list) {\n const baseUrl = web.Url + list.DefaultViewUrl.replace(list.ParentWebUrl, '');\n console.log(baseUrl);\n return baseUrl;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"md`# # UI Components`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":799,"value":"md`## Circle Packing`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"cp_color = d3.scaleSequential([8, 0], d3.interpolateMagma)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":777,"value":"cp_format = d3.format(\",d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":774,"value":"cp_height = cp_width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":772,"value":"cp_width = 975","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"pack = data => d3.pack()\n .size([cp_width - 2, cp_height - 2])\n .padding(3)\n (d3.hierarchy(data)\n .count()\n .sort((a, b) => b.value - a.value))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":382,"value":"md`## Treeview`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"treeView = d3.tree().nodeSize([dx, dy])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"margin = ({top: 10, right: 120, bottom: 10, left: 40})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"dy = width / 6","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"dx = 10","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"diagonal = d3.linkHorizontal().x(d => d.y).y(d => d.x)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"md`## Zoomable Sunburst`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":440,"value":"zs_format = d3.format(\",d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":434,"value":"zs_partition = data => {\n const root = d3.hierarchy(data)\n .count()\n .sort((a, b) => b.id - a.id);\n return d3.partition()\n .size([2 * Math.PI, root.height + 1])\n (root);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"zs_width = 900","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":426,"value":"zs_radius = zs_width / 6","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":421,"value":"zs_arc = d3.arc()\n .startAngle(d => d.x0)\n .endAngle(d => d.x1)\n .padAngle(d => Math.min((d.x1 - d.x0) / 2, 0.005))\n .padRadius(zs_radius * 1.5)\n .innerRadius(d => d.y0 * zs_radius)\n .outerRadius(d => Math.max(d.y0 * zs_radius, d.y1 * zs_radius - 1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"md`## Zoomable Icicle`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"treeMapValue = node => node.value","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"zi_format = d3.format(\",d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":621,"value":"zi_partition = data => {\n const root = d3.hierarchy(contentTypeTree)\n .count()\n .sort((a, b) => b.height - a.height || treeMapValue(b) - treeMapValue(a)); \n return d3.partition()\n .size([zi_height, (root.height + 1) * zi_width / 3])\n (root);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":546,"value":"zi_width = 975","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"zi_height = 1200","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"md`# #Dependencies`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W38","stdlib":"1","titling":"auto"}} 32:"$31:body"