Topic Options
#55121 - 07/26/17 08:52 AM PlanetPress Database Query to JSON
Uomo Del Ghiaccio Offline
OL Expert

Registered: 02/21/01
Posts: 668
With the PlanetPress database query plugin. It would be nice if there was an option to pick the output file emulation for JSON.
Uomo Del Ghiaccio

#55128 - 07/28/17 01:36 PM Re: PlanetPress Database Query to JSON [Re: Uomo Del Ghiaccio]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4956
Loc: Objectif Lune Montreal
Hi Uomo,

If you are using version 8 Connect, a workaround is to use a Run Script action to call a javascript that will build a custom object with values from your database, and you can then call the JSON methods to convert it to a JSON string, and store it in a variable for later use.

Note that this only works with version 8 and higher. In the classic 7.6.2 and lower, the JSON methods are unavailable in the Run Script action.

Raphaël Lalonde-Lefebvre