How do I remove null if the "If" condition is false

[akashvekariya]

I was working on one payload where the template is

let r = .records[0] 
let p = $r.OrderItems.records 

{ "details_view": 
    [ { 
          "display_as": "details", 
          "data": { 
               "date": $r.CreatedDate, 
               "status": $r.StatusCode
          } 
       },
       if ($p)
       { 
          "display_as": "columns", 
          "caption": "products", 
          "data": [
               for ($p) { 
                   "product": .PricebookEntry.Product2.Name, 
                   "quantity": .Quantity, 
                   "price": .UnitPrice 
               }
          ] 
        } 
    ] 
}

And the response I'm getting if the $p is not null is:

{
  "details_view" : [ {
    "display_as" : "details",
    "data" : {
      "date" : "2023-05-09T11:43:13.000+0000",
      "status" : "Activated"
    }
  }, {
    "display_as" : "columns",
    "caption" : "products",
    "data" : [ {
      "product" : "SLA: Bronze",
      "quantity" : 2,
      "price" : 10000
    }, {
      "product" : "SLA: Platinum",
      "quantity" : 2,
      "price" : 40000
    } ]
  } ]
}

and if the $p is null:

{
  "details_view" : [ {
    "display_as" : "details",
    "data" : {
      "date" : "2023-05-09T11:43:13.000+0000",
      "status" : "Activated"
    }
  }, null]
}

But I don't want null there it should only return this

{
  "details_view" : [ {
    "display_as" : "details",
    "data" : {
      "date" : "2023-05-09T11:43:13.000+0000",
      "status" : "Activated"
    }
  }]
}

How do I achieve that?

[FoolMuun]

Try this...

JSLT

let r = .records[0] 
let p = $r.OrderItems.records 

{ "details_view": 
    [for(array([ { 
          "display_as": "details", 
          "data": { 
               "date": $r.CreatedDate, 
               "status": $r.StatusCode
          } 
       },
       if ($p)
       { 
          "display_as": "columns", 
          "caption": "products", 
          "data": [
               for ($p) { 
                   "product": .PricebookEntry.Product2.Name, 
                   "quantity": .Quantity, 
                   "price": .UnitPrice 
               }
          ] 
        } 
    ])). if( . != null)]
}

[akashvekariya]

Thank you so much, exactly what I was looking for

[larsga]

@akashvekariya Did the suggestion solve your problem?

[akashvekariya]

Yes it is resolved!