DateSet JSON File reading not working properly
Hello All,
I have requirement to read JSON file using DATASET. I am not able to read the below structure
Hello All,
I have requirement to read JSON file using DATASET. I am not able to read the below structure
{ "type": "array", "CustomerInfo" : [ { "CifNbr" : "1", "ClientID" : "C10", "NamePrefix" : "Mrs", "FullName" : "Mahesh Puppala", "PrimaryIDType" : "Mahesh123", "Gender" : "Male", "MaritalStatus" : "Married", "Age":"30", "CustomerID" : "C1", "FirstName" : "Mahesh", "LastName" : "Puppala", "Address" : [ { "AddressID" : "1", "Address1" : "1-13", "CustomerID" : "C1", "City" : "Hyderabad", "pyCountry" : "IN", "PIN" : "500085", "State" : "TS", "AddressType" : "Permanent" } ] }
But , If I remove "CustomerInfo" and {} braces from first lines it is working. Could you please help me in resolving these and what exactly the JSON structure we can use.