Import JSON feed to WordPress

by

We have received a URL which is a JSON file apparently:

http://www.domain.com/tools/export-json/?destination=hawaii

I am completely clueless when it comes to JSON and WordPress.

Anybody know where to start?

We will need to create individual posts from this JSON file I presume..

1 Answer
1

  1. json_decode the JSON into an array.

    $slices = json_decode(file_get_contents('yourJSONFile.json'),true);

  2. Loop into the data

    if ($slices) { 
   foreach ($slices as $slice) {
      $title = $slice[1];
      // insert more logic here
  }
}

  3. Create a post programmatically by using wp_insert_post. 

    // Create post object
$my_post = array(
     'post_title'    =>  $title,
     'post_content'  => 'This is my content',
     'post_status'   => 'publish',
     'post_author'   => 1,
     'post_category' => array(8,39)
);

// Insert the post into the database and return the new post ID
$post_id = wp_insert_post( $my_post, true );
if ( is_wp_error( $post_id ) ) {
     // error handling....
}

More details in this tutorial: http://tommcfarlin.com/programmatically-create-a-post-in-wordpress/

Leave a Comment