New - call SharePoint Online REST API from actions
New and exciting feature added! You can now call SharePoint Online (Office 365) REST API directly from Actions in the app version of Ultimate Forms.
We've had the "Call web service" action for a while now, and although extremely powerful, it lacked the ability to communicate with Office 365 REST APIs, due to the complex authentication system required. But now we've added this capability, allowing you to run any custom API calls from actions to perform operations we don't provide direct support for. And because it's REST, you can even perform those operations on a completely different tenant, as long as you have the necessary credentials.
In my example, I'm simply updating the Title column of the item, adding "1" to the end of the existing title. I'm going to explain no to configure the REST call correctly.
- In the URL enter the endpoint for the call. We allow the use of our Value Builder here, so you can inject column values. For instance, here I'm entering the ID of the current item.
- Under Credentials enter your Office 365 credentials, the user entered must have the necessary permissions to execute the call
- Under Parameter values we enter expected JSON string. The key on the left has to be JSON, on the right you enter the JSON expression itself. Again, use any column values you need
- Under Headers we need to enter the two headers required by the Update List Item API call. X-HTTP-Method to inform SharePoint that we are performing an update of an existing item (MERGE) and IF-MATCH rule to handle concurrent updates (using * allows us to update any version of the item)
That's it. Now whenever we execute the action, the item's title get updated.
We are adding a copy of an item to Tenant B when an item is added in Tenant A:
With the full SharePoint REST API at your disposal, there is no limit to what you can do!
For more info regarding the SharePoint REST API, read here.
Add your comment
100% No-Code Solution
It's never been easier, to create, innovate and share, all you need is your web browser!
Address business process pain points immediately. Save time and money.
Fantastic Support Team
Facing difficulties installing the application? Contact our fantastic support team.