Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

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

share

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.