Skip to Content

Now let’s start with consumption of SharePoint REST service using GET Method

Here we need input as SharePoint accessToken String which can be found from previous blog [Part-1] UDF to Get Access Token

In blow Java UDF example, SharePoint AlertCount List is been fetched by consuming respective SharePoint REST service.


String outputString = "";

//SharePoint url to fetch AlertCount List
String wsURL = "https://<client-Domain>'AlertCount')";

//Create HttpConnection
URL url = new URL(wsURL);
URLConnection connection = url.openConnection();
HttpURLConnection httpConn = (HttpURLConnection) connection;

//Set Header
//Get accessToken is output of UDF-1 from blog "Call SharePoint REST Service in SAP-PI: [Part-1] UDF to Get Access Token"
String basicAuth = "Bearer " + accessToken;  
httpConn.setRequestProperty("Authorization", basicAuth);
httpConn.setRequestProperty("Accept", "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8");

// Read the response.
InputStreamReader isr = null;
if (httpConn.getResponseCode() == 200) {
isr = new InputStreamReader(httpConn.getInputStream());
} else {
isr = new InputStreamReader(httpConn.getErrorStream());
BufferedReader in = new BufferedReader(isr);
String responseString = "";

// Write response to a String.
while ((responseString = in.readLine()) != null) {
outputString = outputString + responseString;

}catch (Exception e) {

return outputString;



To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply