HIPCHAT : Cannot find docs on how to run export by calling the export API

[Andrei [errno]]

as seen in https://jira.atlassian.com/browse/HCPUB-1989 and https://bitbucket.org/snippets/hipchat/9qLx9/export-a-single-room-in-hipchat-server : we can start an export job via a REST API call.

However I cannot find any docs about this feature. (I am mostly interested in start/end date parameters...)

Use case - need to offload daily chat logs for compliance reasons.

And while the regular export dumps all history into a file - this is not ideal if I just need 1 day worth of data,

thanks!

[Arbi Dridi · Accepted solution]

Hi Errno, 

What's the issue with the workaround documented in HCPUB-1989?

I have just tested it locally and it works as intended. If you don't wish to run an export and then have to un-encrypt the file to get the data, you can hit Elasticsearch directly. For example: 

curl -s -XPOST http://localhost:9200/_all/document/_search?pretty\&size=10000 -d '{"query":{"bool":{"must":[{"range":{"date.num":{"gte": "2017-05-02T00:00:00Z","lt": "2017-05-04T00:00:00Z"}}}]}}}' | jq '[.[]]' | jq '.[0].hits'

Note that version 2.3.0 that's currently in Beta no longer uses Elasticsearch but will have simpler chat history storage which would make this task much easier. 

I hope this helps. 

[Andrei [errno]]

thank you - do you have any docs on how will it be implemented in 2.3+? we would probably like to future-proof our scripts... thanks again

[Arbi Dridi]

2.3+ will be PostgreSQL. It's currently available in Beta as a Data Center license. 

We don't have documentation for it just yet. 

Thanks.