Many APIs are JSON first. All APIs provide different types of JSON structures.
One of the super powers of a recipe is the ability to process and create any type of JSON using just SQL.
Public Recipe Library Examples
- Use Dot Notation to Access Nested JSON
- Convert Nested Array to Table
- Using SQL to Create Complex JSON Structures
- Nested Object Schemas
Querying JSON structures
You can query JSON using dot notation. To access nested array, you can convert them to tables using the
explode_outer() functions. View the example recipe on the public recipe library.
Creating JSON structures
collect_list() functions can be very helpful in creating the JSON structures needed for your file or API. View the example recipe on the public recipe library.