Skip to content

Instantly share code, notes, and snippets.

@stefanstranger
Created April 1, 2024 13:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stefanstranger/bd69c9e7d8a3486205f4567949ef52a2 to your computer and use it in GitHub Desktop.
Save stefanstranger/bd69c9e7d8a3486205f4567949ef52a2 to your computer and use it in GitHub Desktop.
issue26-2

Azure Logic App Documentation - Issue26-2

Introduction

This document describes the Azure Logic App Workflow Issue26-2 in the demo-rg resource group in the Visual Studio Enterprise subscription.

This document is programmatically generated using a PowerShell script.

Date: 2024-04-01 15:13:08

Logic App Workflow Diagram

graph TB
    Trigger
    subgraph bnAddPeoplePart_eq_true-False
    direction TB
        addPeoplePart
    end
    subgraph bnAddPeoplePart_eq_true-True
    direction TB
        addPeoplePart___Accountmanager
    end
    subgraph Catch
    direction TB
        ExtractLogicAppError
        set_intResponseCode_Catch
        set_strResponseText_Catch
    end
    subgraph CompanyName_eq_INIT___Site_created-True
    direction TB
        Post_message_in_a_chat_or_channel
    end
    subgraph CompanyName_eq_INIT-True
    direction TB
        getAccountCreatorProfile
        messageToAccountCreator
    end
    subgraph Condition-False
    direction TB
        markCustomerAsComplete
    end
    subgraph Condition-True
    direction TB
        la-createATTicket
        setDueDateTime
    end
    subgraph doBudgetsAndContractsStuff
    direction TB
        addColumnDefaultValue___Customer___Budgets_and_Contracts
        addContentTypeToList___Budgetsdocument
        addContentTypeToList___Contractsdocument
        addFolder___Budgets
        addFolder___Contracts
        addListOrLibrary___Budgets_and_Contracts
        addView___Budgets_and_Contracts
        removeContentTypeFromList____Budgets_and_Contracts
    end
    subgraph doChangesStuff
    direction TB
        addColumnDefaultValue___Customer___Changes
        addContentTypeToList___Changes
        addContentTypeToList___Changes_folder
        addContentTypeToList___RFC_Formulier
        addContentTypeToList___RFC_Formulier_-_BND
        addContentTypeToList___RFC_Formulier_-_ENZA
        addListOrLibrary___Changes
        addView___Changes
        removeContentTypeFromList___Changes
        updateColumn___Changes___gi-autotaskLink
        updateColumn___Changes___gi-change
        updateColumn___Changes___gi-changeStatus
        updateColumn___Changes___gi-customer
    end
    subgraph doDocumentsStuff
    direction TB
        addColumnDefaultValue___Customer___Documenten
        addContentTypeToList___Documenten
        addContentTypeToList___Documenten_folder
        addView___Documenten
        allowContentTypesOnList___Documenten
        enableFolderCreation
        removeContentTypeFromList___Documenten
    end
    subgraph doNavigationStuff
    direction TB
        AddAutotaskLink
        addITGlueLink
        addProjectenLink
        removeNavigationNode___Paginas
        removeNavigationNode___Site-inhoud
    end
    subgraph doOpportunitiesStuff
    direction TB
        addColumnDefaultValue___Customer___Opportunities
        addContentTypeToList___Opportunities
        addContentTypeToList___Opportunities_folder
        addListOrLibrary___Opportunities
        addView___Opportunities
        removeContentTypeFromList___Opportunities
        updateColumn___Opportunities___gi-autotaskLink
        updateColumn___Opportunities___gi-customer
        updateColumn___Opportunities___gi-opportunity
        updateColumn___Opportunities___gi-opportunityStatus
    end
    subgraph doPermissionStuff
    direction TB
        addAdministratieToBudgetsContractsGroup
        addBackofficeToContributorsGroup
        addGIAlgemeenToChangeContributorsGroup
        addManagementToBudgetsContractsGroup
        addManagementToContributorsGroup
        addManagementToServicemanagementGroup
        addSalesToBudgetsContractsGroup
        addSalesToContributorsGroup
        addSalesToServicemanagementGroup
        addServiceManagementToBudgetsContractsGroup
        addServicemanagementToServicemanagementGroup
        breakRoleinheritanceBudgetsContracts
        breakRoleinheritanceChanges
        breakRoleinheritanceServicemanagement
        createBudgetsContractsGroup
        createChangeContributorsGroup
        createContributorsGroup
        createServicemanagementGroup
        grantBudgetsContractsGroupContributorRights
        grantChangeContributorsGroupContributorRights
        grantContributorsGroupContributorRights
        grantServicemanagementGroupContributorRights
        la-removeOnwantedCharacters
    end
    subgraph doServicemanagementStuff
    direction TB
        addColumnDefaultValue___Customer___Servicemanagement
        addContentTypeToList___Servicemanagement
        addListOrLibrary___Servicemanagement
        addView___Servicemanagement
        removeContentTypeFromList___Servicemanagement
    end
    subgraph doWebpartStuff
    direction TB
        addFirstSectionToPage
        addWebPart___SiteActivity
        bnAddPeoplePart_eq_true
        setHomepage
    end
    subgraph Finally
    direction TB
        Condition
        Response
    end
    subgraph getSecrets
    direction TB
        get-GraphApplicationID
        get-GraphSecret
        get-GraphTenantID
        get-atApiIntegrationCode
        get-atSecret
        get-atUsername
        get-itgAPIKey
    end
    subgraph ITGlue_ingericht_-True
    direction TB
        set_strITGlueNumber
        updateITGlueSiteColumn
    end
    subgraph Try
    direction TB
        CompanyName_eq_INIT
        CompanyName_eq_INIT___Site_created
        ITGlue_ingericht_
        addTerm
        applySiteDesign
        createSite
        delay___applySiteDesign
        delay___createSite_
        doBudgetsAndContractsStuff
        doChangesStuff
        doDocumentsStuff
        doNavigationStuff
        doOpportunitiesStuff
        doPermissionStuff
        doServicemanagementStuff
        doWebpartStuff
        getAccountCreator
        getAccountManager
        getAccountTeam
        getCompany
        getITGlueID
        getSecrets
        parseAccountCreator
        parseAccountManager
        parseCompany
        parseITGlueID
        set_strMailbody___AccountCreator
        set_strSiteName
        switchAccountmanger
        updateAutotaksColumn
        updateColumn___Budgets_and_Contracts___gi-customer
        updateColumn___Documenten___gi-customer
        updateColumn___Servicemanagement___gi-customer
        updateKlantColumn
        updateKlantsiteColumn
    end
    Try --> Catch
    Catch --> ExtractLogicAppError
    ExtractLogicAppError --> set_intResponseCode_Catch
    set_intResponseCode_Catch --> set_strResponseText_Catch
    Catch --> Finally
    Finally --> Condition
    setDueDateTime --> la-createATTicket
    Condition --> setDueDateTime
    Condition --> markCustomerAsComplete
    Condition --> Response
    init_bnAddPeoplePart --> Try
    parseAccountCreator --> CompanyName_eq_INIT
    CompanyName_eq_INIT --> getAccountCreatorProfile
    getAccountCreatorProfile --> messageToAccountCreator
    set_strMailbody___AccountCreator --> CompanyName_eq_INIT___Site_created
    CompanyName_eq_INIT___Site_created --> Post_message_in_a_chat_or_channel
    updateAutotaksColumn --> ITGlue_ingericht_
    ITGlue_ingericht_ --> set_strITGlueNumber
    set_strITGlueNumber --> updateITGlueSiteColumn
    parseCompany --> addTerm
    delay___createSite_ --> applySiteDesign
    ITGlue_ingericht_ --> createSite
    applySiteDesign --> delay___applySiteDesign
    createSite --> delay___createSite_
    doChangesStuff --> doBudgetsAndContractsStuff
    removeContentTypeFromList____Budgets_and_Contracts --> addColumnDefaultValue___Customer___Budgets_and_Contracts
    addListOrLibrary___Budgets_and_Contracts --> addContentTypeToList___Budgetsdocument
    addContentTypeToList___Budgetsdocument --> addContentTypeToList___Contractsdocument
    addView___Budgets_and_Contracts --> addFolder___Budgets
    addFolder___Budgets --> addFolder___Contracts
    doBudgetsAndContractsStuff --> addListOrLibrary___Budgets_and_Contracts
    addColumnDefaultValue___Customer___Budgets_and_Contracts --> addView___Budgets_and_Contracts
    addContentTypeToList___Contractsdocument --> removeContentTypeFromList____Budgets_and_Contracts
    doOpportunitiesStuff --> doChangesStuff
    addView___Changes --> addColumnDefaultValue___Customer___Changes
    addListOrLibrary___Changes --> addContentTypeToList___Changes
    addContentTypeToList___RFC_Formulier_-_ENZA --> addContentTypeToList___Changes_folder
    addContentTypeToList___Changes --> addContentTypeToList___RFC_Formulier
    addContentTypeToList___RFC_Formulier --> addContentTypeToList___RFC_Formulier_-_BND
    addContentTypeToList___RFC_Formulier_-_BND --> addContentTypeToList___RFC_Formulier_-_ENZA
    doChangesStuff --> addListOrLibrary___Changes
    removeContentTypeFromList___Changes --> addView___Changes
    addContentTypeToList___Changes_folder --> removeContentTypeFromList___Changes
    updateColumn___Changes___gi-changeStatus --> updateColumn___Changes___gi-autotaskLink
    updateColumn___Changes___gi-customer --> updateColumn___Changes___gi-change
    updateColumn___Changes___gi-change --> updateColumn___Changes___gi-changeStatus
    addColumnDefaultValue___Customer___Changes --> updateColumn___Changes___gi-customer
    delay___applySiteDesign --> doDocumentsStuff
    removeContentTypeFromList___Documenten --> addColumnDefaultValue___Customer___Documenten
    allowContentTypesOnList___Documenten --> addContentTypeToList___Documenten
    addContentTypeToList___Documenten --> addContentTypeToList___Documenten_folder
    addColumnDefaultValue___Customer___Documenten --> addView___Documenten
    doDocumentsStuff --> allowContentTypesOnList___Documenten
    addContentTypeToList___Documenten_folder --> enableFolderCreation
    enableFolderCreation --> removeContentTypeFromList___Documenten
    doWebpartStuff --> doNavigationStuff
    doNavigationStuff --> AddAutotaskLink
    AddAutotaskLink --> addITGlueLink
    addITGlueLink --> addProjectenLink
    removeNavigationNode___Site-inhoud --> removeNavigationNode___Paginas
    addProjectenLink --> removeNavigationNode___Site-inhoud
    doDocumentsStuff --> doOpportunitiesStuff
    addView___Opportunities --> addColumnDefaultValue___Customer___Opportunities
    addListOrLibrary___Opportunities --> addContentTypeToList___Opportunities
    addContentTypeToList___Opportunities --> addContentTypeToList___Opportunities_folder
    doOpportunitiesStuff --> addListOrLibrary___Opportunities
    removeContentTypeFromList___Opportunities --> addView___Opportunities
    addContentTypeToList___Opportunities_folder --> removeContentTypeFromList___Opportunities
    updateColumn___Opportunities___gi-opportunityStatus --> updateColumn___Opportunities___gi-autotaskLink
    addColumnDefaultValue___Customer___Opportunities --> updateColumn___Opportunities___gi-customer
    updateColumn___Opportunities___gi-customer --> updateColumn___Opportunities___gi-opportunity
    updateColumn___Opportunities___gi-opportunity --> updateColumn___Opportunities___gi-opportunityStatus
    doNavigationStuff --> doPermissionStuff
    addSalesToBudgetsContractsGroup --> addAdministratieToBudgetsContractsGroup
    addManagementToContributorsGroup --> addBackofficeToContributorsGroup
    createChangeContributorsGroup --> addGIAlgemeenToChangeContributorsGroup
    addAdministratieToBudgetsContractsGroup --> addManagementToBudgetsContractsGroup
    addSalesToContributorsGroup --> addManagementToContributorsGroup
    addSalesToServicemanagementGroup --> addManagementToServicemanagementGroup
    createBudgetsContractsGroup --> addSalesToBudgetsContractsGroup
    createContributorsGroup --> addSalesToContributorsGroup
    addServicemanagementToServicemanagementGroup --> addSalesToServicemanagementGroup
    addManagementToBudgetsContractsGroup --> addServiceManagementToBudgetsContractsGroup
    createServicemanagementGroup --> addServicemanagementToServicemanagementGroup
    addServiceManagementToBudgetsContractsGroup --> breakRoleinheritanceBudgetsContracts
    addGIAlgemeenToChangeContributorsGroup --> breakRoleinheritanceChanges
    addManagementToServicemanagementGroup --> breakRoleinheritanceServicemanagement
    grantServicemanagementGroupContributorRights --> createBudgetsContractsGroup
    grantContributorsGroupContributorRights --> createChangeContributorsGroup
    grantBudgetsContractsGroupContributorRights --> createContributorsGroup
    la-removeOnwantedCharacters --> createServicemanagementGroup
    breakRoleinheritanceBudgetsContracts --> grantBudgetsContractsGroupContributorRights
    breakRoleinheritanceChanges --> grantChangeContributorsGroupContributorRights
    addBackofficeToContributorsGroup --> grantContributorsGroupContributorRights
    breakRoleinheritanceServicemanagement --> grantServicemanagementGroupContributorRights
    doPermissionStuff --> la-removeOnwantedCharacters
    doBudgetsAndContractsStuff --> doServicemanagementStuff
    removeContentTypeFromList___Servicemanagement --> addColumnDefaultValue___Customer___Servicemanagement
    addListOrLibrary___Servicemanagement --> addContentTypeToList___Servicemanagement
    doServicemanagementStuff --> addListOrLibrary___Servicemanagement
    addColumnDefaultValue___Customer___Servicemanagement --> addView___Servicemanagement
    addContentTypeToList___Servicemanagement --> removeContentTypeFromList___Servicemanagement
    doServicemanagementStuff --> doWebpartStuff
    setHomepage --> addFirstSectionToPage
    addFirstSectionToPage --> addWebPart___SiteActivity
    addWebPart___SiteActivity --> bnAddPeoplePart_eq_true
    bnAddPeoplePart_eq_true --> addPeoplePart___Accountmanager
    bnAddPeoplePart_eq_true --> addPeoplePart
    doWebpartStuff --> setHomepage
    set_strSiteName --> getAccountCreator
    CompanyName_eq_INIT --> getAccountManager
    parseAccountManager --> getAccountTeam
    getSecrets --> getCompany
    getAccountTeam --> getITGlueID
    Try --> getSecrets
    get-atUsername --> get-GraphApplicationID
    get-GraphApplicationID --> get-GraphSecret
    get-GraphSecret --> get-GraphTenantID
    getSecrets --> get-atApiIntegrationCode
    get-atApiIntegrationCode --> get-atSecret
    get-atSecret --> get-atUsername
    get-GraphTenantID --> get-itgAPIKey
    getAccountCreator --> parseAccountCreator
    getAccountManager --> parseAccountManager
    getCompany --> parseCompany
    getITGlueID --> parseITGlueID
    updateColumn___Documenten___gi-customer --> set_strMailbody___AccountCreator
    addTerm --> set_strSiteName
    parseITGlueID --> switchAccountmanger
    updateKlantsiteColumn --> updateAutotaksColumn
    updateColumn___Servicemanagement___gi-customer --> updateColumn___Budgets_and_Contracts___gi-customer
    updateColumn___Budgets_and_Contracts___gi-customer --> updateColumn___Documenten___gi-customer
    doPermissionStuff --> updateColumn___Servicemanagement___gi-customer
    switchAccountmanger --> updateKlantColumn
    updateKlantColumn --> updateKlantsiteColumn
    init_strITGlueNumber --> init_bnAddPeoplePart
    init_strSiteName --> init_intResponseCode
    init_strMailBody --> init_strITGlueNumber
    init_strResponseText --> init_strMailBody
    init_intResponseCode --> init_strResponseText
    init_intKlantListID --> init_strSiteName
    Trigger --> init_intKlantListID

Logic App Workflow Actions

This section shows an overview of Logic App Workflow actions and their dependencies.

Actions

ActionName Type RunAfter Inputs
init_intKlantListID InitializeVariable
{
"variables": [
{
"name": "intKlantListID",
"type": "integer"
}
]
}
init_strSiteName InitializeVariable init_intKlantListID
{
"variables": [
{
"name": "strSiteName",
"type": "string"
}
]
}
init_intResponseCode InitializeVariable init_strSiteName
{
"variables": [
{
"name": "intResponseCode",
"type": "integer",
"value": 200
}
]
}
init_strResponseText InitializeVariable init_intResponseCode
{
"variables": [
{
"name": "strResponseText",
"type": "string",
"value": "Company created"
}
]
}
init_strMailBody InitializeVariable init_strResponseText
{
"variables": [
{
"name": "strMailBody",
"type": "string"
}
]
}
init_strITGlueNumber InitializeVariable init_strMailBody
{
"variables": [
{
"name": "strITGlueNumber",
"type": "string"
}
]
}
init_bnAddPeoplePart InitializeVariable init_strITGlueNumber
{
"variables": [
{
"name": "bnAddPeoplePart",
"type": "boolean",
"value": "@false"
}
]
}
Try Scope init_bnAddPeoplePart null
getSecrets Scope Try null
get-atApiIntegrationCode ApiConnection getSecrets
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('at-ApiIntegrationCode')}/value"
}
get-atSecret ApiConnection get-atApiIntegrationCode
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('at-Secret')}/value"
}
get-atUsername ApiConnection get-atSecret
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('at-UserName')}/value"
}
get-GraphApplicationID ApiConnection get-atUsername
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('kg-GraphApplicatonID')}/value"
}
get-GraphSecret ApiConnection get-GraphApplicationID
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('kg-GraphSecret')}/value"
}
get-GraphTenantID ApiConnection get-GraphSecret
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('kg-GraphTenantID')}/value"
}
get-itgAPIKey ApiConnection get-GraphTenantID
{
"host": {
"connection": {
"name": "@parameters('$connections')['keyvault']['connectionId']"
}
},
"method": "get",
"path": "/secrets/@{encodeURIComponent('itg-APIKey')}/value"
}
getCompany Http Try
{
"headers": {
"ApiIntegrationCode": "@body('get-atApiIntegrationCode')?['value']",
"Cache-Control": "no-cache",
"Content-Type": "application/json",
"Secret": "@body('get-atSecret')?['value']",
"UserName": "@body('get-atUsername')?['value']"
},
"method": "GET",
"uri": "https://webservices19.autotask.net/atservicesrest/v1.0/Companies/@{triggerBody()?['Id']}"
}
parseCompany ParseJson getCompany
{
"content": "@body('getCompany')",
"schema": {
"properties": {
"item": {
"properties": {
"companyName": {
"type": "string"
},
"companyNumber": {
"type": "string"
},
"companyType": {
"type": "integer"
},
"createdByResourceID": {
"type": "integer"
},
"id": {
"type": "integer"
},
"isActive": {
"type": "boolean"
},
"lastActivityDate": {
"type": "string"
},
"ownerResourceID": {
"type": "integer"
}
},
"type": "object"
}
},
"type": "object"
}
}
addTerm Function parseCompany
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"casite": "https://xxxx-admin.sharepoint.com",
"keyVault": "xxxx",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"sleep": 5,
"termgroup": "GI",
"termname": "@{trim(body('parseCompany')?['item']?['companyName'])}",
"termset": "Customers"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addTerm"
},
"retryPolicy": {
"type": "none"
}
}
set_strSiteName SetVariable addTerm
{
"name": "strSiteName",
"value": "https://xxxx.sharepoint.com/sites/@{body('parseCompany')?['item']?['id']}"
}
getAccountCreator Http set_strSiteName
{
"headers": {
"ApiIntegrationCode": "@body('get-atApiIntegrationCode')?['value']",
"Cache-Control": "no-cache",
"Content-Type": "application/json",
"Secret": "@body('get-atSecret')?['value']",
"UserName": "@body('get-atUsername')?['value']"
},
"method": "GET",
"uri": "https://webservices19.autotask.net/atservicesrest/v1.0/Resources/@{body('parseCompany')?['item']?['createdByResourceID']}"
}
parseAccountCreator ParseJson getAccountCreator
{
"content": "@body('getAccountCreator')",
"schema": {
"properties": {
"item": {
"properties": {
"email": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
}
CompanyName_eq_INIT If parseAccountCreator null
getAccountCreatorProfile ApiConnection CompanyName_eq_INIT-True
{
"host": {
"connection": {
"name": "@parameters('$connections')['office365users']['connectionId']"
}
},
"method": "get",
"path": "/codeless/v1.0/users/@{encodeURIComponent(body('parseAccountCreator')?['item']?['email'])}"
}
messageToAccountCreator ApiConnection getAccountCreatorProfile
{
"body": {
"messageBody": "

Hey @{body('getAccountCreatorProfile')?['givenName']},
\n
\nJe hebt een nieuw account gemaakt in Autotask waarvan jij ook de account manager bent. Op dit moment wordt de site voor deze klant gemaakt. Ik hou je op de hoogte van het maken van deze site.

",
"recipient": "@body('getAccountCreatorProfile')?['userPrincipalName']"
},
"host": {
"connection": {
"name": "@parameters('$connections')['teams']['connectionId']"
}
},
"method": "post",
"path": "/beta/teams/conversation/message/poster/Flow bot/location/@{encodeURIComponent('Chat with Flow bot')}"
}
getAccountManager Http Try
{
"headers": {
"ApiIntegrationCode": "@body('get-atApiIntegrationCode')?['value']",
"Cache-Control": "no-cache",
"Content-Type": "application/json",
"Secret": "@body('get-atSecret')?['value']",
"UserName": "@body('get-atUsername')?['value']"
},
"method": "GET",
"uri": "https://webservices19.autotask.net/atservicesrest/v1.0/Resources/@{body('parseCompany')?['item']?['ownerResourceID']}"
}
parseAccountManager ParseJson getAccountManager
{
"content": "@body('getAccountManager')",
"schema": {
"properties": {
"item": {
"properties": {
"email": {
"type": "string"
},
"isActive": {
"type": "boolean"
},
"userName": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
}
getAccountTeam Http parseAccountManager
{
"headers": {
"ApiIntegrationCode": "@body('get-atApiIntegrationCode')?['value']",
"Cache-Control": "no-cache",
"Content-Type": "application/json",
"Secret": "@body('get-atSecret')?['value']",
"UserName": "@body('get-atUsername')?['value']"
},
"method": "GET",
"queries": {
"search": "{"filter":[{"op":"eq","field":"CompanyID","value":@{body('parseCompany')?['item']?['id']}}]}"
},
"uri": "https://webservices19.autotask.net/atservicesrest/v1.0/CompanyTeams/query"
}
getITGlueID Http getAccountTeam
{
"headers": {
"Content-Type": "application/vnd.api+json",
"x-api-key": "@body('get-itgAPIKey')?['value']"
},
"method": "GET",
"queries": {
"filter[name]": "@body('parseCompany')?['item']?['companyName']"
},
"uri": "https://api.eu.itglue.com/organizations"
}
parseITGlueID ParseJson getITGlueID
{
"content": "@body('getITGlueID')",
"schema": {
"properties": {
"data": {
"items": {
"properties": {
"id": {
"type": "string"
},
"type": {
"type": "string"
}
},
"required": [
"id",
"type"
],
"type": "object"
},
"type": "array"
},
"meta": {
"properties": {
"current-page": {
"type": "integer"
},
"next-page": {},
"prev-page": {},
"total-count": {
"type": "integer"
},
"total-pages": {
"type": "integer"
}
},
"type": "object"
}
},
"type": "object"
}
}
switchAccountmanger Switch parseITGlueID null
updateKlantColumn ApiConnection switchAccountmanger
{
"body": {
"body": "{\n "formValues":[\n\t{\n\t "FieldName": "gi_x002d_customer",\n\t "FieldValue": "@{body('addTerm')}"\n\t}\n ]\n}",
"method": "POST",
"uri": "_api/web/lists/GetByTitle('Customers')/items(@{variables('intKlantListID')})/validateUpdateListItem"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/sites/portal'))}/httprequest"
}
updateKlantsiteColumn ApiConnection updateKlantColumn
{
"body": {
"body": "{\n\t"__metadata": {\n\t\t"type": "SP.Data.CustomersListItem"\n\t},\n\t"gi_x002d_customerSite": {\n\t\t"Description": "@{body('parseCompany')?['item']?['companyName']}",\n\t\t"Url": "@{variables('strSiteName')}"\n\t}\n}",
"headers": {
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/GetByTitle('Customers')/items(@{variables('intKlantListID')})"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/sites/portal'))}/httprequest"
}
updateAutotaksColumn ApiConnection updateKlantsiteColumn
{
"body": {
"body": "{\n\t"__metadata": {\n\t\t"type": "SP.Data.CustomersListItem"\n\t},\n\t"gi_x002d_autotaskLink": {\n\t\t"Description": "Autotask",\n\t\t"Url": "https://ww19.autotask.net/Autotask/AutotaskExtend/ExecuteCommand.aspx?Code=OpenAccount&AccountID=@{body('parseCompany')?['item']?['id']}\"\n\t}\n}",
"headers": {
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/GetByTitle('Customers')/items(@{variables('intKlantListID')})"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/sites/portal'))}/httprequest"
}
ITGlue_ingericht_ If updateAutotaksColumn null
set_strITGlueNumber SetVariable ITGlue_ingericht_-True
{
"name": "strITGlueNumber",
"value": "@{body('parseITGlueID')?['data'][0]['id']}"
}
updateITGlueSiteColumn ApiConnection set_strITGlueNumber
{
"body": {
"body": "{\n\t"__metadata": {\n\t\t"type": "SP.Data.CustomersListItem"\n\t},\n\t"gi_x002d_itglueLink": {\n\t\t"Description": "IT Glue",\n\t\t"Url": "https://giant-ict.eu.itglue.com/@{variables('strITGlueNumber')}\"\n\t}\n}",
"headers": {
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/GetByTitle('Customers')/items(@{variables('intKlantListID')})"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/sites/portal'))}/httprequest"
}
createSite ApiConnection Try
{
"body": {
"body": "{\n "request": {\n "Title": "@{body('parseCompany')?['item']?['id']}-@{body('parseCompany')?['item']?['companyName']}",\n "Url":"@{variables('strSiteName')}",\n "Lcid": 1043,\n "ShareByEmailEnabled":false,\n "Description":"@{body('parseCompany')?['item']?['id']}-@{body('parseCompany')?['item']?['companyName']}",\n "WebTemplate":"STS#3",\n "Owner":"sa-powerplatform@giant.nl",\n"SiteDesignId":"f6cc5403-0d63-442e-96c0-285923709ffc"\n }\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/SPSiteManager/create"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/'))}/httprequest"
}
delay___createSite_ Wait createSite
{
"interval": {
"count": 30,
"unit": "Second"
}
}
applySiteDesign ApiConnection delay___createSite_
{
"body": {
"body": "{\n "siteDesignId": "5b977fdd-b083-40f7-ba4f-fbffc20fd6ff"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "/_api/Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptUtility.AddSiteDesignTaskToCurrentWeb"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
delay___applySiteDesign Wait applySiteDesign
{
"interval": {
"count": 30,
"unit": "Second"
}
}
doDocumentsStuff Scope delay___applySiteDesign null
allowContentTypesOnList___Documenten Function doDocumentsStuff
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"keyVault": "xxxx",
"listname": "Gedeelde documenten",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"value": 1
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/allowContentTypesOnList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Documenten Function allowContentTypesOnList___Documenten
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Gedeelde documenten",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Documenten_folder Function addContentTypeToList___Documenten
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Gedeelde documenten",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
enableFolderCreation Function addContentTypeToList___Documenten_folder
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"docLib": "Documenten",
"enable": 0,
"keyVault": "xxxx",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/enableFolderCreation"
},
"retryPolicy": {
"type": "none"
}
}
removeContentTypeFromList___Documenten Function enableFolderCreation
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypename": "Document",
"keyVault": "xxxx",
"listname": "Gedeelde documenten",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeContentTypeFromList"
},
"retryPolicy": {
"type": "none"
}
}
addColumnDefaultValue___Customer___Documenten Function removeContentTypeFromList___Documenten
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"field": "gi_x002d_customer",
"folder": "",
"keyVault": "xxxx",
"list": "Documenten",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"termgroup": "GI",
"termset": "Customers",
"type": "term",
"value": "@{body('parseCompany')?['item']?['companyName']}"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addColumnDefaultValue"
},
"retryPolicy": {
"type": "none"
}
}
addView___Documenten Function addColumnDefaultValue___Customer___Documenten
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"default": true,
"fieldstring": "Type
doOpportunitiesStuff Scope Try null
addListOrLibrary___Opportunities Function doOpportunitiesStuff
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"disableFolderCreation": true,
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"template": "DocumentLibrary",
"title": "Opportunity documents"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addListOrLibrary"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Opportunities Function addListOrLibrary___Opportunities
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Opportunity documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Opportunities_folder Function addContentTypeToList___Opportunities
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Opportunity documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
removeContentTypeFromList___Opportunities Function addContentTypeToList___Opportunities_folder
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypename": "Document",
"keyVault": "xxxx",
"listname": "Opportunity documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeContentTypeFromList"
},
"retryPolicy": {
"type": "none"
}
}
addView___Opportunities Function removeContentTypeFromList___Opportunities
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"default": true,
"fieldstring": "Type
addColumnDefaultValue___Customer___Opportunities Function addView___Opportunities
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"field": "gi_x002d_customer",
"folder": "",
"keyVault": "xxxx",
"list": "Opportunity documents",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"termgroup": "GI",
"termset": "Customers",
"type": "term",
"value": "@{body('parseCompany')?['item']?['companyName']}"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addColumnDefaultValue"
}
}
updateColumn___Opportunities___gi-customer ApiConnection addColumnDefaultValue___Customer___Opportunities
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Customer'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Opportunity documents')/Fields/getbytitle('gi-customer')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Opportunities___gi-opportunity ApiConnection updateColumn___Opportunities___gi-customer
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Opportunity'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Opportunity documents')/Fields/getbytitle('gi-opportunity')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Opportunities___gi-opportunityStatus ApiConnection updateColumn___Opportunities___gi-opportunity
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Opportunity status'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Opportunity documents')/Fields/getbytitle('gi-opportunityStatus')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Opportunities___gi-autotaskLink ApiConnection updateColumn___Opportunities___gi-opportunityStatus
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'AT Link'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Opportunity documents')/Fields/getbytitle('gi-autotaskLink')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
doChangesStuff Scope Try null
addListOrLibrary___Changes Function doChangesStuff
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"disableFolderCreation": true,
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"template": "DocumentLibrary",
"title": "Change documents"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addListOrLibrary"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Changes Function addListOrLibrary___Changes
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Change documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___RFC_Formulier Function addContentTypeToList___Changes
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Change documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___RFC_Formulier_-_BND Function addContentTypeToList___RFC_Formulier
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Change documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___RFC_Formulier_-_ENZA Function addContentTypeToList___RFC_Formulier_-_BND
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Change documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Changes_folder Function addContentTypeToList___RFC_Formulier_-_ENZA
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Change documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
removeContentTypeFromList___Changes Function addContentTypeToList___Changes_folder
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypename": "Document",
"keyVault": "xxxx",
"listname": "Change documents",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeContentTypeFromList"
},
"retryPolicy": {
"type": "none"
}
}
addView___Changes Function removeContentTypeFromList___Changes
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"default": true,
"fieldstring": "Type
addColumnDefaultValue___Customer___Changes Function addView___Changes
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"field": "gi_x002d_customer",
"folder": "",
"keyVault": "xxxx",
"list": "Change documents",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"termgroup": "GI",
"termset": "Customers",
"type": "term",
"value": "@{body('parseCompany')?['item']?['companyName']}"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addColumnDefaultValue"
}
}
updateColumn___Changes___gi-customer ApiConnection addColumnDefaultValue___Customer___Changes
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Customer'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Change documents')/Fields/getbytitle('gi-customer')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Changes___gi-change ApiConnection updateColumn___Changes___gi-customer
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Change'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Change documents')/Fields/getbytitle('gi-change')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Changes___gi-changeStatus ApiConnection updateColumn___Changes___gi-change
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Change status'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Change documents')/Fields/getbytitle('gi-changeStatus')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Changes___gi-autotaskLink ApiConnection updateColumn___Changes___gi-changeStatus
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'AT Link'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Change documents')/Fields/getbytitle('gi-autotaskLink')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
doBudgetsAndContractsStuff Scope Try null
addListOrLibrary___Budgets_and_Contracts Function doBudgetsAndContractsStuff
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"disableFolderCreation": false,
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"template": "DocumentLibrary",
"title": "Budgets and Contracts"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addListOrLibrary"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Budgetsdocument Function addListOrLibrary___Budgets_and_Contracts
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Budgets and Contracts",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Contractsdocument Function addContentTypeToList___Budgetsdocument
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 0,
"keyVault": "xxxx",
"listname": "Budgets and Contracts",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
removeContentTypeFromList____Budgets_and_Contracts Function addContentTypeToList___Contractsdocument
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypename": "Document",
"keyVault": "xxxx",
"listname": "Budgets and Contracts",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeContentTypeFromList"
},
"retryPolicy": {
"type": "none"
}
}
addColumnDefaultValue___Customer___Budgets_and_Contracts Function removeContentTypeFromList____Budgets_and_Contracts
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"field": "gi_x002d_customer",
"folder": "",
"keyVault": "xxxx",
"list": "Budgets and Contracts",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"termgroup": "GI",
"termset": "Customers",
"type": "term",
"value": "@{body('parseCompany')?['item']?['companyName']}"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addColumnDefaultValue"
},
"retryPolicy": {
"type": "none"
}
}
addView___Budgets_and_Contracts Function addColumnDefaultValue___Customer___Budgets_and_Contracts
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"default": true,
"fieldstring": "Type
addFolder___Budgets Function addView___Budgets_and_Contracts
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"documentLibrary": "Budgets and Contracts",
"folderColor": "1",
"folderName": "Budgets",
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 60
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addFolder"
}
}
addFolder___Contracts Function addFolder___Budgets
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"documentLibrary": "Budgets and Contracts",
"folderColor": "3",
"folderName": "Contracts",
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 60
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addFolder"
}
}
doServicemanagementStuff Scope Try null
addListOrLibrary___Servicemanagement Function doServicemanagementStuff
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"disableFolderCreation": false,
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"template": "DocumentLibrary",
"title": "Servicemanagement"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addListOrLibrary"
},
"retryPolicy": {
"type": "none"
}
}
addContentTypeToList___Servicemanagement Function addListOrLibrary___Servicemanagement
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypeid": "xxxx",
"default": 1,
"keyVault": "xxxx",
"listname": "Servicemanagement",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addContentTypeToList"
},
"retryPolicy": {
"type": "none"
}
}
removeContentTypeFromList___Servicemanagement Function addContentTypeToList___Servicemanagement
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"contenttypename": "Document",
"keyVault": "xxxx",
"listname": "Servicemanagement",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeContentTypeFromList"
},
"retryPolicy": {
"type": "none"
}
}
addColumnDefaultValue___Customer___Servicemanagement Function removeContentTypeFromList___Servicemanagement
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"field": "gi_x002d_customer",
"folder": "",
"keyVault": "xxxx",
"list": "Servicemanagement",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"termgroup": "GI",
"termset": "Customers",
"type": "term",
"value": "@{body('parseCompany')?['item']?['companyName']}"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addColumnDefaultValue"
},
"retryPolicy": {
"type": "none"
}
}
addView___Servicemanagement Function addColumnDefaultValue___Customer___Servicemanagement
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"default": true,
"fieldstring": "Type
doWebpartStuff Scope Try null
setHomepage Function doWebpartStuff
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"docLib": "SitePages",
"keyVault": "xxxx",
"pageName": "home.aspx",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"site": "@{variables('strSiteName')}",
"sleep": 10
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/setHomepage"
},
"retryPolicy": {
"type": "none"
}
}
addFirstSectionToPage Function setHomepage
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"keyVault": "xxxx",
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "PnPThumbprint",
"sectionOrderIdx": 1,
"sectionTemplate": "TwoColumnLeft",
"site": "@{variables('strSiteName')}",
"sleep": 10,
"zoneEmphasis": 0
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addSectionToPage"
},
"retryPolicy": {
"type": "none"
}
}
addWebPart___SiteActivity Function addFirstSectionToPage
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"column": 1,
"keyVault": "xxxx",
"order": 0,
"pageName": "home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"section": 1,
"site": "@{variables('strSiteName')}",
"sleep": 10,
"webpartType": "SiteActivity"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addWebPart"
},
"retryPolicy": {
"type": "none"
}
}
bnAddPeoplePart_eq_true If addWebPart___SiteActivity null
addPeoplePart___Accountmanager Function bnAddPeoplePart_eq_true-True
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"cardName": "Account team",
"column": 2,
"keyVault": "xxxx",
"pageName": "Home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"section": 1,
"site": "@{variables('strSiteName')}",
"sleep": 0,
"users": "[{'mail':'@{body('parseAccountManager')?['item']?['email']}', 'role':'' }]"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addPeoplePart"
},
"retryPolicy": {
"type": "none"
}
}
addPeoplePart Function bnAddPeoplePart_eq_true-False
{
"body": {
"adminsite": "https://xxxx.sharepoint.com/sites/gi-site-provisioning",
"cardName": "Account team",
"column": 2,
"keyVault": "xxxx",
"pageName": "Home",
"pnpApplicationIDKey": "PnPApplicationID",
"pnpThumbprintKey": "pnpThumbprint",
"section": 1,
"site": "@{variables('strSiteName')}",
"sleep": 0,
"users": "[{'mail':'@{body('parseAccountCreator')?['item']?['email']}', 'role':'' }]"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/addPeoplePart"
},
"retryPolicy": {
"type": "none"
}
}
doNavigationStuff Scope Try null
AddAutotaskLink ApiConnection doNavigationStuff
{
"body": {
"body": "{\n "__metadata": {\n "type": "SP.NavigationNode"\n },\n "IsExternal": true,\n "Title": "Autotask", \n "Url": "https://ww19.autotask.net/Autotask/AutotaskExtend/ExecuteCommand.aspx?Code=OpenAccount&AccountID=@{body('parseCompany')?['item']?['id']}\"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "/_api/web/navigation/QuickLaunch"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
addITGlueLink ApiConnection AddAutotaskLink
{
"body": {
"body": "{\n "__metadata": {\n "type": "SP.NavigationNode"\n },\n "IsExternal": true,\n "Title": "IT Glue", \n "Url": "https://giant-ict.eu.itglue.com/@{variables('strITGlueNumber')}\"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "/_api/web/navigation/QuickLaunch"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
addProjectenLink ApiConnection addITGlueLink
{
"body": {
"body": "{\n "__metadata": {\n "type": "SP.NavigationNode"\n },\n "IsExternal": true,\n "Title": "Projects", \n "Url": "https://xxxx.sharepoint.com/sites/gi-projectsportal/projects/Projects.aspx?FilterField1=gi%5Fx002d%5Fcustomer&FilterValue1=@{body('parseCompany')?['item']?['companyName']}&FilterType1=TaxonomyFieldType&viewid=5599a12e%2D3077%2D464e%2D9076%2D25adb20042c7\"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "/_api/web/navigation/QuickLaunch"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
removeNavigationNode___Site-inhoud ApiConnection addProjectenLink
{
"body": {
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "DELETE",
"uri": "/_api/web/navigation/QuickLaunch(1034)"
},
"function": "{"id":"/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeNavigationNode"}",
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest",
"retryPolicy": {
"type": "none"
}
}
removeNavigationNode___Paginas ApiConnection removeNavigationNode___Site-inhoud
{
"body": {
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "DELETE",
"uri": "/_api/web/navigation/QuickLaunch(2003)"
},
"function": "{"id":"/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-rg/providers/Microsoft.Web/sites/fa-siteprovisioning-ps/functions/removeNavigationNode"}",
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest",
"retryPolicy": {
"type": "none"
}
}
doPermissionStuff Scope Try null
la-removeOnwantedCharacters Workflow doPermissionStuff
{
"body": {
"strToModify": "{"@{body('parseCompany')?['item']?['id']}-@{body('parseCompany')?['item']?['companyName']}"}"
},
"host": {
"triggerName": "manual",
"workflow": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/customer-automation-rg/providers/Microsoft.Logic/workflows/la-removeOnwantedCharacters"
}
}
}
createServicemanagementGroup ApiConnection la-removeOnwantedCharacters
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.Group"\n},\n"Title": "@{body('la-removeOnwantedCharacters')} - Servicemanagement Bijdragers",\n"Description": "Leden met bijdraag rechten op de documentenbibliotheek Servicemanagement"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/SiteGroups"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
addServicemanagementToServicemanagementGroup ApiConnection createServicemanagementGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addSalesToServicemanagementGroup ApiConnection addServicemanagementToServicemanagementGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addManagementToServicemanagementGroup ApiConnection addSalesToServicemanagementGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
breakRoleinheritanceServicemanagement ApiConnection addManagementToServicemanagementGroup
{
"body": {
"headers": {
"Accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/lists/getByTitle('Servicemanagement')/breakroleinheritance(copyRoleAssignments=false, clearSubscopes=true)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
grantServicemanagementGroupContributorRights ApiConnection breakRoleinheritanceServicemanagement
{
"body": {
"headers": {
"accept ": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/lists/getByTitle('Servicemanagement')/roleassignments/addroleassignment(principalid=@{body('createServicemanagementGroup')?['d']?['Id']},roleDefId=1073741827)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
createBudgetsContractsGroup ApiConnection grantServicemanagementGroupContributorRights
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.Group"\n},\n"Title": "@{body('la-removeOnwantedCharacters')} - Budgets Contracts Bijdragers",\n"Description": "Leden met bijdraag rechten op de documentenbibliotheek Budgets and Contracts"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/SiteGroups"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
addSalesToBudgetsContractsGroup ApiConnection createBudgetsContractsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addAdministratieToBudgetsContractsGroup ApiConnection addSalesToBudgetsContractsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addManagementToBudgetsContractsGroup ApiConnection addAdministratieToBudgetsContractsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addServiceManagementToBudgetsContractsGroup ApiConnection addManagementToBudgetsContractsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
breakRoleinheritanceBudgetsContracts ApiConnection addServiceManagementToBudgetsContractsGroup
{
"body": {
"headers": {
"Accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/lists/getByTitle('Budgets and Contracts')/breakroleinheritance(copyRoleAssignments=false, clearSubscopes=true)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
grantBudgetsContractsGroupContributorRights ApiConnection breakRoleinheritanceBudgetsContracts
{
"body": {
"headers": {
"accept ": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/lists/getByTitle('Budgets and Contracts')/roleassignments/addroleassignment(principalid=@{body('createBudgetsContractsGroup')?['d']?['Id']},roleDefId=1073741827)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
createContributorsGroup ApiConnection grantBudgetsContractsGroupContributorRights
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.Group"\n},\n"Title": "@{body('la-removeOnwantedCharacters')} - Bijdragers",\n"Description": "Leden met bijdraag rechten"\n}",
"headers": {
"accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/SiteGroups"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
addSalesToContributorsGroup ApiConnection createContributorsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addManagementToContributorsGroup ApiConnection addSalesToContributorsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
addBackofficeToContributorsGroup ApiConnection addManagementToContributorsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
grantContributorsGroupContributorRights ApiConnection addBackofficeToContributorsGroup
{
"body": {
"headers": {
"accept ": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/roleassignments/addroleassignment(principalid=@{body('createContributorsGroup')?['d']?['Id']},roledefid=1073741827)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
createChangeContributorsGroup ApiConnection grantContributorsGroupContributorRights
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.Group"\n},\n"Title": "@{body('la-removeOnwantedCharacters')} - Change Bijdragers",\n"Description": "Leden met bijdraag rechten op change documents bibliotheek"\n}",
"headers": {
"accept ": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/SiteGroups"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
addGIAlgemeenToChangeContributorsGroup ApiConnection createChangeContributorsGroup
{
"body": {
"body": "{\n"__metadata": {\n"type":"SP.User"\n},\n"LoginName":"c:0o.c
breakRoleinheritanceChanges ApiConnection addGIAlgemeenToChangeContributorsGroup
{
"body": {
"headers": {
"Accept": "application/json;odata=verbose",
"content-Type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/lists/getByTitle('Change documents')/breakroleinheritance(copyRoleAssignments=true, clearSubscopes=true)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
grantChangeContributorsGroupContributorRights ApiConnection breakRoleinheritanceChanges
{
"body": {
"headers": {
"accept ": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose"
},
"method": "POST",
"uri": "_api/web/lists/getByTitle('Change documents')/roleassignments/addroleassignment(principalid=@{body('createChangeContributorsGroup')?['d']?['Id']},roleDefId=1073741827)"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Servicemanagement___gi-customer ApiConnection Try
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Customer'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Servicemanagement')/Fields/getbytitle('gi-customer')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Budgets_and_Contracts___gi-customer ApiConnection updateColumn___Servicemanagement___gi-customer
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Customer'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Budgets and Contracts')/Fields/getbytitle('gi-customer')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
updateColumn___Documenten___gi-customer ApiConnection updateColumn___Budgets_and_Contracts___gi-customer
{
"body": {
"body": "{\n '__metadata': {\n 'type': 'SP.List'\n },\n 'Title': 'Customer'\n}",
"headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
"method": "POST",
"uri": "_api/web/lists/getbytitle('Documenten')/Fields/getbytitle('gi-customer')"
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(variables('strSiteName')))}/httprequest"
}
set_strMailbody___AccountCreator SetVariable updateColumn___Documenten___gi-customer
{
"name": "strMailBody",
"value": "

Hey @{body('getAccountCreatorProfile')?['givenName']},

\n

De site voor klant: @{body('parseCompany')?['item']?['companyName']} is gereed. <a href="@{variables('strSiteName')}">Hier vind je de site.

\n

Succes met deze klant

"
}
CompanyName_eq_INIT___Site_created If set_strMailbody___AccountCreator null
Post_message_in_a_chat_or_channel ApiConnection CompanyName_eq_INIT___Site_created
{
"body": {
"messageBody": "

@{variables('strMailBody')}

",
"recipient": "@body('getAccountCreatorProfile')?['userPrincipalName']"
},
"host": {
"connection": {
"name": "@parameters('$connections')['teams']['connectionId']"
}
},
"method": "post",
"path": "/beta/teams/conversation/message/poster/Flow bot/location/@{encodeURIComponent('Chat with Flow bot')}"
}
Catch Scope Try null
ExtractLogicAppError Function Catch
{
"body": {
"LogicAppName": "@{workflow().name}",
"ResourceGroup": "site-provisioning-kg-rg",
"Runid": "@{workflow().run.name}",
"SubscriptionId": "11111q1z-76b3-45ba-a4c1-c7d3b4a53e13"
},
"function": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/customer-automation-rg/providers/Microsoft.Web/sites/fa-customer-automation-helper-dotnet/functions/ExtractLogicAppError"
},
"retryPolicy": {
"type": "none"
}
}
set_intResponseCode_Catch SetVariable ExtractLogicAppError
{
"name": "intResponseCode",
"value": 500
}
set_strResponseText_Catch SetVariable set_intResponseCode_Catch
{
"name": "strResponseText",
"value": "@{first(body('ExtractLogicAppError'))?['errorMessage']}"
}
Finally Scope Catch null
Condition If Finally null
setDueDateTime Expression Condition-True
{
"baseTime": "@{addDays(utcNow(),2)}",
"destinationTimeZone": "W. Europe Standard Time",
"formatString": "yyyy-MM-ddTHH:mm:ss",
"sourceTimeZone": "UTC"
}
la-createATTicket Workflow setDueDateTime
{
"body": {
"companyID": 0,
"contactMail": "xxxx.xxxx@xxxx.nl",
"defaultContactID": 30686628,
"dueDateTime": "@body('setDueDateTime')",
"priority": 3,
"queueID": 29683484,
"status": 1,
"ticketCategory": 2,
"ticketDescription": "Logic app voor het maken van een klantensite is mislukt. Runid: @{workflow().run.name}\n\nhttps://portal.azure.com/#view/Microsoft_Azure_EMA/LogicAppsMonitorBlade/runid/%2Fsubscriptions%2F11111q1z-76b3-45ba-a4c1-c7d3b4a53e13%2Fresourcegroups%2Fsite-provisioning-kg-rg%2Fproviders%2FMicrosoft.Logic%2Fworkflows%2F@{workflow().name}%2Fruns%2F@{workflow().run.name}",
"ticketTitle": "Fout opgetreden in logic app: @{workflow().name}"
},
"host": {
"triggerName": "manual",
"workflow": {
"id": "/subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/customer-automation-rg/providers/Microsoft.Logic/workflows/la-createATTicket"
}
}
}
markCustomerAsComplete ApiConnection Condition-False
{
"body": {
"Title": "@{first(body('parseCompany')?['item']?['companyName'])}",
"gi_x002d_complete": true
},
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "patch",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/sites/portal'))}/tables/@{encodeURIComponent(encodeURIComponent('06604a18-d94e-4287-8cc4-e2f73355657c'))}/items/@{encodeURIComponent(variables('intKlantListID'))}"
}
Response Response Finally
{
"body": "@variables('strResponseText')",
"statusCode": "@variables('intResponseCode')"
}

Logic App Connections

This section shows an overview of Logic App Workflow connections.

Connections

ConnectionName ConnectionId ConnectionProperties
keyvault-1 /subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-kg-rg/providers/Microsoft.Web/connections/keyvault-1
{
"authentication": {
"type": "ManagedServiceIdentity"
}
}
office365users /subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-kg-rg/providers/Microsoft.Web/connections/office365users null
sharepointonline /subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-kg-rg/providers/Microsoft.Web/connections/sharepointonline null
teams /subscriptions/11111q1z-76b3-45ba-a4c1-c7d3b4a53e13/resourceGroups/site-provisioning-kg-rg/providers/Microsoft.Web/connections/teams null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment