Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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"
}
}
}
}