I’m trying to use a Cloud Nintex Form(office 365 sharepoint) to retrieve data from an on-prem web service or REST API and display it in a form text box. When the user enters an ID, I need to immediately fetch and display information related to that ID in real time, before the form is submitted. Since this has to happen before submission, I can’t use a workflow — I need to call the on-prem service directly from the form.

I’ve confirmed that I can use Cloud Actions like Web Request to get data from open (public) web services. However, it doesn’t seem possible to access on-prem services this way. I considered using a secure key, but while it looks like that might have worked in older Nintex Forms with JavaScript, it seems difficult or impossible in Cloud Nintex Forms.

I’ve heard suggestions to use an Azure Function as a middle layer, but setting that up and managing the request process takes too much time.

Do you have any good ideas or alternative solutions for this?

Let me know if you want me to make it more formal, technical, or conversational!