I’m a newbie with jq.
I get this JSON with curl:
{
“invendus”: [
{
“automatique”: false,
“available”: true,
“createdAt”: “2024-06-27T12:49:01.639270+02:00”,
“dateCollecte”: “2024-06-27”,
“dateFinCollecte”: “2024-06-27”,
“deletedByCommerce”: false,
“description”: “”,
“heureDebutCollecte”: “12:48:00”,
“heureFinCollecte”: “21:30:00”,
“id”: 98291,
“isCopyOf”: “”,
“paf”: 0.5,
“prixLibre”: true,
“prixMaxCollecte”: 6.0,
“prixVente”: 6.0,
“quantMaxUser”: 1,
“quantitePropose”: 2,
“quantiteRestante”: 0,
“refProduitsInvendu”: {
“allergenes”: false,
“dateDebutCollecte”: null,
“dateFinCollecte”: null,
“description”: “”,
“dlcJour”: true,
“id”: 1741,
“infos”: null,
“listeAllergenes”: null,
“mainImage”: “/static/storage/media/2023/06/5wj2M2SstbHA.jpeg”,
“paf”: 0.5,
“prixLibre”: true,
“prixMaxCollecte”: 6.0,
“quantMaxUser”: 1,
“rapporterContenant”: false,
“rapporterSac”: false,
“refCommerce”: {
“adresse”: “Address1”,
“codePostal”: “PostalCode”,
“codeRestreints”: [
12
],
“codeValidation”: true,
“communities”: [],
“comptabilisationDons”: 0,
“createdAt”: “2023-05-03T14:47:14.665788+02:00”,
“dateLastEnvoiBilan”: null,
“datePremierDon”: “2023-06-20”,
“desactive”: false,
“frequenceAttestation”: 2,
“heureBilanSuspendus”: null,
“id”: 802,
“image”: “/static/storage/media/photo_.jpeg”,
“image_cropee”: “/static/storage/media/photo_.jpeg.500x140_q85_box-0%2C333%2C0%2C333_crop_detail.jpg”,
“inclusDansNbMaxSemaine”: true,
“information”: “Informations,
“initialized”: true,
“isDemo”: false,
“limit_per_day”: 1,
“limit_per_week”: 7,
“location”: {
“coordinates”: [
-0.5518213,
44.8640196
],
“type”: “Point”
},
“mailReporting”: false,
“modaliteCollecte”: Collectemodalite,
“montantAbonnement”: 0.0,
“nbMaxCollecteUserParJour”: 1,
“nbMaxCollecteUserParSemaine”: 7,
“nbNote”: 72,
“nom”: ” Name”,
“note”: 4.986111111111111,
“planningCollecte”: [
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5829,
“jour”: 0,
“refCommerce”: 802
},
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5830,
“jour”: 1,
“refCommerce”: 802
},
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5831,
“jour”: 2,
“refCommerce”: 802
},
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5832,
“jour”: 3,
“refCommerce”: 802
},
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5833,
“jour”: 4,
“refCommerce”: 802
},
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5834,
“jour”: 5,
“refCommerce”: 802
},
{
“heureDebutCollecte”: “09:00:00”,
“heureFinCollecte”: “22:00:00”,
“id”: 5835,
“jour”: 6,
“refCommerce”: 802
}
],
“priorityTime”: 60,
“proposeSuspendus”: false,
“quinzeJour”: false,
“refGroupe”: null,"timeToCancel": 60, "typeCommerce": 7, "typePaiement": 0, "updatedAt": "2024-06-27T17:14:13.465373+02:00", "usingScanCodeBarre": false, "valeurCodeValidation": "Code1", "ville": "City" }, "title": "Titre", "type": 1, "updatedAt": "2024-02-26T10:56:17.518514+01:00", "valeurBonSolidaire": 0.0 }, "type": 1, "updatedAt": "2024-06-27T13:39:04.676624+02:00", "valeurBonSolidaire": 0.0 }, { "automatique": false, "available": true, "createdAt": "2024-06-27T15:29:14.965356+02:00", "dateCollecte": "2024-06-27", "dateFinCollecte": "2024-06-27", "deletedByCommerce": false, "description": "Description", "heureDebutCollecte": "15:28:00", "heureFinCollecte": "20:00:00", "id": 98296, "isCopyOf": "", "paf": 0.5, "prixLibre": true, "prixMaxCollecte": 12.0, "prixVente": 12.36, "quantMaxUser": 1, "quantitePropose": 1, "quantiteRestante": 0, "refProduitsInvendu": { "allergenes": false, "dateDebutCollecte": "2024-06-03", "dateFinCollecte": "2029-04-30", "description": null, "dlcJour": false, "id": 1310, "infos": "", "listeAllergenes": "", "mainImage": "/static/storage/media/2024/05/panier_.jpg", "paf": 0.5, "prixLibre": true, "prixMaxCollecte": 12.0, "quantMaxUser": 1, "rapporterContenant": false, "rapporterSac": true, "refCommerce": { "adresse": "Address", "codePostal": "PostalCode", "codeRestreints": [
12
],
“codeValidation”: true,
“communities”: [],
“comptabilisationDons”: 1,
“createdAt”: “2022-04-25T16:39:12.956287+02:00”,
“dateLastEnvoiBilan”: null,
“datePremierDon”: “2022-04-27”,
“desactive”: false,
“frequenceAttestation”: 1,
“heureBilanSuspendus”: null,
“id”: 670,
“image”: “/static/storage/media/_03306300_195138172_uUKiozx.jpg”,
“image_cropee”: “/static/storage/media/_03306300_195138172_uUKiozx.jpg.500x140_q85_box-0%2C25%2C500%2C165_crop_detail.jpg”,
“inclusDansNbMaxSemaine”: true,
“information”: “”,
“initialized”: true,
“isDemo”: false,
“limit_per_day”: 1,
“limit_per_week”: 4,
“location”: {
“coordinates”: [
-0.5723875,
44.8495768
],
“type”: “Point”
},
“modaliteCollecte”: “Collectemodalite”,
“montantAbonnement”: 0.0,
“nbMaxCollecteUserParJour”: 1,
“nbMaxCollecteUserParSemaine”: 4,
“nbNote”: 21,
“nom”: “Shop2 Address PostalCode City”,
“note”: 5.0,
“planningCollecte”: [
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “18:30:00”,
“id”: 3429,
“jour”: 0,
“refCommerce”: 670
},
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “18:30:00”,
“id”: 3423,
“jour”: 1,
“refCommerce”: 670
},
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “20:30:00”,
“id”: 3424,
“jour”: 2,
“refCommerce”: 670
},
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “20:30:00”,
“id”: 3425,
“jour”: 3,
“refCommerce”: 670
},
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “20:30:00”,
“id”: 3426,
“jour”: 4,
“refCommerce”: 670
},
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “20:30:00”,
“id”: 3427,
“jour”: 5,
“refCommerce”: 670
},
{
“heureDebutCollecte”: “16:00:00”,
“heureFinCollecte”: “20:30:00”,
“id”: 3428,
“jour”: 6,
“refCommerce”: 670
}
],
“priorityTime”: 60,
“proposeSuspendus”: false,
“quinzeJour”: false,
“refGroupe”: null,"timeToCancel": 60, "typeCommerce": 2, "typePaiement": 0, "updatedAt": "2024-06-27T06:00:00.838174+02:00", "usingScanCodeBarre": true, "valeurCodeValidation": "ValidationCode", "ville": "City" }, "title": "Titre2", "type": 1, "updatedAt": "2024-06-02T17:26:14.361095+02:00", "valeurBonSolidaire": 0.0 }, "type": 1, "updatedAt": "2024-06-27T15:52:09.869245+02:00", "valeurBonSolidaire": 0.0 }
I already pipe it to jq with this command:
| jq -r -j '.invendus[] |select(.quantiteRestante >= 1) | .refProduitsInvendu.refCommerce.nom,.refProduitsInvendu.title,.description,.prixVente,.refProduitsInvendu.refCommerce.valeurCodeValidation | select( . != null )'
But there are still some results I would like to exclude, for example all keys related to “”refCommerce”: 602″.
Could you please tell me how to do it?
Thanks in advance for your kind help 🙂
Aliot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.