Fetch sub elements in a b API response and return them RSS

• • Reply
  acmedeepak

  Member

  168 Points

  497 Posts

  Fetch sub elements in a b API response and return them

  Dec 06, 2019 05:58 PM|acmedeepak|LINK

  Hi,

  I have a requirement to fetch the details of selected element which is a child node of other element in a tree type json result. I will send the method which picks the tree root element and returns its data:

  // to return main node elements
          public ActionResult GetObjectCarriers(string GUID)
          {
              token = GetToken();
              AuthenticatedUser = Security.GetUserFromToken(token);
              string GetRegisteredCarriers = Common.Http.Get(AuthenticatedUser.AdministrationServicesHost, "RegisteredCarriers?token=" + token);
              RegistrationResponse RegisteredCarrierResponse = JsonConvert.DeserializeObject<RegistrationResponse>(GetRegisteredCarriers);
  
              RegisteredCarrierResponse.RegisteredCarriers.RemoveAll(x => !x.GuID.Contains(GUID));
              return ViewComponent(typeof(CarrierViewComponent), new { identityListResponse = RegisteredCarrierResponse.RegisteredCarriers });
          }

  Now, for the method in controller to return the child node selected element, I have tried:

  public ActionResult GetCarriersChild(string Service)
          {
              token = GetToken();
              AuthenticatedUser = Security.GetUserFromToken(token);
              string GetRegisteredCarriers = Common.Http.Get(AuthenticatedUser.AdministrationServicesHost, "RegisteredCarriers?token=" + token);
              RegistrationResponse RegisteredCarrierResponse = JsonConvert.DeserializeObject<RegistrationResponse>(GetRegisteredCarriers);
  
              List<RegisteredCarrier> LRegisteredCarrier = new List<RegisteredCarrier>();
              LRegisteredCarrier = RegisteredCarrierResponse.RegisteredCarriers;
  
              RegisteredCarrierService lservice = new RegisteredCarrierService();
              List<RegisteredCarrierService> listService = new List<RegisteredCarrierService>();
  
              //RegisteredCarrierResponse.RegisteredCarriers.RemoveAll(x => !x.Services.Contains(Service));
              //var selectedCarrier = RegisteredCarrierService..Where(x => x.Id == Id).FirstOrDefault();
  
  
              //List < Tuple<List<RegistrationResponse>, List<RegisteredCarrier>, RegisteredCarrier, List<RegisteredCarrierService>> >
              //   registeredCarriersAndDocuments.EnabledCarrrierServices.add(new Tuple<RegisteredCarrierResponse, lrcc>)
  
              //foreach (var item in lrcc)
              //{
  
              //for (int j = 0; j < LRegisteredCarrier[j].Services.Count; j++)
              //{
              //    lservice.DisplayName = LRegisteredCarrier[i].Services[j].DisplayName;
              //    lservice.SystemName = LRegisteredCarrier[i].Services[j].SystemName;
              //    lservice.Symbol = LRegisteredCarrier[i].Services[j].Symbol;
              //    listService.Add(lservice);
              //}
              //}
              //i++;
              return ViewComponent(typeof(CarrierServicesViewComponent), new { identityListResponse = listService });
          }

  commented are my other trials which failed as well. I am sending my json result as well for clarity. Please help me how to get the proper result on this:

  {
    "registeredCarriers": [
      {
        "guID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
        "symbol": "DD_Asia",
        "displayName": "DDL(Asia)",
        "systemName": "DDL(Asia)",
        "services": [
          {
            "carrierGuID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
            "symbol": "EXP",
            "displayName": "DDL",
            "systemName": "DDL"
          },
          {
            "carrierGuID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
            "symbol": "EXP_0900",
            "displayName": "DDL",
            "systemName": "DDL"
          },
          {
            "carrierGuID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
            "symbol": "EXP_1200",
            "displayName": "DDL",
            "systemName": "DDL"
          }
        ],
        "documents": [
          {
            "carrierGuID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
            "symbol": "DDL",
            "displayName": "DDL",
            "systemName": "DDL",
            "contentSource": 4,
            "options": [
              {
                "carrierGuID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
                "documentSymbol": "DHL_ASIA_PACKAGE_LABEL",
                "stock": 1,
                "output": 1
              },
              {
                "carrierGuID": "47885300-e62c-4608-985f-7a4b9d4c0a58",
                "documentSymbol": "DDL_ASIA",
                "stock": 1,
                "output": 2
              }
            ]
          }
        ],
        "isModified": false
      },
      {
        "guID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
        "symbol": "S_EXPRESS",
        "displayName": "Sample Express",
        "systemName": "Sample Express",
        "services": [
          {
            "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
            "symbol": "EXP",
            "displayName": "sample Express",
            "systemName": "sample Express"
          },
          {
            "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
            "symbol": "PRM",
            "displayName": "Sample Premium",
            "systemName": "Sample Premium"
          },
          {
            "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
            "symbol": "PRM_FIX",
            "displayName": "Sample Premium Fixed Price",
            "systemName": "Sample Premium Fixed Price"
          }
        ],
        "documents": [
          {
            "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
            "symbol": "STAR",
            "displayName": "Sta Express Package Label",
            "systemName": "Sta Express Package Label",
            "contentSource": 4,
            "options": [
              {
                "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
                "documentSymbol": "STA",
                "stock": 1,
                "output": 1
              },
              {
                "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
                "documentSymbol": "STA",
                "stock": 1,
                "output": 2
              }
            ]
          },
          {
            "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
            "symbol": "Sample_TRACK_MANIFEST",
            "displayName": "Sample Express Manifest",
            "systemName": "Sample Express Manifest",
            "contentSource": 6,
            "options": [
              {
                "carrierGuID": "c20505a8-24a2-4030-be08-4d89b8fc26e7",
                "documentSymbol": "SAMPLE",
                "stock": 3,
                "output": 3
              }
            ]
          }
        ],
        "isModified": false
      },
      {
        "guID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
        "symbol": "AMPLE",
        "displayName": "AMPLE",
        "systemName": "AMPLE",
        "services": [
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "EXP_0900",
            "displayName": "AMPLE 0",
            "systemName": "AMPLE 0"
          },
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "EXP_1000",
            "displayName": "AMPLE 10:00",
            "systemName": "AMPLE 10:00"
          },
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "EXP_1200",
            "displayName": "AMPLE 12:00",
            "systemName": "AMPLE 12:00"
          },
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "OVN",
            "displayName": "AMPLE Overnight Express",
            "systemName": "AMPLE Overnight Express"
          },
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "ROAD",
            "displayName": "AMPLE Road Express",
            "systemName": "AMPLE Road Express"
          },
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "SENSITIVE",
            "displayName": "AMPLE Sensitive Express",
            "systemName": "AMPLE Sensitive Express"
          }
        ],
        "documents": [
          {
            "carrierGuID": "e45a0710-7c21-4be5-aa78-bab2494d0688",
            "symbol": "AMPLE_PACKAGE_LABEL",
            "displayName": "AMPLE Package Label",
            "systemName": "AMPLE Package Label",
            "contentSource": 4,
            "options": []
          }
        ],
        "isModified": false
      }
    ],
    "registeredDocuments": null,
    "success": true,
    "errorCode": 0,
    "displayMessage": null,
    "systemMessage": null,
    "exceptionDetail": null
  }

  I need to display results for Symbol: EXP and then return its content.
  
  
   

• • Reply
  bruce (sqlwo...

  All-Star

  58454 Points

  15765 Posts

  Re: Fetch sub elements in a b API response and return them

  Dec 06, 2019 08:24 PM|bruce (sqlwork.com)|LINK

  your explanation is not clear. show the json you wish to produce.

  bruce (sqlwork.com)