0 Replies Latest reply on Mar 3, 2015 4:56 AM by pablopicasso

    Getting specific data as json instead of csv

    pablopicasso

      Hi,

       

      I have a question regarding the integrated reports in the jive front end.

       

      I have the possibility to get a list of spaces by sending in this request to Jive with a WebRequest object.

      https://jive.ourcompany.com/global-reports.jspa?display=places_activity&dateRangeType=custom&minDate=2014-12-1&maxDate=2014-12-31

       

      The result is a csv list containing all those relevant data:

       

      Place Name

      Display Name

      Creation Date

      Place ID

      Type

      Number of Views

      Number of Likes

      Number of Rates and Votes

      Number of Responses

      Number of Revisions

      Number of Creates

      Current Number of Followers

      Our Help Forum

      our_help

      ########

      2107

      Community

      1386

      5

      0

      54

      0

      26

      369

      The Blue Section

      thebluesection

      ########

      2196

      Community

      644

      2

      0

      0

      0

      8

      101

      QWW Global Team

      qww-global-team

      ########

      1185

      Group

      478

      10

      7

      7

      20

      23

      34

       

       

      I need exactly those data (like Number of Responses, Number of Likes, etc...). I would like to them as JSON instead of CSV. Is there an option to get those data as json?

       

      Any help is appreciated.

       

      Thanks a lot.