Solved

How do i rename a key in JSONObject

Posted on 2009-07-09
12
2,975 Views
Last Modified: 2013-11-08
i am trying to rename  "displayName" key to"text",

where key "dispalyname" is a part of JSONArray which is nested in JSONObject.

like:

{"jsonText":[

{"description":"Employee","displayName":"Guillaumin, Xavier","email":"xguillaumin@hersheys.com","location":"Carretera GDL-ElCastilloKM8.05","title":"Financial Coordinator Global Exports","userId":"HERXGG40"},

{"description":"Former Employee","displayName":"Lugo, Javier","email":"JLugo@Hersheys.com","location":"","title":"Special Projects Manager","userId":"HERJEL40"},

{"description":"Employee","displayName":"Plitnick, Xavier F","email":"HFXFP001@hersheys.com","location":"6 Scotch Pine Drive","title":"HZ_1526_Mst Wrap Mech","userId":"HFXFP001"}

]}


Can anyone suggest way to rename ?
JSONArray jsonArray = new JSONArray();

			JSONObject jsonObj = new JSONObject();

			try {

				Collection<User> user = UserManager.getInstance()

						.findUsersByName(name);

				

                               jsonArray.addAll(user);
 

				jsonObj.put("jsonText", jsonArray);

			} catch (Exception e) {

				e.printStackTrace();

			}
 

			String jsonString = jsonObj.toString();

			System.out.println(jsonString);

Open in new window

0
Comment
Question by:Amos_Mike
  • 6
  • 4
12 Comments
 
LVL 75

Expert Comment

by:Michel Plungjan
Comment Utility
Perhaps add the new key with the value and remove the old ?
0
 
LVL 75

Expert Comment

by:Michel Plungjan
Comment Utility
In JS:



<script>

 jsonText = [ { "description" : "Employee",

        "displayName" : "Guillaumin, Xavier",

        "email" : "xguillaumin@hersheys.com",

        "location" : "Carretera GDL-ElCastilloKM8.05",

        "title" : "Financial Coordinator Global Exports",

        "userId" : "HERXGG40"

      },

      { "description" : "Former Employee",

        "displayName" : "Lugo, Javier",

        "email" : "JLugo@Hersheys.com",

        "location" : "",

        "title" : "Special Projects Manager",

        "userId" : "HERJEL40"

      },

      { "description" : "Employee",

        "displayName" : "Plitnick, Xavier F",

        "email" : "HFXFP001@hersheys.com",

        "location" : "6 Scotch Pine Drive",

        "title" : "HZ_1526_Mst Wrap Mech",

        "userId" : "HFXFP001"

      }

    ] 

jsonText[0].text=jsonText[0].displayName

delete jsonText[0].displayName;

    

alert(jsonText[0].text)    

alert(jsonText[0].displayName)    

</script>

Open in new window

0
 

Author Comment

by:Amos_Mike
Comment Utility
mplugjan

"jsonText" is a part of JSON object, it's a key in Json Object. I am sorry,  I cudn't figure out what are you trying to convey?
0
 
LVL 75

Expert Comment

by:Michel Plungjan
Comment Utility
trying to convey you probably need to copy the key and delete the old.

Anyway why do you want to rename?
0
 

Author Comment

by:Amos_Mike
Comment Utility
K got your point..
Thanks , but the change i am trying to do is on server side i.e.  in a servlet.
So i don't think this will help.

I am passing this JSON object to my javascript and there my jquery will read it for an JSONsuggest function.
my JS file for JSON suggest (plugin in jquery) expects the searchdata key to be "text", that's why i need to rename it from displayName to text
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 75

Expert Comment

by:Michel Plungjan
Comment Utility
And not easier to change the JS?
0
 

Author Comment

by:Amos_Mike
Comment Utility
I know that could be the solution, but the thing is i am using that specific key from JS at other places in my application.
Moreover i was curious if there's a workaround, for what i have asked.
0
 
LVL 75

Expert Comment

by:Michel Plungjan
Comment Utility
If it is not a huge amount of data, ADD the data to a new key
0
 

Author Comment

by:Amos_Mike
Comment Utility
i got the solution, i sat and applied my brain's deepest nerves to get it working in JAVA servlet itself.
I am calling this mapBeans fxn, and replacing my fields from JSONArray.
this fxn references the UserMappingBean which has getter and setter for Text field.
It works fine for me.
Thanks for the help.
private Collection<UserMappingBean> mapBeans(Collection<User> users) {

		List<UserMappingBean> beans = new LinkedList<UserMappingBean>();

		

		for (User user: users) {

			UserMappingBean b = new UserMappingBean();

			b.setText(user.getDisplayName());

			beans.add(b);

		}

Open in new window

0
 
LVL 75

Accepted Solution

by:
Michel Plungjan earned 250 total points
Comment Utility
"If it is not a huge amount of data, ADD the data to a new key"
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
Having worked on larger scale sites, we found out that you are bound to look at more scalable solutions to integrating widgets, code snippets or complete applications and mesh them into functional sites, in any given composition. To share some of…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now