tDBResultsToJSON

• Version 1.0

Converts a database result set to a generic JSON string

---

Overiew of job flow

Setting up the datbaase components

1. Use a DBConnection component
2. The schema will include one column of type Object which is set to pass the ResultSet to the next component

Passing the database connection object

3. Pass the DB connection object by calling a global get

Configuring the features of the tDBResultsToJSON component

4. Define if the DATA, STRUCTURE, or BOTH should be inlcuded in the JSON
5. Define how to handle NULL values

6. Change the advanced setting when including STRUCTURE based on the type of database platform

JSON produced from SQL query