Command line
ftmq
accepts either a line-based input stream an argument with a file uri or a store uri to read (or write) Follow The Money Entities.
Input stream:
Under the hood, ftmq
uses anystore to be able to interpret arbitrary file uris as argument -i
:
ftmq <filter expression> -i ~/Data/entities.ftm.json
ftmq <filter expression> -i https://example.org/data.json.gz
ftmq <filter expression> -i s3://data-bucket/entities.ftm.json
ftmq <filter expression> -i webhdfs://host:port/path/file
Of course, the same is possible for output -o
:
cat data.json | ftmq <filter expression> -o s3://data-bucket/output.json
Filter expressions
Filter for a dataset:
Filter for a schema:
Filter for a schema and all it's descendants or ancestors:
cat entities.ftm.json | ftmq -s LegalEntity --schema-include-descendants
cat entities.ftm.json | ftmq -s LegalEntity --schema-include-ancestors
Filter for properties:
Properties are cli options via --<prop>=<value>
Comparison lookups for properties
Possible lookups:
gt
- greater thanlt
- lower thangte
- greater or equallte
- lower or equallike
- SQLishLIKE
(use%
placeholders)ilike
- SQLishILIKE
, case-insensitive (use%
placeholders)not
- negative lookup