Khoros Community

Occasional Contributor TalendCommunity
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
Honored Contributor

Re: add last_edit_time parameter in where condtition

@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
Reply
Loading...
Khoros Guru
Khoros Guru

Re: add last_edit_time parameter in where condtition

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?


Learn how to master Khoros. Visit the Best Practice Center

If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.
Reply
Loading...
Highlighted
Occasional Contributor TalendCommunity
Occasional Contributor

Re: add last_edit_time parameter in where condtition

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
0 Kudos
Reply
Loading...
Khoros Guru
Khoros Guru

Re: add last_edit_time parameter in where condtition

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.


Learn how to master Khoros. Visit the Best Practice Center

If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.
0 Kudos
Reply
Loading...