using System;

using ChoETL;

​

public class Program

{

    public static void Main()

    {

        string json = @"

{

   ""getUsers"":[

      {

         ""UserInformation"":{

            ""Id"":1111122,

            ""firstName"":""*****1"",

            ""UserType"":{

               ""name"":""CP""

            },

            ""primaryState"":""MA"",

            ""otherState"":[

               ""MA"",

               ""BA""

            ],

            ""createdAt"":null

         }

      },

      {

         ""UserInformation"":{

            ""Id"":3333,

            ""firstName"":""*****3"",

            ""UserType"":{

               ""name"":""CPP""

            },

            ""primaryState"":""MPA"",

            ""otherState"":[

               ""KL"",

               ""TN""

            ],

            ""createdAt"":null

         }

      }

   ]

}";

        var config = new ChoJSONRecordConfiguration();

        config.JSONPath = "$..getUsers[*].UserInformation";

        config.AllowComplexJSONPath = true;

​

        config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("Id"));

        config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("FirstName"));

        config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("UserType", "$.UserType.name"));

        config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("primaryState"));

        config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("otherState", "$.otherState[*]") { FieldType = typeof(string[]) });

        config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("createdAt"));

        using (var r = ChoJSONReader.LoadText(json, config))

        {

            using (var w = new ChoCSVWriter(Console.Out).WithFirstLineHeader()

                .UseNestedKeyFormat(false)

                )

                w.Write(r);

        }       

    }

}