how to read json content in ASp.net Core

prasanna p

4y1.4k.NET

hi Friends,

I have following json Response from the API.

"[\"{\\\"TransactionDetails\\\":{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"BUSINESS_DT\\\":\\\"2021/12/10\\\",\\\"DISCOUNT\\\":0.0,\\\"INV_AMT\\\":-3441.56,\\\"LOCATION_CODE\\\":\\\"57114\\\",\\\"OP_CUR\\\":\\\"INR\\\",\\\"PaymentDetail\\\":[{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"CURRENCY_CODE\\\":\\\"INR\\\",\\\"EXCHANGE_RATE\\\":100.0,\\\"OP_CUR\\\":\\\"INR\\\",\\\"PAYMENT_NAME\\\":\\\"HDFC Reco\\\",\\\"PAYMENT_STATUS\\\":\\\"Sale\\\",\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000736\\\",\\\"TENDER_AMOUNT\\\":3776.0}],\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000736\\\",\\\"RCPT_TM\\\":\\\"54440\\\",\\\"RET_AMT\\\":0.0,\\\"SHIFT_NO\\\":\\\"\\\",\\\"TAX_AMT\\\":334.44,\\\"TERMINAL_ID\\\":\\\"57114011\\\",\\\"TRAN_STATUS\\\":\\\"Sale\\\"}}\",\"{\\\"TransactionDetails\\\":{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"BUSINESS_DT\\\":\\\"2021/12/10\\\",\\\"DISCOUNT\\\":0.0,\\\"INV_AMT\\\":-599.04,\\\"LOCATION_CODE\\\":\\\"57114\\\",\\\"OP_CUR\\\":\\\"INR\\\",\\\"PaymentDetail\\\":[{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"CURRENCY_CODE\\\":\\\"INR\\\",\\\"EXCHANGE_RATE\\\":100.0,\\\"OP_CUR\\\":\\\"INR\\\",\\\"PAYMENT_NAME\\\":\\\"HDFC Reco\\\",\\\"PAYMENT_STATUS\\\":\\\"Sale\\\",\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000742\\\",\\\"TENDER_AMOUNT\\\":629.0}],\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000742\\\",\\\"RCPT_TM\\\":\\\"73872\\\",\\\"RET_AMT\\\":0.0,\\\"SHIFT_NO\\\":\\\"\\\",\\\"TAX_AMT\\\":29.96,\\\"TERMINAL_ID\\\":\\\"57114011\\\",\\\"TRAN_STATUS\\\":\\\"Sale\\\"}}\"]"

When I am reading the API content with the following code getting error

Error reading JObject from JsonReader. Current JsonReader item is not an object: String. Path '', line 1, position 3.'

var json = await response.Content.ReadAsStringAsync();
var responseString = json.Replace(@"\\\", "");
JObject json1 = JObject.Parse(responseString1);

I used the following code also

var myDeserializedClass = JsonConvert.DeserializeObject(jsonResult1);

but not working.

Please tell me how to read the web APi response.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhavin Nandaniya4y ago
it's because the response you getting is not JSON
it's collection of JSON, an array like => [{},{}]
run the following code in .net fiddle (FYI! i was using compiler: .NET 6)

idk what you are trying to get from json and i also dont know the structure of model named Root you are using
so i can't write proper code for you but i think you will get idea on what to do after you run & understand my code below
using System;
using System.Collections.Generic;
using System.Linq;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

public class Program
{
    public static void Main()
    {
        string str = "[\"{\\\"TransactionDetails\\\":{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"BUSINESS_DT\\\":\\\"2021/12/10\\\",\\\"DISCOUNT\\\":0.0,\\\"INV_AMT\\\":-3441.56,\\\"LOCATION_CODE\\\":\\\"57114\\\",\\\"OP_CUR\\\":\\\"INR\\\",\\\"PaymentDetail\\\":[{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"CURRENCY_CODE\\\":\\\"INR\\\",\\\"EXCHANGE_RATE\\\":100.0,\\\"OP_CUR\\\":\\\"INR\\\",\\\"PAYMENT_NAME\\\":\\\"HDFC Reco\\\",\\\"PAYMENT_STATUS\\\":\\\"Sale\\\",\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000736\\\",\\\"TENDER_AMOUNT\\\":3776.0}],\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000736\\\",\\\"RCPT_TM\\\":\\\"54440\\\",\\\"RET_AMT\\\":0.0,\\\"SHIFT_NO\\\":\\\"\\\",\\\"TAX_AMT\\\":334.44,\\\"TERMINAL_ID\\\":\\\"57114011\\\",\\\"TRAN_STATUS\\\":\\\"Sale\\\"}}\",\"{\\\"TransactionDetails\\\":{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"BUSINESS_DT\\\":\\\"2021/12/10\\\",\\\"DISCOUNT\\\":0.0,\\\"INV_AMT\\\":-599.04,\\\"LOCATION_CODE\\\":\\\"57114\\\",\\\"OP_CUR\\\":\\\"INR\\\",\\\"PaymentDetail\\\":[{\\\"BC_EXCH\\\":\\\"INR\\\",\\\"CURRENCY_CODE\\\":\\\"INR\\\",\\\"EXCHANGE_RATE\\\":100.0,\\\"OP_CUR\\\":\\\"INR\\\",\\\"PAYMENT_NAME\\\":\\\"HDFC Reco\\\",\\\"PAYMENT_STATUS\\\":\\\"Sale\\\",\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000742\\\",\\\"TENDER_AMOUNT\\\":629.0}],\\\"RCPT_DT\\\":\\\"2021/12/10\\\",\\\"RCPT_NUM\\\":\\\"5711411I21000742\\\",\\\"RCPT_TM\\\":\\\"73872\\\",\\\"RET_AMT\\\":0.0,\\\"SHIFT_NO\\\":\\\"\\\",\\\"TAX_AMT\\\":29.96,\\\"TERMINAL_ID\\\":\\\"57114011\\\",\\\"TRAN_STATUS\\\":\\\"Sale\\\"}}\"]";

        JArray json = (JArray)JsonConvert.DeserializeObject(str);

        foreach (var item in json.Children())
        {
            var Jobj = JObject.Parse(item.ToString());
            Console.WriteLine((string)Jobj["TransactionDetails"]["OP_CUR"]);
        }
    }
}
The response you are getting is as following
[
{
    "TransactionDetails": {
        "BC_EXCH": "INR",
        "BUSINESS_DT": "2021/12/10",
        "DISCOUNT": 0,
        "INV_AMT": -3441.56,
        "LOCATION_CODE": "57114",
        "OP_CUR": "INR",
        "PaymentDetail": [
            {
                "BC_EXCH": "INR",
                "CURRENCY_CODE": "INR",
                "EXCHANGE_RATE": 100,
                "OP_CUR": "INR",
                "PAYMENT_NAME": "HDFC Reco",
                "PAYMENT_STATUS": "Sale",
                "RCPT_DT": "2021/12/10",
                "RCPT_NUM": "5711411I21000736",
                "TENDER_AMOUNT": 3776
            }
        ],
        "RCPT_DT": "2021/12/10",
        "RCPT_NUM": "5711411I21000736",
        "RCPT_TM": "54440",
        "RET_AMT": 0,
        "SHIFT_NO": "",
        "TAX_AMT": 334.44,
        "TERMINAL_ID": "57114011",
        "TRAN_STATUS": "Sale"
    }
},
{
    "TransactionDetails": {
        "BC_EXCH": "INR",
        "BUSINESS_DT": "2021/12/10",
        "DISCOUNT": 0,
        "INV_AMT": -599.04,
        "LOCATION_CODE": "57114",
        "OP_CUR": "INR",
        "PaymentDetail": [
            {
                "BC_EXCH": "INR",
                "CURRENCY_CODE": "INR",
                "EXCHANGE_RATE": 100,
                "OP_CUR": "INR",
                "PAYMENT_NAME": "HDFC Reco",
                "PAYMENT_STATUS": "Sale",
                "RCPT_DT": "2021/12/10",
                "RCPT_NUM": "5711411I21000742",
                "TENDER_AMOUNT": 629
            }
        ],
        "RCPT_DT": "2021/12/10",
        "RCPT_NUM": "5711411I21000742",
        "RCPT_TM": "73872",
        "RET_AMT": 0,
        "SHIFT_NO": "",
        "TAX_AMT": 29.96,
        "TERMINAL_ID": "57114011",
        "TRAN_STATUS": "Sale"
    }
}
]
Md Sarfaraj4y ago
Hello,
Check this out, Maybe It will help you.
Link: https://stackoverflow.com/questions/6178544/how-can-i-beautify-json-for-display-in-a-textbox
Gajendra Jangid4y ago
Try this
https://stackoverflow.com/questions/34690581/error-reading-jobject-from-jsonreader-current-jsonreader-item-is-not-an-object