I need to produce json files from a fairly simple table. Using settings shown below, the file being produced isn't correct JSON syntax. Specifically, we're missing commas between the arrays, and the [ ] brackets at the start and end. The partner with whom I'm trying to integrate can't accept this invalid json, so I am stuck.
Here’s what is being produced:
{
“BRAND”: “CoMotion”,
“COLOR”: “Premium Paint Color”,
“DESCRIPTION”: “S/O CoMotion 50cm Ochoco 18 Speed Gear Box and Pathfinding Lighting Package”,
“EXPERIENCE”: “TOURING”,
“ID”: 210000124192,
“NAME”: “S/O CoMotion 50cm Ochoco 18 Speed Gear Box and Pathfinding Lighting Package”,
“PRICE”: 5939.99,
“PRICEWPROMO”: 5939.99,
“SIZE”: “Painted Silca Pump”,
“URL”: " "
} {
“BRAND”: “Orbea”,
“COLOR”: “Blk/Red”,
“DESCRIPTION”: “CR Orca OMR”,
“EXPERIENCE”: “COMPETITIVE ROAD”,
“ID”: 210000124221,
“NAME”: “CR Orca OMR”,
“PRICE”: 1900,
“PRICEWPROMO”: 1900,
“SIZE”: “57cm”,
“URL”: " "
}
Here is the valid json I would expect:
[{
“ID”: 210000122824,
“NAME”: “Pivot Mach 6 Pro XT/XTR Float”,
“BRAND”: “Pivot Cycles”,
“EXPERIENCE”: “FS MOUNTAIN LONG TRAVEL”,
“SIZE”: “LG”,
“PRICE”: 7799.9900,
“PRICEWPROMO”: 7019.9500,
“DESCRIPTION”: “Pivot Mach 6 Pro XT/XTR Float”,
“COLOR”: “Stealth”,
“URL”: " "
},
{
“ID”: 210000110574,
“NAME”: “BBB Hotrock 24"”,
“BRAND”: “Specialized”,
“EXPERIENCE”: “KIDS BIKE, USED”,
“SIZE”: “”,
“PRICE”: 250.0000,
“PRICEWPROMO”: 250.0000,
“DESCRIPTION”: “BBB Hotrock 24"”,
“COLOR”: “”,
“URL”: " "
}
]