Skip to content

Instantly share code, notes, and snippets.

View expiscornovus's full-sized avatar

Dennis Goedegebuure expiscornovus

23 followers · 28 following
View GitHub Profile
@expiscornovus
expiscornovus / CreateSharePointPageRESTAPIrequest.json
Created February 25, 2021 20:36
Create SharePoint Page REST API request
Method
POST
Uri
/_api/sitepages/pages
Headers
{
"content-type": "application/json; odata=verbose",
"accept": "application/json; odata=verbose"
@expiscornovus
expiscornovus / CreateSharePointPage_ParseJsonschema.json
Created February 25, 2021 20:38
Create SharePoint Page Parse Json schema
{
"type": "object",
"properties": {
"d": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"id": {
@expiscornovus
expiscornovus / CheckoutSharePointPageRESTAPIrequest.json
Last active March 18, 2022 13:04
Check out SharePoint Page REST API request
Method
POST
URI
/_api/sitepages/pages(@{body('Parse_JSON')?['d']?['Id']})/checkoutpage
Headers
{
"content-type": "application/json;odata=verbose",
"Accept": "application/json;odata=verbose"
@expiscornovus
expiscornovus / SiteIdWebId_response.json
Created February 25, 2021 21:19
SiteId WebId response
outputs('Send_an_HTTP_request_to_SharePoint_-_SiteId')?['body']?['d']['Id']
outputs('Send_an_HTTP_request_to_SharePoint_-_WebId')?['body']?['d']['Id']
@expiscornovus
expiscornovus / Updatedescriptionphonecall_http.json
Last active March 14, 2021 14:12
Update description phone call record via Microsoft Dataverse Web API patch request
Method - PATCH
URI - @{variables('EnvironmentUrl')}/api/data/v9.1/@{variables('Entity')}(@{variables('RecordId')})
Headers -
{
"Content-Type": "application/json",
"OData-MaxVersion": "4.0",
"OData-Version": "4.0"
}
Body -
{
@expiscornovus
expiscornovus / JDNtoUTC.json
Created March 17, 2021 17:46
JDN to UTC
addseconds('0001-01-01', int(mul(sub(variables('JDN'), 1721425.5), 86400)))
@expiscornovus
expiscornovus / FirstTuesdayOfMonth.json
Created March 17, 2021 17:54
First Tuesday of Month
if(equals(dayofWeek(startOfMonth(variables('Now'))), 2), startOfMonth(variables('Now')), if(equals(dayofWeek(startOfMonth(variables('Now'))), 1), addDays(startOfMonth(variables('Now')),1), if(equals(dayofWeek(startOfMonth(variables('Now'))), 0), addDays(startOfMonth(variables('Now')),2), addDays(startOfMonth(variables('Now')),sub(9,dayofWeek(startOfMonth(variables('Now'))))))))
@expiscornovus
expiscornovus / MostRecentDay.json
Created March 17, 2021 18:16
Most recent day of two random date values
max(createArray(div(ticks(variables('Tomorrow')),864000000000),div(ticks(variables('Now')),864000000000)))
@expiscornovus
expiscornovus / UTCNowtoTicksinMinutes.json
Created March 17, 2021 18:22
UTC Now to Ticks in Minutes
div(ticks(utcNow()),600000000)
@expiscornovus
expiscornovus / UTCNowtoTicksinDays.json
Created March 17, 2021 18:25
UTC Now to Ticks in Days
div(ticks(UtcNow()),864000000000)