Navaz Baig
Navaz Baig

Reputation: 73

Looping through JObject c#

I am using JSON.NET to parse my JSON:

JObject jsonObject = JObject.Parse(myJson);

My JSON looks something like this:

{
  "_links": {
    "self": {
      "href": "https://api-uat.dwolla.com/accounts/069b759d-6267-42d6-b30b-5d03ddd25673/funding-sources",
      "type": "application/vnd.dwolla.v1.hal+json",
      "resource-type": "funding-source"
    }
  },
  "_embedded": {
    "funding-sources": [
      {
        "_links": {
          "self": {
            "href": "https://api-uat.dwolla.com/funding-sources/0b2f6a31-b909-4c7d-a9f8-6253e5f791d0",
            "type": "application/vnd.dwolla.v1.hal+json",
            "resource-type": "funding-source"
          },
          "account": {
            "href": "https://api-uat.dwolla.com/accounts/069b759d-6267-42d6-b30b-5d03ddd25673",
            "type": "application/vnd.dwolla.v1.hal+json",
            "resource-type": "account"
          },
          "balance": {
            "href": "https://api-uat.dwolla.com/funding-sources/0b2f6a31-b909-4c7d-a9f8-6253e5f791d0/balance",
            "type": "application/vnd.dwolla.v1.hal+json",
            "resource-type": "balance"
          }
        },
        "id": "0b2f6a31-b909-4c7d-a9f8-6253e5f791d0",
        "status": "verified",
        "type": "bank",
        "name": "Bank Of America",
        "created": "2017-03-22T12:54:51.000Z",
        "removed": false,
        "channels": [
          "ach"
        ],
        "bankName": "SANDBOX TEST BANK"
      },
      {
        "_links": {
          "self": {
            "href": "https://api-uat.dwolla.com/funding-sources/2235c3f5-03d6-4b7c-8ffb-c389c94375eb",
            "type": "application/vnd.dwolla.v1.hal+json",
            "resource-type": "funding-source"
          },
          "account": {
            "href": "https://api-uat.dwolla.com/accounts/069b759d-6267-42d6-b30b-5d03ddd25673",
            "type": "application/vnd.dwolla.v1.hal+json",
            "resource-type": "account"
          }
        },
        "id": "2235c3f5-03d6-4b7c-8ffb-c389c94375eb",
        "status": "verified",
        "type": "bank",
        "name": "Superhero Savings Bank",
        "created": "2017-03-17T06:39:28.000Z",
        "removed": true,
        "channels": [
          "ach"
        ],
        "bankName": "SANDBOX TEST BANK"
      }      
    ]
  }
}

Here I could have N number of funding sources. I want to get the href of self where removed is false for each funding sources. So in the above example I need:

href:"https://api-uat.dwolla.com/funding-sources/0b2f6a31-b909-4c7d-a9f8-6253e5f791d0".

I tried to achieve this by looping through the JObject:

foreach (var x in jsonObject)
{
    if(x.Key == "_embedded")
    {
        foreach (var fundingSources in x.Value["funding-sources"])
        {
            foreach (var y in fundingSources)
            {

            }
        }
    }
}

Unfortunately I could not get the funding sources into an array.

Upvotes: 0

Views: 17419

Answers (2)

Reda Ramadan
Reda Ramadan

Reputation: 31

Try this code block:

JObject jsonObject = JObject.Parse ( myJson );

foreach ( var x in jsonObject )
{
    if ( x.Key == "_embedded" )
    {
        foreach ( var source in x.Value [ "funding-sources" ] )
        {
            var removedAttribute = source [ "removed" ];
            if ( removedAttribute != null && bool.Parse ( removedAttribute.ToString () ) == false )
            {
                var links = source [ "_links" ];
                var self = links [ "self" ];
                var href = self [ "href" ];
            }
        }
    }
}

Upvotes: 3

Brian Rogers
Brian Rogers

Reputation: 129837

Try like this:

JObject jsonObject = JObject.Parse(myJson);
foreach (JToken fundingSource in jsonObject.SelectToken("_embedded.funding-sources"))
{
    bool removed = (bool)fundingSource["removed"];
    if (!removed)
    {
        string href = (string)fundingSource.SelectToken("_links.self.href");
        Console.WriteLine(href);
    }
}

Fiddle: https://dotnetfiddle.net/Jhw8w6

Alternatively you can use LINQ like this:

JObject jsonObject = JObject.Parse(myJson);
List<string> links = jsonObject.SelectToken("_embedded.funding-sources")
    .Where(fundingSource => !(bool)fundingSource["removed"])
    .Select(fundingSource => (string)fundingSource.SelectToken("_links.self.href"))
    .ToList();

Console.WriteLine(string.Join(Environment.NewLine, links));

Fiddle: https://dotnetfiddle.net/gnyGgk

Upvotes: 6

Related Questions