Input JSON

[
  {
    "collectionname": "Property name",
    "idgroup_uuid": "7750ceae-0528-44cb-9aeb-8865602d7f6f",
    "iduser_uuid": "5f9c09ea-6332-7541-9632-4a9a0ee768f1"
  },
  [
    {
      "zone_name": "01 green",
      "zone_type_name": "Green",
      "conditions": {
        "timestamp": "2024-06-11 06:35:41",
        "num_samples": 12,
        "img_extent": {
          "min_lng": -5.877219,
          "max_lng": -5.876672,
          "min_lat": 54.220024,
          "max_lat": 54.220338
        },
        "moisture_avg": 29.01,
        "moisture_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387721?attribute=M&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "moisture_avg_color": "#4EC3DA",
        "moisture_avg_rating": "High",
        "ec_avg": 0.21,
        "ec_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387721?attribute=E&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "ec_avg_color": "#2D882D",
        "ec_avg_rating": "Optimal",
        "salinity_index_avg": 0.73,
        "salinity_index_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387721?attribute=S&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "salinity_index_avg_color": "#AF4440",
        "salinity_index_avg_rating": "Critically Low",
        "surface_heat_f_avg": 49.21,
        "surface_heat_f_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387721?attribute=T&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "surface_heat_f_avg_color": "#AF4440",
        "surface_heat_f_avg_rating": "Critically Low",
        "soil_temp_f_avg": 48.98,
        "soil_temp_f_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387721?attribute=ST&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "soil_temp_f_avg_color": "#AF4440",
        "soil_temp_f_avg_rating": "Critically Low",
        "notes": []
      },
      "pins": []
    },
    {
      "zone_name": "02 Green",
      "zone_type_name": "Green",
      "conditions": {
        "timestamp": "2024-06-11 06:58:30",
        "num_samples": 12,
        "img_extent": {
          "min_lng": -5.87333,
          "max_lng": -5.872946,
          "min_lat": 54.222294,
          "max_lat": 54.222509
        },
        "moisture_avg": 29.3,
        "moisture_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387712?attribute=M&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "moisture_avg_color": "#4EC3DA",
        "moisture_avg_rating": "High",
        "ec_avg": 0.21,
        "ec_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387712?attribute=E&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "ec_avg_color": "#2D882D",
        "ec_avg_rating": "Optimal",
        "salinity_index_avg": 0.73,
        "salinity_index_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387712?attribute=S&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "salinity_index_avg_color": "#AF4440",
        "salinity_index_avg_rating": "Critically Low",
        "surface_heat_f_avg": 49.63,
        "surface_heat_f_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387712?attribute=T&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "surface_heat_f_avg_color": "#AF4440",
        "surface_heat_f_avg_rating": "Critically Low",
        "soil_temp_f_avg": 49.55,
        "soil_temp_f_img": "https://api.pogoturfpro.com/api/partner/maya/insight/5387712?attribute=ST&key=05127be738e28884c2eba2585968eb687aa0cd20dadc299f5282ff6bf82f5e5b",
        "soil_temp_f_avg_color": "#AF4440",
        "soil_temp_f_avg_rating": "Critically Low",
        "notes": []
      },
      "pins": []
    }
  ]
]

Expected Output JSON

[
  {
    "Time": "2024-06-11 06:35:41",
    "VMC": 29.01,
    "EC": 0.21,
    "Temp_Soil_F": 48.98,
    "Temp_Soil": 9.433,
    "Latitude": 54.220181,
    "Longitude": -5.876945,
    "idgroup": "group(7750ceae-0528-44cb-9aeb-8865602d7f6f)",
    "iduser": "user(5f9c09ea-6332-7541-9632-4a9a0ee768f1)",
    "Rod_Length": "S",
    "Soil_type": "D",
    "VWC_Mode": "V"
  },
  {
    "Time": "2024-06-11 06:58:30",
    "VMC": 29.3,
    "EC": 0.21,
    "Temp_Soil_F": 49.55,
    "Temp_Soil": 9.75,
    "Latitude": 54.222401,
    "Longitude": -5.873138,
    "idgroup": "group(7750ceae-0528-44cb-9aeb-8865602d7f6f)",
    "iduser": "user(5f9c09ea-6332-7541-9632-4a9a0ee768f1)",
    "Rod_Length": "S",
    "Soil_type": "D",
    "VWC_Mode": "V"
  }
]

Specifications:

Rod_Length, Soil_type & VWC_Mode are hardcoded values

idgroup is idgroup_uuid

iduser is iduser_uuid

Time is timestamp

VWC is moisture_avg

EC is ec_avg

Temp_Soil_F is soil_temp_f_avg

Temp_Soil is celcius(soil_temp_f_avg) – convert soil_temp_f_avg to celsius

Latitude is (min_lat+ max_lat) / 2

Longitude is (min_lng + max_lng)/2