Does redash JSON datasource support nested objects? #6938

SmallStrayFox · 2024-05-01T01:34:23Z

SmallStrayFox
May 1, 2024

Hey there, I'm aware that the JSON datasource supports the path option so you can return an inner object, but I cannot work out the syntax to use this if the object is several levels deep.

Eg for this JSON as an example, I can use path: data to access stuff in the data object, but it's not clear how I'd access the nested data.awarded or data.awarded.supplier objects. It doesn't seem like you can traverse the JSON.

Any help would be appreciated. Nb the below is just example JSON I pulled for the example. edit: json rest api source for example: https://tenders.guru/api/es/tenders/

{
  "page_count": 7146,
  "page_number": 1,
  "page_size": 100,
  "total": 714598,
  "data": [
    {
      "id": "831333",
      "date": "2021-06-29",
      "deadline_date": "2021-06-07",
      "deadline_length_days": "22",
      "title": "Servicio de producción de células mesenquimales troncales adultas autólogas y alogénicas de medula ósea expandidas, vinculado al proyecto de investigación PIC18/00001",
      "category": "services",
      "sid": "7791427",
      "src_url": "https://contrataciondelestado.es/wps/poc?uri=deeplink:detalle_licitacion&idEvl=IQ7l9PalhEWiEJrVRqloyA%3D%3D",
      "purchaser": {
        "id": "1988",
        "sid": null,
        "name": null
      },
      "type": {
        "id": "negotiated-without-publicity",
        "name": "Negotiated without publicity",
        "slug": "negotiated-without-publicity"
      },
      "awarded": [
        {
          "date": "2021-06-29",
          "value_for_two": 163560.4,
          "suppliers_id": "156913",
          "suppliers": [
            {
              "name": "FUNDACIÓN PARA LA INVESTIGACIÓN BIOMÉDICA DEL HOSPITAL GREGORIO MARAÑÓN",
              "id": "156913",
              "slug": "fundacion-para-la-investigacion-biomedica-del-hospital-gregorio-maranon"
            }
          ],
          "value_for_three": 163560.4,
          "count": "1",
          "offers_count": 1,
          "value_for_one": 163560.4,
          "suppliers_name": "FUNDACIÓN PARA LA INVESTIGACIÓN BIOMÉDICA DEL HOSPITAL GREGORIO MARAÑÓN",
          "value": "163560.40",
          "offers_count_data": {
            "1": {
              "count": 1,
              "value": "163560.40"
            }
          }
        }
      ]
    },