JSFiddle - React, Tailwind, and code Playground

by Frank Liu

HTML

<div id="jsonp-results"></div>

JavaScript

var url1 = "https://spreadsheets.google.com/feeds/list/1nH7lkY7RnFv_l8u0nL9gsrs4_rwODBQiTiuD2FF0GBo/1/public/basic?hl=en_US&alt=json";

$.ajax({
    type: 'GET',
    url: url1,
    async: false,
    jsonpCallback: 'jsonCallback',
    contentType: "application/json",
    dataType: 'jsonp',
    success: function (data) {

        $(data.feed.entry).each(function () {    
            // Column names are name, age, etc.
            var arrStr = this.content.$t.split(/[:,]/);
            var i=1;
                $('#jsonp-results').prepend('<p>' + arrStr[i] + '</p><p>' +arrStr[i+2] + '</p><p>'+arrStr[i+4] +'</p><p>'+arrStr[i+6]+'</p><p>'+arrStr[i+8]+'</p><p>'+arrStr[i+10]+'</p>');  
        });

        console.log(json);
    },
    error: function (e) {
        alert(e.message);
    }
});