Data request result in array

Questions
,
1

hello i have this sort of result

[
{
"PUBAF2": "139.5000",
"VLVOLU": "0.117",
"NOLIGF": "1",
"NUDOSL": "000003675",
"LIB4": "LABEL-CORDSET 2.50M-2PCS/MAST",
"LIB3": "4XE27 BROWN BOX+COLOR",
"PCB": "2",
"REARTF": "CRP19002",
"LIB2": "BLACK MESH RATTAN W/BLACK LEGS",
"LIB1": "SCREEN XXL PENDANT 13 COVERS",
"VLF": "10",
"CDART": "655543",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "50.0000",
"LIBRED": "SCREEN SUSP 4L",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "80202",
"NUCUEF": "2",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "156.7283"
},
{
"PUBAF2": "49.9000",
"VLVOLU": "0.117",
"NOLIGF": "2",
"NUDOSL": "000003675",
"LIB4": "LABEL-CORDSET 2.50M-2PCS/MAST",
"LIB3": "4XE27 WHITE BOX+COLOR",
"PCB": "2",
"REARTF": "CRP19002 WHITE",
"LIB2": "CFRAME & ELECTRIC FITTING ONLY",
"LIB1": "SCREEN XXL PENDANT 13 WHITE",
"VLF": "10",
"CDART": "MP16153",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "80.0000",
"LIBRED": "CA CHI SCREEN",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "80202",
"NUCUEF": "2",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "56.0627"
},
{
"PUBAF2": "17.5000",
"VLVOLU": "0.095",
"NOLIGF": "3",
"NUDOSL": "000003675",
"LIB4": "COLOR LABEL-MASTER 4PCS",
"LIB3": "1XE27 - BROWN BOX",
"PCB": "4",
"REARTF": "CRP19008 WHITE",
"LIB2": "SFRAME & ELECTRIC FITTING ONLY",
"LIB1": "SCREEN WALL LAMP 1L WHITE VE",
"VLF": "10",
"CDART": "MP16155",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "52.0000",
"LIBRED": "CA CHI SCREEN",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "80203",
"NUCUEF": "4",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "19.6613"
},
{
"PUBAF2": "7.7500",
"VLVOLU": "0.081",
"NOLIGF": "4",
"NUDOSL": "000003675",
"LIB4": "PAINT-24P/M-PP BAG-COLOR LABEL",
"LIB3": "INNER WRAPPED BAMBOO-WHITE",
"PCB": "24",
"REARTF": "CRP14006-WHITE",
"LIB2": "TC FABRIC PENDANT Ø12.5*9*30CM",
"LIB1": "OUTER FEATHER INNER WHITE",
"VLF": "10",
"CDART": "513804",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "1008.0000",
"LIBRED": "SUSP.BOULE",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "91334",
"NUCUEF": "24",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "8.7071"
},
{
"PUBAF2": "8.0000",
"VLVOLU": "0.134",
"NOLIGF": "5",
"NUDOSL": "000003675",
"LIB4": "",
"LIB3": "",
"PCB": "8",
"REARTF": "CRP16009",
"LIB2": "Ø56.3*80-HEIGHT 14.6CM-8PC/MAS",
"LIB1": "LEAF SUSPENSION E27-BRASS",
"VLF": "10",
"CDART": "651242",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "304.0000",
"LIBRED": "S METAL LEAF",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "91560",
"NUCUEF": "8",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "8.9880"
},
{
"PUBAF2": "6.0500",
"VLVOLU": "0.134",
"NOLIGF": "6",
"NUDOSL": "000003675",
"LIB4": "",
"LIB3": "",
"PCB": "8",
"REARTF": "CRP16009",
"LIB2": "KØ56.3*80-HEIGHT 14.6CM-8PC/MAS",
"LIB1": "LEAF SUSPENSION E27-MATT BLA",
"VLF": "10",
"CDART": "651241",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "304.0000",
"LIBRED": "S METAL LEAF",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "91560",
"NUCUEF": "8",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "6.7972"
},
{
"PUBAF2": "5.9000",
"VLVOLU": "0.119",
"NOLIGF": "7",
"NUDOSL": "000003675",
"LIB4": "COLOR BOX - MASTER X16 PCS",
"LIB3": "ELEC. FITTING TRIM ALL AROUN",
"PCB": "16",
"REARTF": "CRP19050",
"LIB2": "WHITE TC SHADE+ NATURAL RAFFIA",
"LIB1": "CRP4651 WALL LAMP 10*20*20CM",
"VLF": "10",
"CDART": "654389",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "304.0000",
"LIBRED": "APP.E14.RAP&COT",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "91868",
"NUCUEF": "16",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "6.6287"
},
{
"PUBAF2": "6.1000",
"VLVOLU": "0.021",
"NOLIGF": "8",
"NUDOSL": "000003675",
"LIB4": "MASTER / 50PCS",
"LIB3": "NATURAL COLOR / GLUED EDGE",
"PCB": "50",
"REARTF": "CRP18072",
"LIB2": "LENGHT 42,5CM-WIDTH 28CM",
"LIB1": "NATURAL RATTAN WEAVING PANEL",
"VLF": "10",
"CDART": "CP21001",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "250.0000",
"LIBRED": "CP CHINE 13",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "*****",
"NUCUEF": "50",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "6.8534"
},
{
"PUBAF2": "5.2000",
"VLVOLU": "0.017",
"NOLIGF": "9",
"NUDOSL": "000003675",
"LIB4": "MASTER / 50PCS",
"LIB3": "NATURAL COLOR / GLUED EDGE",
"PCB": "50",
"REARTF": "CRP18074",
"LIB2": "LENGHT 55CM-WIDTH 16CM",
"LIB1": "NATURAL RATTAN WEAVING PANEL",
"VLF": "10",
"CDART": "CP21003",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "200.0000",
"LIBRED": "CP CHINE 17",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "*****",
"NUCUEF": "50",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "5.8422"
},
{
"PUBAF2": "10.2000",
"VLVOLU": "0.041",
"NOLIGF": "10",
"NUDOSL": "000003675",
"LIB4": "",
"LIB3": "50 PCS/MASTER",
"PCB": "50",
"REARTF": "CRP21005",
"LIB2": "LENGHT 121CM-WIDTH 15CM",
"LIB1": "NATURAL RATTAN WEAVING PANEL",
"VLF": "10",
"CDART": "CP22843",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "250.0000",
"LIBRED": "CP CHINE 38",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "*****",
"NUCUEF": "50",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "11.4597"
}
]

and i want something like this:

lignes: [
{
"PUBAF2": "139.5000",
"VLVOLU": "0.117",
"NOLIGF": "1",
"NUDOSL": "000003675",
"LIB4": "LABEL-CORDSET 2.50M-2PCS/MAST",
"LIB3": "4XE27 BROWN BOX+COLOR",
"PCB": "2",
"REARTF": "CRP19002",
"LIB2": "BLACK MESH RATTAN W/BLACK LEGS",
"LIB1": "SCREEN XXL PENDANT 13 COVERS",
"VLF": "10",
"CDART": "655543",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "50.0000",
"LIBRED": "SCREEN SUSP 4L",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "80202",
"NUCUEF": "2",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "156.7283"
}
]
lignes: [
{
"PUBAF2": "49.9000",
"VLVOLU": "0.117",
"NOLIGF": "2",
"NUDOSL": "000003675",
"LIB4": "LABEL-CORDSET 2.50M-2PCS/MAST",
"LIB3": "4XE27 WHITE BOX+COLOR",
"PCB": "2",
"REARTF": "CRP19002 WHITE",
"LIB2": "CFRAME & ELECTRIC FITTING ONLY",
"LIB1": "SCREEN XXL PENDANT 13 WHITE",
"VLF": "10",
"CDART": "MP16153",
"DELAI_DEM": "20230103",
"VL": "10",
"QTCMDF": "80.0000",
"LIBRED": "CA CHI SCREEN",
"DATE_RECEPR": "00000000",
"INDNUL": "1",
"FAMILL": "80202",
"NUCUEF": "2",
"DELAI_CONF": "20230105",
"NUCMDL": "000059326",
"PUBAF1": "56.0627"
}
]

how can i do that ??

thanks for your help

2

Hi @fporta, I think the Set node would be the easiest way to move your current items inside an lignes field. Check out this example workflow:

The result would match the format you have in mind:

image
image1147×930 43.9 KB

1 Like
3

@MutedJam
you’re a genius !!!

1 Like
4

I wish. Glad to hear this helps though :wink:

A full list of variables (like the $json one used here) which can be used in expressions is btw available here:

They are quite powerful, so might be worth taking a closer look

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.