(C#) Iterate JSON where Member Names are Data Values
Demonstrates how to parse JSON where member names are not keywords, but instead are data values.
Chilkat.JsonObject json = new Chilkat.JsonObject();
bool success = json.LoadFile("qa_data/json/valuesAsNames.json");
// Imagine we have JSON such as the following:
// {
// "1680": {
// "entity_id": "1680",
// "type_id": "simple",
// "sku": "123"
// },
// "1701": {
// "entity_id": "1701",
// "type_id": "simple",
// "sku": "456"
// }
// }
//
// This presents a parsing problem because the member names, such as "1680"
// are not keywords. Instead they are data values. We don't know what they
// may be in advance.
// To solve, we iterate over the members, get the name of each, ...
int numMembers = json.Size;
int i;
for (i = 0; i <= numMembers - 1; i++) {
string name = json.NameAt(i);
Debug.WriteLine(name + ":");
Chilkat.JsonObject jRecord = json.ObjectAt(i);
Debug.WriteLine("entity_id: " + jRecord.StringOf("entity_id"));
Debug.WriteLine("type_id: " + jRecord.StringOf("type_id"));
Debug.WriteLine("sku: " + jRecord.StringOf("sku"));
}
|