Page History

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://webservices.web.mi.hof.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <web:remoteAdministrationCall>
         <arg0>
          <loginId>admin@yellowfin.com.au</loginId>
            <password>test</password>
            <orgId>1</orgId>
            <function>GETEXPORTDEPENDENCIES</function>
            <contentResources>
               <resourceId>56169</resourceId>
               <resourceType>VIEW</resourceType>
            </contentResources>         
         </arg0>
      </web:remoteAdministrationCall>
   </soapenv:Body>
</soapenv:Envelope> 

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
   <S:Body>
      <ns2:remoteAdministrationCallResponse xmlns:ns2="http://webservices.web.mi.hof.com/">
         <return>
            <contentResources>
               <resourceDescription/>
               <resourceId>54701</resourceId>
               <resourceName>Yellowfin Configuration Database</resourceName>
               <resourceOrgId>1</resourceOrgId>
               <resourceType>DATASOURCE</resourceType>
            </contentResources>
            <errorCode>0</errorCode>
            <messages>Successfully Authenticated User: admin@yellowfin.com.au</messages>
            <messages>Web Service Request Complete</messages>
            <sessionId>97d7f893d787daf2806a13cdfa6f09d3</sessionId>
            <statusCode>SUCCESS</statusCode>
         </return>
      </ns2:remoteAdministrationCallResponse>
   </S:Body>
</S:Envelope>

• 管理ユーザーとしてのログインと、実行するwebサービスの呼び出しの指定を含む、こちらの関数の基礎的なリクエストから開始します。
  
  

  Code Block
  theme Eclipse language java
  rsr.setLoginId("admin@yellowfin.com.au"); rsr.setPassword("test"); rsr.setOrgId(1); rsr.setFunction("GETEXPORTDEPENDENCIES");

• 特定のクライアント組織を識別することもできます。

   

  Code Block
  theme Eclipse language java
  rsr.setOrgRef("org1");

• ContentResourceオブジェクトを使用して、依存関係を取得するコンテンツの詳細を指定します。

   

  Code Block
  theme Eclipse language java
  ContentResource[] cr = new ContentResource[1]; cr[0] = new ContentResource(); cr[0].setResourceId(70307); cr[0].setResourceType("GROUP"); cr[0].setResourceOrgId(1);

• リクエストにオブジェクトを配置します。

   

  Code Block
  theme Eclipse language java
  rsr.setContentResources(cr);

• リクエストを構成したら、呼び出しを実行します。
  
  

  Code Block
  language java
  AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);

  管理サービスを初期化します。実行方法の詳細は、こちらを参照してください。

• 返される応答には、次の要素が含まれます。：StatusCodeとContentResource。（より詳細な情報は、上記応答パラメーターの表を参照してください）
  
  

<%      
/*      ws_getexportdependecies.jsp             */
%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="com.hof.util.*, java.util.*, java.text.*" %>
<%@ page import="com.hof.web.form.*" %>
<%@ page import="com.hof.mi.web.service.*" %>
<%@ page import="java.nio.file.Files" %>
<%@ page import="java.io.PrintWriter" %>
<%
AdministrationServiceService s_adm = new AdministrationServiceServiceLocator("localhost",8080, "/services/AdministrationService", false);       // adjust host and port number
AdministrationServiceSoapBindingStub adminService = (AdministrationServiceSoapBindingStub) s_adm.getAdministrationService();
AdministrationServiceRequest rsr = new AdministrationServiceRequest();
  
rsr.setLoginId("admin@yellowfin.com.au");                 // provide your Yellowfin webservices admin account
rsr.setPassword("test");                                // set to the password of the account above
rsr.setOrgId(1);
rsr.setFunction("GETEXPORTDEPENDENCIES");
  
ContentResource[] cr = new ContentResource[1];
  
cr[0] = new ContentResource();
cr[0].setResourceId(70307);
cr[0].setResourceType("GROUP");
cr[0].setResourceOrgId(1);
  
rsr.setContentResources(cr);
  
AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);
  
if ("SUCCESS".equals(rs.getStatusCode()) ) {
            out.write("<br>Success");
            ContentResource[] crs = rs.getContentResources();
            out.write("<table>");
            out.write("<tr><td> id </td><td> type </td><td> UUID </td></tr>");
            for (ContentResource c: crs) {
                        out.write("<tr>");
                        out.write("<td>" + c.getResourceId() + "</td><td>" + c.getResourceType() + "</td><td>" + c.getResourceUUID() + "</td>");
                        out.write("</tr>");
   }
} else {
            out.write("Failure");
            out.write(" Code: " + rs.getErrorCode());
}
%>

• 管理ユーザーとしてのログインと、実行するwebサービスの呼び出しの指定を含む、こちらの関数の基礎的なリクエストから開始します。
  
  

  Code Block
  theme Eclipse language java
  rsr.setLoginId("admin@yellowfin.com.au"); rsr.setPassword("test"); rsr.setOrgId(1); rsr.setFunction("GETIMPORTCONTENT");

• インポートするデータを含むファイルを指定します。

   

  Code Block
  theme Eclipse language java
  Path path = Paths.get("/Applications/Yellowfin 7.4/qwerty.yfx"); byte[] data = Files.readAllBytes(path); byte[] encodeBase64 = java.util.Base64.getEncoder().encode(data); String f = new String(encodeBase64, "UTF-8");

• ファイルの拡張子を提供します。例：YFX、またはXMLのいずれかです。

   

  Code Block
  theme Eclipse language java
  rsr.setParameters(new String[]{f,"YFX"});

• リクエストを構成したら、呼び出しを実行します。
  
  

  Code Block
  language java
  AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);

  管理サービスを初期化します。実行方法の詳細は、こちらを参照してください。

• 返される応答には、次の要素が含まれます。：StatusCodeとContentResource。（より詳細な情報は、上記応答パラメーターの表を参照してください）
  
  

<%      
/*      ws_getimportcontent.jsp                     */
%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="com.hof.util.*, java.util.*, java.text.*" %>
<%@ page import="com.hof.web.form.*" %>
<%@ page import="com.hof.mi.web.service.*" %>
<%@ page import="java.nio.file.Files" %>
<%@ page import="java.nio.file.Paths" %>
<%@ page import="java.nio.file.Path" %>
  
<%
AdministrationServiceService s_adm = new AdministrationServiceServiceLocator("localhost",8080, "/services/AdministrationService", false);       // adjust host and port number
AdministrationServiceSoapBindingStub adminService = (AdministrationServiceSoapBindingStub) s_adm.getAdministrationService();
AdministrationServiceRequest rsr = new AdministrationServiceRequest();
  
rsr.setLoginId("admin@yellowfin.com.au");                 // provide your Yellowfin web services admin account
rsr.setPassword("test");                                // set to the password of the above account
rsr.setOrgId(1);
rsr.setFunction("GETIMPORTCONTENT");
  
Path path = Paths.get("/Applications/Yellowfin 7.4/qwerty.yfx");      // existing file
  
byte[] data = Files.readAllBytes(path);
byte[] encodeBase64 = java.util.Base64.getEncoder().encode(data);
String f = new String(encodeBase64, "UTF-8");
  
rsr.setParameters(new String[]{f,"YFX"});
  
AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);
  
if ("SUCCESS".equals(rs.getStatusCode()) ) {
            ContentResource[] cr = rs.getContentResources();
            out.write("<br>Success");
            for (ContentResource o : cr){
                        out.write("<br><br>resourceType: " + o.getResourceType());
                        out.write("<br>resourceCode: " + o.getResourceCode());
                        out.write("<br>resourceName: " + o.getResourceName());
                        out.write("<br>resourceDescription: " + o.getResourceDescription());
                        out.write("<br>resourceOrgId: " + o.getResourceOrgId());
                        out.write("<br>resourceId: " + o.getResourceId());
                        out.write("<br>resourceUUID: " + o.getResourceUUID());
            }
} else {
            out.write("Failure");
            out.write(" Code: " + rs.getErrorCode());
}
%>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://webservices.web.mi.hof.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <web:remoteAdministrationCall>
         <!--Optional:-->
         <arg0>
            <loginId>admin@yellowfin.com.au</loginId>
            <password>test</password>
            <orgId>1</orgId>
            <function>IMPORTCONTENT</function>
            <parameters>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0i ... </parameters>
            <parameters>XML</parameters>
            <importOption>
                    <optionIndex>0</optionIndex>
                        <optionKey>OPTION</optionKey>
                        <optionValue>REPLACE</optionValue>
                    <optionIndex>1</optionIndex>
                        <optionKey>EXISTING</optionKey>
                        <optionValue>70279</optionValue>
             </importOption>
          </arg0>
      </web:remoteAdministrationCall>
   </soapenv:Body>
</soapenv:Envelope>

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
   <S:Body>
      <ns2:remoteAdministrationCallResponse xmlns:ns2="http://webservices.web.mi.hof.com/">
         <return>
            <errorCode>0</errorCode>
            <messages>Successfully Authenticated User: admin@yellowfin.com.au</messages>
            <messages>Web Service Request Complete</messages>
            <sessionId>3c25c8a81c971e26bd23d4ed60194fba</sessionId>
            <statusCode>SUCCESS</statusCode>
         </return>
      </ns2:remoteAdministrationCallResponse>
   </S:Body>
</S:Envelope>

• 管理ユーザーとしてのログインと、実行するwebサービスの呼び出しの指定を含む、こちらの関数の基礎的なリクエストから開始します。
  
  

  Code Block
  theme Eclipse language java
  rsr.setLoginId("admin@yellowfin.com.au"); rsr.setPassword("test"); rsr.setOrgId(1); rsr.setFunction("IMPORTCONTENT");

• インポートするデータを含むファイルを指定します。

   

  Code Block
  theme Eclipse language java
  Path path = Paths.get("/Applications/Yellowfin 7.4/YFexport.xml"); byte[] data = Files.readAllBytes(path); byte[] encodeBase64 = java.util.Base64.getEncoder().encode(data); String f = new String(encodeBase64, "UTF-8");

• ファイルの拡張子を提供します。例：YFX、またはXMLのいずれかです。

   

  Code Block
  theme Eclipse language java
  rsr.setParameters(new String[]{f,"XML"});

• ファイル内のコンテンツのインポート方法を指定します。

   

  Code Block
  theme Eclipse language java
  ImportOption[] options = new ImportOption[2]; options[0] = new ImportOption(); options[0].setItemIndex(0); options[0].setOptionKey("OPTION"); options[0].setOptionValue("REPLACE"); options[1] = new ImportOption(); options[1].setItemIndex(0); options[1].setOptionKey("EXISTING"); options[1].setOptionValue("70279");

• リクエストにインポートオプションオブジェクトを設定します。

   

  Code Block
  theme Eclipse language java
  rsr.setImportOptions(options);

• リクエストを構成したら、呼び出しを実行します。
  
  

  Code Block
  language java
  AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);

  管理サービスを初期化します。実行方法の詳細は、こちらを参照してください。

• 返される応答には、次の要素が含まれます。：StatusCode。（より詳細な情報は、上記応答パラメーターの表を参照してください）
  
  

<%      
/*      ws_importcontent.jsp                */
%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="com.hof.util.*, java.util.*, java.text.*" %>
<%@ page import="com.hof.web.form.*" %>
<%@ page import="com.hof.mi.web.service.*" %>
<%@ page import="java.nio.file.Files" %>
<%@ page import="java.nio.file.Paths" %>
<%@ page import="java.nio.file.Path" %>
<%
AdministrationServiceService s_adm = new AdministrationServiceServiceLocator("localhost",8080, "/services/AdministrationService", false);       // adjust host and port number
AdministrationServiceSoapBindingStub adminService = (AdministrationServiceSoapBindingStub) s_adm.getAdministrationService();
AdministrationServiceRequest rsr = new AdministrationServiceRequest();
  
rsr.setLoginId("admin@yellowfin.com.au");                     // provide your Yellowfin web services admin account
rsr.setPassword("test");                           <resourceCode>ATHLETES</resourceCode>
               <resourceDescription>Athletes</resourceDescription>
               <resourceId>60707</resourceId>
               <resourceName>Athletes</resourceName>
     // set to the password of the above account
rsr.setOrgId(1);
rsr.setFunction("IMPORTCONTENT");
  
/*      Yfexport.xml contains just one report with no dependencies
          <resourceOrgId>1</resourceOrgId>
  which can be retrieved using an EXPORTCONTENT web service call and passing a <resourceType>RPTSUBCATEGORY</resourceType>
single report id.
             <resourceUUID>72e4b4bd-a482-4a01-a031-c6ab76dbb3a5</resourceUUID>
            </contentResources>
FYI. Latest Yellowfin builds do not allow export Yellowfin content WITHOUT dependencies,
            so ImportOption <contentResources>
in this example will not suit any YFX file.
       <resourceCode>CAMP</resourceCode>
     You need to define proper ImportOption anyway
*/
Path path =  <resourceDescription>Camp</resourceDescription>Paths.get("/Applications/Yellowfin 7.4/YFexport.xml");
  
byte[] data = Files.readAllBytes(path);
byte[] encodeBase64 = java.util.Base64.getEncoder().encode(data);
String f = new String(encodeBase64, "UTF-8");
  <resourceId>60708</resourceId>
   
rsr.setParameters(new String[]{f,"XML"});
  
            <resourceName>Camp</resourceName>
    ImportOption[] options = new ImportOption[2];
           <resourceOrgId>1</resourceOrgId>
       options[0] = new ImportOption();
         <resourceType>RPTSUBCATEGORY</resourceType>
   options[0].setItemIndex(0);
            <resourceUUID>465411e5-594b-478e-af64-c0f59fc4546f</resourceUUID>options[0].setOptionKey("OPTION");
            </contentResources>
options[0].setOptionValue("REPLACE");
             <contentResources>
            options[1] =  <resourceCode>KPIS</resourceCode>new ImportOption();
            options[1].setItemIndex(0);
   <resourceDescription>KPIs</resourceDescription>
          options[1].setOptionKey("EXISTING");
     <resourceId>60709</resourceId>
        
       <resourceName>KPIs</resourceName>
      /*      existing report  <resourceOrgId>1</resourceOrgId>
          Id. Can be retrieved from ReportHeader table of Yellowfin database, ReportId column.
     <resourceType>RPTSUBCATEGORY</resourceType>
               <resourceUUID>d514c643-dc01-4781-8905-d34e761ccd19</resourceUUID>
    keep in mind that the reportId changes each </contentResources>
time when a user modifies the report.
      <contentResources>
               <resourceCode>MARKETINGBOOKING</resourceCode>
   You can use the GETIDFORUUID call to get the valid reportId value <resourceDescription>Marketingfor &amp; Booking</resourceDescription>the report.
            */
   <resourceId>60710</resourceId>
          options[1].setOptionValue("70279");
     <resourceName>Marketing &amp; Booking</resourceName>
      
rsr.setImportOptions(options);
  
AdministrationServiceResponse rs1      <resourceOrgId>1</resourceOrgId>
  = adminService.remoteAdministrationCall(rsr);
             <resourceType>RPTSUBCATEGORY</resourceType>
            if ("SUCCESS".equals(rs1.getStatusCode())  <resourceUUID>dbe6d0a3-c088-4d71-b65a-f383aaa54be9</resourceUUID>) {
            </contentResources>
            <contentResources>
    out.write("<br>Test Import Success");
            <resourceCode>TRAINING</resourceCode>}
            else {
  <resourceDescription>Training</resourceDescription>
          out.write("Failure");
     <resourceId>60711</resourceId>
       out.write(" Code: "   + rs1.getErrorCode());
   <resourceName>Training</resourceName>
         }      <resourceOrgId>1</resourceOrgId>
    
  
%>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://webservices.web.mi.hof.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <web:remoteAdministrationCall>
           <resourceType>RPTSUBCATEGORY</resourceType>
               <resourceUUID>c503ea57-cc69-43a9-98bc-a90ebbe1c864</resourceUUID>
            </contentResources>
            <contentResources>
               <resourceDescription/>
               <resourceId>70101</resourceId>
               <resourceName>Oracle database</resourceName>
               <resourceOrgId>1</resourceOrgId>
               <resourceType>DATASOURCE</resourceType>
            </contentResources>
            <contentResources>
         !--Optional:-->
      <resourceDescription/>
   <arg0>
            <resourceId>70109</resourceId><loginId>admin@yellowfin.com.au</loginId>
               <resourceName>Oracle</resourceName><password>test</password>
               <resourceOrgId>1</resourceOrgId><orgId>1</orgId>
            <function>TESTIMPORTCONTENT</function>
   <resourceType>DATASOURCE</resourceType>
          <parameters>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0i ... </contentResources>parameters>
            <contentResources><parameters>XML</parameters>
               <resourceDescription>Ski Team is the demonstration and tutorial database.</resourceDescription>
<importOption>
                    <resourceId>54700<<optionIndex>0</resourceId>optionIndex>
               <resourceName>Ski Team</resourceName>
               <resourceOrgId>1</resourceOrgId><optionKey>OPTION</optionKey>
               <resourceType>DATASOURCE</resourceType>
          <optionValue>REPLACE</optionValue>
  </contentResources>
            <contentResources>
      <optionIndex>1</optionIndex>
         <resourceDescription/>
               <resourceId>54701<<optionKey>EXISTING</resourceId>optionKey>
               <resourceName>Yellowfin Configuration Database</resourceName>
       <optionValue>70279</optionValue>
        <resourceOrgId>1</resourceOrgId>
     </importOption>
          <resourceType>DATASOURCE<</resourceType>arg0>
      </web:remoteAdministrationCall>
   </soapenv:Body>
</soapenv:Envelope> 

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">  </contentResources>
   <S:Body>
         <contentResources><ns2:remoteAdministrationCallResponse xmlns:ns2="http://webservices.web.mi.hof.com/">
               <resourceDescription/><return>
            <contentResources>
   <resourceId>70108</resourceId>
            <resourceDescription>months, 6/3/2018 8:53 <resourceName>c<AM</resourceName>resourceDescription>
               <resourceOrgId>1<<resourceId>70279</resourceOrgId>resourceId>
            <resourceName>My Report  <resourceType>DATASOURCE<1000</resourceType>resourceName>
            <<resourceType>REPORT</contentResources>resourceType>
            <contentResources>
   <resourceUUID>fd3794b3-62c0-4cf8-bac0-755e68d9c41e</resourceUUID>
            <resourceDescription</>contentResources>
               <resourceId>70110</resourceId><errorCode>0</errorCode>
               <resourceName>f</resourceName><importIssues>
               <resourceOrgId>1</resourceOrgId>
<issueElements>
                <resourceType>DATASOURCE</resourceType><messageKey>error.reports.import.view</messageKey>
            </contentResources>
    <renderedMessage>View has not been selected.</renderedMessage>
    <contentResources>
        </issueElements>
       <resourceDescription>This is a tutorial view for<issueElements>
 training and demo purposes.</resourceDescription>
               <resourceId>60543</resourceId><messageKey>error.reports.import.category</messageKey>
               <resourceName>Ski Team</resourceName>
<renderedMessage>Folder has not been selected.</renderedMessage>
           <resourceType>VIEW< </resourceType>issueElements>
            <resource>
   <resourceUUID>e3632adb-5194-460c-a172-c085416f493f</resourceUUID>
            </contentResources>
   <resourceDescription>months, 6/3/2018 8:53 AM</resourceDescription>
      <contentResources>
           <resourceId>70279</resourceId>
    <resourceDescription>This view should be used to monitor usage of Yellowfin by User and<resourceName>My ContentReport Type.<1000</resourceDescription>resourceName>
               <resourceId>56169</resourceId>
   <resourceType>REPORT</resourceType>
                <resourceName>Yellowfin Usage Audit</resourceName> <resourceUUID>fd3794b3-62c0-4cf8-bac0-755e68d9c41e</resourceUUID>
               <resourceType>VIEW</resourceType></resource>
            </importIssues>
   <resourceUUID>fb6416c4-441e-42b3-a442-e7426f25f6b4</resourceUUID>
         <messages>Successfully Authenticated  </contentResources>User: admin@yellowfin.com.au</messages>
            <contentResources>
<messages>Web Service Request Complete</messages>
            <resourceDescription>This dashboard contains a set of reports covering general system and admin information, including performance, sessions, data source &amp; view usage.</resourceDescription><sessionId>ab398569ce36672e9d776c3dae3804d6</sessionId>
          <statusCode>SUCCESS</statusCode>
         </return>
      </ns2:remoteAdministrationCallResponse>
   </S:Body>
</S:Envelope>

• 管理ユーザーとしてのログインと、実行するwebサービスの呼び出しの指定を含む、こちらの関数の基礎的なリクエストから開始します。
  
  

  Code Block
  theme Eclipse language java
  rsr.setLoginId("admin@yellowfin.com.au"); rsr.setPassword("test"); rsr.setOrgId(1); rsr.setFunction("TESTIMPORTCONTENT");

• インポートするデータを含むファイルを指定します。

   

  Code Block
  theme Eclipse language java
  Path path

• = Paths.get("/Applications/Yellowfin 7.4/qwerty.yfx"); byte[] data = Files.readAllBytes(path); byte[] encodeBase64 = java.util.Base64.getEncoder().encode(data); String f = new String(encodeBase64, "UTF-8");

• ファイルの拡張子を提供します。例：YFX、またはXMLのいずれかです。

   

  Code Block
  theme Eclipse language java
  rsr.setParameters(new String[]{f,"YFX"});

• リクエストを構成したら、呼び出しを実行します。
  
  

  Code Block
  language java
  AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);

  管理サービスを初期化します。実行方法の詳細は、こちらを参照してください。

• インポートしたコンテンツをテストします。

   

  Code Block
  theme Eclipse language java
  if ("SUCCESS".equals(rs.getStatusCode()) ) {

• out.write("<br>Success"); ContentResource[] crs = rs.getContentResources(); ImportIssue[] ImportIssues

• = rs.getImportIssues();

• out.write("<br>Import Issues: " + (ImportIssues!=null?ImportIssues.length:"no issues"));

• out.write("<table>");

• out.write("<tr><td> ResourceId </td><td> ResourceType </td><td> ResourceName </td><td> ResourceUUID <

• /td></tr>");

• for (ContentResource c: crs) {

• out.write("<tr>");

• out.write("<td>" + c.getResourceId() +

• "</td><td>" + c.getResourceType() + "</td><td>" + c.getResourceName() + "</td><td>" + c.getResourceUUID() + "</td>");