Calling Web Services in InfoPath on SPO

%3CLINGO-SUB%20id%3D%22lingo-sub-60538%22%20slang%3D%22en-US%22%3ECalling%20Web%20Services%20in%20InfoPath%20on%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-60538%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20currently%20migrating%20from%202010%20to%20Office%20365%20and%20we%20have%20a%20web%20service%20that%20is%20used%20in%20many%20of%20our%20InfoPath%20forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20accurate%20that%20the%20only%20way%20to%20do%20this%20is%20deploy%20the%20web%20service%20to%20Azure%20or%20other%20internet%20addressable%20server%20to%20host%20the%20web%20service%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-60538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-61754%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20Web%20Services%20in%20InfoPath%20on%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61754%22%20slang%3D%22en-US%22%3E%3CP%3EExcellent%2C%20thank%20you%20for%20the%20info.%20We%20were%20able%20to%20move%20the%20service%20to%20an%20Azure%20Web%20App!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPART%20II%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccessing%20data%20from%20on%20premises%20sources%20from%20the%20Azure%20App%20Web%20Service.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20Live%20IP%20the%20only%20option%3F%20Is%20anyone%20using%20this%20option%3F%20How%20was%20it%20received%20from%20your%20Infrastructure%20and%20Security%20teams%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20not%20found%20a%20way%20to%20do%20this%20via%20the%20On-premises%20data%20gateway%20associated%20with%20Power%20BI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20in%20the%20Azure%20Portal%20there%20is%20another%20%22On-premises%20data%20gateway%20(preview)%22%20as%20an%20option%20that%20seems%20to%20talk%20about%20this%20type%20of%20funcationality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20are%20most%20of%20your%20organization%20moving%20data%20to%20Azure%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-61279%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20Web%20Services%20in%20InfoPath%20on%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61279%22%20slang%3D%22en-US%22%3EShort%20answer%20-%20yes..%20You'll%20need%20to%20move%20that%20web%20service%20into%20Azure.%20There's%20a%20few%20ways%20to%20do%20it%20but%20undoubtedly%20yes%20it%20needs%20to%20be%20in%20Azure.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-61170%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20Web%20Services%20in%20InfoPath%20on%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61170%22%20slang%3D%22en-US%22%3EDeploying%20the%20Web%20Service%20as%20part%20of%20a%20Provider-Hosted%20App%20could%20work%20but%20I%20think%20using%20App%20Only...other%20posible%20scenario%20you%20could%20evaluate%20is%20use%20an%20Azure%20AD%20App%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-61162%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20Web%20Services%20in%20InfoPath%20on%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61162%22%20slang%3D%22en-US%22%3EWhen%20you%20say%20%22with%20Azure%20you%20won't%20need%20this%22%20is%20that%20due%20to%20the%20fact%20that%20all%20of%20my%20O365%20users%20are%20in%20Azure%20AD%20and%20I%20can%20utilize%20that%20for%20authentication%2Fauthorization%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20this%20constitute%20a%20%22provider%20hosted%22%20app%3F%20Which%20would%20mean%20the%20claims%20ticket%20is%20available%20for%20all%20of%20these%20types%20of%20apps%3F%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20having%20ADFS%20in%20place%20for%20SSO%20change%20this%20at%20all%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-60564%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20Web%20Services%20in%20InfoPath%20on%20SPO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-60564%22%20slang%3D%22en-US%22%3EBasically%20the%20answer%20is%20yes%2C%20you%20need%20to%20deploy%20your%20web%20service%20in%20a%20place%20that%20will%20allow%20you%20to%20call%20the%20web%20service%20from%20Internet.%20Additionally%20to%20this%2C%20it's%20quite%20probable%20you%20will%20need%20to%20secure%20your%20web%20service%20(thinking%20on%20the%20OnPremises%20deployment%20option...with%20Azure%20you%20won't%20need%20this)%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

We're currently migrating from 2010 to Office 365 and we have a web service that is used in many of our InfoPath forms.

 

Is it accurate that the only way to do this is deploy the web service to Azure or other internet addressable server to host the web service?

 

 

5 Replies
Highlighted
Basically the answer is yes, you need to deploy your web service in a place that will allow you to call the web service from Internet. Additionally to this, it's quite probable you will need to secure your web service (thinking on the OnPremises deployment option...with Azure you won't need this)
Highlighted
When you say "with Azure you won't need this" is that due to the fact that all of my O365 users are in Azure AD and I can utilize that for authentication/authorization?

Would this constitute a "provider hosted" app? Which would mean the claims ticket is available for all of these types of apps?

Does having ADFS in place for SSO change this at all?
Highlighted
Deploying the Web Service as part of a Provider-Hosted App could work but I think using App Only...other posible scenario you could evaluate is use an Azure AD App
Highlighted
Short answer - yes.. You'll need to move that web service into Azure. There's a few ways to do it but undoubtedly yes it needs to be in Azure.
Highlighted

Excellent, thank you for the info. We were able to move the service to an Azure Web App!

 

PART II

 

Accessing data from on premises sources from the Azure App Web Service.

 

Is Live IP the only option? Is anyone using this option? How was it received from your Infrastructure and Security teams?

 

I have not found a way to do this via the On-premises data gateway associated with Power BI.

 

However, in the Azure Portal there is another "On-premises data gateway (preview)" as an option that seems to talk about this type of funcationality.

 

Or are most of your organization moving data to Azure?