Forum Discussion
Nav- If you are accessing articles using REST API V2, below is the query which will be helpful.
SELECT * FROM messages WHERE post_time > 2013-10-07T10:04:30-08:00 AND post_time < 2013-11-07T10:04:30-08:00 LIMIT 5
For the date format, you can use timestamp or the format I have used on above query. You can also pass the limit at the end of the query.
Below link might be helpful.
Thanks for your quick response.
I am importing the articles from Lithium to another application.
I successfully imported all by using below CURL request
curl_setopt($ch, CURLOPT_URL, "https://eu.api.lithium.com/lsi-data/v1/data/export/community/********?fromDate=20180210&toDate=20180213
Right now I am looking to filter only the Community articles. Please suggest.
Thanks
- TariqHussain7 years agoBoss
Nav- I believe you only want to fetch article from the community and your call is getting all the messages type, If that is the case, you need to filter the data at your side. There is message.type field inside the result, you can check if the value of message.type is article.
https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=bulkdata
- Nav7 years agoAce
Hi TariqHussain,
Thanks.
I believe you are advised to apply filter in the CURL response right?
I would like to get the article message type in the CURL request itself to avoid delay to bring other details.
Thanks.
- TariqHussain7 years agoBoss
Nav - Unfortunately, bulk API doesn't provide any filter params for this. The only workaround is, filtering from the response.
Related Content
- 5 months ago
- 4 months ago
- 5 years ago