How to sanitize multiple nasty strings to JSON for Slack blocks

Questions
, , ,
5

Thanks for the suggestions @samliew, @ponvaskon ! It was however not what I was looking for.

What I actually needed was to take a few steps back and now I return with a solution.

  1. Google Sheet module - Many variables data source
  2. Parse JSON module - Will correctly map variables into the final JSON object. Do not use “data structure” only use JSON string. Run the scenario with sample data to be able to populate last module.
  3. Slack module - Will accept (bundle) output from module 2. Seems to be proper sanitized JSON.

See screenshots. Result is nicely formatted Slack blocks message without dealing with sluggish 1700vh high “data structure” editor.

image
image2669×1290 230 KB

image
image1572×429 36.6 KB