Forum Discussion

Nav's avatar
Nav
Ace
7 years ago

Bulk data api - How to get Conversation title instead of their replies

Hi,

I am new to Lithium Community.

In Bulk Api responses, I am looking for conversation.title without their replies. I can see same conversation title appear with different Visit.id, Visitor.Id and with other some changes. 

Which is the actual conversation in the response and how to filter it? 

 

[20] => Array
        (
            [document.id] => visits.visit-summary_SESSION_xxxxxxxxxxxxxxxxxx
            [action.duration] => 0
            [board.uid] => xxxx
            [board.title] => xxxxxxxxxxxxxxxx
            [community_app] => xxxxxxxxxxx
            [conversation.uid] => xxxxxxxxxxxxxxx
            [conversation.title] => xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
            [node.ancestor_path] => /x/x/xxx/
            [visit.id] => xxxxxxxxxxxxxxxx
            [visitor.id] => xxxxxxxxxxxxx
            [user.uid] => -x
            [user.login] => xxxxxxxxxxxxxxx
            [request.url.host] => xxxxxxxxxxxxxxxxxxxxxxx
            [request.headers.user_agent] => xxxxx
            [request.headers.referrer.url] => Array
                (
                    [0] => xxxxx
                )

            [request.headers.referrer.host] => Array
                (
                    [0] => xxxx
                )

            [request.device] => xxxx
            [event.time.ms] => xxxx
            [action.key] => visits.visit-summary
            [request.geo.city] => xxxxxxxxxxxxxxxxxxx
            [request.geo.country_code] => xxxx
            [request.geo.country] => xxxxxxxxxx
            [request.geo.geohash] => xxxxxxxxxxxxxxxxx
            [request.geo.postal] => xxxxx
            [request.geo.region] => xxxxxxxxx
            [request.geo.timezone] => -xxxxxxxxxx
            [request.geo.latitude] => xx.xxxx
            [request.geo.longitude] => -xx.xxxx
        )

 Thanks.

    • Nav's avatar
      Nav
      Ace
      7 years ago

      VikasB,

       

      I am using the below CURL request.

      curl_setopt($ch, CURLOPT_URL, "https://eu.api.lithium.com/lsi-data/v1/data/export/community/********?fromDate=20180210&toDate=20180213

       Thanks.

      • VikasB's avatar
        VikasB
        Boss
        7 years ago

        Nav

        As per the documentation, there should be "message.is_topic" parameter.  You need to filter all those topics which have message.is_topic = true. 

        https://prnt.sc/ihecgs

  • srujanayeruvaka's avatar
    srujanayeruvaka
    Champion
    7 years ago

    Hi Nav,

     

    You can count on the field "message.type = topic" to filter out actual conversations (root thread).

    The field "message.is_topic = TRUE" is also helpful; however in some cases there will be an entry for image uploads as below - 

    conversation.title = new2.jpg

    message.subject = new2.jpg

    message.is_topic = TRUE

    message.type = message

     

    Therefore, the suggestible approach is to go for a combination check  - 

    message.is_topic = TRUE

    message.type = topic

     

    Hope this helps!

     

    Thanks,

    Srujana.

     

     

    • Nav's avatar
      Nav
      Ace
      7 years ago

      Hi srujanayeruvaka

      Anyway we can get articles without article type and topic are mentioned?. 

      I can see many such articles in my community app.

      Thanks.

      • srujanayeruvaka's avatar
        srujanayeruvaka
        Champion
        7 years ago

        Nav,

         

        I am not sure I understood your question. Sorry... could you be more specific?

         

        Thanks,

        Srujana.