TM1 Forum

Code: Select all

public class CAM_Try {

  public static void main(String[] args) {
    System.out.println("testing starts");

    //for localhost testing only
    javax.net.ssl.HttpsURLConnection.setDefaultHostnameVerifier(
      new javax.net.ssl.HostnameVerifier(){
        public boolean verify(String hostname
                   , javax.net.ssl.SSLSession sslSession) {
	  if (hostname.equals("localhost")) {
	    return true;
	  }
	  return false;
	}
       }
     );

     try {

       URL u = new URL("http://169.46.63.237:50102/api/v1/$metadata");
       HttpURLConnection c = (HttpURLConnection) u.openConnection();
       String encoded = Base64.encodeBase64String
       ("<userID>:<password>:<CAMNamespace ID>".getBytes());
       c.setRequestProperty("Authorization", "CAMNamespace " + encoded);
       System.out.println("\n encoded" + encoded);
       c.setRequestProperty("Accept","application/json; charset=utf-8");
       c.setRequestProperty("Content-Type","application/json;charset=utf-8");
       c.setRequestProperty("WWW-Authenticate"
       ,"CAMPassport http://ibmdemo.demos.ibm.com:9300/bi/v1/disp, CAMNamespace");
       c.setRequestMethod("GET");

       c.connect();

       int status = c.getResponseCode();
       System.out.println(status);
       System.out.println( "Response1  "+ c.getResponseMessage()+ "\n\n");

       Map<String, List<String>> map = c.getHeaderFields();
       System.out.println("Printing Response Header...\n");

       for (Map.Entry<String, List<String>> entry : map.entrySet()) {
         
	 System.out.println("Key : " + entry.getKey() + " ,Value : " + entry.getValue());

       }
       
       switch (status) {
         
	 case 200:
	 case 201:
	   BufferedReader br = new BufferedReader(
	          new InputStreamReader(c.getInputStream())
	        );
	   StringBuilder sb = new StringBuilder();
	   String line;
	   while ((line = br.readLine()) != null) {
	     System.out.println(line);
	   }
	   br.close();
	}

     } catch (MalformedURLException ex) {
         System.out.println(ex.getMessage());
	 System.err.println(Arrays.toString(ex.getStackTrace()));
     } catch (IOException ex) {
         System.err.println(ex.getMessage());
	 System.err.println(Arrays.toString(ex.getStackTrace()));
	 ex.printStackTrace();       
     }
	
  }

}

Code: Select all

String tm1Url = Constants.getBaseURL()+  "/api/v1/ExecuteMDX?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells";
HttpPost httpPost = new HttpPost(tm1Url);
httpPost.addHeader("Authorization", Constants.getAuthorisationType()  + Constants.getAuthorisation());

Code: Select all

public class Constants {
	private static String hostname = "hostname.company.com"; 
	private static String portNumber = "12345"; 
	private static String userName = "admin"; 
	private static String password = "apple"; 
	private static String nameSpace = "namespace";
	private static String authorizationType = "CAMNamespace "; 
	
	private static String authorization = userName + ":" + password+ ":" + nameSpace; 
	private static String baseURL = "http://" + hostname + ":" + portNumber;
		
	private static byte[] authorizationBytes = authorization.getBytes(StandardCharsets.UTF_8);
	private static String authorizationEncoded = Base64.getEncoder().encodeToString(authorizationBytes);

	

	public Constants() {
	}

	public static String getBaseURL(){
		return baseURL;
	}
	
	public static String getAuthorisation(){
	return authorizationEncoded;
	}

	public static String getAuthorisationType () {
		return authorizationType;
		}

}