Pimics

All data in Publication are available also through API.

Publication Channel

endpoints

Webhooks

Power Automate Example

{
  "name": "e1325159-5295-4021-b2f0-483856800f52",
  "id": "/providers/Microsoft.Flow/flows/e1325159-5295-4021-b2f0-483856800f52",
  "type": "Microsoft.Flow/flows",
  "properties": {
    "apiId": "/providers/Microsoft.PowerApps/apis/shared_logicflows",
    "displayName": "BC Publication Test (env: Allium/Pimics)",
    "definition": {
      "metadata": {
        "workflowEntityId": null,
        "processAdvisorMetadata": null,
        "flowChargedByPaygo": null,
        "flowclientsuspensionreason": "None",
        "flowclientsuspensiontime": null,
        "flowclientsuspensionreasondetails": null,
        "creator": {
          "id": "5fabcc2a-6acd-4f1f-89bf-2151d2d5a765",
          "type": "User",
          "tenantId": "72365aaa-0678-49dc-86f9-e48e1b806e78"
        },
        "provisioningMethod": "FromDefinition",
        "failureAlertSubscription": true,
        "clientLastModifiedTime": "2024-10-16T14:48:53.6195171Z",
        "connectionKeySavedTimeKey": "2024-10-16T14:48:53.6195171Z"
      },
      "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
      "contentVersion": "1.0.0.0",
      "parameters": {
        "$connections": {
          "defaultValue": {},
          "type": "Object"
        },
        "$authentication": {
          "defaultValue": {},
          "type": "SecureObject"
        }
      },
      "triggers": {
        "When_a_business_event_occurs_(V3)": {
          "splitOn": "@triggerOutputs()?['body/value']",
          "metadata": {
            "operationMetadataId": "455ca3a4-7ace-4f6c-bb73-ffbf8a0eede6"
          },
          "type": "OpenApiConnectionWebhook",
          "inputs": {
            "host": {
              "apiId": "/providers/Microsoft.PowerApps/apis/shared_dynamicssmbsaas",
              "connectionName": "shared_dynamicssmbsaas",
              "operationId": "CreateBusinessEventSubscriptionV3"
            },
            "parameters": {
              "bcenvironment": "PIMICS",
              "businessevent": "publicationLineUpdated(394dc561-0292-494f-93f0-4583392bd7e0)",
              "company": ""
            },
            "authentication": "@parameters('$authentication')"
          }
        }
      },
      "actions": {
        "Initialize_variable": {
          "runAfter": {},
          "metadata": {
            "operationMetadataId": "6bcbe6f2-2d57-4601-b5b9-2c140f35c63d"
          },
          "type": "InitializeVariable",
          "inputs": {
            "variables": [
              {
                "name": "Test",
                "type": "string",
                "value": "@{triggerOutputs()?['body/Line Type']} @{triggerOutputs()?['body/Number']}"
              }
            ]
          }
        },
        "Switch": {
          "runAfter": {
            "Initialize_variable": [
              "Succeeded"
            ]
          },
          "cases": {
            "Case": {
              "case": "Item",
              "actions": {
                "Get_record_(V3)": {
                  "runAfter": {},
                  "metadata": {
                    "operationMetadataId": "4f7ed93a-f2ef-4cd2-924d-7c9d361676ef"
                  },
                  "type": "OpenApiConnection",
                  "inputs": {
                    "host": {
                      "apiId": "/providers/Microsoft.PowerApps/apis/shared_dynamicssmbsaas",
                      "connectionName": "shared_dynamicssmbsaas",
                      "operationId": "GetItemV3"
                    },
                    "parameters": {
                      "bcenvironment": "PIMICS",
                      "company": "@triggerOutputs()?['body/$companyId']",
                      "dataset": "pimics/publication/v2.0",
                      "table": "items",
                      "id": "@triggerOutputs()?['body/LineId']"
                    },
                    "authentication": "@parameters('$authentication')"
                  }
                }
              }
            },
            "Case_2": {
              "case": "Feature",
              "actions": {
                "Get_record_(V3)_2": {
                  "runAfter": {},
                  "metadata": {
                    "operationMetadataId": "10d4c959-95f6-4845-bb44-769f67c49ebc"
                  },
                  "type": "OpenApiConnection",
                  "inputs": {
                    "host": {
                      "apiId": "/providers/Microsoft.PowerApps/apis/shared_dynamicssmbsaas",
                      "connectionName": "shared_dynamicssmbsaas",
                      "operationId": "GetItemV3"
                    },
                    "parameters": {
                      "bcenvironment": "PIMICS",
                      "company": "@triggerOutputs()?['body/$companyId']",
                      "dataset": "pimics/publication/v2.0",
                      "table": "features",
                      "id": "@triggerOutputs()?['body/LineId']"
                    },
                    "authentication": "@parameters('$authentication')"
                  }
                }
              }
            }
          },
          "default": {
            "actions": {
              "Terminate": {
                "runAfter": {},
                "metadata": {
                  "operationMetadataId": "ef55ed0a-e4c1-40f3-afeb-3c50ec0da517"
                },
                "type": "Terminate",
                "inputs": {
                  "runStatus": "Cancelled"
                }
              }
            }
          },
          "expression": "@triggerOutputs()?['body/Line Type']",
          "metadata": {
            "operationMetadataId": "5a354f2e-c0ce-4845-b229-c81ff1427feb"
          },
          "type": "Switch"
        }
      },
      "outputs": {}
    },
    "connectionReferences": {
      "shared_dynamicssmbsaas": {
        "connectionName": "shared-dynamicssmbsa-217c877e-2d0f-42ed-839c-be372a018c00",
        "source": "Embedded",
        "id": "/providers/Microsoft.PowerApps/apis/shared_dynamicssmbsaas",
        "tier": "NotSpecified"
      }
    },
    "flowFailureAlertSubscribed": false,
    "isManaged": false
  }
}