Showing results for 
Search instead for 
Did you mean: 
Nintex Employee
Nintex Employee

Calling Office 365 Rest API and parsing the results from Nintex Workflow

There are 2 ways to call Office 365 REST API and parse the results from Nintex workflow :


1. Using a Call a web service with Get an Item from a Dictionary actions :CallWebService.PNGCall HTTP Web Service and Get the results from dictionary


First, to get the results deserialized into a Dictionary, the request should be configured with the headers as follows :CallWebService2.PNGRequest JSON format


Then, after calling HTTP Web Service and getting the response content in a dictionary, to parse the results you should have to use the same format syntax that work with dictionaries in SharePoint 2013, as follows : 

 CallWebService3.PNGParse the response to have the Editor's email of the first item



Note : The workflow app should have permissions on the content you request using OAuth2. Otherwise, the results will be as follows :
      "code":"-2147024891, System.UnauthorizedAccessException",
         "value":"Access denied. You do not have permission to perform this action or access this resource."
Note : This action executes within your Office 365 tenancy.

2. Using a Web Request with Query XML actions :WebRequest.PNG


To get the XML format for the response, no needs to add headers or at least, the header should be as follows :WebRequest2.PNG


Then, the Query XML to get the same item property should be configured as follows :WebRequest3.PNG

Using Web Request action, you can configure the credentials of the account with the permissions to access to content requested and/or used others methods.



Note : This action is not fully bounded by your Office 365 tenancy. It either calls outside of the tenant or executes on servers potentially running outside.


Labels: (1)
1 Reply
Nintex Employee
Nintex Employee

Re: Calling Office 365 Rest API and parsing the results from Nintex Workflow

Awesome job Cecilia this will help a lot of users (and the support team) Smiley Happy
0 Kudos