删除JSON数组的重复键并获取其JSON路径

Removing the duplicate keys of a JSON array and getting its JSON path

本文关键字：JSON 获取 路径 数组 删除      更新时间：2023-09-26

我有JSON如下:

{"响应":{"结果":{"领导":{"行":[{"LEADID":"849730000000063017","SMOWNERID":"849730000000061001"},{"LEADID":"849730000000063015","SMOWNERID":"849730000000061001","HIII":"你好"},{"LEADID":"849730000000063007","SMOWNERID":"849730000000061001","BYEE":"塔塔"},{"LEADID":"849730000000063005","SMOWNERID":"849730000000061001"},{"LEADID":"849730000000063003","SMOWNERID":"849730000000061001"},{"LEADID":"849730000000063001","SMOWNERID":"849730000000061001"}]}},"uri":"私人/json/导致//crm/getMy记录"}}

我需要获得JSON路径，为此我使用了下面的代码:

var str={"response":{"result":{"Leads":{"row":[{"LEADID":"849730000000063017","SMOWNERID":"849730000000061001",},
  {"LEADID":"849730000000063015","SMOWNERID":"849730000000061001"},
  {"LEADID":"849730000000063007","SMOWNERID":"849730000000061001","HIII":"hello"},
  {"LEADID":"849730000000063005","SMOWNERID":"849730000000061001","BYEE":"tata"},
  {"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);
    }
  }
}

输出如下:

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
HIII=response.result.Leads.row.1.HIII
2=response.result.Leads.row.2
LEADID=response.result.Leads.row.2.LEADID
SMOWNERID=response.result.Leads.row.2.SMOWNERID
 BYEE=response.result.Leads.row.2.BYEE
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

数组元素键是重复的(即LEADID和SMOWNERID在数组中是重复的)。我想删除整个数组的重复项，并像这样显示输出:

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
HIII=response.result.Leads.row.0.HIII
BYEE=response.result.Leads.row.0.BYEE
uri=response.uri

我被卡在这里了，任何关于这方面的帮助都会很有帮助。

将函数getKeys修改为:

function getKeys(keys, obj, path) {
  for(key in obj) {
    var currpath = path+'.'+key;
    keys.push([key, currpath]);
    if(typeof(obj[key]) === 'object') {
      if(obj[key] instanceof Array){                   //added check for array
        keys.push(['0', currpath+'.0']);
        getKeys(keys, obj[key][0], currpath+'.0');
      }
      else
      getKeys(keys, obj[key], currpath);
    }
  }
}

更新
function getKeys(keys, obj, path) {
  for(key in obj) {
    var currpath = path+'.'+key;
    addKeys(key, currpath);
    //keys.push([key, currpath]);
    if(typeof(obj[key]) === 'object') {
      getKeys(keys, obj[key], currpath);
    }
  }
}
function addKeys(key, currpath) {                      //check before adding
  present = keys.map(function(x){return(x[1].split('.').slice(-1)[0])});
  if (present.indexOf(key)==-1){
    keys.push([key, currpath]);
  }
}

答案不完全像你想要的，但这是我能得到的最接近的答案。此外，你给HIII和BYEE的值是错误的。最后，可能在不同的级别上有相同的键，但我只匹配键的名称。如果在不同级别使用相同的keyname，则可能无法工作。

另一种方法是将键从数组更改为对象-将var keys = []更改为var keys = {}，然后更改getKeys方法，如下所示:

function getKeys(keys, obj, path) {
 for(key in obj) {
  var currpath = path+'.'+key;
  if(keys[key])
    continue;
  keys[key] = currpath;
  if(typeof(obj[key]) === 'object') {
    getKeys(keys, obj[key], currpath);
  }
 }
}

现在您还需要更改从getKeys返回后打印值的方式，因为现在keys不是一个数组，而是一个对象。

相关文章：