Anyone successfully connect web service which is in SOAP?
Mind to share the concept?
I tried to create Azure logic app but get error on "Failed to fetch". Even if it is successful, I have no idea on how to connect it to PowerApps as I am new on Logic Apps and Azure.
Hopefully someone can share their experiences here.
I have used Azure Automation Runbooks for interacting with our ERP software's SOAP based web services. I only use it for pushing data into the software, since it's not exactly a fast mechanism.
If you are new to SOAP and haven't yet made a successful call, you may want to consider downloading Soap UI here: https://www.soapui.org/ You can use Soap UI to explore the web service and figure out how it works.
If you already know your endpoint URL, you basically just need to create a WebServiceProxy to it, and then call methods within. In my case below, the first 3 lines are concatenating the endpoint URL as: https://myserver.com:port/wsdls/AddJob.jws
First, you effectively connect to the server with the New-WebServiceProxy function and store the response in a variable. If your endpoint is valid, that variable should contain methods or "functions" that the web service can perform. In my case below, if I was to run the commented out line of $proxy | gm, it would have included a method for "AddJob". The other thing you should do at this stage is to look at the definition of the method, which includes all of the expected parameters for the method.
From there, you build a command like below to execute the action/method you're trying to perform like such:
This is very helpful for basic understanding of the concepts in play: https://codingbee.net/powershell/powershell-web-services-wsdl-and-soap
Since every software/situation is different, you may want to look at this if authentication is required: https://thycotic.force.com/support/s/article/API-PowerShell-Scripts-Getting-Started
Hope this helps. Soap isn't the best.
Hi @Anonymous ,
Could you please share a bit more about your scenario?
Do you want to call SOAP webservice from PowerApps app?
If you wantto call SOAP webservice from a PowerApps app, I afraid that there is no way to achieve your needs in PowerApps currently.
If you want to call your own web service from PowerApps app, I think the custom connector functionality could achieve your needs. But for PowerApps and Microsoft Flow (Power Automate), you must support stable HTTP REST APIs for your service. Please refer to the following article for more details:
As an alternative solution, I think the combination of PowerApps and Microsoft Flow (Power Automate) could achieve your needs. On your side, you could consider fire a flow (Microsoft Flow) from a canvas app, then within the flow, you could add a "HTTP" action to call your SOAP webservice, then add a "Response" action or "Respond to PowerApps or flow" action to return retrieved results back to your app.
I have made a test on my side, please consider take a try with the following workaround:
Microsoft Flow configuration:
Note: The XML data type is not supported in PowerApps, but the result returned from a SOAP Webservice is a XML data, you need to convert the xml data into a json data using json function (WDL Expression) in MS Flow, then return the converted json data back to your app.
More details about firing a flow from an app, please check the following article or video:
More details about returning data back to app from a flow, please refer to the following blog:
Please take a try with above solution, then check if it could help in your scenario.
Note: Currently, there is no way to intergrate PowerApps app with Azure Logic Apps. You could consider use Microsoft Flow (Power Automate) to achieve your needs instead of Azure Logic Apps.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!