Filter on JSON response

Grafana Dashboards
1

Hi ,

For my Grafana query variable , I get a JSON response as below -

                "content": [
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-LAB/EMKT-LabMarket/ESTC-LabTac",
                    "id": "12279988000014527009",
                    "name": "PLMN-PLMN/ESIC-1/EREG-LAB/EMKT-LabMarket/ESTC-LabTac",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5692672",
                    "id": "12279988000014445171",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5692672",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696256",
                    "id": "12279988000014445176",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696256",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696512",
                    "id": "12279988000014433793",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696512",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696768",
                    "id": "12279988000014444126",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696768",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5697536",
                    "id": "12279988000014439047",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5697536",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307136",
                    "id": "12279988000014436130",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307136",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307392",
                    "id": "12279988000014436321",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307392",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307904",
                    "id": "12279988000014438191",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307904",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5308160",
                    "id": "12279988000014436136",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5308160",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5825660",
                    "id": "12279988000015266447",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5825660",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },
                  {
                    "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826304",
                    "id": "12279988000014436157",
                    "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826304",
                    "objectLevel": "MADTES-ESTC",
                    "type": "managed"
                  },

…

Now, from this JSON response , I want to filter out only those ESTC objects associated with a particular market object ( E.g : Connecticut , Long_Island ..etc ) … How to achieve that in Grafana ? Any pointers / suggestions ?

I need to do it at a Grafana query type variable level only …

Please let me know.

Thanks,
Nilanjan

2

please post a valid json data blob?

3

Hi ,

The response is as below -

  "response": {
    "results": {
      "A": {
        "status": 200,
        "frames": [
          {
            "schema": {
              "name": "A",
              "refId": "A",
              "meta": {
                "typeVersion": [
                  0,
                  0
                ],
                "custom": {
                  "data": {
                    "content": [
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-LAB/EMKT-LabMarket/ESTC-LabTac",
                        "id": "12279988000014527009",
                        "name": "PLMN-PLMN/ESIC-1/EREG-LAB/EMKT-LabMarket/ESTC-LabTac",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5692672",
                        "id": "12279988000014445171",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5692672",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696256",
                        "id": "12279988000014445176",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696256",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696512",
                        "id": "12279988000014433793",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696512",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696768",
                        "id": "12279988000014444126",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696768",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5697536",
                        "id": "12279988000014439047",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5697536",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307136",
                        "id": "12279988000014436130",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307136",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307392",
                        "id": "12279988000014436321",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307392",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307904",
                        "id": "12279988000014438191",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307904",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5308160",
                        "id": "12279988000014436136",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5308160",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5825660",
                        "id": "12279988000015266447",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5825660",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826304",
                        "id": "12279988000014436157",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826304",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826560",
                        "id": "12279988000014436164",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826560",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826816",
                        "id": "12279988000014440980",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826816",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5827072",
                        "id": "12279988000014434272",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5827072",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5829120",
                        "id": "12279988000014446393",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5829120",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435648",
                        "id": "12279988000014454255",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435648",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435904",
                        "id": "12279988000014448150",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435904",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436160",
                        "id": "12279988000014452680",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436160",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436416",
                        "id": "12279988000014437687",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436416",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436672",
                        "id": "12279988000014441001",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436672",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436928",
                        "id": "12279988000014439069",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436928",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5437184",
                        "id": "12279988000014440376",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5437184",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632256",
                        "id": "12279988000014437703",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632256",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632512",
                        "id": "12279988000014433842",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632512",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632768",
                        "id": "12279988000014433809",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632768",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633024",
                        "id": "12279988000014436332",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633024",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633280",
                        "id": "12279988000014437752",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633280",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633536",
                        "id": "12279988000014484473",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633536",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633792",
                        "id": "12279988000014477353",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633792",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788160",
                        "id": "12279988000014436183",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788160",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788416",
                        "id": "12279988000014439081",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788416",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788672",
                        "id": "12279988000014445075",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788672",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5828864",
                        "id": "12279988000014823212",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5828864",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891584",
                        "id": "12279988000014439446",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891584",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891840",
                        "id": "12279988000014439109",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891840",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892096",
                        "id": "12279988000014436198",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892096",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892352",
                        "id": "12279988000014442232",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892352",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892608",
                        "id": "12279988000014437760",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892608",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892864",
                        "id": "12279988000014441777",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892864",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893120",
                        "id": "12279988000014436212",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893120",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893376",
                        "id": "12279988000014436374",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893376",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893632",
                        "id": "12279988000014441742",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893632",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893888",
                        "id": "12279988000014441754",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893888",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5826816",
                        "id": "12279988000014749796",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5826816",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827328",
                        "id": "12279988000014437790",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827328",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827584",
                        "id": "12279988000014437610",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827584",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827840",
                        "id": "12279988000014439451",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827840",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828096",
                        "id": "12279988000014434296",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828096",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828352",
                        "id": "12279988000014439163",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828352",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828376",
                        "id": "12279988000017788013",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828376",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828608",
                        "id": "12279988000014463865",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828608",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828864",
                        "id": "12279988000014436396",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828864",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829120",
                        "id": "12279988000014436412",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829120",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829376",
                        "id": "12279988000014444227",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829376",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829632",
                        "id": "12279988000014436422",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829632",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898240",
                        "id": "12279988000014472635",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898240",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898496",
                        "id": "12279988000014458826",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898496",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898752",
                        "id": "12279988000014680175",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898752",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5899008",
                        "id": "12279988000014444245",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5899008",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8064256",
                        "id": "12279988000014438274",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8064256",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8065536",
                        "id": "12279988000014436432",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8065536",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112640",
                        "id": "12279988000014444777",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112640",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112896",
                        "id": "12279988000014437814",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112896",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },
                      {
                        "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8113664",
                        "id": "12279988000014444261",
                        "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8113664",
                        "objectLevel": "MADTES-ESTC",
                        "type": "managed"
                      },

…
…

Thanks,
Nilanjan

4

that is still not a valid json, please validate before posting?

image
image772Ă—301 10.3 KB

5

{
“results”: {
“A”: {
“status”: 200,
“frames”: [
{
“schema”: {
“name”: “A”,
“refId”: “A”,
“meta”: {
“typeVersion”: [
0,
0
],
“custom”: {
“data”: {
“content”: [
{
“dn”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Arkansas/NSTC-11763712”,
“id”: “12279988000000325260”,
“name”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Arkansas/NSTC-11763712”,
“objectLevel”: “MADTNS-NSTC-2”,
“type”: “managed”
},
{
“dn”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Arkansas/NSTC-11795968”,
“id”: “12279988000000052805”,
“name”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Arkansas/NSTC-11795968”,
“objectLevel”: “MADTNS-NSTC-2”,
“type”: “managed”
},
{
“dn”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Arkansas/NSTC-11796224”,
“id”: “12279988000000052826”,
“name”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Arkansas/NSTC-11796224”,
“objectLevel”: “MADTNS-NSTC-2”,
“type”: “managed”
},
{
“dn”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Chicago/NSTC-10617600”,
“id”: “12279988000000024594”,
“name”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Chicago/NSTC-10617600”,
“objectLevel”: “MADTNS-NSTC-2”,
“type”: “managed”
},
{
“dn”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Chicago/NSTC-10617856”,
“id”: “12279988000000064495”,
“name”: “PLMN-PLMN/NSPQ-1/NRGN-CENTRAL/NMKT-Chicago/NSTC-10617856”,
“objectLevel”: “MADTNS-NSTC-2”,
“type”: “managed”
},

…
…

6

Uploaded portion of the actual json response

7 
{
    "response": {
        "results": {
            "A": {
                "status": 200,
                "frames": [
                    {
                        "schema": {
                            "name": "A",
                            "refId": "A",
                            "meta": {
                                "typeVersion": [
                                    0,
                                    0
                                ],
                                "custom": {
                                    "data": {
                                        "content": [
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-LAB/EMKT-LabMarket/ESTC-LabTac",
                                                "id": "12279988000014527009",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-LAB/EMKT-LabMarket/ESTC-LabTac",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5692672",
                                                "id": "12279988000014445171",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5692672",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696256",
                                                "id": "12279988000014445176",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696256",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696512",
                                                "id": "12279988000014433793",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696512",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696768",
                                                "id": "12279988000014444126",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5696768",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5697536",
                                                "id": "12279988000014439047",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Central_PA/ESTC-5697536",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307136",
                                                "id": "12279988000014436130",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307136",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307392",
                                                "id": "12279988000014436321",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307392",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307904",
                                                "id": "12279988000014438191",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5307904",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5308160",
                                                "id": "12279988000014436136",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Connecticut/ESTC-5308160",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5825660",
                                                "id": "12279988000015266447",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5825660",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826304",
                                                "id": "12279988000014436157",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826304",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826560",
                                                "id": "12279988000014436164",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826560",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826816",
                                                "id": "12279988000014440980",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5826816",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5827072",
                                                "id": "12279988000014434272",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5827072",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5829120",
                                                "id": "12279988000014446393",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-Long_Island/ESTC-5829120",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435648",
                                                "id": "12279988000014454255",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435648",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435904",
                                                "id": "12279988000014448150",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5435904",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436160",
                                                "id": "12279988000014452680",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436160",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436416",
                                                "id": "12279988000014437687",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436416",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436672",
                                                "id": "12279988000014441001",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436672",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436928",
                                                "id": "12279988000014439069",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5436928",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5437184",
                                                "id": "12279988000014440376",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5437184",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632256",
                                                "id": "12279988000014437703",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632256",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632512",
                                                "id": "12279988000014433842",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632512",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632768",
                                                "id": "12279988000014433809",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5632768",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633024",
                                                "id": "12279988000014436332",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633024",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633280",
                                                "id": "12279988000014437752",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633280",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633536",
                                                "id": "12279988000014484473",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633536",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633792",
                                                "id": "12279988000014477353",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_England/ESTC-5633792",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788160",
                                                "id": "12279988000014436183",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788160",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788416",
                                                "id": "12279988000014439081",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788416",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788672",
                                                "id": "12279988000014445075",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5788672",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5828864",
                                                "id": "12279988000014823212",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5828864",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891584",
                                                "id": "12279988000014439446",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891584",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891840",
                                                "id": "12279988000014439109",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5891840",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892096",
                                                "id": "12279988000014436198",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892096",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892352",
                                                "id": "12279988000014442232",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892352",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892608",
                                                "id": "12279988000014437760",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892608",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892864",
                                                "id": "12279988000014441777",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5892864",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893120",
                                                "id": "12279988000014436212",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893120",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893376",
                                                "id": "12279988000014436374",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893376",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893632",
                                                "id": "12279988000014441742",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893632",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893888",
                                                "id": "12279988000014441754",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_Jersey/ESTC-5893888",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5826816",
                                                "id": "12279988000014749796",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5826816",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827328",
                                                "id": "12279988000014437790",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827328",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827584",
                                                "id": "12279988000014437610",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827584",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827840",
                                                "id": "12279988000014439451",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5827840",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828096",
                                                "id": "12279988000014434296",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828096",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828352",
                                                "id": "12279988000014439163",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828352",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828376",
                                                "id": "12279988000017788013",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828376",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828608",
                                                "id": "12279988000014463865",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828608",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828864",
                                                "id": "12279988000014436396",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5828864",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829120",
                                                "id": "12279988000014436412",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829120",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829376",
                                                "id": "12279988000014444227",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829376",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829632",
                                                "id": "12279988000014436422",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5829632",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898240",
                                                "id": "12279988000014472635",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898240",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898496",
                                                "id": "12279988000014458826",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898496",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898752",
                                                "id": "12279988000014680175",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5898752",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5899008",
                                                "id": "12279988000014444245",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-New_York/ESTC-5899008",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8064256",
                                                "id": "12279988000014438274",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8064256",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8065536",
                                                "id": "12279988000014436432",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8065536",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112640",
                                                "id": "12279988000014444777",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112640",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112896",
                                                "id": "12279988000014437814",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8112896",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            },
                                            {
                                                "dn": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8113664",
                                                "id": "12279988000014444261",
                                                "name": "PLMN-PLMN/ESIC-1/EREG-NORTHEAST/EMKT-North_Carolina/ESTC-8113664",
                                                "objectLevel": "MADTES-ESTC",
                                                "type": "managed"
                                            }
                                        ]
                                    }
                                }
                            }
                        }
                    }
                ]
            }
        }
    }
}
1 Like
8

checkout this jsonata

https://try.jsonata.org/VKefMx0yn

9

Hi ,

Thanks for the response.

Need one clarification.

My requirement is to make the call to the datasource once and cache the response in Grafana .

Is it possible to cache the JSON response in Grafana ..?

Please let me know.

Thanks,
Nilanjan

10

Probably best to open a new thread for that