KB486718: How to retrieve Report Service Document data in XML format with MicroStrategy Task API

To retrieve report service document data in XML format using the Task API in Strategy 2021 and above, the following steps should be followed.

• Login to the Strategy task admin page and create a task named "RWDataService" at the following URL: http://<webserver>/MicroStrategy/servlet/taskAdmin?pg=builder#
  
• In the task field, locate the following parameters and fill in the respective values
  
• Task Envelope = xml
  
• Task Content Type = xml [Default]
  
• styleName = RWDataVisualizationXMLStyle
  
• reportViewMode = 1
  
• Enter the necessary server, project, document, and authentication parameters:
  

• Click on 'Update URL' to generate the Task API URL.
  
• Click on 'Invoker URL' to obtain the returned XML data captured from the underlying document. 
  

Note: In case users encounter errors like "Report has merge row headers. Make sure the report property 'MergeCells' is off" while invoking the Task URL for Strategy 2021, consider the following options:

1. Include the parameter "resultFlags=393216"
   
2. Alternatively, add the following parameter to the sys_defaults.xml file under WEB-INF/xml/
   
• <pr n="isMergeRowHeadersNewBehavior" scp="server" v="0" dt="boolean"/>
  
3. ​​​​​​​​​​​​​​Restart the web server.​​​​​​​​​​​​​​