Many API's return data in a form of a JSON object. All APIs provide different types of JSON structures.One of the superpowers of a Lingk recipe is the ability to process and create any type of JSON, using just SQL.Public Recipe Library ExamplesUse Dot Notation to access nested JSON - https://recipelib.lingk.io/recipe/selecting-nested-data-in-recipes/Convert Nested Array to Table - https://recipelib.lingk.io/recipe/convert-nested-array-to-table/Using SQL to create complex JSON structures - https://recipelib.lingk.io/recipe/using-sql-to-create-complex-json-structures/Nested Object Schemas - https://recipelib.lingk.io/recipe/nested-object-schemas/Querying JSON Structures - https://recipelib.lingk.io/recipe/convert-nested-array-to-table/Creating JSON Structures - https://recipelib.lingk.io/recipe/using-sql-to-create-complex-json-structures/Querying JSON structuresYou can query JSON using dot notation. To access nested array, you can convert them to tables using the inline(), explode() and explode_outer() functions. View the example recipe on the public recipe library.Creating JSON structuresThe struct(), named_struct() and 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.