How to create wordpress post from SQL table with date in JSON?

Question

JSON

the table contains:
- entry id
- category slug
- json data
question: how to create entries in the wordpress database using queries from the current database?

Answer 1

Make a request through $wpdb to the desired table or database.
Then start the cycle. Get JSON. Make decode_json into array.
And then insert posts from the array through wp_isert_post.