Tip #1457: Format JSON for human consumption
Data often flows in automation using the JSON format, which is not user-friendly. A code-only connector can be created to produce nicely formatted emails with form submission results. The JSON Extractor CoC can be used to accomplish this in three steps: 1. Call the Extract JSON action to get an array of all property names. 2. Transform the properties array into a name/value array using the Select action. 3. Create an HTML table. The result is a formatted table that can be included in an email. Note that single-value properties are unfurled, while arrays or objects are kept as is.
Article 13m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time