Hi Make community,
i’m a new Make.com user, and i’m trying to show some data from online orders.
My scenario is this
My current scenario gives me a list of orders like this
The result of each operation is like this
My purpose is to have a the end an email with text showing
the list of orders (Reference) containing missing articles (that is to say articles where qteManquanteArticle is > 0),
and for each of these orders
the list of the missing articles & corresponding missing quantity qteManquanteArticle
It might be quite simple, but i’m confused with arrays, collections, aggregators and can’t manage to get it !
Here is the example of a bundle output (which corresponds to an order).
Thank you very much for your help !
[
{
"total": 1,
"commandes": [
{
"entrepotNom": "Le Mans",
"bloquee": false,
"blocageLogistique": false,
"listeMotifBlocageLogistique": [],
"motifBlocage": null,
"messageCadeau": null,
"referenceEKAN": "EK050224438904",
"reference": "C-240212-13373",
"referenceSecondaire": null,
"referenceClient": null,
"dateCreation": "2024-02-12T08:40:29+01:00",
"etat": "ATTENTE_STOCK",
"etatLibelle": "En attente de stock",
"dateCommande": "2024-02-12T00:00:00+01:00",
"dateExpeditionSouhaitee": null,
"etatPaiement": 1,
"etatPaiementLibelle": "Payé",
"montantToAssurer": null,
"montantHT": null,
"deviseMontantHT": "EUR",
"incoterm": null,
"categorieEnvoi": null,
"fraisDePort": null,
"deviseFraisDePort": "EUR",
"messageCommercial": null,
"commentaire": "%%IdCde46988765IdCde%%",
"dateModification": "2024-02-12T08:41:58+01:00",
"hasDocument": false,
"hasFacture": false,
"hasFormulaire": false,
"factureNecessaire": false,
"commandeMere": null,
"client": {
"nom": "Grégoire",
"prenom": "Isabelle",
"reference": "",
"typeClient": "Entreprise",
"codeTypeClient": "ENTREPRISE"
},
"serviceTransporteur": {
"nom": "DPD",
"code": "39",
"transporteur": {
"nom": "DPD",
"code": "DPD"
}
},
"infoFacturation": {
"nom": "Grégoire",
"prenom": "Isabelle",
"etageCouloirEscalier": null,
"adresse": "Avenue du Vivier d'Oie 75",
"ville": "Bruxelles",
"codePostal": "1000",
"codePays": "BE",
"entreeBatimentImmeuble": null,
"adresseSecondaire": null,
"telephoneFixe": null,
"telephoneMobile": null,
"email": "isabelle@society.be"
},
"infoLivraison": {
"societe": "La Villa Traiteur",
"nom": "Villa",
"prenom": "Marie",
"telephoneFixe": "+32471777925",
"telephoneMobile": "+32477736925",
"email": "traiteur@villa.be",
"etageCouloirEscalier": null,
"entreeBatimentImmeuble": null,
"adresse": "Place Dumon 33",
"adresseSecondaire": null,
"codePostal": "1150",
"ville": "Bruxelles Woluwe-Saint-Pierre",
"codePays": "BE",
"nrPointDepot": null,
"commentaire": "HORAIRES LIVRAISON lun-ven : 10h30-19h"
},
"details": [
{
"article": {
"titre": "Biscuits sablés Bio aux 3 Poivres - 35g",
"refEcommercant": "BIP004",
"EAN13": "3760243072543",
"taille": null,
"couleur": null,
"marque": "SUPERP "
},
"qteCommandeArticle": 1,
"qteManquanteArticle": 0,
"dlc": "",
"nrSerie": null,
"pack": null,
"prixVenteUnitaire": null,
"devisePrixVenteUnitaire": "EUR",
"emballageCadeau": false,
"remarque": null
},
{
"article": {
"titre": "Menu de saison Superproducteur - Automne",
"refEcommercant": "MDS001",
"EAN13": null,
"taille": null,
"couleur": null,
"marque": null
},
"qteCommandeArticle": 1,
"qteManquanteArticle": 0,
"dlc": "",
"nrSerie": null,
"pack": null,
"prixVenteUnitaire": null,
"devisePrixVenteUnitaire": "EUR",
"emballageCadeau": false,
"remarque": null
},
{
"article": {
"titre": "Crème Fine Bio d'Artichauts - 100g",
"refEcommercant": "ARB002",
"EAN13": "3760243070969",
"taille": null,
"couleur": null,
"marque": null
},
"qteCommandeArticle": 36,
"qteManquanteArticle": 0,
"dlc": "",
"nrSerie": null,
"pack": null,
"prixVenteUnitaire": null,
"devisePrixVenteUnitaire": "EUR",
"emballageCadeau": false,
"remarque": null
},
{
"article": {
"titre": "Rillettes de Saint Jacques 90g",
"refEcommercant": "SAB001",
"EAN13": "3760243070617",
"taille": null,
"couleur": null,
"marque": "SUPERP"
},
"qteCommandeArticle": 12,
"qteManquanteArticle": 12,
"dlc": "",
"nrSerie": null,
"pack": null,
"prixVenteUnitaire": null,
"devisePrixVenteUnitaire": "EUR",
"emballageCadeau": false,
"remarque": null
},
{
"article": {
"titre": "Rillettes de Langoustines - 90g",
"refEcommercant": "LAN002",
"EAN13": "3760243071195",
"taille": null,
"couleur": null,
"marque": "Superp"
},
"qteCommandeArticle": 12,
"qteManquanteArticle": 0,
"dlc": "",
"nrSerie": null,
"pack": null,
"prixVenteUnitaire": null,
"devisePrixVenteUnitaire": "EUR",
"emballageCadeau": false,
"remarque": null
}
]
}
]
}
]
