Leer un trozo de json
Publicado por xavi (7 intervenciones) el 21/09/2021 12:11:46
Hola a todos
Necesito un poco de vuestra ayuda profesional
*** Con esta rutina obtengo los datos de un JSON ***
private void Ver_Pedidos()
{
RestClient client = new RestClient("https://devws.web.com/api-ws/v1.1/orders");
RestRequest request = new RestRequest(Method.GET);
request.AddHeader("Accept", "application/json");
request.AddHeader("authorization", "Bearer " + X_Token);
request.RequestFormat = DataFormat.Json;
var response = client.Execute(request).Content;
DataTable dt = (DataTable) JsonConvert.DeserializeObject(response, typeof(DataTable));
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
textBox1.Text += dt.Rows[i]["orderId"].ToString();
textBox1.Text += dt.Rows[i]["stateOrderId"].ToString();
textBox1.Text += dt.Rows[i]["state"].ToString();
textBox1.Text += dt.Rows[i]["customerId"].ToString();
etc...
}
}
}
*** NOTA: El problema es que no se como leer los campos a partir del
items: ["ean","name","quantity", etc...] ***
* El JSON que recibo es el siguiente:
{
"orderId": "100000131",
"stateOrderId": 2,
"state": "Delegado al socio",
"customerId": 7,
"orderDate": "08/06/2016",
"updatedDate": "08/06/2016",
"shippingContryIsoA2": "ES",
"shippingRegion": "Barcelona",
"shippingTown": "Barcelona",
"shippingAddress": "Avda. Diagonal nº612, 3º 5º",
"shippingPostCode": "08021",
"shippingFirstname": "susursal",
"shippingLastname": "empresa",
"shippingPhone": "950 343434",
"shippingEmail": "[email protected]",
"items": [ <------------------------- No se como leer apartir de aquí
{
"ean": "4242002490915",
"name": "Bosch HMT75G451 microondas",
"quantity": 1,
"weight": 10,
"totalWeight": 10,
"price": 200,
"taxPercent": 21,
"totalTax": 42,
"totalPriceTax": 242
}
],
"shippings": [
{
"carrierId": "correos",
"warehouseOriginId": 440001,
"items": [
{
"EAN": "4242002490915",
"quantity": 1
}
]
}
],
**********************
Muchas gracias.
Necesito un poco de vuestra ayuda profesional
*** Con esta rutina obtengo los datos de un JSON ***
private void Ver_Pedidos()
{
RestClient client = new RestClient("https://devws.web.com/api-ws/v1.1/orders");
RestRequest request = new RestRequest(Method.GET);
request.AddHeader("Accept", "application/json");
request.AddHeader("authorization", "Bearer " + X_Token);
request.RequestFormat = DataFormat.Json;
var response = client.Execute(request).Content;
DataTable dt = (DataTable) JsonConvert.DeserializeObject(response, typeof(DataTable));
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
textBox1.Text += dt.Rows[i]["orderId"].ToString();
textBox1.Text += dt.Rows[i]["stateOrderId"].ToString();
textBox1.Text += dt.Rows[i]["state"].ToString();
textBox1.Text += dt.Rows[i]["customerId"].ToString();
etc...
}
}
}
*** NOTA: El problema es que no se como leer los campos a partir del
items: ["ean","name","quantity", etc...] ***
* El JSON que recibo es el siguiente:
{
"orderId": "100000131",
"stateOrderId": 2,
"state": "Delegado al socio",
"customerId": 7,
"orderDate": "08/06/2016",
"updatedDate": "08/06/2016",
"shippingContryIsoA2": "ES",
"shippingRegion": "Barcelona",
"shippingTown": "Barcelona",
"shippingAddress": "Avda. Diagonal nº612, 3º 5º",
"shippingPostCode": "08021",
"shippingFirstname": "susursal",
"shippingLastname": "empresa",
"shippingPhone": "950 343434",
"shippingEmail": "[email protected]",
"items": [ <------------------------- No se como leer apartir de aquí
{
"ean": "4242002490915",
"name": "Bosch HMT75G451 microondas",
"quantity": 1,
"weight": 10,
"totalWeight": 10,
"price": 200,
"taxPercent": 21,
"totalTax": 42,
"totalPriceTax": 242
}
],
"shippings": [
{
"carrierId": "correos",
"warehouseOriginId": 440001,
"items": [
{
"EAN": "4242002490915",
"quantity": 1
}
]
}
],
**********************
Muchas gracias.
Valora esta pregunta


0