Using PI 7.3’s Directory API

Hi William,

I have implemented the above code and was sucessfully able to retrieve the Number of ICO's and Number of Communication Channels . But my requiremnt is to get the Communication Channel names along with the Attributes. Could you please suggest as to what parameters should be used to get the Communication Channel names and List of attributes used in the Channel like user name , password etc instead of just getting the number , i need to get the names of the Channels as well.

Thanks,

Soundarya

Hi Martin,

I am presently running the above code in NWDS in my system. It would be great if you could give the entire logic along with the utility class as i'm unable to connect to some of the term used in the above code while using in my nwds editor.

As of now , the code that i'm using to get the communication channel number is as follows:

1. import
   javax.xml.ws.BindingProvider;

1. import
   org.apache.poi.xssf.usermodel.XSSFSheet;
2. import
   org.apache.poi.xssf.usermodel.XSSFWorkbook;

1. import
   com.sap.xi.basis.CommunicationChannelID;
2. import
   com.sap.xi.basis.CommunicationChannelQueryIn;

import com.sap.xi.basis.IntegratedConfigurationIn;

import com.sap.xi.basis.IntegratedConfigurationInService;

import com.sap.xi.basis.IntegratedConfigurationQueryIn;

import com.sap.xi.basis.IntegratedConfigurationQueryOut;

1. import
   com.sap.xi.basis.CommunicationChannelIn;
2. import
   com.sap.xi.basis.CommunicationChannelInService;
3. import
   com.sap.xi.basis.CommunicationChannelQueryOut;

import com.sap.xi.basis.MessageHeaderID;

import com.sap.xi.basis.global.LONGDescription;

import java.io.File;

import java.io.FileNotFoundException;

1. import
   java.io.FileOutputStream;

import java.io.IOException;

import java.util.Date;

import java.util.Map;

import java.util.Set;

import java.util.TreeMap;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFDataFormat;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.util.HSSFColor;

1. import
   org.apache.poi.ss.usermodel.Cell;
2. import
   org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class
CommunicationChannels {

     private static String apiURL = "/CommunicationChannelInService/CommunicationChannelInImplBean?wsdl=binding&mode=ws_policy";

     private String serverPort = "";

     private String user = "";

     private String password = "";

     private String url = new String();

     private
CommunicationChannelIn port;

     public
CommunicationChannels() {

        
setURL(serverPort);

         try {

              port = getPort();

        
}

         catch (Exception e) {

             
e.printStackTrace();

        
}

     }

     public List
query() {

        
CommunicationChannelQueryIn queryIn = new CommunicationChannelQueryIn();

        
CommunicationChannelID msgHdr = new
CommunicationChannelID();    

          queryIn.setCommunicationChannelID(msgHdr);

        
CommunicationChannelQueryOut queryOut = port.query(queryIn);

        
List lMsgHdr = queryOut.getCommunicationChannelID();

         return lMsgHdr;

        

     }

     private void setURL(String
serverPort) {

         if (serverPort == null)

              return;

         else

              this.url = this.url.concat("http://").concat(serverPort).concat(apiURL);

     }

     private
CommunicationChannelIn getPort() throws Exception{

        
CommunicationChannelIn port = null;

         try {

             
CommunicationChannelInService service = null;

             
service = new CommunicationChannelInService();

             
port = (CommunicationChannelIn) service.getCommunicationChannelIn_Port();

            
BindingProvider bp = (BindingProvider)port;

            
bp.getRequestContext().put(BindingProvider.USERNAME_PROPERTY, user);

            
bp.getRequestContext().put(BindingProvider.PASSWORD_PROPERTY, password);

             if (url.length() != 0)

                 
bp.getRequestContext().put(BindingProvider.ENDPOINT_ADDRESS_PROPERTY, url);

        
}

         catch (Exception ex){

             
ex.printStackTrace();

        
}

         return port;

     }

     /**

      * @param args

      */

     public static void main(String[]
args) {

         //TODO
Auto-generated method stub

        
CommunicationChannels test = new CommunicationChannels();

        
List listMsgHdr = test.query();

        
System.out.println("Done - number of communication channels = " +
listMsgHdr.size());

       //Blank
workbook

        
XSSFWorkbook workbook = new XSSFWorkbook();

          //Create a
blank sheet

        
XSSFSheet sheet = workbook.createSheet("Communication Channel ID's");

         //This
data needs to be written (Object[])

        
Map<String, Object[]> data = new TreeMap<String, Object[]>();

        
data.put("1", new Object[] {"S.no", "Comm
Channel", "Number"});

        
data.put("2", new Object[] {1, "number
of Comm channels",+ listMsgHdr.size() });

       //Iterate
over data and write to sheet

        
Set<String> keyset = data.keySet();

         int rownum = 0;

         for (String key :
keyset)

        
{

        
Row row = sheet.createRow(rownum++);

        
Object [] objArr = data.get(key);

         int cellnum = 0;

         for (Object obj :
objArr)

        
{

        
Cell cell = row.createCell(cellnum++);

         if(obj instanceof String)

        
cell.setCellValue((String)obj);

         else if(obj instanceof Integer)

        
cell.setCellValue((Integer)obj);

        
}

        
}

         try

    
    {

         //Write
the workbook in file system

        
FileOutputStream out = new FileOutputStream(new File("C:/Java/CommchannelList.xlsx"));

        
workbook.write(out);

        
out.close();

        
System.out.println("Comm List written successfully on disk.");

        
}

          catch (Exception e)

          {

        
e.printStackTrace();

        
}

     }

}

With the help of the above code i'm able to successfully populate an xls sheet with the number of Comm Channels but unable to read the Comm channel names and attributes.

Could you please help me out as to at which place , the above method that you mentioned should be called? My requiremnt is to populate the xls with comm channel names and attributes.

Could you please give methe end to end code along with the utility class that you are using as the above code that you mentioned has references to you own classes which i'm unaware of.How should this metho be called from the main method? The current channel is one of the parameters in this method, from where should this be passed?

Aprreciate your response and looking forward for any quick help on the same.

Regards,

Soundarya

Soundarya. The way to find out how to get all of the fields and their detail content so you can list or display them is to look in the com.sap.xi.basis directory for the appropriate object, ConfigurationScenario, in this case. Many of the components are other types you need to look up to see their specific detail fields.

Using this process you can get any of the component objects you need.