PlanetPress Database Query to JSON

Posted by: Uomo Del Ghiaccio

PlanetPress Database Query to JSON - 07/26/17 08:52 AM

With the PlanetPress database query plugin. It would be nice if there was an option to pick the output file emulation for JSON.
Posted by: Raphael Lalonde Lefebvre

Re: PlanetPress Database Query to JSON - 07/28/17 01:36 PM

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