PostgreSQL to join Array column
This is the PostgreSQL to pull all the Rules and associated Journey information for a single journeyid. Learned how to join an array column (actions.rules) from Gary Seiling’s website. SELECT …
Development Tools
JSON Formatter: https://jsonformatter.curiousconcept.com/ This makes our JSON data retrieved from APIs super easy to read. Observepoint Javascript Regex Tester: http://regex.observepoint.com/ Helpful to test Javascript regex