JSON import

[juanrojas]

Hello, someone who knows a module to import products in JSON that are not the only 2 modules that are in addons, I have tried them and they are not fine

[knacky]

And isn't it faster to convert json feed to xml?

$getJson = file_get_contents('myjson.json');
$array = json_decode($getJson, true);

$xml = new SimpleXMLElement('<root/>');
array_walk_recursive($array, array($xml, 'addChild'));

print $xml->asXML();

 

Edited June 16, 2022 by knacky (see edit history)

[juanrojas]

hello, thanks for answering, I imagine that it would also be faster to convert to csv, but we are talking about one more step, the client downloads the JSON from a site and wants this file to remain in a cron task for updates, now well I don't know if the same technique that is used to download those products in JSON gives you the ability to say that you want it in XML. you want is to avoid one more step

[knacky]

After all, you can process a JSON file directly.

/*
{
    "items": [
        {
            "product": {
                "googleId": "1111111111111",
                "author": {"name": "product one, "reference": "ABCD123","price": "123.85"}
            }
        }
    ]
}
*/

$getJson = file_get_contents('myjson.json');
$array = json_decode($getJson, true);

foreach ($array>items as $item) {
   var_dump($item->product->reference);
}