IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

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: 669
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
--------------------

Top
#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.

Regards,
Raphaël Lalonde-Lefebvre

Top