Hi Team,
I am new to make.com and trying to figure out to get an array from my output bundle so that I can use them in Microsoft word template loop. My output bundle looks like below
[
{
“document”: {
“sections”: ,
“documentId”: “142”,
“indexFields”: [
{
“SystemField”: true,
“FieldName”: “DWDOCID”,
“FieldLabel”: “Document ID”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: 142,
“ItemElementName”: “Int”
},
{
“SystemField”: true,
“FieldName”: “DWDOCSIZE”,
“FieldLabel”: “Document size”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: 0,
“ItemElementName”: “Int”
},
{
“SystemField”: true,
“FieldName”: “DWSTOREUSER”,
“FieldLabel”: “Stored by”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “ADMIN”,
“ItemElementName”: “String”
},
{
“SystemField”: true,
“FieldName”: “DWSTOREDATETIME”,
“FieldLabel”: “Stored on”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “2025-02-05T06:39:43.000Z”,
“ItemElementName”: “DateTime”
},
{
“SystemField”: true,
“FieldName”: “DWEXTENSION”,
“FieldLabel”: “File type”,
“IsNull”: true,
“ReadOnly”: true,
“ItemElementName”: “String”
},
{
“SystemField”: true,
“FieldName”: “DWMODUSER”,
“FieldLabel”: “Modified by”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “ADMIN”,
“ItemElementName”: “String”
},
{
“SystemField”: true,
“FieldName”: “DWMODDATETIME”,
“FieldLabel”: “Modified on”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “2025-02-05T06:39:43.000Z”,
“ItemElementName”: “DateTime”
},
{
“SystemField”: true,
“FieldName”: “DWSECTIONCOUNT”,
“FieldLabel”: “Section count”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: 0,
“ItemElementName”: “Int”
},
{
“SystemField”: true,
“FieldName”: “DWPAGECOUNT”,
“FieldLabel”: “Section count”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: 0,
“ItemElementName”: “Int”
},
{
“SystemField”: false,
“FieldName”: “DOCUMENT_TYPE”,
“FieldLabel”: “Document Type”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “Contract”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “COMPANY”,
“FieldLabel”: “Company”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “ABCDEF Investments”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “CONTACT”,
“FieldLabel”: “Contact”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “James Anderson”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “CUSTOMER_ID”,
“FieldLabel”: “Customer ID”,
“IsNull”: true,
“ReadOnly”: false,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “EMAIL”,
“FieldLabel”: “Email”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “someone@gmail.com”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “SUBJECT”,
“FieldLabel”: “Subject”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “SERVICE LEVEL AGREEMENT”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “STATUS”,
“FieldLabel”: “Status”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “New”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “DOCUMENT_NUMBER”,
“FieldLabel”: “Document Number”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “OA-IMG//2025/SLA/005 R/demo”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “PROJECT”,
“FieldLabel”: “Project”,
“IsNull”: true,
“ReadOnly”: false,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “VAT_ID”,
“FieldLabel”: “Tax ID”,
“IsNull”: true,
“ReadOnly”: false,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “SUBTYPE”,
“FieldLabel”: “Subtype”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “OA”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “CONTRACT_TYPE”,
“FieldLabel”: “Contract Type”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “CopyPack”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “Q_NUMBER”,
“FieldLabel”: “Q Number”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “Q1212123”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “COPY_LIMIT”,
“FieldLabel”: “Copy Limit”,
“IsNull”: true,
“ReadOnly”: false,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “SERIAL_NO”,
“FieldLabel”: “Serial No”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “ABCD123”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “ADDRESS”,
“FieldLabel”: “Address”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “Road No 2”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “LOCATION”,
“FieldLabel”: “Location”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “Nairobi”,
“ItemElementName”: “String”
},
{
“SystemField”: false,
“FieldName”: “COLOR_READING”,
“FieldLabel”: “Color Reading”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: 1234,
“ItemElementName”: “Int”
},
{
“SystemField”: false,
“FieldName”: “MONO_READING”,
“FieldLabel”: “Mono Reading”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: 1234,
“ItemElementName”: “Int”
},
{
“SystemField”: false,
“FieldName”: “TOTAL_READING”,
“FieldLabel”: “Total Reading”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: 2468,
“ItemElementName”: “Int”
},
{
“SystemField”: false,
“FieldName”: “DATE”,
“FieldLabel”: “Date”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “2025-02-05”,
“ItemElementName”: “Date”
},
{
“SystemField”: false,
“FieldName”: “PENDING_DATE”,
“FieldLabel”: “Pending Date”,
“IsNull”: true,
“ReadOnly”: false,
“ItemElementName”: “Date”
},
{
“SystemField”: false,
“FieldName”: “START_DATE”,
“FieldLabel”: “Start Date”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “2025-02-01”,
“ItemElementName”: “Date”
},
{
“SystemField”: false,
“FieldName”: “END_DATE”,
“FieldLabel”: “End Date”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: “2026-01-31”,
“ItemElementName”: “Date”
},
{
“SystemField”: false,
“FieldName”: “AMOUNT”,
“FieldLabel”: “Amount”,
“IsNull”: true,
“ReadOnly”: false,
“ItemElementName”: “Decimal”
},
{
“SystemField”: false,
“FieldName”: “DETAILS”,
“FieldLabel”: “Details”,
“IsNull”: false,
“ReadOnly”: false,
“Item”: [
{
“DETAI_MODEL”: “IM 3000”,
“DETAI_SERIALNO”: “ABC123”,
“DETAI_LOCATION”: “Japan”,
“DETAI_AMOUNT”: “12000”,
“DETAI_QNUMBER”: “Q123”
},
{
“DETAI_MODEL”: “IM C3000”,
“DETAI_SERIALNO”: “SWS1111”,
“DETAI_LOCATION”: “Korea”,
“DETAI_AMOUNT”: “10000”,
“DETAI_QNUMBER”: “Q345”
},
{
“DETAI_MODEL”: “IM 2500”,
“DETAI_SERIALNO”: “QAW122”,
“DETAI_LOCATION”: “England”,
“DETAI_AMOUNT”: “8000”,
“DETAI_QNUMBER”: “Q456”
}
],
“ItemElementName”: “Table”
},
{
“SystemField”: true,
“FieldName”: “DWCONTENTMODUSER”,
“FieldLabel”: “Content modified by”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “ADMIN”,
“ItemElementName”: “String”
},
{
“SystemField”: true,
“FieldName”: “DWCONTENTMODDATETIME”,
“FieldLabel”: “Content modified on”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “2025-02-05T06:39:43.000Z”,
“ItemElementName”: “DateTime”
},
{
“SystemField”: true,
“FieldName”: “DWDISK”,
“FieldLabel”: “Disk number”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: 1,
“ItemElementName”: “Int”
},
{
“SystemField”: true,
“FieldName”: “DWDISKNO”,
“FieldLabel”: “Disk number”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: 1,
“ItemElementName”: “Int”
},
{
“SystemField”: true,
“FieldName”: “DWCOMMENT”,
“FieldLabel”: “Change comment”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “”,
“ItemElementName”: “String”
},
{
“SystemField”: true,
“FieldName”: “DERSTATUS”,
“FieldLabel”: “Version status”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “Current version”,
“ItemElementName”: “String”
},
{
“SystemField”: true,
“FieldName”: “DWION”,
“FieldLabel”: “Version number”,
“IsNull”: false,
“ReadOnly”: true,
“Item”: “1.0”,
“ItemElementName”: “String”
}
],
“documentTitle”: “Unnamed Document with id 142 from 2/5/2025 9:39:43 AM”,
“fileCabinetId”: “f864-ae0c3e4baedb”,
“documentTotalPages”: 0,
“documentContentType”: “application/octet-stream”
}
}
]
My interest is only in the Array called ITEM and its collections. How can we create an array with this information and ignore other information? My required information is available in the Array called Index Fields Collection no 35 in the attached picture
I tried Iterator with no luck. Your support would be highly appreciated.