Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.
Solved
JSON Objects in ColdFusion
Posted on 2010-08-16
I have a partner that wants to send my CFC the following Array of Objects using JSON:
[
{
"fullName": "Joe Strummer",
"phoneNumber" : 2028586745,
"city" : "Washington, DC"
},
{
"fullName": "Mick Jones",
"phoneNumber" : 2029768143,
"city" : "Washington, DC"
},
{
"fullName": "Ian MacKaye",
"phoneNumber" : 2022675545,
"city" : "Washington, DC"
}
]
What's the best way to get this data into my database? I've read the following article:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_43.html#5176845 . It's helpful but it is calling the feed rather than another application calling MY cfc. How do access the data above so I can pass it to the deserializeJSON()?
[
{
"fullName": "Joe Strummer",
"phoneNumber" : 2028586745,
"city" : "Washington, DC"
},
{
"fullName": "Mick Jones",
"phoneNumber" : 2029768143,
"city" : "Washington, DC"
},
{
"fullName": "Ian MacKaye",
"phoneNumber" : 2022675545,
"city" : "Washington, DC"
}
]
What's the best way to get this data into my database? I've read the following article:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_43.html#5176845 . It's helpful but it is calling the feed rather than another application calling MY cfc. How do access the data above so I can pass it to the deserializeJSON()?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
Active today
which database ?
For Oracle the following may help : http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/JSON/A_2715-Import-and-Export-datas-from-JSON-string-to-Oracle-with-Java-Stored-Procedure.html
For Oracle the following may help : http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/JSON/A_2715-Import-and-Export-datas-from-JSON-string-to-Oracle-with-Java-Stored-Procedure.html
leakim971,
Thanks for the link. I'm using mySQL. What I need help with is how to access the JSON data sent to my web service in ColdFusion.
Thanks for the link. I'm using mySQL. What I need help with is how to access the JSON data sent to my web service in ColdFusion.
Active today
generaly you get a string and you unserialize it : http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_43.html
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key.
We will concen…
Objective of This Article
In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in
size by cleaning up the database.
This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used.
Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website.
This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration.
Go to your WordPress login page. This will look like the…
Suggested Courses
Course of the Month7 days, 20 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.