WP JSON to Timeline JS

As part of some thoughts on building out a series of reflective views for student portfolio blogs, I thought seeing your WordPress posts in the TimelineJS view might be a useful way to look back over your progress.

I intend to wrap this into a custom spreadsheet template and/or a plugin1 but figured I’d sketch out how it works so far in case anyone was interested.

The WP Rest API makes it pretty easy to write the data via Google Script. I just want to cut out chunks of the data and put it in the right fields. The following script does that and writes it to a page named “wp.”

function getPosts() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('wp');
  
//get the data from the feed and get the last 50 items in this case (set via the URL)
  var url = 'https://bionicteaching.com/wp-json/wp/v2/posts?_embed&per_page=50';
  var response = UrlFetchApp.fetch(url); // get feed
  var json = response.getContentText(); // 
  var data = JSON.parse(json);
  //Logger.log(data);
  
  for (i = 0; i < data.length; i++){
    var ssData = [];    
    
    ssData.push(data[i].date.substring(0,4)); //post year   
    ssData.push(data[i].date.substring(5,7)); //post month   
    ssData.push(data[i].date.substring(8,10)); //post day   
    ssData.push(data[i].date.substring(11,19)); //post time 
  
    ssData.push(""); //filler for now for end date  info
    ssData.push("");
    ssData.push("");
    ssData.push("");
    ssData.push("");

    ssData.push(theUrl(data[i]) + data[i].title.rendered + '</a>'); //post title w link
    ssData.push(data[i].excerpt.rendered); //post excerpt
    
    ssData.push(featuredCheck(data[i])); //post feature image
    
    sheet.appendRow(ssData)[i];
  }
  
}

//have a featured image? then get it . . . 
function featuredCheck (data) {
  try {data._embedded['wp:featuredmedia'][0].media_details.sizes.full.source_url;
       return data._embedded['wp:featuredmedia'][0].media_details.sizes.full.source_url;
      } 
  catch (err){
    return "";
  }
   
}

//make things a bit neater by building the href via function
 function theUrl (data) {
   return '<a href="' + data.guid.rendered + '">'; //build the url 
 }


1 Or maybe just a page where you throw in a blog URL and get a bunch of alternate view/data options.

Comments on this post

  1. Anne Kergroach said on January 3, 2018 at 11:04 am

    Hello,
    it’s exactly what i’m looking for since 3 weeks!
    how do think i must proceed to include and call this code?

    thank in advance
    Anne

  2. Anne said on January 9, 2018 at 1:16 pm

    Hello and sorry to solicit you again 😀

    but once the script created does it link to the official spreadsheet of the timelinejs or to a new one? do you link the script to a cell?
    and how do you deploy it, to get the code of the source?

    Thank you
    Anne

    • Tom Woodward said on January 9, 2018 at 3:59 pm

      Anne- This uses the WordPress site itself to create the data for the timeline. In this scenario there is no spreadsheet at all. To change the site feeding the timeline you can just change the site address in the URL to the blog you want to use (assuming it’s a modern WordPress site).

      If you give me a better idea about what you’re trying to do I might be able to make some suggestions.

      • Anne said on January 10, 2018 at 3:09 am

        Hello Tom, yes it’s for a recent wordpress site.
        I changed the path of line 6 to a wp page that I created via wp-json (I found that it worked) and inserted an iframe tag in the landing page to https: // cdn.knightlab.com/libs/timeline3/latest/embed/index.html? but I do not know which source to paste after url
        I guess it was when exporting the code that I missed something?!?

  3. Tom Woodward said on January 11, 2018 at 10:05 pm

    Oh man. I’m sorry I was confusing this with another thing I did later. You can see the new version here and it’s kind of easier. You just change the url where it says cogdogblog.com to whatever site you want to use.

    To answer your question, using the google sheets path, I’d put that script in the same sheet you’d normally use for your timeline JS. That script writes to a page named “wp” (line 3) so you’d need to create that. Then you can just use a sheets function to mirror it to the normal page.

    If you want to share the doc with me at bionicteaching@gmail.com, I can make it work.

Leave a Reply

Trackbacks and Pingbacks on this post

No trackbacks.

TrackBack URL