locked
Invalid Mashup Expression using supplied values.\r\n inner exception: The key didn't match any rows in the table.\r\nclientRequestId: RRS feed

  • Question

  • I'm getting the above error, checked all rules are set. 

    UseCase: Tring to get records add/edited from SQL Server(Local) using Logic Apps (DataGateway), but gets error:

    "Invalid Mashup Expression using supplied values

     Below command also works fine from PowerShell cmd

    Test-NetConnection -ComputerName watchdog.servicebus.windows.net -Port 9350

    Error Descriptio:

    {
      "status"400,
      "message""Invalid Mashup Expression using supplied values.\r\n     inner exception: The key didn't match any rows in the table.\r\nclientRequestId: 3241abed-fdc7-4aa1-9555-3792ce5a3cb7",
      "source""sql-logic-cp-southindia.logic-ase-southindia.p.azurewebsites.net"
    }


    Sunday, November 5, 2017 1:03 PM

All replies

  • Rajeev, do you mean to say that you are using the OnItemUpdated or OnItemCreated trigger for SQL? If so, make sure your table has a TIMESTAMP (for OnUpdate notifications) and an IDENTITY (for OnCreate notifications)

    If you manually typed in your sql table, then that explains why this isn't working. The connector will filter out tables that won't work with these triggers.

    Be sure to read the limiations at the bottom of this post:  https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/ 

    -Cameron

    Monday, November 6, 2017 7:36 PM