I have the below json
{"response":{"result":{"Leads":{"row":[{"LEADID":"849730000000063017","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063015","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063007","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063005","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063003","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063001","SMOWNERID":"849730000000061001",}]}},"uri":"/crm/private/json/Leads/getMyRecords"}}
I had a requirement to get the json path for which i used the code below
var str={"response":{"result":{"Leads":{"row":[{"LEADID":"849730000000063017","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063015","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063007","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063005","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063003","SMOWNERID":"849730000000061001",},{"LEADID":"849730000000063001","SMOWNERID":"849730000000061001",}]}},"uri":"/crm/private/json/Leads/getMyRecords"}}
var keys = [];
getKeys(keys,str, '');
for(var i=0; i<keys.length; i++)
{
var d=new Array();
d= keys[i][1].replace(/^\.|\.$/g, '')
console.log(keys[i][0] + '=' +d)
}
function getKeys(keys, obj, path) {
for(key in obj) {
var currpath = path+'.'+key;
keys.push([key, currpath]);
if(typeof(obj[key]) === 'object')
{
getKeys(keys, obj[key], currpath);
}
}
}
below is my output
response=response
result=response.result
Leads=response.result.Leads
row=response.result.Leads.row
0=response.result.Leads.row.0
LEADID=response.result.Leads.row.0.LEADID
SMOWNERID=response.result.Leads.row.0.SMOWNERID
1=response.result.Leads.row.1
LEADID=response.result.Leads.row.1.LEADID
SMOWNERID=response.result.Leads.row.1.SMOWNERID
2=response.result.Leads.row.2
LEADID=response.result.Leads.row.2.LEADID
SMOWNERID=response.result.Leads.row.2.SMOWNERID
3=response.result.Leads.row.3
LEADID=response.result.Leads.row.3.LEADID
SMOWNERID=response.result.Leads.row.3.SMOWNERID
4=response.result.Leads.row.4
LEADID=response.result.Leads.row.4.LEADID
SMOWNERID=response.result.Leads.row.4.SMOWNERID
5=response.result.Leads.row.5
LEADID=response.result.Leads.row.5.LEADID
SMOWNERID=response.result.Leads.row.5.SMOWNERID
uri=response.uri
The array elements keys are repetitive (ie) LEADID and SMOWNERID is repetitive in the array.I want to remove and display the output as below
response=response
result=response.result
Leads=response.result.Leads
row=response.result.Leads.row
0=response.result.Leads.row.0
LEADID=response.result.Leads.row.0.LEADID
SMOWNERID=response.result.Leads.row.0.SMOWNERID
uri=response.uri
I am stuck here any help regarding this will be much helpful