В общем нашел решение, если кому-то пригодится:
распарсить JSON в двумерный массив .sheets[0].data[*] отфильтровать двумерный массив по значению [[RESULT]] = [[PARSED_JSON_VALUES]].filter(function (e) { return (e)[0] == 'KR0601437U00 Bosch GLI 10,8 V-LI'})Очередной вопрос по jpath
-
{"sheets":[{"name":"Sheet1","data":[["SKU","model","brand","price","cityId","PP7","preOrder/PP7","PP9","preOrder/PP9","PP5","preOrder/PP5","PP8","preOrder/PP8","PP6","preOrder/PP6","PP10","preOrder/PP10"],[5000552,"Jaguar A-317 белый","jaguar",38027,511010000,"no",1,"no",1,"yes",1,"no",1,"no","","no",""],[5000552,"Jaguar A-317 белый","jaguar",39890,750000000,"no",1,"no",1,"yes",1,"no",1,"no","","no",""],[5000552,"Jaguar A-317 белый","jaguar",38952,710000000,"no",1,"no",1,"yes",1,"no",1,"no","","no",""],[9300004,"Sony MHC-GT4D черный","sony",299787,511010000,"no","","no","","yes","","no","","no","","no",""],[9300004,"Sony MHC-GT4D черный","sony",299787,750000000,"no","","no","","yes","","no","","no","","no",""],[9300004,"Sony MHC-GT4D черный","sony",299787,710000000,"no","","no","","yes","","no","","no","","no",""],[9300078,"LG OK65 черный","LG",108447,511010000,"no","","no","","yes","","no","","no","","no",""],[9300078,"LG OK65 черный","LG",108447,750000000,"no","","no","","yes","","no","","no","","no",""],[9300078,"LG OK65 черный","LG",108447,710000000,"no","","no","","yes","","no","","no","","no",""],[9101570,"Rapoo VT900 черный","Rapoo",19400,511010000,"no","","no","","yes","","no","","no","","no",""],[9101570,"Rapoo VT900 черный","Rapoo",19400,750000000,"no","","no","","yes","","no","","no","","no",""],[9101570,"Rapoo VT900 черный","Rapoo",19400,710000000,"no","","no","","yes","","no","","no","","no",""]]}]}Здравствуйте. Подскажите пожалуйста как из такого json получить data у которых значения первого элемента равно 5000552
-
Вопрос закрыт. Разобрался .sheets[0].data[?(@[0] == 5000552)]