YAQL

I would want to get a child element from JSON snippet

Asked by Nagendran

{
    "lagId": "1",
    "portThreshold": "0",
    "portThresholdAction": "down",
    "portThresholdStaticCost": "0",
    "dynamicCosting": "false",
    "primaryLagMemberId": "0",
    "primaryLagMemberName": "N/A",
    "isMcLagParticipant": "false",
    "reasonDown": [],
    "lagPortType": "standard",
    "adaptQoS": "distribute",
    "perLinkHashing": "false",
    "perFpIngQueuing": "false",
    "perFpEgrQueuing": "false",
    "includeEgrHashCfg": "false",
    "perFpSapInstance": "false",
    "lagName": "LAGR",
    "lagSize": "2",
    "lagSelectedPorts": "2",
    "lagAttachedPorts": "2",
    "lagType": "lacpOff",
    "lagUniProfilePointer": "",
    "portShgName": "N/A",
    "portShgPointer": "",
    "vplsMode": "none",
    "lagAggrType": "radioL1",
    "lagAggrHashing": "l1",
    "lagMbrSize": "2",
    "lagMinSize": "1",
    "channelSize": "2",
    "lagWTR": "1000",
    "lagConfiguredSpeed": "Line Rate",
    "lagOperationalSpeed": "0",
    "lagTPID": "1",
    "lagLosProp": "laserOn",
    "laglptConsequenceAction": "noAction",
    "lagBandwidth": "0",
    "lagIngressAvailBandwidth": "0",
    "lagEgressAvailBandwidth": "0",
    "spbServicePortMode": "none",
    "isLagSpbNetwIf": "false",
    "portAccessDescription": "N/A",
    "portVlanXlation": "down",
    "weightThreshold": "0",
    "weightThresholdAction": "down",
    "weightThresholdStaticCost": "0",
    "portWeightSpeed": "0",
    "perLinkHashWeighted": "false",
    "autoRebalance": "false",
    "enableDei": "false",
    "lagLoadBalancing": "default",
    "role": "unknown",
    "lagBfdDisableSoftReset": "false",
    "accessBandwidth": "0",
    "accessBookingFactor": "100",
    "accessAvailableBW": "0",
    "accessBookedBW": "0",
    "lagMemberType": "port",
    "customProperties": null,
    "enableTableClassification": "false",
    "monitorOperGroupName": "",
    "monitorOperGroupPtr": "",
    "snmpPortId": "50122",
    "portId": "0",
    "portCategory": "lag",
    "portClass": "radio",
    "specificType": "unknownPort",
    "specificCardType": [
        "mda_unknown",
        "unassigned"
    ],
    "description": "N/A",
    "mode": "network",
    "hasUserAssignedMac": "false",
    "isl2UplinkMode": "false",
    "macAddress": "00-00-00-00-00-00",
    "hwMacAddress": "00-00-00-00-00-00",
    "encapType": "nullEncap",
    "holdTimeUp": "0",
    "holdTimeDown": "0",
    "upProtocols": [],
    "isLinkUp": "false",
    "state": "none",
    "previousState": "none",
    "isTerminatable": "true",
    "isConnectionTerminated": "true",
    "hasConnections": "false",
    "mtuValue": "1500",
    "operationalMTU": "1500",
    "neSpecificMtu": "0",
    "speed": "lineRate",
    "actualSpeed": "0",
    "accountingPolicyCapable": "false",
    "accountingPolicyId": "0",
    "accountingPolicyName": "N/A",
    "accountingPolicyObjectPointer": "",
    "collectStats": "false",
    "etherAccountingPolicyObjectPointer": "",
    "etherCollectStats": "false",
    "networkQueuePolicyName": "default",
    "networkQueueObjectPointer": "",
    "networkQueuePolicyCapable": "true",
    "portName": "LAG 1",
    "numberOfPossibleChannels": "0",
    "isPortChannelALeaf": "unspecified",
    "parentSnmpPortId": "0",
    "currentNumberOfChannels": "0",
    "intervalNumber": "1",
    "mirrorStatus": [],
    "loadBalanceAlgorithm": "notApplicable",
    "portSchedulerPolicyObjectPointer": "",
    "portEgrHsmdaSchedulerPolicy": "",
    "uniProfilePointer": "",
    "portIngrNamedPoolPlcy": "",
    "portEgrNamedPoolPlcy": "",
    "portIngrPoolPercentageRate": "100",
    "portEgrPoolPercentageRate": "100",
    "vlanAutoBind": "true",
    "portUsage": "empty",
    "ubtSpeed": "oneGbps",
    "ubtListBits": [],
    "l2ProfilePointer": "",
    "memberOfIGH": "",
    "holdTimeUnits": "seconds",
    "linkTrap": "disable",
    "userLabel": "N/A",
    "mptSubrackPointer": "",
    "mptCombiner": "disable",
    "mptCombinerImplemented": "false",
    "iomType": [
        "mda_unknown",
        "unassigned"
    ],
    "portStateFPNumber": "0",
    "portStateMacChipNumber": "0",
    "portStateLicensed": "false",
    "portRsFecOperMode": "none",
    "shelfId": "1",
    "hwIndex": "0",
    "displayedName": "LAG 1",
    "siteId": "135.250.64.156",
    "siteName": "BLR_64_156",
    "manufacturer": "N/A",
    "serialNumber": "N/A",
    "manufacturerBoardNumber": "N/A",
    "manufactureDate": "N/A",
    "equipmentCategory": "port",
    "hwName": "N/A",
    "cleiCode": "N/A",
    "equipmentState": "equipmentOperationallyDown",
    "containingEquipmentState": "noProblem",
    "compositeEquipmentState": "equipmentOperationallyDown",
    "operationalState": "portOutOfService",
    "administrativeState": "portInService",
    "isEquipped": "true",
    "baseMacAddress": "00-00-00-00-00-00",
    "hardwareFailureReason": "N/A",
    "isEquipmentInserted": "true",
    "manufacturingAssemblyNo": "N/A",
    "manufacturingDeviations": "N/A",
    "isTempSensorAvailable": "false",
    "hardwareClass": "notApplicable",
    "backgroundDiagnosticsState": "unknown",
    "backgroundDiagnosticsFaultReason": "N/A",
    "manufacturingVariant": "N/A",
    "hwFirmwareRevisionStatus": "notApplicable",
    "oesShelfId": "0",
    "phyShelfClass": "unknown",
    "phyShelfType": "unknownShelf",
    "olcState": "inService",
    "lockOlcState": "false",
    "deploymentState": 0,
    "objectFullName": "network:135.250.64.156:lag:interface-1",
    "name": "interface-1",
    "className": "lag.Interface",
    "selfAlarmed": "true",
    "lag.Interface": {},
    "lag.PortTermination": [
        {
            "memberName": "6/5",
            "shelfId": "1",
            "lagId": "1",
            "priority": "128",
            "subGroupId": "1",
            "selectedLagId": "0",
            "attachedLagId": "0",
            "activeStdby": "Active",
            "forced": "dash",
            "lagCommand": "noCmd",
            "lagCommandActiveStdby": "active",
            "portActorNumber": "0",
            "portActorSystemPriority": "0",
            "portActorSystemId": "00-00-00-00-00-00",
            "portActorAdminKey": "0",
            "portActorOperKey": "0",
            "portPartnerNumber": "0",
            "portPartnerAdminSystemPriority": "0",
            "portPartnerOperSystemPriority": "0",
            "portPartnerAdminSystemId": "00-00-00-00-00-00",
            "portPartnerOperSystemId": "00-00-00-00-00-00",
            "portPartnerAdminKey": "0",
            "portPartnerOperKey": "0",
            "portPartnerAdminPort": "0",
            "portPartnerOperPort": "0",
            "portPartnerAdminPortPriority": "0",
            "portPartnerOperPortPriority": "0",
            "actorAdminState": [
                "lcapTimeout",
                "lacpActivity",
                "defaulted",
                "aggregation"
            ],
            "actorOperState": [],
            "partnerAdminState": [
                "distributing",
                "defaulted",
                "aggregation",
                "collecting"
            ],
            "partnerOperState": [
                "distributing",
                "defaulted",
                "synchronization",
                "aggregation",
                "collecting"
            ],
            "lagPortState": "selected",
            "lacpEnabled": "disabled",
            "isPrimaryLagMember": "false",
            "portIfIndex": "0",
            "portRxLacpPackets": "0",
            "portTxLacpPackets": "0",
            "portIllegalPackets": "0",
            "portUnknownPackets": "0",
            "customProperties": null,
            "hashWeight": "0",
            "olcState": "inService",
            "lockOlcState": "false",
            "portPointer": "network:135.250.64.156:shelf-1:cardSlot-6:card:port-5",
            "innerEncapValue": "0",
            "outerEncapValue": "0",
            "portIdentifyingName": "6/5",
            "underlyingResourceState": "missing",
            "compositeState": "underlyingResourceMissing",
            "resourceState": "OK",
            "operationalState": "unknown",
            "administrativeState": "lagMemberUnknown",
            "ctpPointer": "network:135.250.64.156:shelf-1:cardSlot-6:card:port-5:TP",
            "terminatedObjectPointer": "network:135.250.64.156:shelf-1:cardSlot-6:card:port-5",
            "terminatedObjectId": "70605",
            "terminatedObjectName": "Port 6/5",
            "routerId": "0",
            "routerName": "",
            "portId": "51165",
            "portName": "6/5",
            "encapType": "qEncap",
            "terminatedPortPointer": "network:135.250.64.156:shelf-1:cardSlot-6:card:port-5",
            "terminatedPortClassName": "equipment.PhysicalPort",
            "terminatedPortCombinedEncapValue": "0",
            "terminatedPortInnerEncapValue": "0",
            "terminatedPortOuterEncapValue": "0",
            "isExclusiveTermination": "true",
            "provisionedMtu": "1500",
            "actualMtu": "1500",
            "mtuMismatch": "false",
            "terminationParticipationType": "client",
            "domain": "unknown",
            "application": "unknown",
            "nodeName": "BLR_64_156",
            "nodeId": "135.250.64.156",
            "displayedName": "N/A",
            "description": "N/A",
            "deploymentState": "0",
            "objectFullName": "network:135.250.64.156:lag:interface-1:port-6/5",
            "name": "port-6/5",
            "selfAlarmed": "false",
            "lag.PortTermination-fdn": "network:135.250.64.156:lag:interface-1:port-6/5",
            "lag.PortTermination-pfdn": "network:135.250.64.156:lag:interface-1",
            "lag.PortTermination-isFolder": true,
            "lag.PortTermination-id": "network:135.250.64.156:lag:interface-1:port-6/5",
            "lag.PortTermination-className": "lag.PortTermination",
            "lag.PortTermination-parentId": "network:135.250.64.156:lag:interface-1",
            "lag.PortTermination-pObjClassName": "lag.Interface"
        },
        {
            "memberName": "5/5",
            "shelfId": "1",
            "lagId": "1",
            "priority": "128",
            "subGroupId": "1",
            "selectedLagId": "0",
            "attachedLagId": "0",
            "activeStdby": "Active",
            "forced": "dash",
            "lagCommand": "noCmd",
            "lagCommandActiveStdby": "active",
            "portActorNumber": "0",
            "portActorSystemPriority": "0",
            "portActorSystemId": "00-00-00-00-00-00",
            "portActorAdminKey": "0",
            "portActorOperKey": "0",
            "portPartnerNumber": "0",
            "portPartnerAdminSystemPriority": "0",
            "portPartnerOperSystemPriority": "0",
            "portPartnerAdminSystemId": "00-00-00-00-00-00",
            "portPartnerOperSystemId": "00-00-00-00-00-00",
            "portPartnerAdminKey": "0",
            "portPartnerOperKey": "0",
            "portPartnerAdminPort": "0",
            "portPartnerOperPort": "0",
            "portPartnerAdminPortPriority": "0",
            "portPartnerOperPortPriority": "0",
            "actorAdminState": [
                "lcapTimeout",
                "lacpActivity",
                "defaulted",
                "aggregation"
            ],
            "actorOperState": [],
            "partnerAdminState": [
                "distributing",
                "defaulted",
                "aggregation",
                "collecting"
            ],
            "partnerOperState": [
                "distributing",
                "defaulted",
                "synchronization",
                "aggregation",
                "collecting"
            ],
            "lagPortState": "selected",
            "lacpEnabled": "disabled",
            "isPrimaryLagMember": "false",
            "portIfIndex": "0",
            "portRxLacpPackets": "0",
            "portTxLacpPackets": "0",
            "portIllegalPackets": "0",
            "portUnknownPackets": "0",
            "customProperties": null,
            "hashWeight": "0",
            "olcState": "inService",
            "lockOlcState": "false",
            "portPointer": "network:135.250.64.156:shelf-1:cardSlot-5:card:port-5",
            "innerEncapValue": "0",
            "outerEncapValue": "0",
            "portIdentifyingName": "5/5",
            "underlyingResourceState": "missing",
            "compositeState": "underlyingResourceMissing",
            "resourceState": "OK",
            "operationalState": "unknown",
            "administrativeState": "lagMemberUnknown",
            "ctpPointer": "network:135.250.64.156:shelf-1:cardSlot-5:card:port-5:TP",
            "terminatedObjectPointer": "network:135.250.64.156:shelf-1:cardSlot-5:card:port-5",
            "terminatedObjectId": "70505",
            "terminatedObjectName": "Port 5/5",
            "routerId": "0",
            "routerName": "",
            "portId": "51155",
            "portName": "5/5",
            "encapType": "qEncap",
            "terminatedPortPointer": "network:135.250.64.156:shelf-1:cardSlot-5:card:port-5",
            "terminatedPortClassName": "equipment.PhysicalPort",
            "terminatedPortCombinedEncapValue": "0",
            "terminatedPortInnerEncapValue": "0",
            "terminatedPortOuterEncapValue": "0",
            "isExclusiveTermination": "true",
            "provisionedMtu": "1500",
            "actualMtu": "1500",
            "mtuMismatch": "false",
            "terminationParticipationType": "client",
            "domain": "unknown",
            "application": "unknown",
            "nodeName": "BLR_64_156",
            "nodeId": "135.250.64.156",
            "displayedName": "N/A",
            "description": "N/A",
            "deploymentState": "0",
            "objectFullName": "network:135.250.64.156:lag:interface-1:port-5/5",
            "name": "port-5/5",
            "selfAlarmed": "false",
            "lag.PortTermination-fdn": "network:135.250.64.156:lag:interface-1:port-5/5",
            "lag.PortTermination-pfdn": "network:135.250.64.156:lag:interface-1",
            "lag.PortTermination-isFolder": true,
            "lag.PortTermination-id": "network:135.250.64.156:lag:interface-1:port-5/5",
            "lag.PortTermination-className": "lag.PortTermination",
            "lag.PortTermination-parentId": "network:135.250.64.156:lag:interface-1",
            "lag.PortTermination-pObjClassName": "lag.Interface"
        }
    ]
}

If I try to get the child "lag.PortTermination" in YAQL by quering $.lag.PortTermination in YAQL valuator it throwing operation not found.

Please help

Question information

Language:
English Edit question
Status:
Expired
For:
YAQL Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said : 		#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.