HiI am tried to load the json to the html table with datatable response but i am not able to It keeps throwing Invalid JsonHeres the JSON34MEASURE NAME3434Age Appropriate Screening Colonoscopy3434MEASURE DESCRIPTION3434The percentage of patients greater than 85 years of age who received a screening colonoscopy from January 1 to December 313434eMEASURE NQF3434NA3434NQF3434NA3434NQS DOMAIN3434Efficiency and Cost Reduction

Hi Vikash21The way which you are trying to access the json data to datatable is bit more complexed and we need to do alot workaround if need to use your way and its not better one tooI have created a sample which full fill your requirement you need to modify the code according to your needHTMLltdivgt lttable id34tblcategory34gt lttablegtltdivgtltdivgt ltscript type34textjavascript34 src34httpscodejquerycomjquery1124js34gtltscriptgt ltscript type34textjavascript34 src34httpmaxcdnbootstrapcdncombootstrap337jsbootstrapminjs34gtltscriptgt ltlink rel34stylesheet34 href34httpmaxcdnbootstrapcdncombootstrap337cssbootstrapmincss34 gt ltlink rel34Stylesheet34 href34httpscdndatatablesnet11015cssjquerydataTablesmincss34 gt ltscript type34textjavascript34 src34httpscdndatatablesnet11015js

Error: Invalid Json in DataTable plugin in ASP.Net

Vikash21

SOLVED CLOSED ACTIVE ANSWERED
User: Vikash21
Posted: on Jul 12, 2017 02:59 AM
Forum: Data Controls
Answer: 1
Views: 10101
Sample Code: Download

Hi,

I am tried to load the json to the html table with datatable response but i am not able to. It keeps throwing Invalid Json.

Here's the JSON.

[{"MEASURE NAME":"Age Appropriate Screening Colonoscopy","MEASURE DESCRIPTION":"The percentage of patients greater than 85 years of age who received a screening colonoscopy from January 1 to December 31","eMEASURE NQF":"N/A","NQF":"N/A","NQS DOMAIN":"Efficiency and Cost Reduction","MEASURE TYPE":"Efficiency","HIGH PRIORITY MEASURE":"Yes","DATA SUBMISSION METHOD":"Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Gastroenterological Association"},{"MEASURE NAME":"Appropriate Follow-Up Interval for Normal Colonoscopy in Average Risk Patients","MEASURE DESCRIPTION":"Percentage of patients aged 50 to 75 years of age receiving a screening colonoscopy without biopsy or polypectomy who had a recommended follow-up interval of at least 10 years for repeat colonoscopy documented in their colonoscopy report","eMEASURE NQF":"N/A","NQF":"658","NQS DOMAIN":"Communication and Care Coordination","MEASURE TYPE":"Process","HIGH PRIORITY MEASURE":"Yes","DATA SUBMISSION METHOD":"Claims,Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Gastroenterological Association"},{"MEASURE NAME":"Colonoscopy Interval for Patients with a History of Adenomatous Polyps - Avoidance of Inappropriate Use","MEASURE DESCRIPTION":"Percentage of patients aged 18 years and older receiving a surveillance colonoscopy, with a history of a prior adenomatous polyp(s) in previous colonoscopy findings, which had an interval of 3 or more years since their last colonoscopy","eMEASURE NQF":"N/A","NQF":"659","NQS DOMAIN":"Communication and Care Coordination","MEASURE TYPE":"Process","HIGH PRIORITY MEASURE":"Yes","DATA SUBMISSION METHOD":"Claims,Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Gastroenterological Association"},{"MEASURE NAME":"Hepatitis C: Discussion and Shared Decision Making Surrounding Treatment Options","MEASURE DESCRIPTION":"Percentage of patients aged 18 years and older with a diagnosis of hepatitis C with whom a physician or other qualified healthcare professional reviewed the range of treatment options appropriate to their genotype and demonstrated a shared decision making approach with the patient. To meet the measure, there must be documentation in the patient record of a discussion between the physician or other qualified healthcare professional and the patient that includes all of the following: treatment choices appropriate to genotype, risks and benefits, evidence of effectiveness, and patient preferences toward treatment","eMEASURE NQF":"N/A","NQF":"N/A","NQS DOMAIN":"Person and Caregiver-Centered Experience and Outcomes","MEASURE TYPE":"Process","HIGH PRIORITY MEASURE":"Yes","DATA SUBMISSION METHOD":"Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Gastroenterological Association"},{"MEASURE NAME":"Inflammatory Bowel Disease (IBD): Assessment of Hepatitis B Virus (HBV) Status Before Initiating Anti-TNF (Tumor Necrosis Factor) Therapy","MEASURE DESCRIPTION":"Percentage of patients aged 18 years and older with a diagnosis of inflammatory bowel disease (IBD) who had Hepatitis B Virus (HBV) status assessed and results interpreted within one year prior to receiving a first course of anti-TNF (tumor necrosis factor) therapy","eMEASURE NQF":"N/A","NQF":"N/A","NQS DOMAIN":"Effective Clinical Care","MEASURE TYPE":"Process","HIGH PRIORITY MEASURE":"No","DATA SUBMISSION METHOD":"Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Gastroenterological Association"},{"MEASURE NAME":"Inflammatory Bowel Disease (IBD): Preventive Care: Corticosteroid Related Iatrogenic Injury - Bone Loss Assessment","MEASURE DESCRIPTION":"Percentage of patients aged 18 years and older with an inflammatory bowel disease encounter who were prescribed prednisone equivalents greater than or equal to 10 mg/day for 60 or greater consecutive days or a single prescription equating to 600 mg prednisone or greater for all fills and were documented for risk of bone loss once during the reporting year or the previous calendar year","eMEASURE NQF":"N/A","NQF":"N/A","NQS DOMAIN":"Effective Clinical Care","MEASURE TYPE":"Process","HIGH PRIORITY MEASURE":"No","DATA SUBMISSION METHOD":"Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Gastroenterological Association"},{"MEASURE NAME":"Screening Colonoscopy Adenoma Detection Rate","MEASURE DESCRIPTION":"The percentage of patients age 50 years or older with at least one conventional adenoma or colorectal cancer detected during screening colonoscopy","eMEASURE NQF":"N/A","NQF":"N/A","NQS DOMAIN":"Effective Clinical Care","MEASURE TYPE":"Outcome","HIGH PRIORITY MEASURE":"Yes","DATA SUBMISSION METHOD":"Registry","Specialty Set":"Gastroenterology","PRIMARY MEASURE STEWARD":"American Society for Gastrointestinal Endoscopy"}]

Here's the JS:

$(document).ready(function (){
    if ($.fn.dataTable.isDataTable('#tbl_category')) {
        t.destroy();
    }
    t = $("#tbl_category").DataTable({
        processing: true,
        serverSide: true,
        info: true,
        ajax: {
            type: "POST",
            dataType: "json",
            url: 'priority.aspx?priselect=Yes',
            data: function (data) {
                delete data.columns;
            }
        },
        columns: [
                    { "data": "MEASURE NAME" },
                    { "data": "MEASURE DESCRIPTION" },
                    { "data": "eMEASURE NQF" },
                    { "data": "NQF" },
                    { "data": "NQS DOMAIN" },
                    { "data": "MEASURE TYPE" },
                    { "data": "HIGH PRIORITY MEASURE" },
                    { "data": "DATA SUBMISSION METHOD" },
                    { "data": "SPECIALTY MEASURE SET" },
                    { "data": "PRIMARY MEASURE STEWARD" },
                    {
                        "render": function (data, type, full, meta) {
                            return '<a class="btn btn-warning" onClick="editdata(' + full.srno + ',\'' + full.MEASURE0NAME + '\',\'' + full.MEASUREDESCRIPTION + '\',\'' + full.NQF + '\',\'' + full.NQSDOMAIN + '\',\'' + full.MEASURETYPE + '\')" href="javascript://">Edit</a>&nbsp;&nbsp;<a class="btn btn-danger" onClick="deletePhantom(' + full.srno + ',\'DELETE\')" href="javascript://">Remove</a>';
                        }
                    }
        ],
        order: [[0, 'desc']],
        select: true,
        dom: 'lfrtip',
        responsive: true,
        buttons: true
    });
    t.on('order.dt search.dt', function () {
        t.column(0, { search: 'applied', order: 'applied' }).nodes().each(function (cell, i) {
            cell.innerHTML = i + 1;
        });
    }).draw();

});
    </script>

I am notsure if how should I address the JSON Invalid alert.

Any help would be great

Also, I am using these CDNs:

 <link rel="Stylesheet" href="https://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css" />
    <script type="text/javascript" src="https://code.jquery.com/jquery-1.12.3.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>

Thanks in advance,

Vikash

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

AnandM

0 8

Reply
ANSWER
User: AnandM
Replied: on Jul 24, 2017 09:29 AM
Report

Hi Vikash21,

The way which you are trying to access the json data to datatable is bit more complexed and we need to do alot workaround if need to use your way and its not better one too.

I have created a sample which full fill your requirement you need to modify the code according to your need.

HTML

<div>
    <table id="tbl_category">
    </table>
</div>
<div>
    <script type="text/javascript" src="https://code.jquery.com/jquery-1.12.4.js"></script>
    <script type="text/javascript" src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" />
    <link rel="Stylesheet" href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css" />
    <script type="text/javascript" src="https://cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $.ajax({
                type: "POST",
                url: "priority.aspx/GetPriRecords",
                data: "{ priselect : 'yes'}",
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (response) {
                    var xmlDoc = $.parseXML(response.d);
                    var PriRecords = $(xmlDoc).find("PriRecords");
                    $('#tbl_category').append('<thead><tr><th>Data</th></tr></thead>');
                    $('#tbl_category').append('<tbody>');
                    $.each(PriRecords, function () {
                        var tr = $('<tr />');
                        var PriRecord = $(this);
                        var MEASURENAME = $(PriRecord).find('MEASURENAME').text();
                        var MEASUREDESCRIPTION = $(PriRecord).find('MEASUREDESCRIPTION').text();
                        var MEASURETYPE = $(PriRecord).find('MEASURETYPE').text();
                        var NQF = $(PriRecord).find('NQF').text();
                        var NQSDOMAIN = $(PriRecord).find('NQSDOMAIN').text();
                        var Details = '';
                        Details += '<span style="font-weight: 700;">MEASURENAME :</span> ' + MEASURENAME + '<br />';
                        Details += '<span style="font-weight: 700;">MEASUREDESCRIPTION :</span> ' + MEASUREDESCRIPTION + '<br />';
                        Details += '<span style="font-weight: 700;">MEASURETYPE :</span> ' + MEASURETYPE + '<br />';
                        Details += '<span style="font-weight: 700;">NQF :</span> ' + NQF + '<br />';
                        Details += '<span style="font-weight: 700;">NQSDOMAIN :</span> ' + NQSDOMAIN + '<hr style="border: 1px solid;" />';
                        var td = $('<td />');
                        $(td).append(Details);
                        $(tr).append(td);
                        $('#tbl_category').append(tr);
                    });
                    $('#tbl_category').append('</tbody>');
                    $('#tbl_category').dataTable();
                }
            });
        });
    </script>
</div>

[WebMethod]
public static string GetPriRecords(string priselect)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        DataTable dt = new DataTable("PriRecords");
        SqlCommand cmd = new SqlCommand("[qqpbyhighprioritys]", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@HIGHPRIORITY", SqlDbType.VarChar).Value = priselect;
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        da.Fill(dt);
        DataSet ds = new DataSet();
        ds.Tables.Add(dt);
        return ds.GetXml();
    }        
}

VB.Net

<WebMethod> _
Public Shared Function GetPriRecords(priselect As String) As String
	Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
	Using con As New SqlConnection(constr)
		Dim dt As New DataTable("PriRecords")
		Dim cmd As New SqlCommand("[qqpbyhighprioritys]", con)
		cmd.CommandType = CommandType.StoredProcedure
		cmd.Parameters.Add("@HIGHPRIORITY", SqlDbType.VarChar).Value = priselect
		Dim da As New SqlDataAdapter()
		da.SelectCommand = cmd
		da.Fill(dt)
		Dim ds As New DataSet()
		ds.Tables.Add(dt)
		Return ds.GetXml()
	End Using
End Function

ScreenShot

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

Error: Invalid Json in DataTable plugin in ASP.Net

Company

Explore

Follow us

Contact Us