Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Prestashop Web service to return JSON

After extensive search over internet i am sure that Prestashop does not return data in JSON format, it only returns in XML format (which leads to cross domain accessing issue unfortunately).

Now, I am trying to convert XML(returned by Prestashop) to JSON. I want to write php code which could take XML from web service and sent back JSON. For this purpose i tried many tutorial but in vain. The converted JSON does not have value in it, so is useless. The methods i tried are listed below.

http://www.sitepoint.com/php-xml-to-json-proxy/
PHP convert XML to JSON

XML to convert:

<name>
<language id="1" xlink:href="http://localhost/prestashop/api/languages/1">
<![CDATA[ iPod Nano ]]>
</language>
</name>

Returned JSON:

"name":{"language":{"@attributes":{"id":"1"}}}
like image 200
Saba Sarwat Avatar asked May 30 '13 08:05

Saba Sarwat


3 Answers

I don't know about historical support for this, but...

In the latest version of Prestashop (currently v1.6.0.9), you can get a JSON response from any WebService API request by appending output_format=JSON to your request query string.

E.g. http://example.prestashop.com/api/products?output_format=JSON

like image 173
Mikuso Avatar answered Nov 10 '22 16:11

Mikuso


Using php pear "XML_Serializer":

{
  "product": {
    "id_category_default": "XXX",
    "id_tax_rules_group": "1",
    "type": "simple",
    "id_shop_default": "1",
    "reference": "XXXXXXXX",
    "price": "XX.XXXXXX",
    "active": "1",
    "redirect_type": "404",
    "id_product_redirected": "0",
    "available_for_order": "1",
    "condition": "new",
    "show_price": "1",
    "indexed": "0",
    "visibility": "both",
    "advanced_stock_management": "0",
    "link_rewrite": {
      "language": {
        "_attributes": {
          "id": "1"
        },
        "_content": "ipod-nano"
      }
    },
    "name": {
      "language": {
        "_attributes": {
          "id": "1"
        },
        "_content": "iPod Nano"
      }
    },
    "associations": {
      "categories": {
        "category": {
          "id": "XXX"
        }
      },
      "stock_availables": {
        "stock_available": {
          "id": "XXXX",
          "id_product_attribute": "X"
        }
      }
    }
  }
}

See this link: https://www.prestashop.com/forums/topic/602449-aporte-webservice-prestashop-16-json-request-post-y-put/#elComment_2930631

like image 2
Jose Lorenzo Avatar answered Nov 10 '22 15:11

Jose Lorenzo


only add ?output_format=JSON end url

http://example.com/api/products?output_format=JSON

like image 1
Behnam.sh Avatar answered Nov 10 '22 15:11

Behnam.sh