Zerg00s

# ================================================================================================== #
#                                Prerequisites
# ================================================================================================== #
# Install-Module SharePointPnPPowerShellOnline -Scope CurrentUser
# Install-Module -Name Az -Repository PSGallery -Force -Scope CurrentUser
# ================================================================================================== #


# ================================================================================================== #
# Parameters

Zerg00s

// Get SharePoint List Fields in a table
function getListSchema(listName) {
    var siteUrl = _spPageContextInfo.webAbsoluteUrl;
    var endpointUrl = `${siteUrl}/_api/web/lists/getbytitle('${listName}')/fields?$filter=Hidden eq false`;

    fetch(endpointUrl, {
        method: 'GET',
        headers: {
            'Accept': 'application/json;odata=nometadata',
            'Content-Type': 'application/json;odata=verbose',

Zerg00s

{
	"info": {
		"_postman_id": "7f9a258e-feee-40a7-827f-760caa441e43",
		"name": "Cognitive Search API Reusable",
		"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json",
		"_exporter_id": "641744"
	},
	"item": [
		{
			"name": "Create SharePoint Data Source",

Zerg00s

SELECT 
    last_user_update 
FROM 
    sys.dm_db_index_usage_stats 
WHERE 
    database_id = DB_ID('BOP') AND 
    OBJECT_ID=OBJECT_ID('TempUsers')

Zerg00s

document.addEventListener('DOMContentLoaded', function() {
    var linksToHide = document.querySelectorAll('a.link-to-hide');

    for (var i = 0; i < linksToHide.length; i++) {
        var linkText = linksToHide[i].textContent || linksToHide[i].innerText;
        if (linkText === 'Links' || linkText === 'Liens') {
            linksToHide[i].style.display = 'none';
        }
    }
});

Zerg00s

{"LastCopyTime":"2023-04-29T19:45:46.7675207+00:00","CopiedDataKind":0,"Data":"{\"SourceDocumentVersion\":\"1.330\",\"ClientSessionId\":\"a0c7c6e9-5f02-435f-b39e-99b798283ef8\",\"CorrelationId\":\"d5c65ece-c939-4618-81c2-be51697537fe\",\"Entities\":[{\"Type\":\"ControlInfo\",\"Name\":\"StartButton\",\"HasDynamicProperties\":false,\"Template\":{\"Id\":\"http://microsoft.com/appmagic/button\",\"Version\":\"2.2.0\",\"LastModifiedTimestamp\":\"0\",\"Name\":\"button\",\"FirstParty\":true,\"IsPremiumPcfControl\":false,\"IsCustomGroupControlTemplate\":false,\"CustomGroupControlTemplateName\":\"\",\"IsComponentDefinition\":false,\"OverridableProperties\":{}},\"Index\":0.0,\"PublishOrderIndex\":3,\"VariantName\":\"\",\"LayoutName\":\"\",\"MetaDataIDKey\":\"\",\"PersistMetaDataIDKey\":false,\"IsFromScreenLayout\":false,\"StyleName\":\"defaultButtonStyle\",\"Parent\":\"WelcomeScreen\",\"IsDataControl\":false,\"AllowAccessToGlobals\":true,\"IsGroupControl\":false,\"IsAutoGenerated\":false,\"Rules\":[{\"Property\":\"Text\

Zerg00s

$registryPath = "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System"
$keyName = "EnableLUA"
$desiredValue = 0

try {
    if (Test-Path $registryPath) {
        $currentValue = Get-ItemProperty -Path $registryPath -Name $keyName -ErrorAction Stop
        if ($currentValue.$keyName -ne $desiredValue) {
            Set-ItemProperty -Path $registryPath -Name $keyName -Value $desiredValue -ErrorAction Stop
            Write-Host "The value of '$keyName' has been set to $desiredValue."

Zerg00s

# Load user32.dll
Add-Type -TypeDefinition @"
    using System;
    using System.Runtime.InteropServices;

    public class User32 {
        [DllImport("user32.dll", SetLastError=true)]
        public static extern bool SetCursorPos(int x, int y);

        [DllImport("user32.dll")]

Zerg00s

SharePoint Onlye App + Python Authentication Tutorial

Create a new App Principal (TODO: can we automate it?)

https://TENANT.sharepoint.com/_layouts/15/appregnew.aspx

Grant tenant-wide permissions. See full list of permissions.

https://TENANT.-admin.sharepoint.com/_layouts/15/appinv.aspx

<AppPermissionRequests AllowAppOnlyPolicy="true">

Zerg00s

{
    "type": "object",
    "properties": {
        "id": {
            "type": "string"
        },
        "object": {
            "type": "string"
        },
        "created": {