Azure / logicapps

Azure Logic Apps labs, samples, and tools
MIT License
368 stars 302 forks source link

Dataverse Trigger Failing With 500 #1207

Closed BACBcnorris closed 3 weeks ago

BACBcnorris commented 1 month ago

Describe the Bug

Getting an error when using Dataverse Connector Trigger. "When a row is modified, added, or deleted"

Plan Type

Consumption

Steps to Reproduce the Bug or Issue

Using the following action: "when a row is modified, added, or deleted" Environment: will select my appropriate environment from the drop down. Table Name: will select the appropriate entity from the drop down. Change Type: will select modified from the drop down. Scope will select organization from the drop down.

{
    "statusCode": 500,
    "headers": {
        "Access-Control-Allow-Methods": "GET, PUT, PATCH, DELETE, POST",
        "Access-Control-Allow-Origin": "*",
        "Access-Control-Max-Age": "3600",
        "Access-Control-Expose-Headers": "*",
        "Date": "Mon, 14 Oct 2024 13:15:48 GMT",
        "Content-Length": "400",
        "Content-Type": "application/json"
    },
    "body": {
        "error": {
            "code": 500,
            "message": "Value cannot be null.\r\nParameter name: input\r\n   at System.Text.RegularExpressions.Regex.Match(String input)",
            "source": "logic-apis-centralus.azure-apim.net",
            "path": "choose[3]\\when[1]\\choose\\when[2]\\choose[3]\\when[1]\\return-response",
            "policyId": "",
            "clientRequestId": "80975ffe-74ae-40c0-9a5d-6420c1010b3e"
        }
    }
}

Workflow JSON

"triggers": {
            "When_an_Audit_is_Denied": {
                "conditions": [],
                "inputs": {
                    "body": {
                        "entityname": "bacb_audits",
                        "message": 3,
                        "scope": "4",
                        "url": "@listCallbackUrl()",
                        "version": 1
                    },
                    "headers": {
                        "Consistency": "Strong",
                        "catalog": "all",
                        "category": "all",
                        "organization": "https://{removed}.dynamics.com"
                    },
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['commondataservice']['connectionId']"
                        }
                    },
                    "path": "/api/data/v9.1/callbackregistrations"
                },
                "type": "ApiConnectionWebhook"
            }
        }

Screenshots or Videos

Image

Additional context

No response

BACBcnorris commented 1 month ago

There has been no action on this, so I am commenting on this to prevent premature closure.