Skip to main content

View Dashboard metrics via API

  • October 6, 2012
  • 7 replies
  • 254 views
A
Apprentice
How would we construct an API call to view the dashboard metrics (open, overdue, pending, etc) via a third-party app? Is it related to view tickets?
    This topic has been closed for replies.

    7 replies

    V
    Contributor
    • vijay.shankar
    • Contributor
    • October 8, 2012
    Hi Allen

    Easiest way to address this would be creating a Custom View. Go to Tickets -> Select the 3 checkbox - Open,Overdue & Pending. Now, click on SAVE on the top and give a name to this view - e.g. APIView

    Now, use this method to fetch this data via API

     $.ajax({
    url: getUrl("helpdesk/tickets/filter/new_my_open"),
    dataType : 'json',
    success: function(data) {
    - code for processing data --
      }

    regards
    Vijay

     
    A
    Apprentice
    • allen
    • Author
    • Apprentice
    • October 8, 2012
    Hi Vijay,

    Thanks for your feedbck. I tried all of the following URLs:

    http://support.MYDOMAIN.com/helpdesk/tickets.xml
    http://support.MYDOMAIN.com/helpdesk/tickets

    http://support.MYDOMAIN.com/helpdesk/tickets/filter/new_my_open

    http://support.MYDOMAIN.com/helpdesk/tickets/filter/new_my_open.xml
    http://support.flatcreek.com/helpdesk/tickets/view/#####
    http://support.flatcreek.com/helpdesk/tickets/view/#####.xml

    And keep getting the error message:

    "Unable to retrieve data. Try a different URL or check to make sure the resource is available."

    I am using basic HTTP authentication and checking for JSON datatype.

    Any thoughts on what might be wrong?

    Thank you,
    Allen 
    V
    Contributor
    • vijay.shankar
    • Contributor
    • October 8, 2012
    Hey Allen,

    Just raised this as a Ticket, so we can discuss further on this

    regards
    Vijay
    V
    Contributor
    • vijay.shankar
    • Contributor
    • October 13, 2012

     

    Hi Allen

    You can use the URL directly in the Klipfolio datasource section, I tried a few views like Open Tickets or All Open and they work fine.

    Follow the process below.
     
    1. Select the filters on the Right side, in Tickets list view.
    2. E.g Open, Pending 
    3. Save this view and you will notice the URL for this view as : abc.freshdesk.com/helpdesk/tickets/view/12345
    4. Now this : 12345 is the key to be used to get those tickets via API
    5. In Klipfolio, Add a New Data source -> Web accessible Resource.
    6. In URL, use the method : https://abc.freshdesk.com/helpdesk/tickets.xml?filter_key=12345
    7. Data format : XML , Method : GET , Authentication Type : Basic - Give your Admin Username and Password
    8. Now, after you save, you will see all the tickets in the 1st page and if you need to go to next page, select ?Page=2 and so on
    9. Currently we don't have the option to show Open or Closed counts value. We will enable this in our API soon
    You can access your ticket online here – https://support.freshdesk.com/helpdesk/tickets/23082

    Kind regards

    Vijay Shankar
    Freshdesk Support

    PS : Check our Solutions & Forums for FAQs and Features.

    M
    Community Debut
    • m.vanleeuwen
    • Community Debut
    • June 20, 2013

    Hi Vijay,


    Is the open and closed count option available in the API? We really could use this for our dashboard. 


    Kind regards,


    Martijn

    B
    Community Debut
    • balashoff
    • Community Debut
    • September 23, 2013

    It's been 11 months since last answer and still no simple 'count' requests in API. Please add open, closed and overdue count to the API.
    That's the only data we need for our dashboard.
    H
    Community Debut
    • helpdesk
    • Community Debut
    • September 18, 2015

    Are there any plans to improve the dashboard view to columnar form where we can simply filter what type of columns we want to view to get a birds eye view on a number of ticket data. For example, I would like have a column for all selected type tickets fields to display action column data rather than having to go into each ticket to view action or task or to do list. It is a bit cumbersome not to be able to get dashboard outlay of ticket data as a matrix without having to export the data.



    Terms of UseAccessibility statement