'The operation ID 'executeQuery' for service provider '/serviceProviders/Jdbc' is not valid.'

MOHAMED KAMIL HUSSAIN 0 Reputation points
2025-12-17T08:21:32.5933333+00:00

I have following this documentation : https://learn.microsoft.com/en-us/azure/logic-apps/connectors/built-in/reference/jdbc/#execute-query

Placed a oracle jdbc jar file , ojdbc17.jar file.

Getting this error : validation and creation failed. Error: 'The operation ID 'executeQuery' for service provider '/serviceProviders/Jdbc' is not valid.'

{
  "Lookup_Employee_from_ORSQL": {
    "type": "ServiceProvider",
    "inputs": {
      "serviceProviderConfiguration": {
        "operationId": "executeQuery",
        "connectionName": "dbsoracle",
        "serviceProviderId": "/serviceProviders/Jdbc"
      },
      "parameters": {
        "query": "SELECT EmployeeID, NationalID FROM HumanResources_Directory WHERE EmailAddress = :Email",
        "parameters": [
          {
            "name": "Email",
            "value": "@{items('For_Each_Item')?['fields']?['Title']}"
          }
        ],
        "resultFormat": "Json"
      }
    }
  }
}
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.