How to loop through key value pair receiving from Payload

Hello Basit,

You can use a JSON library such as Newtonsoft.Json to deserialize the JSON payload into a C# object, and then use LINQ to loop through the key-value pairs inside the "ContractInvoicePerDays" array.

Here's an example:

using Newtonsoft.Json.Linq; // Add this namespace

// Deserialize the JSON payload into a JObject
var payload = JArray.Parse(cipdRejectedView.ContractInvoicePerDays)[0];

// Loop through the key-value pairs inside the "ContractInvoicePerDays" array using LINQ
var contractInvoicePerDays = payload["ContractInvoicePerDays"]
    .SelectMany(kvp => kvp.Properties())
    .Select(kvp => new ContractInvoicePerDay
    {
        ContractInvoicePerDayID = int.Parse(kvp.Name),
        InvoiceDate = DateTime.Parse(kvp.Value.ToString())
    });

foreach (var contractInvoicePerDay in contractInvoicePerDays)
{
    // Do something with the ContractInvoicePerDay object
    // ...
}

Thanks

Naimish Makwana

Hello, 
You can iterate over a JSON object using dynamic object

public int IterateOverJsonDynamically()
{
    var jsonData = JsonConvert.DeserializeObject(ContractInvoicePerDays);

    foreach (var data in jsonData)
    {
        var id = data.id;
        var date = data.date;

        Console.WriteLine($"Id: {id}, date: {date});
    }

    var count = jsonData.Count;
    return count;
}