Overview
Syllabus
Welcome and introduction
Using the BTP Setup Automator container image for easy access to all the tools incl. jq, ijq and more
Taking a look at some of the jq command line options via jq --help
Starting with jqterm for our session
Considering valid JSON values
Thinking about streams of JSON values
Looking what slurp -s does for us
Considering raw input -R for non-JSON values
Looking briefly at the jq language server
Exploring some more realistic JSON, obtained via the btp CLI
Understanding what data the filter is looking at
Shorthand vs longhand filter expression
Capturing data via the variable operator, and how data is or isn't consumed
Using 'map', passing a filter expression, and how it's similar to JS
Asking for the length of an object gives us the number of properties
Understanding how jq passed data to multiple consuming filters
Producing objects using convenient property shorthand features
Filtering data out with 'select' plus a predicate expression
Sorting with 'sort_by'
Producing a flat list of values for further consumption or file storage, with raw output -r
A brief digression to consider the importance of the array iterator .[] and how it produces multiple values downstream
Looking at what the @tsv and @csv formatters will do for us
Transforming structure with 'group_by' and taking care to understand the new structure produced
Another digression on 'first' being just syntactic sugar for .[0]
Producing a list of data centers providers, with a count
A brief intro to how 'add' can add objects together
Taught by
SAP Developers