cancel
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

 

 

Spoiler
Note : The workflow app should have permissions on the content you request using OAuth2. Otherwise, the results will be as follows :
{ 
   "error":{ 
      "code":"-2147024891, System.UnauthorizedAccessException",
      "message":{ 
         "lang":"en-US",
         "value":"Access denied. You do not have permission to perform this action or access this resource."
      }
   }
}
Spoiler
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.

 

Spoiler

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)
Reply
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
Reply