Insert items in SharePoint using SAP-PI UDF

[dilipkkp2412]

Overview:

Here, we will see, that, how SharePoint's AlertCount list can be updated from SAP-PI UDF.

To update AlertCount list inside SharePoint, following SharePoint-REST protocols can be used:

• URL: https://<org_Shp_Host>/teams/SPdev/AlertsCount/_api/web/Lists/GetByTitle('AlertCount')/Items


• Method: POST


• Headers:
  
  
  
  • Authorization  : “Bearer ” + <SharePointAccessToken>
    accept            : application/json;odata=verbose
    Content-Type : “application/json;odata=verbose”
  
  
  
  


• Body: (Request Parameter format)
  
  
  
  • {__metadata: { 'type': 'SP.Data.AlertCountListItem' },
    Col1 : '',
    Col2 : ''
    }
  
  
  
  


• where,
  
  
  
  • <org_Shp_Host> is Organisation's SharePoint host name
  
  
  • Col1 is 1st column of AlertCountList
  
  
  • Col2 is 2nd column of AlertCountList
  
  
  • <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 insert AlertCount list items in SharePoint:

public String writeAlertCount(String accessToken, String InputCol1, String InputCol2, Container container) throws StreamTransformationException{		

		 /**

		 * Using this function, we can update AlertCountList items of SharePoint.	

		 * Suppose, if we want to insert data into two columnItems ('Col1' & 'Col2') of AlertCountList in SharePoint, then following SharePoint-REST will be consumed inside this UDF

		 * REST URL: https://<org_Shp_Host>/teams/SPdev/AlertsCount/_api/web/Lists/GetByTitle('AlertCount')/Items

		 * Request Format:

		 * 			 {__metadata: { 'type': 'SP.Data.AlertCountListItem' }, Col1: 'E01', Col1: '1562' }		 * 

		 * Where, 

		 * 		<org_Shp_Host> is Organisation's SharePoint host name 

		 */

		

		String response = "";

		try {



			//SharePoint REST url to update AlertCount Item List

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



			// Create Http Connection

			URL url = new URL(wsURL);

			URLConnection connection = url.openConnection();

			HttpURLConnection httpConn = (HttpURLConnection) connection;



			// Set Header

			httpConn.setDoOutput(true);

			httpConn.setDoInput(true);

			httpConn.setRequestMethod("POST");

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

			httpConn.setRequestProperty("accept","application/json;odata=verbose");			

			httpConn.setRequestProperty("content-Type",	"application/json;odata=verbose");

			

			// Set Request parameters

			String requestP = "{__metadata: { 'type': 'SP.Data.AlertCountListItem' }, "

							+ "Col1: '"	+ InputCol1  +"', "

							+ "Col2: '"	+ InputCol2+"' }";



			// Send Request

			DataOutputStream wr = new DataOutputStream(httpConn.getOutputStream());

			wr.writeBytes(requestP);

			wr.flush();

			wr.close();



			//Read the response		

			if (httpConn.getResponseCode() == 200) {

				response = "Http Response Code: " + httpConn.getResponseCode();

			}else if (httpConn.getResponseCode() == 201) {

				// when HttpResponseCode is 201, this insert is successful in SharePoint.

				response = "Http Response Code: " + httpConn.getResponseCode() + "\n Item inserted successfully in sharepoint";

			}else{

				response = "Error with Http Response Code: " + httpConn.getResponseCode();

			}



		} catch (Exception e) {

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

		}

		return response;

}

 

Testing:

• UDF Run inside Graphical Map:


• 


• Results in SharePoint


• 

 

 

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