Forum Discussion

DanielThurber's avatar
DanielThurber
Qrew Trainee
7 years ago

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

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. 

3 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 | [email protected]
    Quandary Knowledge Base
  • 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 | [email protected]
    Quandary Knowledge Base