I have the following json response coming back to my page using jQuery after a sponsor is added to our database:
{"message":"A sponsor was added.","data":{"rsSponsor
,"Sample Sponsor Name","February, 24 2009 15:42:25"]]}},"event":"Spo
Using javascript (or perhaps more specifically, jQuery), how do I get the "ID" out of this response?
Starting out just providing the json response, but if I need to provide more code (including jQuery calls to the ColdFusion controller) I will.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Well, as it is now I don't think you can because of how the json is structured. If you changed your coldfusion object to output something different then you could access it by name, but unless you do that, right now all you can do is access it by number. If you want to access it by name, the structure would have to look something like what I list below. I'm not sure if you can change it or how it works but, if you changed it to what I have below, then you could access it with "jsonResponse.data.rsSpons
hmm.. the [0][0] trick isn't even working either. If I just output jsonReponse in an alert, i just get [object Object]. Does that lead to any additional information? I may have to supply additional code i think... will pick this up again in the morning, thanks for the help so far... I'll look in to reformatting the response also...
I've used the online json validator to make sure the string is valid (www.jsonlint.com), and it is, and here it is in an easier to view format:
{
"message": "A sponsor was added.",
"data": {
"rsSponsor": {
"COLUMNS": [
"ID",
"NAME",
"DTCREATED"
],
"DATA": [
[
"ADB6C521-1320-2F55-7904B8
"New Sponsor Name",
"February, 25 2009 08:50:23"
]
]
}
},
"event": "SponsorAdded",
"html": ""
}
And I figured out my answer, when the above comes back into the page as "response":
sponsorId = response.data.rsSponsor.DA
Business Accounts
Answer for Membership
by: ritetekPosted on 2009-02-24 at 15:15:07ID: 23727979
If your response is held in the variable jsonResponse, you would access it by "jsonResponse.data.rsSpons