HiHow can I parse this result I use Aspnet with c 34CHECKAPI34 34RESULT34 34SUCCESS34 34MESSAGE34 34Valide API Key34 34TRACKING34 34TRACKINGNUMBER34 34RCH082069088EA34 34RESULT34 34SUCCESS34 34MESSAGE34 34Valid tracking number34 34HISTORY34 34134 34STATUT34 34Nouveau Colis34 34TIME34 34159707168434 34TIM

Hi yafadiCheck this example Now please take its reference and correct your codeFor this example i am reading the response from text fileNamespacesCusing SystemIOusing NewtonsoftJsonusing NewtonsoftJsonLinqVBNetImports SystemIOImports NewtonsoftJsonImports NewtonsoftJsonLinqCodeCprotected void PageLoadobject sender EventArgs e string json FileReadAllTextServerMapPath34TextFiletxt34Replace34TRACKINGNUMBER34 34TRACKINGNUMBER34 JsonResult res JsonConvertDeserializeObjectltJsonResultgtjson JObject jObject JsonConvertDeserializeObjectltJObjectgtresTRACKINGHISTORYToString foreach var item in jObject History hist JsonConvertDeserializeObjectltHistorygtitemValueToString string status histSTATUT string date histTIMESTR string time histTIME string message histCOMMENT Store in database public class JsonResult pu

Parse JSON string and insert into database using C# and VB.Net in ASP.Net

yafadi

SOLVED CLOSED ACTIVE ANSWERED
User: yafadi
Posted: on Aug 25, 2020 08:10 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 12279
Sample Code: Download

Hi,

How can I parse this result (I use Asp.net with c#):

{
  "CHECK_API": {
    "RESULT": "SUCCESS",
    "MESSAGE": "Valide API Key"
  },
  "TRACKING": {
    "TRACKING-NUMBER": "RCH082069088EA",
    "RESULT": "SUCCESS",
    "MESSAGE": "Valid tracking number",
    "HISTORY": {
      "1": {
        "STATUT": "Nouveau Colis",
        "TIME": "1597071684",
        "TIME_STR": "2020-08-10 16:01",
        "COMMENT": ""
      },
      "2": {
        "STATUT": "Attente De Ramassage",
        "TIME": "1597071721",
        "TIME_STR": "2020-08-10 16:02",
        "COMMENT": ""
      },
      "3": {
        "STATUT": "Ramass\u00e9",
        "TIME": "1597083258",
        "TIME_STR": "2020-08-10 19:14",
        "COMMENT": ""
      },
      "4": {
        "STATUT": "Exp\u00e9di\u00e9",
        "TIME": "1597171738",
        "TIME_STR": "2020-08-11 19:48",
        "COMMENT": ""
      },
      "5": {
        "STATUT": "Re\u00e7u",
        "TIME": "1597400834",
        "TIME_STR": "2020-08-14 11:27",
        "COMMENT": ""
      },
      "6": {
        "STATUT": "Mise en distribution",
        "TIME": "1597400834",
        "TIME_STR": "2020-08-14 11:27",
        "COMMENT": "Livreur: OZON ERRACHIDIA | T\u00e9l\u00e9phone: 06.00.00.00.00"
      },
      "7": {
        "STATUT": "Livr\u00e9",
        "TIME": "1597760105",
        "TIME_STR": "2020-08-18 15:15",
        "COMMENT": "Livreur: OZON ERRACHIDIA | T\u00e9l\u00e9phone: 07.66.35.36.94"
      },
      "8": {
        "STATUT": "Livr\u00e9",
        "TIME": "1598343806",
        "TIME_STR": "2020-08-25 09:23",
        "COMMENT": ""
      }
    },
    "LAST_TRACKING": {
      "STATUT": "Livr\u00e9",
      "TIME": "1598343806",
      "TIME_STR": "2020-08-25 09:23",
      "COMMENT": ""
    }
  }
}

public class JsonResult
{
    public List<Check_api> CHECK_API { get; set; }
    public List<Tracking> TRACKING { get; set; }
    public List<History> HISTORY { get; set; }
}

public class Check_api
{
    public string RESULT { get; set; }
    public string MESSAGE { get; set; }
}

public class Tracking
{
    public string TRACKING-NUMBER { get; set; }
    public string RESULT { get; set; }
    public string MESSAGE { get; set; }
}
 
  public class History
{
    public string STATUT { get; set; }
    public string TIME { get; set; }
    public string TIME_STR { get; set; }
    public string COMMENT { get; set; }
}
Uri address = new Uri(@"https://api.ozonexpress.ma/customers/{code}/{XXXXXXX}/tracking");
HttpWebRequest request = WebRequest.Create(address) as HttpWebRequest;
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
//tracking-number={0} :
//string Track_num = DateTime.Now.ToString("yyMMdd") + reader[7].ToString().PadLeft(4, '0');
string postString = string.Format("tracking-number={0}", TxtBoxUser.Text);
//string postString = string.Format("tracking-number={0}", "BML082071359YO");

StreamWriter requestWriter = new StreamWriter(request.GetRequestStream());
requestWriter.Write(postString);
requestWriter.Close();
 
using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
{
    StreamReader reader = new StreamReader(response.GetResponseStream());
    //Récupération le code d'envoi :
    TextBox1.Text = reader.ReadToEnd();
}
 
List<HISTORY> res = (List<HISTORY>)JsonConvert.DeserializeObject(TextBox1.Text, typeof(List<HISTORY>));
foreach (var item in res)
{
    //Store in database
    TextBox1.Text = "Date:" + item.STATUT.ToString() + "    Status:" + item.TIME.ToString() + "     Email:" + item.TIME_STR.ToString() + "       Message:" + item.COMMENT.ToString() + "";
 
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Aug 26, 2020 04:32 AM
Report

Hi yafadi,

Check this example. Now please take its reference and correct your code.

For this example i am reading the response from text file.

Namespaces

using System.IO;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

VB.Net

Imports System.IO
Imports Newtonsoft.Json
Imports Newtonsoft.Json.Linq

Code

protected void Page_Load(object sender, EventArgs e)
{
    string json = File.ReadAllText(Server.MapPath("~/TextFile.txt")).Replace("TRACKING-NUMBER", "TRACKING_NUMBER");
    JsonResult res = JsonConvert.DeserializeObject<JsonResult>(json);
    JObject jObject = JsonConvert.DeserializeObject<JObject>(res.TRACKING.HISTORY.ToString());
    foreach (var item in jObject)
    {
        History hist = (JsonConvert.DeserializeObject<History>(item.Value.ToString()));
        string status = hist.STATUT;
        string date = hist.TIME_STR;
        string time = hist.TIME;
        string message = hist.COMMENT;
        //Store in database
    }
}

public class JsonResult
{
    public CHECK_API CHECK_API { get; set; }
    public TRACKING TRACKING { get; set; }
}

public class CHECK_API
{
    public string RESULT { get; set; }
    public string MESSAGE { get; set; }
}

public class TRACKING
{
    public string TRACKING_NUMBER { get; set; }
    public string RESULT { get; set; }
    public string MESSAGE { get; set; }
    public object HISTORY { get; set; }
}
public class History
{
    public string STATUT { get; set; }
    public string TIME { get; set; }
    public string TIME_STR { get; set; }
    public string COMMENT { get; set; }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim json As String = File.ReadAllText(Server.MapPath("~/TextFile.txt")).Replace("TRACKING-NUMBER", "TRACKING_NUMBER")
    Dim res As JsonResult = JsonConvert.DeserializeObject(Of JsonResult)(json)
    Dim jObject As JObject = JsonConvert.DeserializeObject(Of JObject)(res.TRACKING.HISTORY.ToString())
    For Each item In jObject
        Dim hist As History = (JsonConvert.DeserializeObject(Of History)(item.Value.ToString()))
        Dim status As String = hist.STATUT
        Dim [date] As String = hist.TIME_STR
        Dim time As String = hist.TIME
        Dim message As String = hist.COMMENT
    Next
End Sub

Public Class JsonResult
    Public Property CHECK_API As CHECK_API
    Public Property TRACKING As TRACKING
End Class

Public Class CHECK_API
    Public Property RESULT As String
    Public Property MESSAGE As String
End Class

Public Class TRACKING
    Public Property TRACKING_NUMBER As String
    Public Property RESULT As String
    Public Property MESSAGE As String
    Public Property HISTORY As Object
End Class

Public Class History
    Public Property STATUT As String
    Public Property TIME As String
    Public Property TIME_STR As String
    Public Property COMMENT As String
End Class

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Parse JSON string and insert into database using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us