Hi,
I’m trying to create multiple variables from an array of subitems from the monday.com get an item module to use later in a scenario.
I would like to create the variables from the subitem Name and a column value.
The problem I am having is that the subitem Value im after is an array within the subitem array so i’m not sure what to do to get this value.
If someone could let me know the best way to do this that would be great.
[
{
"id": "6683190293",
"name": "Test",
"email": "heatdifferent_pulse_6683190293_28b6a9c299bf4320b211__26870181@use1.mx.monday.com",
"created_at": "2024-05-21T19:36:08Z",
"updated_at": "2024-05-30T14:49:45Z",
"state": "active",
"board": {
"id": "6683169770"
},
"creator_id": "26870181",
"group": {
"id": "topics",
"title": "Group Title",
"deleted": false,
"archived": false
},
"column_values": [
{
"id": "subitems__1",
"value": "{\"changed_at\":\"2024-05-30 13:19:24 +0000\",\"linkedPulseIds\":[{\"linkedPulseId\":6737015696},{\"linkedPulseId\":6737015910},{\"linkedPulseId\":6737016168},{\"linkedPulseId\":6737016456},{\"linkedPulseId\":6737016695},{\"linkedPulseId\":6737016971},{\"linkedPulseId\":6737017271}]}",
"text": null,
"title": "Subitems"
},
{
"id": "connect_boards__1",
"value": "{\"changed_at\":\"2024-05-21T19:36:11.903Z\",\"linkedPulseIds\":[{\"linkedPulseId\":6610430146}]}",
"text": "Alan Kelf Deal",
"title": "Opportunities"
},
{
"id": "item_id__1",
"value": "{\"item_id\":\"6683190293\"}",
"text": "6683190293",
"title": "Item ID"
},
{
"id": "status__1",
"value": "{\"index\":2,\"post_id\":null,\"changed_at\":\"2024-05-28T09:24:52.970Z\"}",
"text": "No",
"title": "EPC available",
"additional_info": "{\"label\":\"No\",\"color\":\"#df2f4a\",\"changed_at\":\"2024-05-28T09:24:52.970Z\"}"
},
{
"id": "dropdown2__1",
"value": "{\"ids\":[2]}",
"text": "Retrofit",
"title": "Property type"
},
{
"id": "dropdown0__1",
"value": "{\"ids\":[1]}",
"text": "Oil boiler",
"title": "Current heat source"
},
{
"id": "text8__1",
"value": "\"Existing oil boiler suppling space heating and domestic hot water to a radiator heating circuit\"",
"text": "Existing oil boiler suppling space heating and domestic hot water to a radiator heating circuit",
"title": "Current system description"
},
{
"id": "long_text__1",
"value": "{\"text\":\"Hybrid air source heat pump system using a Viessmann Vitocal 200-A Pro\",\"changed_at\":\"2024-05-30T10:09:25.582Z\"}",
"text": "Hybrid air source heat pump system using a Viessmann Vitocal 200-A Pro",
"title": "Proposed System"
},
{
"id": "dropdown__1",
"value": "{\"ids\":[2]}",
"text": "Air source heat pump",
"title": "Heat pump type"
},
{
"id": "status_1__1",
"value": "{\"index\":1,\"post_id\":null,\"changed_at\":\"2024-05-30T13:19:12.465Z\"}",
"text": "Monovalent",
"title": "System Type",
"additional_info": "{\"label\":\"Monovalent\",\"color\":\"#00c875\",\"changed_at\":\"2024-05-30T13:19:12.465Z\"}"
},
{
"id": "status1__1",
"value": "{\"index\":1,\"changed_at\":\"2024-05-28T07:37:38.915Z\"}",
"text": "Create proposal",
"title": "Status",
"additional_info": "{\"label\":\"Create proposal\",\"color\":\"#00c875\",\"changed_at\":\"2024-05-28T07:37:38.915Z\"}"
},
{
"id": "long_text1__1",
"value": null,
"text": "",
"title": "Scope Overview"
},
{
"id": "dup__of_scope_overview__1",
"value": null,
"text": "",
"title": "Scope Solution"
},
{
"id": "mirror9__1",
"value": null,
"text": "64164.8, 7778.4, 8885.59, 18459, 5740, 3747.8, 20672.00, 5200.00, 34526.80",
"title": "Proposal Total ex VAT"
},
{
"id": "connect_boards7__1",
"value": "{\"changed_at\":\"2024-05-30T10:32:04.643Z\",\"linkedPulseIds\":[{\"linkedPulseId\":6718471995},{\"linkedPulseId\":6735984257},{\"linkedPulseId\":6735944213},{\"linkedPulseId\":6735981636},{\"linkedPulseId\":6735977023},{\"linkedPulseId\":6735974340},{\"linkedPulseId\":6735970020},{\"linkedPulseId\":6735966521},{\"linkedPulseId\":6736017691}]}",
"text": "Viessmann Vitocal 200-A Pro, Labour, System design, Labour, Insulation, Electrical items, Pipework and fittngs, Buffer Cylinder & freshwater module, Plant room build",
"title": "Anmer Hall (Quote)"
}
],
"assets": [],
"parent_item": null,
"subitems": [
{
"id": "6737015696",
"name": "Heat loss kW",
"created_at": "2024-05-30T13:19:15Z",
"updated_at": "2024-05-30T14:03:44Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"1\"",
"text": "1",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "1"
}
},
{
"id": "6737015910",
"name": "Space heating Requirement kWh/yr",
"created_at": "2024-05-30T13:19:16Z",
"updated_at": "2024-05-30T14:03:44Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"2\"",
"text": "2",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "2"
}
},
{
"id": "6737016168",
"name": "DHW Requirement kWh/yr",
"created_at": "2024-05-30T13:19:18Z",
"updated_at": "2024-05-30T14:03:45Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"3\"",
"text": "3",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "3"
}
},
{
"id": "6737016456",
"name": "Existing System Consumption (Heating)",
"created_at": "2024-05-30T13:19:19Z",
"updated_at": "2024-05-30T14:03:46Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"4\"",
"text": "4",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "4"
}
},
{
"id": "6737016695",
"name": "Existing System Consumption (Hot Water)",
"created_at": "2024-05-30T13:19:21Z",
"updated_at": "2024-05-30T14:03:48Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"5\"",
"text": "5",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "5"
}
},
{
"id": "6737016971",
"name": "Heat Pump Electricity Consumption (Heating)",
"created_at": "2024-05-30T13:19:22Z",
"updated_at": "2024-05-30T14:03:49Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"6\"",
"text": "6",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "6"
}
},
{
"id": "6737017271",
"name": "Heat Pump Electricity Consumption (Hot Water)",
"created_at": "2024-05-30T13:19:24Z",
"updated_at": "2024-05-30T14:03:50Z",
"state": "active",
"board": {
"id": "6683387336"
},
"creator_id": "26870181",
"group": {
"id": "topics"
},
"column_values": [
{
"id": "numbers9__1",
"value": "\"7\"",
"text": "7",
"title": "Value"
}
],
"mappable_column_values": {
"numbers9__1": "7"
}
}
],
"mappable_column_values": {
"subitems__1": {
"changed_at": "2024-05-30 13:19:24 +0000",
"linkedPulseIds": [
{
"linkedPulseId": 6737015696
},
{
"linkedPulseId": 6737015910
},
{
"linkedPulseId": 6737016168
},
{
"linkedPulseId": 6737016456
},
{
"linkedPulseId": 6737016695
},
{
"linkedPulseId": 6737016971
},
{
"linkedPulseId": 6737017271
}
]
},
"connect_boards__1": {
"changed_at": "2024-05-21T19:36:11.903Z",
"linkedPulseIds": [
{
"linkedPulseId": 6610430146
}
],
"text": "Alan Kelf Deal"
},
"item_id__1": {
"item_id": "6683190293",
"text": "6683190293"
},
"status__1": {
"index": 2,
"post_id": null,
"changed_at": "2024-05-28T09:24:52.970Z",
"additonal_info": {
"label": "No",
"color": "#df2f4a",
"changed_at": "2024-05-28T09:24:52.970Z"
},
"text": "No"
},
"dropdown2__1": {
"ids": [
2
],
"text": "Retrofit"
},
"dropdown0__1": {
"ids": [
1
],
"text": "Oil boiler"
},
"text8__1": "Existing oil boiler suppling space heating and domestic hot water to a radiator heating circuit",
"long_text__1": {
"text": "Hybrid air source heat pump system using a Viessmann Vitocal 200-A Pro",
"changed_at": "2024-05-30T10:09:25.582Z"
},
"dropdown__1": {
"ids": [
2
],
"text": "Air source heat pump"
},
"status_1__1": {
"index": 1,
"post_id": null,
"
