Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleTABSFROMPARENTGROUPID

Returns the metadata of all published dashboards’ parent tabs, along with details of the dashboard reports. In case of multiple sub tabs within the dashboard, only the details of the parent tab are retrieved, however this call will return metadata of the entire dashboard's reports, including those in the sub tabs. Use the AdministrationPerson object to specify the user for this calluser's dashboard tabs with their sub tab's IDs. You may provide the ID of a particular tab or sub tab to retrieve its details. Specify the user by using the AdministrationPerson object.

 

Request Parameters

The following parameters should be passed with this request:

Request Element

Data Type

Description

LoginId

String

An admin account to connect to Yellowfin web services. This can be the user ID or the email address, depending on the Logon ID method.

This account must have the “web services” role enabled, and must belong to the default (i.e. primary) org.

Password

String

Password of the above account.

OrgId

Integer

Default (i.e. primary) organization ID within Yellowfin. Always set this to 1.

Function

String

Web service function. Set this to "GETUSERTABSWITHREPORTSTABSFROMPARENTGROUPID".

PersonAdministrationPersonObject containing details of the user. See table below.
OrgRefStringAn optional parameter to specify a client organization reference ID to search for the dashboard tab within a particular client org, instead of the default organization.
DashboardTabIdIntegerThis optional parameter can be used to retrieve details of a specific dashboard tab and its reports. Note, however, that this tab should already exist in Yellowfin.

 

Anchor
getusertabrepapgetgrouptabsapgetusertabrepap
getgrouptabsap

These are the main parameters that you must set in the AdministrationPerson object for this web service call:

AdministrationPerson Element

Data Type

Description

UserId

String

To identify the user for whom to retrieve the dashboard tab. This could be the user ID or email address, depending on the Logon ID method.

 

 

Request Example

Below is a SOAP XML example for this request:

Code Block
languagexml
 

 

Response Parameters

The returned response will contain these parameters:

Response Element

Data Type

Description

StatusCode

String

Status of the web service call. Possible values include:

  • SUCCESS
  • FAILURE

ReportGroups

AdministrationReportGroup[]

An array object containing the dashaboard metadata along with the elements listed in the table below.

 

Each element of the ReportGroups will contain the following elements:

Response Element

Data Type

Description

GroupReportsAdministrationReport[]An array object containing the metadata of all of the dashboard's reports.

 

 

Response Example

The service will return the below response, according to our SOAP example:

Code Block
languagexml
 

 

Instructions

See below for step-by-step instructions on how to perform this call, using a Java example:

Expand
titleStep-by-step instructions
 <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>TABSFROMPARENTGROUPID</function>
            <person>
                <userId>admin@yellowfin.com.au</userId>              
            </person>       
         </arg0>
      </web:remoteAdministrationCall>
   </soapenv:Body>
</soapenv:Envelope>

 

Response Parameters

Start with a basic request for this function, which includes logging in as the admin user and specifying the web service call to perform:
Code Block
languagejava
AdministrationServiceRequest rsr = new AdministrationServiceRequest();

rsr.setLoginId("admin@yellowfin.com.au");
rsr.setPassword("test");
rsr.setOrgId(1);

rsr.setFunction("GETUSERTABSWITHREPORTS");

You may even identify a specific client organization:

Code Block
languagejava
rsr.setOrgRef("org1");
  • Specify the user for whom to retrieve the report:

    Code Block
    languagejava
    AdministrationPerson ap = new AdministrationPerson();
    ap.setUserId("admin@yellowfin.com.au");
    
    rsr.setPerson(ap);
    • Once the request is configured, perform the call:

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

      Initialize the Administration web service. Click here to learn how to do this. 

     

    The response returned will contain these parameters:

    The returned response will contain these parameters:

    Response Element

    Data Type

    Description

    StatusCode

    String

    Status of the web service call. Possible values include:

    • SUCCESS
    • FAILURE
    ReportGroups

    ParentDashboards

    AdministrationReportGroup

    ParentDashboard[]

    An array object containing the

    dashaboard metadata along with the

    dashboard's metadata including elements listed in the table below.

     

    Each element of the

    ReportGroups

    ParentDashboard will contain the following elements:

    Response Element

    Data Type

    Description

    GroupReports

    DashboardName

    String

     Name of the dashboard.

    DashboardGroupId

    Integer

     

    TabIds

    String

    AdministrationReport

    []

    An array object containing the metadata of all of the dashboard's reports.You can then retrieve the reports of the first dashboard tab:
    Code Block
    languagejava
    AdministrationReport[] rpts =  response.getReportGroups()[0].getGroupReports();

     

    Array of the sub tabs id’s

    TabNames

    String[]

    Array of the sub tabs names

    statusCodes

    String[]

    Array of the sub tabs statuses

     

     

    Response Example

    The service will return the below response, according to our SOAP example:

    Code Block
    languagexml
     <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>Getting user information...</messages>
                <messages>Getting user information...</messages>
                <messages>Web Service Request Complete</messages>
                <parentDashboards>
                   <dashboardGroupId>61250</dashboardGroupId>
                   <dashboardName>Sales Performance</dashboardName>
                   <statusCodes>OPEN</statusCodes>
                   <tabIds>61251</tabIds>
                   <tabNames>New Tab</tabNames>
                </parentDashboards>
                <parentDashboards>
                   <dashboardGroupId>61209</dashboardGroupId>
                   <dashboardName>Campaign Analysis</dashboardName>
                   <statusCodes>OPEN</statusCodes>
                   <statusCodes>OPEN</statusCodes>
                   <tabIds>61210</tabIds>
                   <tabIds>61243</tabIds>
                   <tabNames>Campaigns</tabNames>
                   <tabNames>Marketing</tabNames>
                </parentDashboards>
                <person>
                   <emailAddress>admin@yellowfin.com.au</emailAddress>
                   <firstName>System</firstName>
                   <initial/>
                   <ipId>5</ipId>
                   <languageCode>EN</languageCode>
                   <lastName>Administrator</lastName>
                   <roleCode>YFADMIN</roleCode>
                   <salutationCode/>
                   <status>ACTIVE</status>
                   <timeZoneCode>AUSTRALIA/SYDNEY</timeZoneCode>
                   <userId>admin@yellowfin.com.au</userId>
    

     

     

    Complete Example

    Below is a full example of this web service call. To use it for yourself, carry out the following the steps:

    1. Copy the code and save it as ws_ getusertabswithreports.jsp.
    2. Put the file in the root folder: Yellowfin/appserver/webapps/ROOT.
    3. Adjust the host, port, and admin user according to your environment.
    4. Run http://<host>:<port>/ws_ getusertabswithreports.jsp from your Internet browser.

     

    Code Block
    languagexml
    themeEclipse
    <%            </person>
    /*            <sessionId>1b1898c42b69302ce9b3426b5a17e5a0</sessionId>
                  ws_getusertabswithreports.jsp<statusCode>SUCCESS</statusCode>
             </return>
          *</ns2:remoteAdministrationCallResponse>
    %>
    <%@ 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.*" %>
    <%
    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 </S:Body>
    </S:Envelope>

     

    Instructions

    See below for step-by-step instructions on how to perform this call, using a Java example:

    Expand
    titleStep-by-step instructions
    • Start with a basic request for this function, which includes logging in as the admin user and specifying the web service call to perform:

      Code Block
      languagejava
      AdministrationServiceRequest rsr = new AdministrationServiceRequest();
      
      rsr.setLoginId("admin@yellowfin.com.au");
      rsr.setPassword("test");
      rsr.setOrgId(1);
      
      rsr.setFunction("TABSFROMPARENTGROUPID");
    • You may even identify a specific client organization:

      Code Block
      languagejava
      rsr.setOrgRef("org1");



    • Specify the user for whom to retrieve the dashboard:

      Code Block
      languagejava
      AdministrationPerson ap = new AdministrationPerson();
      ap.setUserId("admin@yellowfin.com.au");
      
      rsr.setPerson(ap);
    • Provide a dashboard ID to view only that dashboard's details:

      Code Block
      languagejava
      rsr.setDashboardTabId(61209);  				// dashboard Id (ReportGroup.GroupId field of Yellowfin's database)
      



    • Once the request is configured, perform the call:

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

      Initialize the Administration web service. Click here to learn how to do this. 

     

    • The response returned will contain these parameters: StatusCode and ParentDashboard array. See the response parameter chart above for details on these.

     

     

     

    Complete Example

    Below is a full example of this web service call. To use it for yourself, carry out the following the steps:

    1. Copy the code and save it as ws_tabsfromparentgroupid.jsp.
    2. Put the file in the root folder: Yellowfin/appserver/webapps/ROOT.
    3. Adjust the host, port, and admin user according to your environment.
    4. Run http://<host>:<port>/ws_tabsfromparentgroupid.jsp from your Internet browser.

     

    Code Block
    languagejava
    themeEclipse
    <%   // provide your Yellowfin web services admin account
    rsr.setPassword("test");                           // set to the password of the above account
    rsr.setOrgId(1);
    
    rsr.setFunction("GETUSERTABSWITHREPORTS");
    rsr.setOrgRef("org1");
    AdministrationPerson ap = new AdministrationPerson();
    ap.setUserId("admin@yellowfin.com.au");  			
    rsr.setPerson(ap);
    
    AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);
    
    if ("SUCCESS".equals(rs.getStatusCode()) ) {
    	out.write("Success<br>" + rs.getReportGroups().length + " tabs retrieved");
    	
    	// get the tabs details:
    	AdministrationReportGroup[] tabs = rs.getReportGroups();
    	for (AdministrationReportGroup tab: tabs){
    		out.write("<br><br><h1>Dashboard Name: " + tab.getReportGroupName() + "</h1>");
    		AdministrationReport[] rpts = tab.getGroupReports();
    		if (rpts != null)
    			for (AdministrationReport r: rpts){ 
    				out.write("Report Name: " + r.getReportName());
    				out.write("<br>Description: " + r.getReportDescription());
    				out.write("<br>ReportId: " + r.getReportId());
    				out.write("<br>ReportUUID: " + r.getReportUUID());
    				out.write("<br>ExecutionObject: " + r.getExecutionObject());
    				out.write("<br>ReportCategory: " + r.getReportCategory());
    				out.write("<br>SubCategory: " + r.getReportSubCategory());
    				out.write("<br>BirtData: " + r.getBirtData());
    				out.write("<br>SourceName: " + r.getSourceName());
    				out.write("<br>SourceId: " + r.getSourceId());
    				out.write("<br>AuthoringMode: " + r.getAuthoringMode());
    				out.write("<br>ReportTemplate: " + r.getReportTemplate());
    				out.write("<br>DataOutput: " + r.getDataOutput());
    				out.write("<br>DashboardEnabled: " + r.isDashboardEnabled());
    				out.write("<br>ViewId: " + r.getViewId());
    				out.write("<br>ViewName: " + r.getViewName());
    				out.write("<br>ViewDescription: " + r.getViewDescription());
    				out.write("<br>LastModifierName: " + r.getLastModifierName());
    				out.write("<br>LastModifierId: " + r.getLastModifierId());
    				out.write("<br>LastModifiedDate: " + r.getLastModifiedDate());
    				out.write("<br>PublishDate: " + r.getPublishDate());
    				out.write("<br>DeliveryMode: " + r.getDeliveryMode());
    				out.write("<br>LastRunTime: " + r.getLastRunTime());
    				out.write("<br>AverageRunTime: " + r.getAverageRunTime());
    				out.write("<br>RoleCode: " + r.getRoleCode());
    				out.write("<br>ChartTypeCode: " + r.getChartTypeCode());
    				out.write("<br>Usage: " + r.getUsage());
    				out.write("<br><br>");
    			}
    /*              ws_tabsfromparentgroupid.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.*" %>
    <%
    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("TABSFROMPARENTGROUPID");
    
    //rsr.setDashboardTabId(61209);  					// add this to get subtabs for a particular dashboard tab.
    
     
    rsr.setOrgRef("org1");
    AdministrationPerson ap = new AdministrationPerson();
    ap.setUserId("admin@yellowfin.com.au");  			
    rsr.setPerson(ap);
    
    AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);
    
    if ("SUCCESS".equals(rs.getStatusCode()) ) {
    	
    	//out.write("Success<br>" + rs.getReportGroups().length + " tabs retrieved");
    	// get the tabs details:
    	ParentDashboard[] tabs = rs.getParentDashboards();
    	if (tabs != null) 
    	for (ParentDashboard tab: tabs){
    		out.write("<br><br>Dashboard Name: " + tab.getDashboardName());
    		out.write("<br>DashboardId: " + tab.getDashboardGroupId());
    		out.write("<br>tabIds (N): " + tab.getTabIds().length);
    	}
    } else {
    		out.write("Failure");
    		out.write(" Code: " + rs.getErrorCode());
    }
    %>
    
    

     


     

    Expand
    titleGETUSERPARENTTABSWITHREPORTSLOADTABS

    Returns the metadata of all published dashboards’ parent tabs, along with details of the dashboard reports. In case of multiple sub tabs within the dashboard, only the details of the parent tab are retrieved, however this call will return metadata of the entire dashboard's reports, including those in the sub tabs. Use the AdministrationPerson object to specify the user for this call.

     

    Request Parameters

    The following parameters should be passed with this request:

    Request Element

    Data Type

    Description

    LoginId

    String

    An admin account to connect to Yellowfin web services. This can be the user ID or the email address, depending on the Logon ID method.

    This account must have the “web services” role enabled, and must belong to the default (i.e. primary) org.

    Password

    String

    Password of the above account.

    OrgId

    Integer

    Default (i.e. primary) organization ID within Yellowfin. Always set this to 1.

    Function

    String

    Web service function. Set this to "GETUSERTABSWITHREPORTS".

    PersonAdministrationPersonObject containing details of the user. See table below.
    OrgRefStringAn optional parameter to specify a client organization reference ID to search for the dashboard within a particular client org, instead of the default organization.
    DashboardTabIdIntegerThis optional parameter can be used to retrieve details of a specific dashboard tab and its reports. Note, however, that this tab should already exist in Yellowfin.

     

    Anchor
    getusertabrepap
    getusertabrepap

    These are the main parameters that you must set in the AdministrationPerson object for this web service call:

    AdministrationPerson Element

    Data Type

    Description

    UserId

    String

    To identify the user for whom to retrieve the dashboard. This could be the user ID or email address, depending on the Logon ID method.

     

     

    Request Example

    Below is a SOAP XML example for this request:

    Code Block
    languagexml
     

     

    Response Parameters

    The returned response will contain these parameters:

    Response Element

    Data Type

    Description

    StatusCode

    String

    Status of the web service call. Possible values include:

    • SUCCESS
    • FAILURE

    ReportGroups

    AdministrationReportGroup[]

    An array object containing the dashaboard metadata along with the elements listed in the table below.

     

    Each element of the ReportGroups will contain the following elements:

    Response Element

    Data Type

    Description

    GroupReportsAdministrationReport[]An array object containing the metadata of all of the dashboard's reports.

     

     

    Response Example

    The service will return the below response, according to our SOAP example:

    Code Block
    languagexml
     

     

    Instructions

    See below for step-by-step instructions on how to perform this call, using a Java example:

    Expand
    titleStep-by-step instructions
    • Start with a basic request for this function, which includes logging in as the admin user and specifying the web service call to perform:

      Code Block
      languagejava
      AdministrationServiceRequest rsr = new AdministrationServiceRequest();
      
      rsr.setLoginId("admin@yellowfin.com.au");
      rsr.setPassword("test");
      rsr.setOrgId(1);
      
      rsr.setFunction("GETUSERTABSWITHREPORTS");
    • You may even identify a specific client organization:

      Code Block
      languagejava
      rsr.setOrgRef("org1");



    • Specify the user for whom to retrieve the report:

      Code Block
      languagejava
      AdministrationPerson ap = new AdministrationPerson();
      ap.setUserId("admin@yellowfin.com.au");
      
      rsr.setPerson(ap);
    • Once the request is configured, perform the call:

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

      Initialize the Administration web service. Click here to learn how to do this. 

     

    • The response returned will contain these parameters:

      The returned response will contain these parameters:

      Response Element

      Data Type

      Description

      StatusCode

      String

      Status of the web service call. Possible values include:

      • SUCCESS
      • FAILURE

      ReportGroups

      AdministrationReportGroup[]

      An array object containing the dashaboard metadata along with the elements listed in the table below.

       

      Each element of the ReportGroups will contain the following elements:

      Response Element

      Data Type

      Description

      GroupReportsAdministrationReport[]An array object containing the metadata of all of the dashboard's reports.
    • You can then retrieve the reports of the first dashboard tab:

      Code Block
      languagejava
      AdministrationReport[] rpts =  response.getReportGroups()[0].getGroupReports();

     

     

     

    Complete Example

    Below is a full example of this web service call. To use it for yourself, carry out the following the steps:

    1. Copy the code and save it as ws_ getusertabswithreports.jsp.
    2. Put the file in the root folder: Yellowfin/appserver/webapps/ROOT.
    3. Adjust the host, port, and admin user according to your environment.
    4. Run http://<host>:<port>/ws_ getusertabswithreports.jsp from your Internet browser.

     

    Code Block
    languagexml
    themeEclipse
    <%            
    /*              ws_getusertabswithreports.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.*" %>
    <%
    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("GETUSERTABSWITHREPORTS");
    rsr.setOrgRef("org1");
    AdministrationPerson ap = new AdministrationPerson();
    ap.setUserId("admin@yellowfin.com.au");  			
    rsr.setPerson(ap);
    
    AdministrationServiceResponse rs = adminService.remoteAdministrationCall(rsr);
    
    if ("SUCCESS".equals(rs.getStatusCode()) ) {
    	out.write("Success<br>" + rs.getReportGroups().length + " tabs retrieved");
    	
    	// get the tabs details:
    	AdministrationReportGroup[] tabs = rs.getReportGroups();
    	for (AdministrationReportGroup tab: tabs){
    		out.write("<br><br><h1>Dashboard Name: " + tab.getReportGroupName() + "</h1>");
    		AdministrationReport[] rpts = tab.getGroupReports();
    		if (rpts != null)
    			for (AdministrationReport r: rpts){ 
    				out.write("Report Name: " + r.getReportName());
    				out.write("<br>Description: " + r.getReportDescription());
    				out.write("<br>ReportId: " + r.getReportId());
    				out.write("<br>ReportUUID: " + r.getReportUUID());
    				out.write("<br>ExecutionObject: " + r.getExecutionObject());
    				out.write("<br>ReportCategory: " + r.getReportCategory());
    				out.write("<br>SubCategory: " + r.getReportSubCategory());
    				out.write("<br>BirtData: " + r.getBirtData());
    				out.write("<br>SourceName: " + r.getSourceName());
    				out.write("<br>SourceId: " + r.getSourceId());
    				out.write("<br>AuthoringMode: " + r.getAuthoringMode());
    				out.write("<br>ReportTemplate: " + r.getReportTemplate());
    				out.write("<br>DataOutput: " + r.getDataOutput());
    				out.write("<br>DashboardEnabled: " + r.isDashboardEnabled());
    				out.write("<br>ViewId: " + r.getViewId());
    				out.write("<br>ViewName: " + r.getViewName());
    				out.write("<br>ViewDescription: " + r.getViewDescription());
    				out.write("<br>LastModifierName: " + r.getLastModifierName());
    				out.write("<br>LastModifierId: " + r.getLastModifierId());
    				out.write("<br>LastModifiedDate: " + r.getLastModifiedDate());
    				out.write("<br>PublishDate: " + r.getPublishDate());
    				out.write("<br>DeliveryMode: " + r.getDeliveryMode());
    				out.write("<br>LastRunTime: " + r.getLastRunTime());
    				out.write("<br>AverageRunTime: " + r.getAverageRunTime());
    				out.write("<br>RoleCode: " + r.getRoleCode());
    				out.write("<br>ChartTypeCode: " + r.getChartTypeCode());
    				out.write("<br>Usage: " + r.getUsage());
    				out.write("<br><br>");
    			}
    	}
    } else {
    		out.write("Failure");
    		out.write(" Code: " + rs.getErrorCode());
    }
    %>