{"id":22521,"date":"2024-11-01T06:54:14","date_gmt":"2024-11-01T06:54:14","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=22521"},"modified":"2024-11-01T06:54:14","modified_gmt":"2024-11-01T06:54:14","slug":"split-an-array-of-nested-json-objects","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/datafilesplitter\/split-an-array-of-nested-json-objects.html","title":{"rendered":"Split an array of nested JSON objects"},"content":{"rendered":"

I see a post https:\/\/stackoverflow.com\/questions\/67607384\/split-an-array-of-nested-json-objects-using-jq<\/a>, the poster gave an example JSON file:<\/p>\n

{\r\n  \"storeId\": \"1412\",\r\n  \"templateCheck\": [\r\n    {\r\n      \"rom\": 37,\r\n      \"updateDate\": \"2021-05-09 07:53:17\",\r\n      \"lhb\": \"2021-05-09 06:32:41\",\r\n      \"templateCode\": \"REGULAR\",\r\n      \"lId\": \"50-19-78-5C\",\r\n      \"sk\": \"830066\",\r\n      \"skUpdateDate\": \"2020-07-21 05:37:07\",\r\n      \"battery\": 30,\r\n      \"status\": 1\r\n    },\r\n    {\r\n      \"rom\": 37,\r\n      \"updateDate\": \"2021-05-09 07:54:02\",\r\n      \"lhb\": \"2021-05-09 06:32:41\",\r\n      \"templateCode\": \"REGULAR\",\r\n      \"lId\": \"50-1B-FE-6E\",\r\n      \"sk\": \"740541\",\r\n      \"skUpdateDate\": \"2021-03-22 05:59:00\",\r\n      \"battery\": 30,\r\n      \"status\": 1\r\n    },\r\n    {\r\n      \"rom\": 37,\r\n      \"updateDate\": \"2021-05-09 07:52:05\",\r\n      \"lhb\": \"2021-05-09 06:32:41\",\r\n      \"templateCode\": \"REGULAR\",\r\n      \"lId\": \"50-1C-22-6E\",\r\n      \"sk\": \"846760\",\r\n      \"skUpdateDate\": \"2021-05-08 03:34:22\",\r\n      \"battery\": 29,\r\n      \"status\": 1\r\n    }\r\n  ]\r\n}\r\n<\/pre>\n
He want to split it to JSON files like this:<\/p>\n
{\r\n    \"storeId\": \"1412\",\r\n    \"templateCheck\": {\r\n      \"rom\": 37,\r\n      \"updateDate\": \"2021-05-09 07:53:17\",\r\n      \"lhb\": \"2021-05-09 06:32:41\",\r\n      \"templateCode\": \"REGULAR\",\r\n      \"lId\": \"50-19-78-5C\",\r\n      \"sk\": \"830066\",\r\n      \"skUpdateDate\": \"2020-07-21 05:37:07\",\r\n      \"battery\": 30,\r\n      \"status\": 1\r\n    {\r\n}\r\n<\/pre>\n
He uses jq, I am not familiar with jq, I have a tool Data File Splitter<\/a>, so I use this tool to split the JSON array.<\/p>\n
\"split
\nAdjust “To Sublevel” and “Record On”.<\/p>\n
\"set
\nIn this case, we need to set “JSON Format” to “One by One”.<\/p>\n
And the “Next” and “Next”, split, get smaller JSON files, like this:<\/p>\n
{\r\n\t\"storeId\":\"1412\",\r\n\t\"templateCheck\":{\r\n\t\t\"rom\":\"37\",\r\n\t\t\"updateDate\":\"2021-05-09 07:53:17\",\r\n\t\t\"lhb\":\"2021-05-09 06:32:41\",\r\n\t\t\"templateCode\":\"REGULAR\",\r\n\t\t\"lId\":\"50-19-78-5C\",\r\n\t\t\"sk\":\"830066\",\r\n\t\t\"skUpdateDate\":\"2020-07-21 05:37:07\",\r\n\t\t\"battery\":\"30\",\r\n\t\t\"status\":\"1\"\r\n\t}\r\n}\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
I see a post https:\/\/stackoverflow.com\/questions\/67607384\/split-an-array-of-nested-json-objects-using-jq, the poster gave an example JSON file: { “storeId”: “1412”, “templateCheck”: [ { “rom”: 37, “updateDate”: “2021-05-09 07:53:17”, “lhb”: “2021-05-09 06:32:41”, “templateCode”: “REGULAR”, “lId”: “50-19-78-5C”, “sk”: “830066”, “skUpdateDate”: “2020-07-21 05:37:07”, “battery”: 30, “status”: 1 }, { “rom”: 37, “updateDate”: “2021-05-09 07:54:02”, “lhb”: “2021-05-09 06:32:41”, “templateCode”: “REGULAR”, “lId”: “50-1B-FE-6E”, “sk”: “740541”, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3144],"tags":[1418,2677,3405],"class_list":["post-22521","post","type-post","status-publish","format-standard","hentry","category-datafilesplitter","tag-json","tag-split-json","tag-split-json-array"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=22521"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22521\/revisions"}],"predecessor-version":[{"id":22522,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22521\/revisions\/22522"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=22521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=22521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=22521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}