JSON to Table usage

B

Bruno plant

Новичок

01.12.2016

#1

Hello,

Using this tutorial : http://zennolab.com/wiki/en:json_xml?&#processing-json-xml-from-code

I'm trying to save JSON to table but i have an error (cf screenshot).

Anyone have an idea ?

Thanks in advance.

Код:

{
    "Code" : "OK",
    "ErrorMessage" : "",
    "FullError" : "",
    "FirstBackLinkDate" : "2016-08-29",
    "IndexBuildDate" : "2016-12-01 12:37:45",
    "IndexType" : 1,
    "MostRecentBackLinkDate" : "2016-11-30",
    "QueriedRootDomains" : 1,
    "QueriedSubDomains" : 1,
    "QueriedURLs" : 1,
    "QueriedURLsMayExist" : 0,
    "ServerBuild" : "2016-11-30 18:42:06",
    "ServerName" : "ECHOLIMA",
    "ServerVersion" : "1.0.6178.33663",
    "UniqueIndexID" : "20161201123745-FRESH",
    "DataTables" : {
        "Results" : {
            "Headers" : {
                "MaxTopicsRootDomain" : 30,
                "MaxTopicsSubDomain" : 20,
                "MaxTopicsURL" : 10,
                "TopicsCount" : 3
            },
            "Data" : [
                { "ItemNum" : 0, "Item" : "https://www.growthhacking.fr/", "ResultCode" : "OK", "Status" : "Found", "ExtBackLinks" : 39, "RefDomains" : 13, "AnalysisResUnitsCost" : 39, "ACRank" : 4, "ItemType" : 3, "IndexedURLs" : 1, "GetTopBackLinksAnalysisResUnitsCost" : 5000, "DownloadBacklinksAnalysisResUnitsCost" : 25000, "DownloadRefDomainBacklinksAnalysisResUnitsCost" : 25000, "RefIPs" : 10, "RefSubNets" : 8, "RefDomainsEDU" : 0, "ExtBackLinksEDU" : 0, "RefDomainsGOV" : 0, "ExtBackLinksGOV" : 0, "RefDomainsEDU_Exact" : 0, "ExtBackLinksEDU_Exact" : 0, "RefDomainsGOV_Exact" : 0, "ExtBackLinksGOV_Exact" : 0, "CrawledFlag" : "True", "LastCrawlDate" : "2016-11-30", "LastCrawlResult" : "DownloadedSuccessfully", "RedirectFlag" : "False", "FinalRedirectResult" : "", "OutDomainsExternal" : 3, "OutLinksExternal" : 3, "OutLinksInternal" : 53, "LastSeen" : "", "Title" : "Growthhacking.fr | La communauté au service de votre croissance", "RedirectTo" : "", "CitationFlow" : 37, "TrustFlow" : 19, "TrustMetric" : 19, "TopicalTrustFlow_Topic_0" : "Games/Video Games/Sports", "TopicalTrustFlow_Value_0" : "18", "TopicalTrustFlow_Topic_1" : "Computers/Internet", "TopicalTrustFlow_Value_1" : "16", "TopicalTrustFlow_Topic_2" : "Computers/Internet/Web Design and Development", "TopicalTrustFlow_Value_2" : "16" },
                { "ItemNum" : 1, "Item" : "www.growthhacking.fr", "ResultCode" : "OK", "Status" : "Found", "ExtBackLinks" : 465, "RefDomains" : 84, "AnalysisResUnitsCost" : 465, "ACRank" : -1, "ItemType" : 2, "IndexedURLs" : 20994, "GetTopBackLinksAnalysisResUnitsCost" : 5000, "DownloadBacklinksAnalysisResUnitsCost" : 25000, "DownloadRefDomainBacklinksAnalysisResUnitsCost" : 25000, "RefIPs" : 70, "RefSubNets" : 60, "RefDomainsEDU" : 0, "ExtBackLinksEDU" : 0, "RefDomainsGOV" : 0, "ExtBackLinksGOV" : 0, "RefDomainsEDU_Exact" : 0, "ExtBackLinksEDU_Exact" : 0, "RefDomainsGOV_Exact" : 0, "ExtBackLinksGOV_Exact" : 0, "CrawledFlag" : "False", "LastCrawlDate" : "", "LastCrawlResult" : "", "RedirectFlag" : "False", "FinalRedirectResult" : "", "OutDomainsExternal" : 0, "OutLinksExternal" : 0, "OutLinksInternal" : 0, "LastSeen" : "", "Title" : "Growthhacking.fr | La communauté au service de votre croissance", "RedirectTo" : "", "CitationFlow" : 32, "TrustFlow" : 13, "TrustMetric" : 13, "TopicalTrustFlow_Topic_0" : "Games/Video Games/Sports", "TopicalTrustFlow_Value_0" : "12", "TopicalTrustFlow_Topic_1" : "Computers/Internet/Web Design and Development", "TopicalTrustFlow_Value_1" : "11", "TopicalTrustFlow_Topic_2" : "Computers/Internet", "TopicalTrustFlow_Value_2" : "11" },
                { "ItemNum" : 2, "Item" : "growthhacking.fr", "ResultCode" : "OK", "Status" : "Found", "ExtBackLinks" : 823, "RefDomains" : 149, "AnalysisResUnitsCost" : 823, "ACRank" : -1, "ItemType" : 1, "IndexedURLs" : 22916, "GetTopBackLinksAnalysisResUnitsCost" : 5000, "DownloadBacklinksAnalysisResUnitsCost" : 25000, "DownloadRefDomainBacklinksAnalysisResUnitsCost" : 25000, "RefIPs" : 122, "RefSubNets" : 107, "RefDomainsEDU" : 1, "ExtBackLinksEDU" : 2, "RefDomainsGOV" : 0, "ExtBackLinksGOV" : 0, "RefDomainsEDU_Exact" : 1, "ExtBackLinksEDU_Exact" : 2, "RefDomainsGOV_Exact" : 0, "ExtBackLinksGOV_Exact" : 0, "CrawledFlag" : "False", "LastCrawlDate" : "", "LastCrawlResult" : "", "RedirectFlag" : "True", "FinalRedirectResult" : "", "OutDomainsExternal" : 0, "OutLinksExternal" : 0, "OutLinksInternal" : 0, "LastSeen" : "", "Title" : "Growthhacking.fr | La communauté au service de votre croissance", "RedirectTo" : "http://www.growthhacking.fr/", "CitationFlow" : 27, "TrustFlow" : 12, "TrustMetric" : 12, "TopicalTrustFlow_Topic_0" : "Games/Video Games/Sports", "TopicalTrustFlow_Value_0" : "10", "TopicalTrustFlow_Topic_1" : "Computers/Internet", "TopicalTrustFlow_Value_1" : "10", "TopicalTrustFlow_Topic_2" : "Computers/Internet/Web Design and Development", "TopicalTrustFlow_Value_2" : "9" }
            ]
            }
        }
}

Последнее редактирование: 01.12.2016