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

  • 9 September 2019
  • 1 reply
  • 84 views

Userlevel 3
Badge +8

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 :4298iA9FE79A58AEE2ABA.png

 

First, to get the results deserialized into a Dictionary, the request should be configured with the headers as follows :4299iFD6A204DC9F6FF40.png

 

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 : 

 4300iDB9B37AC77DC0CF6.png

 

 

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."
      }
   }
}

Note : This action executes within your Office 365 tenancy.

2. Using a Web Request with Query XML actions :4301iC40C9F8BAB2B8234.png

 

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

 

Then, the Query XML to get the same item property should be configured as follows :4303i4484B5C1A60D2F56.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.

 

 


1 reply

Awesome job Cecilia this will help a lot of users (and the support team) 🙂

Reply