Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Occasional Contributor

add last_edit_time parameter in where condtition

Hi

I am calling API v2 to retrieve the messages from Lithium, what I want is to retrieve only the messages whose last_edit_time is greater than a value. I see only the post_time can be used in the where condition. Any idea to get only the new messages which is updated/edited recently?

Thanks!

Shong

4 Replies 4
Honored Contributor

@TalendCommunity - 

 

At this moment you can't use the current_revision.last_edit_time as a constraint in your LIQL queries. This is not supported by Lithium's APIv2.

 

https://community.lithium.com/t5/Developer-Discussion/Get-all-messages-that-are-less-than-a-certain-...

Give kudos if you find my posts helpful or mark solution if it answers your query.
Tariq
Khoros Alumni (Retired)

As Tariq pointed out this restriction is currently not supported in LiQL. I'd recommend to submit a product enhancement idea as I can see how it could be useful, particularly for TKB scenarios.

I'm curious what the scenario is that you would use it in, @TalendCommunity?


Khoros Best Practice until August 2019. Onwards posting as Claudius.
Learn how to master Khoros. Learn Best Practice in the Community Documentation
If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.

Hi ClaudiusH
I need to load the community data by calling Lithium API to build our data warehouse and do the analysis. Because the volume of data becomes big and big, we have to implement incremental load and load only the changed data. Any idea?

Regards
Shong

If you want to replicate and perform analysis on larger sections of community data in your own warehouse I would recommend you use the Lithium Bulk Data API to pull the necessary elements into your own DWH.


Khoros Best Practice until August 2019. Onwards posting as Claudius.
Learn how to master Khoros. Learn Best Practice in the Community Documentation
If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.