对于以下JSON文件，我很难生成命令

Question

这就是我的JSON文件的外观，

   "Patient":{
      "Name":{
         "Patient First Name":"James",
         "Patient Middle Name":"Adam",
         "Patient Last Name":"Manchester"
      },
      "Unique ID":163983,
      "Demographics":{
         "Sex":"M",
         "Birthdate":"7/24/1940"
      },
      "IntakeCriteria":{
         "DmDxDate":"8/25/2012",
         "InitialHgbA1c":8.1,
         "Comorbidity":["Diabetes Mellitus","CHF","DVT"]
      },
      "Labs":{
         "LDLCholesterol":{
            "LDLResultDate":"5/6/2013",
            "LDLLevel":200
         },
         "SerumCreatinine":{
            "CreatinineResultDate":"11/1/2016",
            "CreatinineLevel":0.9
         }
      },
      "CareLocation":{
         "Facility Name":"East Side Clinic",
         "Facility Contact Name":"Mary Silverman",
         "Facility Contact Phone":"618-348-1891"
      }
   }
}

我需要使用以下字段来准备查询：

Patient Unique ID number.
Patient First Name.
Patient Last Name.
Lab Test Date.
HgbA1c Level.
LDL Level.
Creatinine Level.

我尝试了此结果，因此没有结果

jq - r’[.Patient.UniqueID, .Patient.Name.FirstName, .Patient.Name.LastName, .Patient.Labs.LDLCholesterol.LabResultDate, .Patient.IntakeCriteria.InitialHgbA1c, .Patient.Labs.LDLCholesterol.LDLLevel, .Patient.Labs.SerumCreatine.CreatineLevel] | @csv’ data.json > csvtest.out

Answer 1

当使用您必须按照JSON文件中的使用完全提供字段名称。另外，如果它们包含特殊字符，例如白色空间（或以数字开头），请用双引号包围以澄清：

jq -r '[
  .Patient."Unique ID",
  .Patient.Name."Patient First Name",
  .Patient.Name."Patient Last Name",
  .Patient.Labs.LDLCholesterol.LDLResultDate,
  .Patient.IntakeCriteria.InitialHgbA1c,
  .Patient.Labs.LDLCholesterol.LDLLevel,
  .Patient.Labs.SerumCreatinine.CreatinineLevel
] | @csv' data.json > csvtest.out

163983,"James","Manchester","5/6/2013",8.1,200,0.9

demo

要稍微缩短过滤器，您也可以使用带管的子滤光器 |在与括号进行分组 （）：

jq -r '[.Patient |
  ."Unique ID",
  (.Name | ."Patient First Name", ."Patient Last Name"),
  .Labs.LDLCholesterol.LDLResultDate,
  .IntakeCriteria.InitialHgbA1c,
  (.Labs | .LDLCholesterol.LDLLevel, .SerumCreatinine.CreatinineLevel)
] | @csv' data.json > csvtest.out

163983,"James","Manchester","5/6/2013",8.1,200,0.9