Skip to main content
Question

How to get raw data from Report so i can make a custom HTML page with my own formatting and look and feel

  • May 14, 2019
  • 0 replies
  • 55 views
I want to be able to change the look and feel of the report using a custom html page. How can i grab the data used in a report or a current view to make my own HTML page. 
    This topic has been closed for replies.

    API_DoQuery will get you the raw result in XML format that you can parse into a collection and then put that data into an HTML table or whatever format you want. Just parse the XML out and organize it however you need and display it accordingly. 

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    • DanielThurber
    • Author
    • Registered
    • May 14, 2019
    Thank you. Can you give me a sample URL DO query? I am trying to get it working now. I have looked into the guide and got this error  

    <action>API_DoQuery</action>
    <errcode>4</errcode>
    <errtext>Bad ticket</errtext>
    <errdetail>Your ticket was not formatted correctly.</errdetail>
    How in particular are you making the doQuery request? Via GET or POST? The sample post from the API doc is below. From you particular error - you have an auth issue. So you're either not authenticated when you're trying to load this - or you have something off about the <ticket> or <usertoken> tags

    <qdbapi>
       <ticket>auth_ticket</ticket>
       <apptoken>app_token</apptoken>
       <udata>mydata</udata>
       <query>{'5'.CT.'Ragnar Lodbrok'}AND{'5'.CT.'Acquisitions'}</query>
       <includeRids>1</includeRids>
       <clist>5.6.7.22.3</clist>
       <slist>3</slist>
       <options>num-4.sortorder-A.skp-10.onlynew</options>
       <fmt>structured</fmt>
    </qdbapi>

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    Terms & ConditionsAccessibility statement