# Dump all conversations in a file and structured data

**URL:** <https://meta.discourse.org/t/dump-all-conversations-in-a-file-and-structured-data/202351>\
**Category:** Support\
**Created:** [September 1, 2021, 2:59pm UTC](https://meta.discourse.org/t/dump-all-conversations-in-a-file-and-structured-data/202351 "2021-09-01T14:59:40Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [September 14, 2021, 11:35pm UTC](https://meta.discourse.org/t/dump-all-conversations-in-a-file-and-structured-data/202351/5 "2021-09-14T23:35:14Z")

</div>

```
 SELECT * FROM posts where topic_id=425

```

That will give you the posts the first topic in your query (given that I can type on this phone).

But if what you want is JSON, you could do something like

```
  https://meta.discourse.org/t/dump-all-conversations-in-a-file-and-structured-data/202351.json

```

---

_[View the full topic](https://meta.discourse.org/t/dump-all-conversations-in-a-file-and-structured-data/202351)._