Hi,
New and exciting feature added! You can now call SharePoint Online (Microsoft 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 Microsoft 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 Microsoft 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.
Another example:
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.
