Skip to main content

Working with JSON

Documentation in progress

This page is part of the planned documentation structure. Content will be migrated from Help Center or written fresh.

Who this is for: builders extracting and transforming structured data in Wrkflows What you'll learn: how to use JSON Path and SQL to retrieve, transform, and aggregate JSON data.

Video overview

This video covers:

  • Using JSON Path to retrieve values from JSON
  • Using SQL to transform and aggregate JSON

Planned sections

  • When to use JSON Path vs. SQL in Wrk Actions
  • Retrieving values with JSON Path expressions
  • Transforming and aggregating JSON with SQL
  • Mapping results to Fields to Capture and the Data Library
  • Related resources