agaitan026 Posts - Answer Overflow

agaitan026

Explore posts from servers

•Created by agaitan026 on 1/13/2024 in #help

issues loading winform with api rest

hi i got the following code:

using Json.Net;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Net.Http;
using Syncfusion.WinForms.DataGrid;

namespace SfDataGrid_REST_API
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            sfDataGrid1.DataSource = GetRESTData("http://45.237.184.122:4000/clientes?limit=10");
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "OrderID" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "CustomerID" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "EmployeeID" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "Freight" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCity" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "Verified" });
        }

        private JArray GetRESTData(string uri)
        {
            var webRequest = (HttpWebRequest)WebRequest.Create(uri);
            var webResponse = (HttpWebResponse)webRequest.GetResponse();
            var reader = new StreamReader(webResponse.GetResponseStream());
            string data = reader.ReadToEnd();
            return JsonConvert.DeserializeObject<JArray>(data);       
        }
    }
}

using Json.Net;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Net.Http;
using Syncfusion.WinForms.DataGrid;

namespace SfDataGrid_REST_API
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            sfDataGrid1.DataSource = GetRESTData("http://45.237.184.122:4000/clientes?limit=10");
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "OrderID" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "CustomerID" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "EmployeeID" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "Freight" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCity" });
            this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "Verified" });
        }

        private JArray GetRESTData(string uri)
        {
            var webRequest = (HttpWebRequest)WebRequest.Create(uri);
            var webResponse = (HttpWebResponse)webRequest.GetResponse();
            var reader = new StreamReader(webResponse.GetResponseStream());
            string data = reader.ReadToEnd();
            return JsonConvert.DeserializeObject<JArray>(data);       
        }
    }
}

but getting this: Newtonsoft.Json.JsonSerializationException: 'Deserialized JSON type 'Newtonsoft.Json.Linq.JObject' is not compatible with expected type 'Newtonsoft.Json.Linq.JArray'. Path '', line 1, position 9636.' what im missing?

20 replies

Gaming

Programming