Convert JSON to CSV using XSLT

Use any tool or language to make a request

Example:

curl -H "Content-Type: application/json" --data @PurchaseOrder.json "https://api.productivepathway.com/transform/xslt?xslPath=https%3A%2F%2Fwww.productivepathway.com%2Fsample%2Fjson-csv.xslt&accessToken=accessTokenValue"

PurchaseOrder.json is a file with the source JSON
https%3A%2F%2Fwww.productivepathway.com%2Fsample%2Fjson-csv.xslt is the URL encoded path to the XSL file
accessTokenValue is the current access token from Account.

Input Type:

Input:
{ "PurchaseOrder": { "PurchaseOrderNumber": "99503", "OrderDate": "1999-10-20", "Address": [ { "Type": "Shipping", "Name": "Ellen Adams", "Street": "123 Maple Street", "City": "Mill Valley", "State": "CA", "Zip": "10999", "Country": "USA" }, { "Type": "Billing", "Name": "Tai Yee", "Street": "8 Oak Avenue", "City": "Old Town", "State": "PA", "Zip": "95819", "Country": "USA" } ], "DeliveryNotes": "Please leave packages in shed by driveway.", "Items": { "Item": [ { "PartNumber": "872-AA", "ProductName": "Lawnmower", "Quantity": "1", "USPrice": "148.95", "Comment": "Confirm this is electric" }, { "PartNumber": "926-AA", "ProductName": "Baby Monitor", "Quantity": "2", "USPrice": "39.98", "ShipDate": "1999-05-21" } ] } } }

Stylesheet:
<?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text"/> <xsl:variable name='newline'><xsl:text> </xsl:text></xsl:variable> <xsl:template match="/PurchaseOrder"> <xsl:value-of select="concat('PO Number,Part Number,Product Name,Quantity,US Price,Comment',$newline)"/> <xsl:for-each select="./Items/Item"> <xsl:value-of select="concat('"',/PurchaseOrder/PurchaseOrderNumber,'","',PartNumber,'","',ProductName,'",',Quantity,',',USPrice,',"',Comment,'"',$newline)"/> </xsl:for-each> </xsl:template> </xsl:stylesheet>

Will produce this output:
PO Number,Part Number,Product Name,Quantity,US Price,Comment "99503","872-AA","Lawnmower",1,148.95,"Confirm this is electric" "99503","926-AA","Baby Monitor",2,39.98,""

Versatile	XML to HTML, XML to CSV, JSON to HTML, JSON to CSV, and more
Productive	Use our online API service to transform your XML without any installed software
Cost Effective	Requests start at $0.01 each and volume discounts can bring it as low as $0.00002 each.
Free to try	Your first 100 transformations are free!
Scalable	Our platform can scale with your growth because we use the power of the Amazon cloud services.
Easy to integrate	Use any tool or language to make a request to our online API. See details in the documentation.
Responsive	We are always looking for more and better ways to make you more productive. How can we serve you better? Please tell us how we can serve you better!
Sustainable	Because we run on the Amazon Cloud platform, resources are only used when needed.
Easy to signup	You can Signup with just an email address and credit card.
Easy to test	After login go to our test page to immediately start your transformations.

How can we serve you better?
Please tell us how we can serve you better!