Delete values from JSON

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN":

 

{
  "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6",
  "details": [
    {
      "keyInformation": {
        "dunsNumber": "NaN",
        "organizationType": "LIMITED_COMPANY"
      }
    },
    {
      "keyInformation": {
        "dunsNumber": "123",
        "organizationType": "LIMITED_COMPANY"
      }
    }
  ],
  "nisse": 123
}

 

So that the result becomes:

 

{
  "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6",
  "details": [
    {
      "keyInformation": {
        "organizationType": "LIMITED_COMPANY"
      }
    },
    {
      "keyInformation": {
        "dunsNumber": "123",
        "organizationType": "LIMITED_COMPANY"
      }
    }
  ],
  "nisse": 123
}

 

Thanks.

 

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@xxxxxxxxxx

www.visena.com