求助：JSON格式数据解析 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

汗，第一次用这玩意，居然不能强类型引用

Dim json As String = jsonString

Dim ScriptControl As Object, data As Object, JscriptCode As String

JscriptCode = "function toObject(json) {eval(""var o=""+json);return o;}"

ScriptControl = CreateObject("MSScriptControl.ScriptControl")

With ScriptControl

.Language = "Javascript"

.Timeout = -1

.AddCode(JscriptCode)

data = .Run("toObject", json)

End With

For Each obj As object In data.item

Output.Show(obj.media_id)

For Each item As object In obj.content.news_item

Output.Show(item.title)

Dim dr As DataRow

For Each obj As object In data.item

For Each item As object In obj.content.news_item

dr = DataTables("表A").AddNew

dr("media_id") = obj.media_id

dr("update_time") = obj.update_time

dr("title") = item.title

dr("url") = item.url

msgbox(json)看看是什么内容

没有其它办法。

也没有必要每次都从接口全量下载这些数据。

公众号是你自己的，向怎么做都可以。微信接口又有创建，更新和删除的操作。就像操作表格一样就行

Javascript是大小写敏感的，要关闭代码编辑器的着色功能

http://www.foxtable.com/webhelp/scr/1273.htm

'...

Dim postdata As String ="{""begin_date"": ""2015-10-13"", ""end_date"": ""2015-10-13""}"

Dim url = String.Format("https://api.weixin.qq.com/datacube/getarticlesummary?access_token=jWwr17bx9IlRG__YdtKfJfLzUzLecGInR8Rq2T5EiOlvjW5DJIcuyZe3A9D2OgZ5FcoM3g3Ydbyh5O9bfI3rx_R7sNv3aw5WecBJvpuzPx4v01ZmjpEXEi9Wt89yjo_WVXZhAEAIKM")

Using ms As New System.IO.MemoryStream()

Dim bytes = ConvertHelper.EncodingToBytes(postdata, System.Text.Encoding.UTF8)

ms.Write(bytes, 0, bytes.Length)

ms.Seek(0, System.IO.SeekOrigin.Begin)

Dim json As String = Functions.Execute("HttpPost",url, ms)

Dim ScriptControl As Object, data As Object, JscriptCode As String

JscriptCode = "function toObject(json) {eval(""var o=""+json);return o;}"

ScriptControl = CreateObject("MSScriptControl.ScriptControl")

With ScriptControl

.Language = "Javascript"

.Timeout = -1

.AddCode(JscriptCode)

data = .Run("toObject", json)

End With

For Each obj As object In data.list

output.Show(obj.title)

End Using

主题：求助：JSON格式数据解析