Hi All
I am new to the world of .json and i need to extract some data from a file is there anybody that can maybe help me.
I need to get data from a stock count form.
I need to extract the following responses (data) from the from when submitted:
- Location of the Count (Suite Number)
- Count Date
- Counted By:
- Count for each product.
Please see the Output:
{
"audit_data": {
"score": 0,
"date_completed": 1698683524,
"name": "30 Oct 2023 / Eugene Di Blasi",
"date_modified": 1698683524,
"duration": 47,
"authorship": {
"owner": "Eugene Di Blasi",
"device_id": "user_4fa3584adc7444f3a6f918cbbb4b07fb",
"author": "Eugene Di Blasi"
},
"date_started": 1698683476,
"total_score": 0
},
"item": [
{
"combined_score": 0,
"parent_id": "",
"score": 0,
"responses": {},
"item_id": "55e69ecc-c080-4a26-ac00-d6efb9969e21",
"total_score": 0,
"label": "E-Lites",
"type": "section",
"combined_total_score": 0,
"options": {}
},
{
"combined_score": 0,
"parent_id": "55e69ecc-c080-4a26-ac00-d6efb9969e21",
"score": 0,
"responses": {
"text": "1"
},
"item_id": "2ea4788c-dc48-4b6f-bab4-b2ba41a00f1c",
"total_score": 0,
"label": "Nordic Spirit - Bergamt Wildberry 6mg",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "4c4a4a1a-9521-4845-8730-e7ab6ae51e0a",
"total_score": 0,
"label": "Spirit Gin Hendricks 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "a883adb3-fbef-4316-bf80-f079425bed41",
"total_score": 0,
"label": "Spirit Gin Hendricks 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "64ade71c-97a9-48eb-aa2d-9029b9d9b458",
"total_score": 0,
"label": "Spirit Gin Tanqueray 10 100cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "7e8c9d5b-ba9e-40bd-aef0-53b3ec3f574e",
"total_score": 0,
"label": "Spirit Jack Daniels 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "8880d9f2-d75a-45d3-8598-ea47e7185dc1",
"total_score": 0,
"label": "Proper No. Twelve Blended Irish Whisky 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "20a9e23d-1d1f-4e38-9da1-c99e86c9e3ee",
"total_score": 0,
"label": "Spirit Whisky - Bushmills Original",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "77eaad24-1ca4-4a59-96d4-4c8255c06326",
"total_score": 0,
"label": "Spirit Whisky - Sexton Irish Whiskey",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "85d69ff7-6884-45b2-bc93-cd6359f84b9a",
"total_score": 0,
"label": "Spirit Whisky Irish Jamesons 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "97dbe39a-63a5-472f-855e-2562ed76bb50",
"total_score": 0,
"label": "Spirit Whisky - Dewars 12 Year Old",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "ff6a0706-f0dc-4772-bc9b-a0802cedd1d6",
"total_score": 0,
"label": "Spirit Whisky Chivas Regal 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "b8f2f9ec-5498-40ee-bbaf-baa4c33b9083",
"total_score": 0,
"label": "Spirit Whisky - Craigellachie 13 Year Old",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "67e6b985-354c-4967-be6e-c0a023886ff6",
"total_score": 0,
"label": "Spirit Whisky - Yamazaki 12 Year Old Japanese Malt Whiskey 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "248c1c00-a966-4805-b55b-47b24d3522e4",
"total_score": 0,
"label": "Spirit Whisky Bourbon Makers Mark 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "d397b911-77fd-44c0-bd29-a3ef36dd50b1",
"total_score": 0,
"label": "Spirit Rum White Bacardi Super 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "8bbbe5b1-34f3-4ce6-a5cf-1963ac3c9d87",
"total_score": 0,
"label": "Spirit Rum Bacardi Ocho 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "82c0d770-b565-450a-b722-ed8798f95879",
"total_score": 0,
"label": "Spirit Rum - Kraken Black Cherry & Madagascan Vanilla",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "2247a317-54a5-4379-9383-cb8a3e0421a0",
"total_score": 0,
"label": "Spirit Rum - Kraken Roast Coffee",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "f5489522-98a7-4991-89ce-f48f12ac38d6",
"total_score": 0,
"label": "Spirit Rum - Kraken Spiced",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "fd3d78f4-1d37-4e4e-af74-917c4bec3e2d",
"total_score": 0,
"label": "Spirit Tequila - Jose Cuervo Especial Silver",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "761b2255-24b0-4a44-91ca-305c07334ca0",
"total_score": 0,
"label": "Spirit Tequila - 1800 Silver",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "45341285-114d-47c2-89e6-a50393999899",
"total_score": 0,
"label": "Spirit Tequila - 1800 Reposado (Speciality)",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "50f1f49a-bd41-47d3-b47a-853f9163a1cf",
"total_score": 0,
"label": "Spirit Tequila - 1800 Coconut (Speciality)",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "83c74f01-9005-4b84-8c51-6cbb13637ab2",
"total_score": 0,
"label": "Liqueurs - Amaretto Disaronno",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "d620a90f-63f1-4168-bd87-fb9e30f3b9df",
"total_score": 0,
"label": "Liqueurs - Cointreau",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "5d3ac284-0d6d-4eda-839b-2a6b5d6f8a54",
"total_score": 0,
"label": "Spirit Southern Comfort 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "b32da3bc-9b4a-4992-9666-66462441808e",
"total_score": 0,
"label": "Liqueurs - Sambuca Cesari",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "97211e36-9e23-4900-a416-17f292b5ae23",
"total_score": 0,
"label": "Spirit Other - Pimms",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "2209329a-bf67-483d-8e10-40d83e29bda4",
"total_score": 0,
"label": "Wine - Fortified Aperol",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "55b687ff-cadb-4d3a-8b14-9db847b0fe29",
"total_score": 0,
"label": "Wine - Fortified Campari",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "4d2ad323-32c2-47d8-a462-0c016ce6bb4f",
"total_score": 0,
"label": "Spirit Liqueur Passoa 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "ee619a2e-8d9b-42bc-8f21-20b9050df903",
"score": 0,
"responses": {},
"item_id": "2316c794-ed5e-4b7a-9729-64a511a3a302",
"total_score": 0,
"label": "Spirit Malibu 70cl",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "",
"score": 0,
"responses": {},
"item_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"total_score": 0,
"label": "Soft Drinks, Mixers, Water & Juice",
"type": "section",
"combined_total_score": 0,
"options": {}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "f9f91696-cbb7-408d-b03f-7d8d89af31c2",
"total_score": 0,
"label": "Pepsi Max 330ml Can",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "42716aeb-6612-46e7-b675-548bd2527288",
"total_score": 0,
"label": "R Whites Lemonade 330ml Can",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "80e55735-a35c-4bcb-a4ed-eadc5a23152d",
"total_score": 0,
"label": "R Whites Lemonade 150ml Flight Can",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "2b2de37c-5ccf-4fa0-acf6-ed65329cd57f",
"total_score": 0,
"label": "Pepsi 200ml NRB",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "f953fd0a-78cc-48a1-98f5-b03967fa71e2",
"total_score": 0,
"label": "Pepsi Max 200ml NRB",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "7a42ca23-e5ba-4827-9cec-0f975ad76a32",
"total_score": 0,
"label": "Diet Pepsi 200ml NRB",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "7053ac27-dd52-483f-b93e-ac9f51273e8c",
"total_score": 0,
"label": "Mixers - London Essence Ginger Ale NRB 200ml",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "bd6293cb-5f6f-4464-9a2f-39c0f25d6b28",
"score": 0,
"responses": {},
"item_id": "6b671bd1-30b2-484f-bfff-348d44b5d538",
"total_score": 0,
"label": "Mixers - London Essence Tonic NRB 200ml",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "0a8065cf-96ea-4965-9acd-65b9efcd191e",
"score": 0,
"responses": {},
"item_id": "47878614-6141-4611-a30a-b589bcba0dd1",
"total_score": 0,
"label": "Nuts Peanut Salted KP Box 50g",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "0a8065cf-96ea-4965-9acd-65b9efcd191e",
"score": 0,
"responses": {},
"item_id": "6587d03b-42d7-4efd-b747-3f4750af01e8",
"total_score": 0,
"label": "Popcorn Sweet/Salty Propercorn 30g",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "0a8065cf-96ea-4965-9acd-65b9efcd191e",
"score": 0,
"responses": {},
"item_id": "67e7970a-688a-436f-aefb-73975abd7bfe",
"total_score": 0,
"label": "Sweets - Fruit Pastilles Hanging Bag (Nestle) 1x10",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "0a8065cf-96ea-4965-9acd-65b9efcd191e",
"score": 0,
"responses": {},
"item_id": "2e92c736-e844-43ae-bf2a-fb278144b787",
"total_score": 0,
"label": "Sweets - Munchies Hanging Bag (Nestle) 1x8",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "0a8065cf-96ea-4965-9acd-65b9efcd191e",
"score": 0,
"responses": {},
"item_id": "78360fc2-26ac-4bc1-8faa-96f96d38fc84",
"total_score": 0,
"label": "Sweets - Randoms Hanging Bag (Nestle) 1x9",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
},
{
"combined_score": 0,
"parent_id": "1aaff204-7e62-476c-8a3d-425c9f3079a3",
"score": 0,
"responses": {},
"item_id": "86418549-eb89-4b1c-884a-c384ca874483",
"total_score": 0,
"label": "Cup Hot Drink SingleWall Paper Wht 12Oz",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1
}
}
],
"audit_id": "audit_037965dd92cd4b6292a2154f954c60fd",
"template_data": {
"authorship": {
"owner": "Eugene Di Blasi",
"date_created": 1697028396,
"author": "Eugene Di Blasi",
"device_id": "user_4fa3584adc7444f3a6f918cbbb4b07fb",
"date_modified": 1697033044
},
"metadata": {
"industry": -1,
"image": "bbbfe7b8-c486-4aab-8ea1-b896e008375e",
"description": "Individual Suites Weekly Stock Count Form",
"name": "Individual Suites Stock Input",
"subindustry": -1
}
},
"header": [
{
"combined_score": 0,
"parent_id": "",
"score": 0,
"responses": {},
"item_id": "f3245d39-ea77-11e1-aff1-0800200c9a66",
"total_score": 0,
"label": "Title Page",
"type": "section",
"combined_total_score": 0,
"options": {}
},
{
"combined_score": 0,
"parent_id": "f3245d39-ea77-11e1-aff1-0800200c9a66",
"score": 0,
"responses": {
"text": "201"
},
"item_id": "386d0140-3f27-4727-b199-60fa5fe7434c",
"total_score": 0,
"label": "Location (Suite Number)",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"text_format": 1,
"is_mandatory": true
}
},
{
"combined_score": 0,
"parent_id": "f3245d39-ea77-11e1-aff1-0800200c9a66",
"score": 0,
"responses": {
"datetime": 1698683476
},
"item_id": "f3245d42-ea77-11e1-aff1-0800200c9a66",
"total_score": 0,
"label": "Count Date",
"type": "datetime",
"combined_total_score": 0,
"options": {
"enable_time": "1",
"is_mandatory": true,
"enable_date": "1"
}
},
{
"combined_score": 0,
"parent_id": "f3245d39-ea77-11e1-aff1-0800200c9a66",
"score": 0,
"responses": {
"text": "Eugene Di Blasi"
},
"item_id": "f3245d43-ea77-11e1-aff1-0800200c9a66",
"total_score": 0,
"label": "Counted by",
"type": "textsingle",
"combined_total_score": 0,
"options": {
"is_mandatory": true
}
}
],
"template_id": "template_9c16787fe3b24a75bd27fddc43790308"
}
Thank you in advance.