Dim jt As JSONTable = New JSONTable()
jt.PageSize = 8
jt.PageIndex = 1
jt.TotalRows = 16
jt.TableName = "Categories"
jt.JSelectColumns = New List(Of JTableSelectColumn)()
Dim jts As JTableSelectColumn = New JTableSelectColumn()
jts.ColumnName = "CategoryID"
jt.JSelectColumns.Add(jts)
Dim jts1 As JTableSelectColumn = New JTableSelectColumn()
jts1.ColumnName = "CategoryName"
jt.JSelectColumns.Add(jts1)
jt.JOrderByList = New List(Of JOrderBy)()
Dim jo As JOrderBy = New JOrderBy()
jo.ColumnName = "CategoryName"
jo.OrderDirection = "Desc"
jt.JOrderByList.Add(jo)
Dim data As String = jt.PostRequest("PostGetRecordListForTable", "CommonRestful")
Once you have the record, you just have to parse through it. Here we have Product class which is used for creating a list of records
Dim productsList As New List(Of Products)
Dim results As JArray = JArray.Parse(CStr(JsonConvert.DeserializeObject(data)))
If results.Count <> 0 Then
For i As Integer = 0 To results.Count - 1
Dim recVals As List(Of JToken) = results(i).Children().ToList()
Dim prod As Products = New Products()
prod.ProductName = recVals(0)
prod.ProductID = recVals(1)
productsList.Add(prod)
Next
End If