How to deserialize a JsonArray using Newtonsoft.Json?

Question

Hi I have the following code and from it I want to get some fields and put into an Android.TextView

using System;
using Android.App;
using Android.Widget;
using Android.OS;
using RestSharp;
using Newtonsoft.Json;
using Android.Util;
using App4.Resources;
using Newtonsoft.Json.Linq;
using Org.Json;
using System.Net;
using System.IO;
using System.Collections.Generic;

namespace App4
{
[Activity(Label = "App4", MainLauncher = true, Icon = "@drawable/icon")]
public class MainActivity : Activity
{
    EditText edtcpf;
    Button btnConsumer;
    TextView txtcpf;
    RestRequest cpf { get; set; }
    public RestClient consumer { get; set; }
    IRestResponse mensagemConsumer;
    TextView txtsobrenome;
    RestClient orderId { get; set; }
    RestRequest requestorderId { get; set; }
    IRestResponse answerorder { get; set; }
    TextView txtnome;
    TextView txtorder;
    TextView txtmensagem;

    protected override void OnCreate(Bundle bundle)
    {
        base.OnCreate(bundle);

        // Set our view from the "main" layout resource
        SetContentView(Resource.Layout.Main);
        btnConsumer = FindViewById<Button>(Resource.Id.btnConsumer);
        edtcpf = FindViewById<EditText>(Resource.Id.edtcpf);
        txtcpf = FindViewById<TextView>(Resource.Id.txtcpf);
        txtsobrenome = FindViewById<TextView>(Resource.Id.txtresposta);
        txtnome = FindViewById<TextView>(Resource.Id.txtNome);
        txtorder = FindViewById<TextView>(Resource.Id.txtorder);
        txtmensagem = FindViewById<TextView>(Resource.Id.txtMensagem);
        btnConsumer.Click += BtnConsumer_Click;

    }

    private void BtnConsumer_Click(object sender, EventArgs e)
    {
        try
        {
            // API Consumer CPF

            consumer = new RestClient("https://qa.api-latam.whirlpool.com/v1.0/consumers");
            cpf = new RestRequest("/" + edtcpf.Text, Method.GET);
            cpf.AddHeader("Content-Type", "application/json; charset=utf-8");
            cpf.AddHeader("Authorization", "Bearer 70197e6c-d81b-384c-bb32-d69e8c10b101");
            mensagemConsumer = consumer.Execute(cpf);
            Pessoa pessoa = JsonConvert.DeserializeObject<Pessoa>(mensagemConsumer.Content);
            txtnome.Text = "Nome: " +pessoa.firstName;
            txtsobrenome.Text = "Sobrenome: "+ pessoa.lastName;

            // API Consumer Appliances
            orderId = new RestClient("https://qa.api-latam.whirlpool.com/v1.0/consumers/");
            requestorderId = new RestRequest("/"+ edtcpf.Text+ "/service-orders", Method.GET);
            requestorderId.AddHeader("Content-Type", "application/json; charset=utf-8");
            requestorderId.AddHeader("Authorization", "Bearer 70197e6c-d81b-384c-bb32-d69e8c10b101");
            answerorder = orderId.Execute(requestorderId);
            CustomerJson json = JsonConvert.DeserializeObject<List<CustomerJson>>(json);
            txtorder.Text = json.Customer.orderId;





        }
        catch (Exception)
        {

            throw;
        }




    }


}

}

And I'm trying to Deserialize a JsonResponse that is an array, here is the response I get from the API:

**{
  "orders": [
   {
  "order": {
    "orderId": 7004093603,
    "orderStatusCode": "CANC",
    "orderStatusDescription": "Cancelado",
    "serviceProviderId": 3649,
    "orderOpeningDate": "2015-07-07",
    "orderSchedulingDate": "2015-07-18",
    "orderSchedulingPeriod": "M",
    "orderSettlementDate": null,
    "orderCancellationDate": null
  }
},
{
  "order": {
    "orderId": 7004153791,
    "orderStatusCode": "AGEN",
    "orderStatusDescription": "Agendado",
    "serviceProviderId": 3524,
    "orderOpeningDate": "2016-08-31",
    "orderSchedulingDate": "2016-09-01",
    "orderSchedulingPeriod": "M",
    "orderSettlementDate": null,
    "orderCancellationDate": null
  }
},
{
  "order": {
    "orderId": 7004156972,
    "orderStatusCode": "ABRT",
    "orderStatusDescription": "Aberto",
    "serviceProviderId": 30820,
    "orderOpeningDate": "2017-04-13",
    "orderSchedulingDate": null,
    "orderSchedulingPeriod": null,
    "orderSettlementDate": null,
    "orderCancellationDate": null
  }
},
{
  "order": {
    "orderId": 7002178478,
    "orderStatusCode": "CANC",
    "orderStatusDescription": "Cancelado",
    "serviceProviderId": 3555,
    "orderOpeningDate": "2014-02-22",
    "orderSchedulingDate": "2014-02-24",
    "orderSchedulingPeriod": "M",
    "orderSettlementDate": null,
    "orderCancellationDate": null
  }
},
{
  "order": {
    "orderId": 7002118317,
    "orderStatusCode": "CANC",
    "orderStatusDescription": "Cancelado",
    "serviceProviderId": 3555,
    "orderOpeningDate": "2014-02-10",
    "orderSchedulingDate": "2014-02-15",
    "orderSchedulingPeriod": "M",
    "orderSettlementDate": null,
    "orderCancellationDate": null
    }
    }
    ]
    }**

I created a class that has this strings

 class RootObject
{
 [JsonProperty("orders")]
public Results Results { get; set; }
}

class Results
{
[JsonProperty("order")]
public Dictionary<string, JobCode> JobCodes { get; set; }
}

class JobCode
{
[JsonProperty("orderId")]
public string orderId { get; set; }
[JsonProperty("orderStatusCode")]
public string orderStatusCode { get; set; }
[JsonProperty("orderStatusDescription")]
public string orderStatusDescription { get; set; }
  }

The fields that I need to insert into the applicative are orderId orderStatusCode and orderStatusDescription.

I'm trying to deserialize it but it returns this message: Argument 1: cannot convert from 'CustomerJson' to 'string' and Use of Unassigned local variable 'json'

How can I deserialize this?

score 0 · Answer 1 · edited May 23 '17 at 12:25

0

IMPORTANT THING

1) Order is sub-element of orders[] array.

2) Customer is sub-element of Order.

You should search in oders[] array step by step with an enumarator, a loop, and so on... And then, When every every loop is complete, you should parse Customer class in order element.

Example;

foreach(var order in orders)
{ 
   var order = order.name;
   //access to order data;
}

Deserialize JSON to C# Classes

edited May 23 '17 at 12:25

Community

1
1

answered Apr 26 '17 at 11:47

Dentrax

574
8
22

I changed the class but I'm still having the error. Please check the new class. :) – Lucas Moreira Apr 26 '17 at 13:40

score 0 · Answer 2 · answered Apr 26 '17 at 11:52

Your json is incorrect, you're missing a '}'. Here's the valid json

{
  "orders": [{
    "order": {
        "orderId": 7004093603,
        "orderStatusCode": "CANC",
        "orderStatusDescription": "Cancelado",
        "serviceProviderId": 3649,
        "orderOpeningDate": "2015-07-07",
        "orderSchedulingDate": "2015-07-18",
        "orderSchedulingPeriod": "M",
        "orderSettlementDate": null,
        "orderCancellationDate": null
    }
  }]
}

Also, I created the model using http://json2csharp.com/ I'm pasting them below. Try parsing your json with the following model, it should work

public class Order2 {
  public long orderId { get; set; }
  public string orderStatusCode { get; set; }
  public string orderStatusDescription { get; set; }
  public int serviceProviderId { get; set; }
  public string orderOpeningDate { get; set; }
  public string orderSchedulingDate { get; set; }
  public string orderSchedulingPeriod { get; set; }
  public object orderSettlementDate { get; set; }
  public object orderCancellationDate { get; set; }
}

public class Order{
  public Order2 order { get; set; }
}

public class RootObject{
  public List<Order> orders { get; set; }
}

When I try to deserialize I'm still having the error about cannot convert. var r = JsonConvert.DeserializeObject(r); — Lucas Moreira, Apr 26 '17 at 12:26

How to deserialize a JsonArray using Newtonsoft.Json?

2 Answers2