nestedJson | C# Online Compiler

nestedJson by nanuuq

open System
open FSharp.Data
open FSharp.Data.JsonExtensions
open Newtonsoft.Json.Linq
open Deedle



apiResponse = {"data":
                    {"Shipments":
                               {"ErrorMessage":null,
                                 "Success":true,
                                 "ValidationResult":null,
                                 "TotalCount":494,
                                 "Data":[
                                         {
                                         "CompletedDate":"2021-04-12T10:13:13.436Z",
                                          "ItemId":"dd4520bb-aa0a-...",
                                          "Organization":{
                                                      "OrganizationId":"cac43a32-1f08-...",
                                                      "OrganizationName":"XXX"
                                                      },
                                          "ShipmentContent" : [
                                                           {
                                                             "MaterialId": "cac43a32-1f08-..",
                                                             "unit": "kg",
                                                             "quantity": 2.0, 
                                                             "labels" : ["A1", "A2", "A3"]
                                                            }, 
                                                            {
                                                             "MaterialId": "cac43333-1f08-",
                                                             "unit": "t",
                                                             "quantity": 0.4, 
                                                             "labels" : ["B1", "B2", "B3"]
                                                             }
                                                             ] 
                                      },
                                      {
                                         "CompletedDate":"2021-04-12T10:13:14.436Z",
                                          "ItemId":"dd4520bb-aa0a-www",
                                          "Organization":{
                                                      "OrganizationId":"cac43a32-1f08-www",
                                                      "OrganizationName":"XXX"
                                                      },
                                          "ShipmentContent" : [
                                                           {
                                                             "MaterialId": "cad43a32-1f08-yy",
                                                             "unit": "kg",
                                                             "quantity": 2.0, 
                                                             "labels" : ["A3", "A4", "A5"]
                                                            }, 
                                                            {
                                                             "MaterialId": "ced43333-1f08-yyy",
                                                             "unit": "t",
                                                             "quantity": 0.4, 
                                                             "labels" : ["B1", "B8", "B0"]
                                                             }
                                                             ] 
                                     }
                                     ]
                                     }}}
                                   
                                     
                                     
type ApiTypes = 
  {
    ItemId : Guid
    CompletedDate : Nullable<DateTime> 
    Organization: 
      {|
        OrganizationId : Guid
        OrganizationName : string
       |}
    ShipmentContent : // ? How to define the List
      {|
        MaterialId : Guid 
        Quantity : Nullable<decimal> 
        Unit : string
        Labels: List // ?LIST

      |}
  }
  
  
  
let jsonObject = JObject.Parse(apiResponse)

let frame =
  jsonObject.["data"].["Shipments"].["Data"].Children()
      |> Seq.map (fun jtok -> jtok.ToObject<ApiTypes>())
      |> Frame.ofRecords

​x
 
open System
open FSharp.Data
open FSharp.Data.JsonExtensions
open Newtonsoft.Json.Linq
open Deedle
​
​
​
apiResponse = {"data":
                    {"Shipments":
                               {"ErrorMessage":null,
                                 "Success":true,
                                 "ValidationResult":null,
                                 "TotalCount":494,
                                 "Data":[
                                         {
                                         "CompletedDate":"2021-04-12T10:13:13.436Z",
                                          "ItemId":"dd4520bb-aa0a-...",
                                          "Organization":{
                                                      "OrganizationId":"cac43a32-1f08-...",
                                                      "OrganizationName":"XXX"
                                                      },
                                          "ShipmentContent" : [
                                                           {
                                                             "MaterialId": "cac43a32-1f08-..",
                                                             "unit": "kg",
                                                             "quantity": 2.0, 
                                                             "labels" : ["A1", "A2", "A3"]
                                                            }, 
                                                            {
                                                             "MaterialId": "cac43333-1f08-",
                                                             "unit": "t",
                                                             "quantity": 0.4, 
                                                             "labels" : ["B1", "B2", "B3"]
                                                             }
                                                             ] 
                                      },
                                      {
                                         "CompletedDate":"2021-04-12T10:13:14.436Z",
                                          "ItemId":"dd4520bb-aa0a-www",
                                          "Organization":{
                                                      "OrganizationId":"cac43a32-1f08-www",
                                                      "OrganizationName":"XXX"
                                                      },
                                          "ShipmentContent" : [
                                                           {
                                                             "MaterialId": "cad43a32-1f08-yy",
                                                             "unit": "kg",
                                                             "quantity": 2.0, 
                                                             "labels" : ["A3", "A4", "A5"]
                                                            }, 
                                                            {
                                                             "MaterialId": "ced43333-1f08-yyy",
                                                             "unit": "t",
                                                             "quantity": 0.4, 
                                                             "labels" : ["B1", "B8", "B0"]
                                                             }
                                                             ] 
                                     }
                                     ]
                                     }}}
                                   
                                     
                                     
type ApiTypes = 
  {
    ItemId : Guid
    CompletedDate : Nullable<DateTime> 
    Organization: 
      {|
        OrganizationId : Guid
        OrganizationName : string
       |}
    ShipmentContent : // ? How to define the List
      {|
        MaterialId : Guid 
        Quantity : Nullable<decimal> 
        Unit : string
        Labels: List // ?LIST
​
      |}
  }
  
  
  
let jsonObject = JObject.Parse(apiResponse)
​
let frame =
  jsonObject.["data"].["Shipments"].["Data"].Children()
      |> Seq.map (fun jtok -> jtok.ToObject<ApiTypes>())
      |> Frame.ofRecords

Environment version: .NET 9.0.0 (9.0.0)

<scheme-master>
  <general-information>
    <schemecode>XXXXX</schemecode>
    <year>2020</year>
    <month>04</month>
    <requestid>0008052020</requestid>
  </general-information>
  <scheme-details>
    <location>
      <district_code>503</district_code>
      <district_name>Chittoor</district_name>
      <state_code>28</state_code>
      <state_name>Andhra pradesh</state_name>
    </location>
    <beneficiary-details>
      <no_of_beneficiaries_normative_central_and_state_share>10000</no_of_beneficiaries_normative_central_and_state_share>
      <no_of_additional_beneficiaries_supported_by_state>0</no_of_additional_beneficiaries_supported_by_state>
      <total_no_of_beneficiaries>10000</total_no_of_beneficiaries>
      <no_of_beneficiaries_record_digitized>10000</no_of_beneficiaries_record_digitized>
      <no_of_authenticated_seeded_beneficiaries>10000</no_of_authenticated_seeded_beneficiaries>
      <no_of_beneficiaries_whom_mobile_no_captured>10000</no_of_beneficiaries_whom_mobile_no_captured>
    </beneficiary-details>
    <fundtransfer-details>
      <central_share_fund_transferred_cash>10000</central_share_fund_transferred_cash>
      <normative_state_share_fund_transferred_cash>0</normative_state_share_fund_transferred_cash>
      <additional_state_share_fund_transferred_cash>0</additional_state_share_fund_transferred_cash>
      <state_share_fund_transferred_to_additional_beneficiaries_cash>0</state_share_fund_transferred_to_additional_beneficiaries_cash>
      <total_fund_transferred_cash>10000</total_fund_transferred_cash>
      <central_share_expenditure_incurred_inkind>0</central_share_expenditure_incurred_inkind>
      <normative_state_share_expenditure_incurred_inkind>0</normative_state_share_expenditure_incurred_inkind>
      <additional_state_share_expenditure_incurred_inkind>0</additional_state_share_expenditure_incurred_inkind>
      <state_share_expenditure_incurred_to_additional_beneficiaries_inkind>0</state_share_expenditure_incurred_to_additional_beneficiaries_inkind>
      <total_expenditure_incurred_inkind>0</total_expenditure_incurred_inkind>
    </fundtransfer-details>
    <transaction-details>
      <total_no_transactions_electronic_modes_cash>10000</total_no_transactions_electronic_modes_cash>
      <payment_electronic_modes_cash>10000</payment_electronic_modes_cash>
      <total_no_transactions_other_modes_cash>0</total_no_transactions_other_modes_cash>
      <payment_other_modes_cash>0</payment_other_modes_cash>
      <quantity_transferred_inkind>0</quantity_transferred_inkind>
      <no_of_authenticated_transactions_inkind>0</no_of_authenticated_transactions_inkind>
      <dbt_expenditure_incurred_inkind>0</dbt_expenditure_incurred_inkind>
    </transaction-details>
  </scheme-details>
  <scheme-details>
    <location>
      <district_code>504</district_code>
      <district_name>Cuddapah (YSR Kadapa)</district_name>
      <state_code>28</state_code>
      <state_name>Andhra pradesh</state_name>
    </location>
    <beneficiary-details>
      <no_of_beneficiaries_normative_central_and_state_share>10000</no_of_beneficiaries_normative_central_and_state_share>
      <no_of_additional_beneficiaries_supported_by_state>0</no_of_additional_beneficiaries_supported_by_state>
      <total_no_of_beneficiaries>10000</total_no_of_beneficiaries>
      <no_of_beneficiaries_record_digitized>10000</no_of_beneficiaries_record_digitized>
      <no_of_authenticated_seeded_beneficiaries>10000</no_of_authenticated_seeded_beneficiaries>
      <no_of_beneficiaries_whom_mobile_no_captured>10000</no_of_beneficiaries_whom_mobile_no_captured>
    </beneficiary-details>
    <fundtransfer-details>
      <central_share_fund_transferred_cash>10000</central_share_fund_transferred_cash>
      <normative_state_share_fund_transferred_cash>0</normative_state_share_fund_transferred_cash>
      <additional_state_share_fund_transferred_cash>0</additional_state_share_fund_transferred_cash>
      <state_share_fund_transferred_to_additional_beneficiaries_cash>0</state_share_fund_transferred_to_additional_beneficiaries_cash>
      <total_fund_transferred_cash>10000</total_fund_transferred_cash>
      <central_share_expenditure_incurred_inkind>0</central_share_expenditure_incurred_inkind>
      <normative_state_share_expenditure_incurred_inkind>0</normative_state_share_expenditure_incurred_inkind>
      <additional_state_share_expenditure_incurred_inkind>0</additional_state_share_expenditure_incurred_inkind>
      <state_share_expenditure_incurred_to_additional_beneficiaries_inkind>0</state_share_expenditure_incurred_to_additional_beneficiaries_inkind>
      <total_expenditure_incurred_inkind>0</total_expenditure_incurred_inkind>
    </fundtransfer-details>
    <transaction-details>
      <total_no_transactions_electronic_modes_cash>10000</total_no_transactions_electronic_modes_cash>
      <payment_electronic_modes_cash>10000</payment_electronic_modes_cash>
      <total_no_transactions_other_modes_cash>0</total_no_transactions_other_modes_cash>
      <payment_other_modes_cash>0</payment_other_modes_cash>
      <quantity_transferred_inkind>0</quantity_transferred_inkind>
      <no_of_authenticated_transactions_inkind>0</no_of_authenticated_transactions_inkind>
      <dbt_expenditure_incurred_inkind>0</dbt_expenditure_incurred_inkind>
    </transaction-details>
  </scheme-details>
  <scheme-details>
    <location>
      <district_code>503</district_code>
      <district_name>Chittoor</district_name>
      <state_code>28</state_code>
      <state_name>Andhra pradesh</state_name>
    </location>
    <beneficiary-details>
      <no_of_beneficiaries_normative_central_and_state_share>10000</no_of_beneficiaries_normative_central_and_state_share>
      <no_of_additional_beneficiaries_supported_by_state>0</no_of_additional_beneficiaries_supported_by_state>
      <total_no_of_beneficiaries>10000</total_no_of_beneficiaries>
      <no_of_beneficiaries_record_digitized>10000</no_of_beneficiaries_record_digitized>
      <no_of_authenticated_seeded_beneficiaries>10000</no_of_authenticated_seeded_beneficiaries>
      <no_of_beneficiaries_whom_mobile_no_captured>10000</no_of_beneficiaries_whom_mobile_no_captured>
    </beneficiary-details>
    <fundtransfer-details>
      <central_share_fund_transferred_cash>10000</central_share_fund_transferred_cash>
      <normative_state_share_fund_transferred_cash>0</normative_state_share_fund_transferred_cash>
      <additional_state_share_fund_transferred_cash>0</additional_state_share_fund_transferred_cash>
      <state_share_fund_transferred_to_additional_beneficiaries_cash>0</state_share_fund_transferred_to_additional_beneficiaries_cash>
      <total_fund_transferred_cash>10000</total_fund_transferred_cash>
      <central_share_expenditure_incurred_inkind>0</central_share_expenditure_incurred_inkind>
      <normative_state_share_expenditure_incurred_inkind>0</normative_state_share_expenditure_incurred_inkind>
      <additional_state_share_expenditure_incurred_inkind>0</additional_state_share_expenditure_incurred_inkind>
      <state_share_expenditure_incurred_to_additional_beneficiaries_inkind>0</state_share_expenditure_incurred_to_additional_beneficiaries_inkind>
      <total_expenditure_incurred_inkind>0</total_expenditure_incurred_inkind>
    </fundtransfer-details>
    <transaction-details>
      <total_no_transactions_electronic_modes_cash>10000</total_no_transactions_electronic_modes_cash>
      <payment_electronic_modes_cash>10000</payment_electronic_modes_cash>
      <total_no_transactions_other_modes_cash>0</total_no_transactions_other_modes_cash>
      <payment_other_modes_cash>0</payment_other_modes_cash>
      <quantity_transferred_inkind>0</quantity_transferred_inkind>
      <no_of_authenticated_transactions_inkind>0</no_of_authenticated_transactions_inkind>
      <dbt_expenditure_incurred_inkind>0</dbt_expenditure_incurred_inkind>
    </transaction-details>
  </scheme-details>
  <scheme-details>
    <location>
      <district_code>504</district_code>
      <district_name>Cuddapah (YSR Kadapa)</district_name>
      <state_code>28</state_code>
      <state_name>Andhra pradesh</state_name>
    </location>
    <beneficiary-details>
      <no_of_beneficiaries_normative_central_and_state_share>10000</no_of_beneficiaries_normative_central_and_state_share>
      <no_of_additional_beneficiaries_supported_by_state>0</no_of_additional_beneficiaries_supported_by_state>
      <total_no_of_beneficiaries>10000</total_no_of_beneficiaries>
      <no_of_beneficiaries_record_digitized>10000</no_of_beneficiaries_record_digitized>
      <no_of_authenticated_seeded_beneficiaries>10000</no_of_authenticated_seeded_beneficiaries>
      <no_of_beneficiaries_whom_mobile_no_captured>10000</no_of_beneficiaries_whom_mobile_no_captured>
    </beneficiary-details>
    <fundtransfer-details>
      <central_share_fund_transferred_cash>10000</central_share_fund_transferred_cash>
      <normative_state_share_fund_transferred_cash>0</normative_state_share_fund_transferred_cash>
      <additional_state_share_fund_transferred_cash>0</additional_state_share_fund_transferred_cash>
      <state_share_fund_transferred_to_additional_beneficiaries_cash>0</state_share_fund_transferred_to_additional_beneficiaries_cash>
      <total_fund_transferred_cash>10000</total_fund_transferred_cash>
      <central_share_expenditure_incurred_inkind>0</central_share_expenditure_incurred_inkind>
      <normative_state_share_expenditure_incurred_inkind>0</normative_state_share_expenditure_incurred_inkind>
      <additional_state_share_expenditure_incurred_inkind>0</additional_state_share_expenditure_incurred_inkind>
      <state_share_expenditure_incurred_to_additional_beneficiaries_inkind>0</state_share_expenditure_incurred_to_additional_beneficiaries_inkind>
      <total_expenditure_incurred_inkind>0</total_expenditure_incurred_inkind>
    </fundtransfer-details>
    <transaction-details>
      <total_no_transactions_electronic_modes_cash>10000</total_no_transactions_electronic_modes_cash>
      <payment_electronic_modes_cash>10000</payment_electronic_modes_cash>
      <total_no_transactions_other_modes_cash>0</total_no_transactions_other_modes_cash>
      <payment_other_modes_cash>0</payment_other_modes_cash>
      <quantity_transferred_inkind>0</quantity_transferred_inkind>
      <no_of_authenticated_transactions_inkind>0</no_of_authenticated_transactions_inkind>
      <dbt_expenditure_incurred_inkind>0</dbt_expenditure_incurred_inkind>
    </transaction-details>
  </scheme-details>
</scheme-master>

Last Run:	7:44:23 am
Compile:	0.02s
Execute:	0.1s
Memory:	9.02Mb
CPU:	0.12s

View IL Code