Tom Powers
asked on
How do I make a URLREQUEST in Javvascript or Jquery I don't want it to take the browser there just pull in parameters in URL Call
How do I make a URLREQUEST in Javascript or Jquery I don't want it to take the browser there just pull in parameters in URL Call.I'm converting a Flash application to HTML 5 WEB APP.
HERE IS THE URL
http://www.sportsnetwork.com/mlbpitchingsplits.asp?ID="+pitcher_id+"&vs="+splitp
A button click will request split stats. I was wondering how to do it in JS OR JQUERY.
Because in Flash you can use
xmlSplitStatLoad.load(new URLRequest(url_Split_path)
HERE IS THE URL
http://www.sportsnetwork.com/mlbpitchingsplits.asp?ID="+pitcher_id+"&vs="+splitp
A button click will request split stats. I was wondering how to do it in JS OR JQUERY.
Because in Flash you can use
xmlSplitStatLoad.load(new URLRequest(url_Split_path)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is a nightmare project. The parameters I set before the asp call but I just put in a pitcher's ID 21219. And it pulls a xml file created on the fly
http://www.sportsnetwork.com/mlbpitchingsplits.asp?ID=21219&vs=%22+splitpitvs+%22&ha=%22+splitpitha+%22&bas=%22+splitbase+%22&ris=22&out=%22+splitout+%22&inn=%22+splitinn+%22&%22
this is default so I got to pull SplitValue="RISP I defined all xml attribs as variables.
You can see flash gamecast and splitstats button and what happens. I just want to pull default SplitValue="RISP" tHIS IS WHAT i MADE. Big_Daddy i BELIEVE Your code works but I am not sure what to do how to capture getParameterByName for all xml attribs.
And Chris my friend I heard about JSON and how great it is but this is a xml file generated on the fly
http://www.sportsnetwork.com/mlbpitchingsplits.asp?ID=21219&vs=%22+splitpitvs+%22&ha=%22+splitpitha+%22&bas=%22+splitbase+%22&ris=22&out=%22+splitout+%22&inn=%22+splitinn+%22&%22
this is default so I got to pull SplitValue="RISP I defined all xml attribs as variables.
You can see flash gamecast and splitstats button and what happens. I just want to pull default SplitValue="RISP" tHIS IS WHAT i MADE. Big_Daddy i BELIEVE Your code works but I am not sure what to do how to capture getParameterByName for all xml attribs.
And Chris my friend I heard about JSON and how great it is but this is a xml file generated on the fly
<SplitStats><Pitching ID="21219" SplitOrder="22" SplitValue="RISP"><Wins>0</Wins><Losses>1</Losses><Saves>0</Saves><BlownSaves>1</BlownSaves><Holds>1</Holds><Pct>0</Pct><WHIP>1.269</WHIP><InningsPitched>8</InningsPitched><InningFractions>2</InningFractions><Hits>7</Hits><Runs>15</Runs><EarnedRuns>14</EarnedRuns><ERA>14.539</ERA><Walks>4</Walks><KOs>11</KOs><KL>5</KL><HomeRuns>2</HomeRuns><HitBatters>0</HitBatters><IBBs>0</IBBs><WildPitches>1</WildPitches><Balks>0</Balks><Appearances>17</Appearances><Starts>0</Starts><CompleteGames>0</CompleteGames><ShutOuts>0</ShutOuts><BF>33</BF></Pitching></SplitStats><!doctype html>
<html>
<link rel="stylesheet" href="http://199.233.14.112/aspdata/mlb2/css/smoothness/jquery-ui-1.8.9.customver1.css">
<style type="text/css">
#apDiv1 {
position: absolute;
width: 100%;
height: 144px;
z-index: 100;
left: 7px;
top: 27px;
background-color: #000000;
}
Tablinks {
color: #FFF;
}
.tablink {
color: #FFF;
}
div {
color: #FFF;
}
</style>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript">
var xmlPath = '/xml/mlb/scores/real';
var xmlGameID = '36987';
var innin = {
"1":"Top of the 1st",
"2":"Bottom of the 1st",
"3":"Top of the 2nd",
"4":"Bottom of the 2nd",
"5":"Top of the 3rd",
"6":"Bottom of the 3rd",
"7":"Top of the 4th",
"8":"Bottom of the 4th",
"9":"Top of the 5th",
"10":"Bottom of the 5th",
"11":"Top of the 6th",
"12":"Bottom of the 6th",
"13":"Top of the 7th",
"14":"Bottom of the 7th",
"15":"Top of the 8th",
"16":"Bottom of the 8th",
"17":"Top of the 9th",
"18":"Bottom of the 9th",
"19":"Top of the 10th",
"20":"Bottom of the 10th",
"21":"Top of the 11th",
"22":"Bottom of the 11th",
"23":"Top of the 12th",
"24":"Bottom of the 12th",
"25":"Top of the 13th",
"26":"Bottom of the 13th",
"27":"Top of the 14th",
"28":"Bottom of the 14th",
"29":"Top of the 15th",
"30":"Bottom of the 15th",
"31":"Top of the 16th",
"32":"Bottom of the 16th",
"33":"Top of the 17th",
"34":"Bottom of the 17th",
"35":"Top of the 18th",
"36":"Bottom of the 18th",
"37":"Top of the 19th",
"38":"Bottom of the 19th",
"39":"Top of the 20th",
"40":"Bottom of the 20th",
"41":"Top of the 21st",
"42":"Bottom of the 21st",
"43":"Top of the 22th",
"44":"Bottom of the 22th",
"45":"Top of the 23rd",
"46":"Bottom of the 23rd",
"47":"Top of the 24th",
"48":"Bottom of the 24th",
"49":"Top of the 25th",
"50":"Bottom of the 25th",
"51":"Top of the 26th",
"52":"Bottom of the 26th",
"53":"Top of the 27th",
"54":"Bottom of the 27th"
}
var txtPitcher = "", txtBatter = "", txtNextBatter = "", intPitcher = 0, intBatter = 0;
var srcBatter = "", srcBatterTeam = "", srcPitcher = "", srcPitcherTeam = "";
var arrStrikeImages = ['Dot2.png', 'Strike1.png', 'Strike2.png'];
var arrBallsImages = ['Dot3.png', 'Ball1.png', 'Ball2.png', 'Ball3.png', 'Ball4.png'];
var intBalls, intStrikes;
var splitpitvs, splitpitha, splitbase, splitout, splitinn;
var vsRL, inn, out, risp, bs, ha,wins,losses,saves,bsaves,holds,whip,hits,runs,er,era,kos,bf,innpit,innfrac,walks,appear,hr,kl,so,ibbs,starts,cgame;
$(document).ready(function() {
$('#Abutton1').click(function(){
$('#apDiv1').show();
});
$('#Abutton2').click(function(){
$('#apDiv1').hide();
});
});
function PitSplitStatParameters() {
$.ajax({
type: "GET",
url: xmlPath+"/"+xmlGameID+".xml",
dataType: "xml",
success: function(data){
var d = $(data);
var intOuts = d.find('Play').attr("Outs")
if (intOuts === "0") {
splitout = "23";
} else if (intOuts === "1"){
splitout = "24";
} else if (intOuts === "2"){
splitout = "25";
}
var d = $(data);
var Teamid = d.find('Pitcher').attr("TeamID");
splitpitha = Teamid.attr("vh");
if (splitpitha == "H") {
splitpitha = "3";
} else if (splitpitha == "A") {
splitpitha = "4";
}
var d = $(data);
var Pitcherid = d.find('Pitcher').attr("ID");
var Batterid = d.find('Batter').attr("ID");
var pitlr = Pitcherid.attr("Throws");
var batlr = Batterid.attr("Bats");
if ((pitlr == "L") || (batlr == "S")) {
splitpitvs = "2";
} else if ((pitlr == "R") || (batlr == "S")){
splitpitvs = "1";
} else if ((pitlr == "L") || (batlr == "R")){
splitpitvs = "2";
} else if ((pitlr == "L") || (batlr == "L")){
splitpitvs = "1";
} else if ((pitlr == "R") || (batlr == "R")){
splitpitvs = "2";
} else if ((pitlr == "R") || (batlr == "L")){
splitpitvs = "1";
}
var d = $(data);
var Teamid = d.find('Team').attr("ID");
var hometeam = Teamid.attr("vh");
var lastPitch = $(d.find('Pitches')).find('Pitch').last();
var baserunner1 = lastPitch.attr('Runner1ID')*1;
var baserunner2 = lastPitch.attr('Runner2ID')*1;
var baserunner3 = lastPitch.attr('Runner3ID')*1;
if (baserunner1 != 0 && baserunner2 != 0 && baserunner3 != 0) splitbase = "21";
else if (baserunner1 > 0 && baserunner3 > 0) splitbase = "14";
else if (baserunner2 > 0 && baserunner3 > 0) splitbase = "20";
else if (baserunner1 > 0 && baserunner2 > 0) imgDiamond = splitbase = "17";
else if (baserunner1 > 0 ) splitbase = "18";
else if (baserunner2 > 0 ) splitbase = "16";
else if (baserunner3 > 0 ) splitbase = "15";
else /* if (baserunner1 == 0 && baserunner2 == 0 && baserunner3 == 0) */ splitbase = "18";
}
}); // end each
}
function checkStatus() {
$.ajax({
type: "GET",
url: xmlPath+"/"+xmlGameID+".xml",
dataType: "xml",
success: function(data){
var d = $(data);
if (d.find('Play').attr("Status").toUpperCase() === "FINAL") {
clearInterval(myVar);
}
// find pitching stats by looking at table headings
d.find('Pitchers').children().each(function(i, p) { // players
if ($(p).attr('ID') == intPitcher) {
$('#tblPitStat tr:first td').each(function(i, stat){
var st = $.trim($(stat).text()).replace('PITCHES', 'PCTOTAL');
if (st != '') {
// name of the stat (IP KO BB ER ERA)
$('#tblPitStat tr:nth-child(2) td:nth-child('+(i+1)+')').text( $(p).find('Pitching').attr(st) );
}
});
$('#tblPitSeaStat tr:nth-child(2) td').each(function(i, stat){
var st = $.trim($(stat).text().replace('W', 'WIN').replace('L', 'LOSS').replace('SV', 'SAVE'));
if (st != '') { // name of the season stat
$('#tblPitSeaStat tr:nth-child(3) td:nth-child('+(i+1)+')').text( $(p).find('Season').attr(st) );
}
});
}
}); // end each
var intOuts = d.find('Play').attr("Outs") || 0;
if (intOuts === "3") {
// Clear strikes , Balls and outs aka dot2.png and dot3.png
intOuts = 0;
intBalls = 0;
intStrikes = 0;
}
$('#Outs').attr('src', arrStrikeImages[intOuts]);
$('#Balls').attr('src', arrBallsImages[intBalls]);
$('#Strikes').attr('src', arrStrikeImages[intStrikes]);
var blnBatterFound = false; // when current batter found, set to true, then next batter name can be filled
d.find('Batters').children().each(function(i, p) { // players
if ($(p).attr('ID') == intBatter) {
blnBatterFound = true;
$('#tblHitStat tr:first td').each(function(i, stat){
var st = $.trim($(stat).text()).replace('AVG', 'AVERAGE');
if (st != '') { // name of the stat (...)
$('#tblHitStat tr:nth-child(2) td:nth-child('+(i+1)+')').text( $(p).find('Hitting').attr(st) );
}
});
$('#tblHitSeaStat tr:nth-child(2) td').each(function(i, stat){
var st = $.trim($(stat).text());
if (st != '') { // name of the season stat
$('#tblHitSeaStat tr:nth-child(3) td:nth-child('+(i+1)+')').text( $(p).find('Season').attr(st) );
}
});
} else if (blnBatterFound) {
blnBatterFound = false; // set back to false to skip the rest
$('#txtNextBatter').html($(p).attr('FirstName') + ' ' + $(p).attr('Lastname'));
}
}); // end each
}
});
}
function loadData() {
$.ajax({
type: "GET",
url: xmlPath+"/"+xmlGameID+"-PITCH.xml",
dataType: "xml",
success: function(data){
var d = $(data);
var atbat = "At Bat: ";
var pitch = "Pitching: ";
//var intOuts = d.find('Play').attr("Outs") || 0;
//$('#Outs').attr('src', arrStrikeImages[intOuts]);
var inn = d.find('Play').attr('Inning') || '1';
$('#txtIN').html( innin[inn] );
var colNodes = d.find('Play').children();
for (var i=0; i < colNodes.length; i++) {
var objNode = colNodes[i];
//document.getElementById("demo").innerHTML += '/'+objNode.nodeName;
switch(objNode.nodeName) {
case 'Batter':
txtBatter = atbat + $(objNode).attr('FirstName') + ' ' + $(objNode).attr('Lastname');
intBatter = $(objNode).attr('ID');
intBatterSave = intBatter;
srcBatter = 'http://images.sportsnetwork.com/MLB/attheballpark/players/'+intBatter+'.jpg';
srcBatterTeam = 'http://images.sportsnetwork.com/MLB/attheballpark/pbp_logos/'+$(objNode).attr('TeamID')+'.png';
break;
case 'Pitcher':
txtPitcher = pitch + $(objNode).attr('FirstName') + ' ' + $(objNode).attr('Lastname');
intPitcher = $(objNode).attr('ID');
srcPitcher = 'http://images.sportsnetwork.com/MLB/attheballpark/players/'+intPitcher+'.jpg';
srcPitcherTeam = 'http://images.sportsnetwork.com/MLB/attheballpark/pbp_logos/'+$(objNode).attr('TeamID')+'.png';
break;
case 'Pitches':
intBalls = $(objNode).children().last().attr("Balls");
intStrikes = $(objNode).children().last().attr("Strikes");
// var intOuts = d.find('Play').attr("Outs") || 0;
// $('#Outs').attr('src', arrStrikeImages[intOuts]);
default:
break;
}
}
checkStatus();
$('#txtBatter').html(txtBatter);
$('#txtPitcher').html(txtPitcher);
if (srcBatter != "") $('#imgBatter').attr('src', srcBatter);
if (srcBatterTeam != "") $('#imgBatterTeam').attr('src', srcBatterTeam);
if (srcPitcher != "") $('#imgPitcher').attr('src', srcPitcher);
if (srcPitcherTeam != "") $('#imgPitcherTeam').attr('src', srcPitcherTeam);
},
error: function() {
}
});
}
</script>
<title>The Sports Network</title>
<body>
<div class="areaLineup2">
<div id="apDiv1">
<div align="center">
<table width="100%" border="0">
<tr>
<td width="17%" colspan="2"><div align="center"><strong>v<span class="tablink">sRL</span></strong></div></td>
<td width="14%" colspan="2"><div align="center"><strong>inn</strong></div></td>
<td width="16%" colspan="2"><div align="center"><strong>out</strong></div></td>
<td width="17%" colspan="2"><div align="center"><strong>risp</strong></div></td>
<td width="16%" colspan="2"><div align="center"><strong>bs</strong></div></td>
<td width="15%" colspan="2"><div align="center"><strong>ha</strong></div></td>
<td width="5%"><span class="GCmatchbutton"><img src="Images/button.png" alt="" name="Abutton2" width="15" height="15" id="Abutton2"></span></td></tr>
<tr>
<td><div align="center">Wins</div></td>
<td><div align="center">Losses</div></td>
<td><div align="center">Saves</div></td>
<td><div align="center">Bsaves</div></td>
<td><div align="center">Holds</div></td>
<td><div align="center">Whip</div></td>
<td><div align="center">Hits</div></td>
<td><div align="center">Runs</div></td>
<td><div align="center">Er</div></td>
<td><div align="center">Era</div></td>
<td><div align="center">Kos</div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
</tr>
<tr>
<td><div align="center" id="wins"></div></td>
<td><div align="center" id="losses"></div></td>
<td><div align="center" id="saves"></div></td>
<td><div align="center" id="bsaves"></div></td>
<td><div align="center" id="holds"></div></td>
<td><div align="center" id="whip"></div></td>
<td><div align="center" id="hits"></div></td>
<td><div align="center" id="runs"></div></td>
<td><div align="center" id="er"></div></td>
<td><div align="center" id="era"></div></td>
<td><div align="center" id="kos"></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
</tr>
<tr>
<td><div align="center">Innpit</div></td>
<td><div align="center">Innfrac</div></td>
<td><div align="center">walks</div></td>
<td><div align="center">appear</div></td>
<td><div align="center">Hr</div></td>
<td><div align="center">Kl</div></td>
<td><div align="center">So</div></td>
<td><div align="center">ibbs</div></td>
<td><div align="center">Starts</div></td>
<td><div align="center">CGames</div></td>
<td><div align="center">Bf</div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
</tr>
<tr>
<td><div align="center" id="innpit"></div></td>
<td><div align="center" id="innfrac"></div></td>
<td><div align="center" id="walks"></div></td>
<td><div align="center" id="appear"></div></td>
<td><div align="center" id="hr"></div></td>
<td><div align="center" id="kl"></div></td>
<td><div align="center" id="so"></div></td>
<td><div align="center" id="ibbs"></div></td>
<td><div align="center" id="starts"></div></td>
<td><div align="center" id="cgames"></div></td>
<td><div align="center" id="bf"></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
</tr>
</table>
</div>
<table width="100%" border="0">
</table>
</div>
<table width="100%" border="0" cellpadding="2" cellspacing="0">
<tr>
<td width="100%" class="GCmatchtop">
Matchup
</td>
</tr>
</table>
</div>
<div class="areaMatchUp">
<table width="100%" border="0" cellpadding="1" cellspacing="1" class="GCmatchTable">
<tr>
<td width="5%">
<table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr>
<td width="82"><img src="Images/HSholder.png" alt="" name="imgPitcher" width="82" height="109" id="imgPitcher" /></td>
</tr>
</table>
</td>
<td width="95%">
<table width="100%" border="0" cellpadding="1" cellspacing="1" class="GCmatchblack">
<tr>
<td width="100%" id="txtPitcher" class="GCmatchPName">
<table width="100%" border="0">
<tr>
<td width="33%"> </td>
<td width="58%"> </td>
<td width="9%"> </td>
</tr>
</table>
</td>
<td width="5%" class="GCmatchbutton"><img src="Images/button.png" alt="" width="15" height="15" id="Abutton1"></td>
</tr>
<tr>
<td colspan="7">
<table width="100%" border="0" id="tblPitStat">
<tr>
<td width="15%" class="GCmatchP">Stats</td>
<td width="15%" class="GCmatchP">IP</td>
<td width="16%" class="GCmatchP">KO</td>
<td width="16%" class="GCmatchP">BB</td>
<td width="17%" class="GCmatchP">ER</td>
<td width="17%" class="GCmatchP">ERA</td>
<td width="19%" class="GCmatchP">PITCHES</td>
</tr>
<tr>
<td class="GCmatchP2">Today</td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="7">
<table width="100%" border="0" cellpadding="1" cellspacing="1" id="tblPitSeaStat" style="height: 59px">
<tr>
<td></td>
</tr>
<tr>
<td width="16%" class="GCmatchP">Stats</td>
<td width="16%" class="GCmatchP">IP</td>
<td width="14%" class="GCmatchP">KO</td>
<td width="16%" class="GCmatchP">BB</td>
<td width="15%" class="GCmatchP">ER</td>
<td width="12%" class="GCmatchP">W</td>
<td width="13%" class="GCmatchP">L</td>
<td width="14%" class="GCmatchP">SV</td>
</tr>
<tr>
<td class="GCmatchP2">Season</td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="5%">
<table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr>
<td width="82"><img src="Images/HSholder.png" alt="" name="imgBatter" width="82" height="109" id="imgBatter" /></td>
</tr>
</table>
</td>
<td width="95%">
<table width="100%" border="0" cellpadding="1" cellspacing="1" class="GCmatchblack">
<tr>
<td width="95%" id="txtBatter" class="GCmatchPName"> </td>
<td width="5%" class="GCmatchbutton"><img src="Images/button.png" width="15" height="15"></td>
</tr>
<tr>
<td colspan="7">
<table width="100%" border="0" id="tblHitStat">
<tr>
<td width="17%" class="GCmatchP">Stats</td>
<td width="17%" class="GCmatchP">AB</td>
<td width="15%" class="GCmatchP">R</td>
<td width="15%" class="GCmatchP">H</td>
<td width="16%" class="GCmatchP">RBI</td>
<td width="18%" class="GCmatchP">HR</td>
<td width="19%" class="GCmatchP">AVG</td>
</tr>
<tr>
<td class="GCmatchP2">Today</td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="7">
<table width="100%" border="0" cellpadding="1" cellspacing="1" id="tblHitSeaStat">
<tr>
<td></td>
</tr>
<tr>
<td width="17%" class="GCmatchP">Stats</td>
<td width="16%" class="GCmatchP">AB</td>
<td width="14%" class="GCmatchP">R</td>
<td width="16%" class="GCmatchP">H</td>
<td width="15%" class="GCmatchP">RBI</td>
<td width="12%" class="GCmatchP">HR</td>
<td width="13%" class="GCmatchP">SB</td>
</tr>
<tr>
<td class="GCmatchP2">Season</td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
<td class="GCmatchP2"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<script>
var myVar=setInterval(function(){myTimer()},1000);
function myTimer()
{
//var d=new Date();
//var t=d.toLocaleTimeString();
//document.getElementById("demo").innerHTML=t;
loadData();
//checkStatus();
}
</script>
</body>
</html>ASKER
Here is html page
matchupver2withsplitstats.html
matchupver2withsplitstats.html
Your problem is down to what's know as Same Origin Policy. Javascript can do a lot of things with data on your own server, but as a security measure, it's limited in what it can do across different domains.
As I said, you could do a JSONP request for data if you can control the format of the destination data, but as you're limited to requesting XML data, then this isn't going to work for you.
The route I'd take would be to create your own server-side script using something like PHP. Server-side scripts aren't limited to the Same Original Policy so would have no problem requesting the XML data. Your Javascript would then request data from your own server-side script (which in turn would request data fromt he remote server).
As I said, you could do a JSONP request for data if you can control the format of the destination data, but as you're limited to requesting XML data, then this isn't going to work for you.
The route I'd take would be to create your own server-side script using something like PHP. Server-side scripts aren't limited to the Same Original Policy so would have no problem requesting the XML data. Your Javascript would then request data from your own server-side script (which in turn would request data fromt he remote server).
ASKER
Chris it's not cross domain so I know what your saying but I think I should be able to pull cause the Flash version of this gamecast does it. I just I'm not sure how to use Big Daddy's getParameterByName(name) with calling the asp page up with parameters but not navigating to the generated xml file. I didn't code for asp page cause don't know how to code for it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent solution I just need to pull it into use and see it work.
You could make a request for JSONP data, but calling that URL looks like it returns XML data. Is there a way for you to get the data back in JSON format?