How do I post in bulk?

Cathas9lives

What tables will be involved when we start discussions in flarum? How to achieve this with SQL statement insertion!

clarkwinkelmann

In the most basic situation, the tables discussions and posts are used.

If you insert anything directly in the database, any additional behavior added by extensions will be skipped, including sending emails, sending notifications, linking mentions, parsing custom post content, ... In all cases you will most likely need a running version of the TextFormatter to prepare the post content before inserting in the database.

Ideally you should use the Discussion::startDiscussion() method via an extension to make sure all logic is properly applied.

Maybe you can describe in more details what you are trying to achieve ? Where does your bulk data comes from ?

Cathas9lives

clarkwinkelmann I use a spider get the data and want upload to my flarum。

clarkwinkelmann

Cathas9lives if the data is coming from an external app the best would be to use the API and POST to /api/discussions.

You can take a look at the browser network tab to see how the data is formatted when you submit via the Flarum frontend.

Your script can use an API key to authenticate with the API.

[deleted]

clarkwinkelmann @Cathas9lives I'm doing something like this in my own forum if it helps. I simply use the API in a foreach loop in PHP

Cathas9lives

clarkwinkelmann I get a mistake , {"errors":[{"status":"422","code":"validation_error","detail":"The title field is required.","source":{"pointer":"\/data\/attributes\/title"}}]}