JSON missing data in import

  • Resolved mukeshwani

    (@mukeshwani)


    9 years, 7 months ago

    I have a JSON coming in this format. The importer reads up until “Products” and then it doesn’t import further (including Products). How could we fix this? I’m assuming it is because there is an array within an array?

    JSON:
    [
    {
    “ID”: 1691,
    “Number”: “14189”,
    “NumberDate”: “2014-05-22T00:00:00”,
    “Description”: “TThis is a sample description”,
    “URL”: “https://url_to_details”,
    “Title”: “Lakeshore Title”,
    “Contact”: “Contact us at 888-555-2222.”,
    “LastPublishDate”: “2015-01-09T00:00:00”,
    “Products”: [
    {
    “Name”: “Toy 1”,
    “Description”: “Toy descriptoin”,
    “Model”: “44rr2”,
    “Type”: “Sets”,
    “CategoryID”: “2201”,
    “NumberOfUnits”: “About 2,000”
    }
    ],
    “Images”: [
    {
    “URL”: “https://url_toimage.jpg”
    }
    ],
    “Manufacturers”: [
    {
    “Name”: “ToyMAN”,
    “CompanyID”: “”
    }
    ],
    “ManufacturerCountries”: [
    {
    “Country”: “China”
    }
    ],
    “ProductUPCs”: [

    ]
    }
    ]

    https://www.ads-software.com/plugins/tablepress/

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question and sorry for the trouble!

    The JSON format that is supported is quite simple:
    It just needs to be a two-dimensional array, like

    [["Cell 1","Cell 2","Cell 3"],["Cell 4","Cell 5","Cell 6"]]

    More complex things, like an object notation, as in your example, are not supported.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘JSON missing data in import’ is closed to new replies.