Read SharePoint items using SAP PI UDF

[dilipkkp2412]

Overview:

Here, we will see, that, how we can read SharePoint’s AlertCount list item using SAP-PI UDF.

To read ShaePoint AlertCount list item, following SharePoint-REST protocols can be used:

• REST-URL:
  
  
  
  • https://<org_Shp_Host>/teams/SPdev/AlertsCount/_api/web/Lists/GetByTitle('AlertCount')/GetItemById('<ID>')
  
  
  
  


• Method:
  
  
  
  • GET
  
  
  
  


• Headers:
  
  
  
  • Authorization  : “Bearer ” + <SharePointAccessToken>
  
  
  
  


• where,
  
  
  
  • <org_Shp_Host> is Organisation’s SharePoint host name
  
  
  • <ID> is unique item Id of every record inside AlertCount List
  
  
  • <SharePointAccessToken>: it is security token required to authenticate SharePoint REST request while inserting items, this token can be fetched from following blog’s udf:
    
    
    
    • Get SharePoint AccessToken using SAP PI UDF
    
    
    
    
  
  
  
  

SAP PI Java UDF example to read AlertCount list items of SharePoint

• Suppose, if we want to read Item 'E01' from sharePoint as shown in below SharePoint-screen


• 


• , then using its ID (itemID) inside SharePoint-REST as below:
  
  
  
  • https://<org_Shp_Host>/teams/SPdev/AlertsCount/_api/web/Lists/GetByTitle('AlertCount')/GetItemById('21115')
  
  
  
  


• , we can fetch complete detail using following UDF example:

public String readAlertCount(String accessToken, Container container) throws StreamTransformationException{

		

		String response = "";

		try {

			// SharePoint url to fetch AlertCount List

			String wsURL = "https://<org_Shp_Host>/teams/SPdev/AlertsCount/_api/web/Lists/GetByTitle('AlertCount')/GetItemById('21115')";



			// Create HttpConnection

			URL url = new URL(wsURL);

			URLConnection connection = url.openConnection();

			HttpURLConnection httpConn = (HttpURLConnection) connection;



			// Set Header

			httpConn.setRequestProperty("Authorization", "Bearer " + accessToken);

			httpConn.setRequestMethod("GET");



			// 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) {

				response = response + responseString;

			}

		} catch (Exception e) {

			response = "Error: " + e.getMessage();

		}

		return response;

}

• Result of UDF will be a xml string like below:


• 

 

 

<<<<< Parent blog reference…..  Integrate SharePoint using SAP PI