OpenAPI + Steampipe

select
  api_path,
  operation_id,
  summary,
  deprecated,
  tags
from
  openapi_path;

+----------+---------------------+--------------------------+------------+--------+
| api_path | operation_id        | summary                  | deprecated | tags   |
+----------+---------------------+--------------------------+------------+--------+
| /get     | listVersionsv2      | List API versions        | false      | <null> |
| /v2/get  | getVersionDetailsv2 | Show API version details | false      | <null> |
+----------+---------------------+--------------------------+------------+--------+

steampipe plugin install openapi

connection "openapi" {
  plugin = "openapi"

  # Paths is a list of locations to search for OpenAPI definition files
  # Paths can be configured with a local directory, a remote Git repository URL, or an S3 bucket URL
  # Refer https://hub.steampipe.io/plugins/turbot/openapi#supported-path-formats for more information
  # Wildcard based searches are supported, including recursive searches
  # Local paths are resolved relative to the current working directory (CWD)

  # For example:
  #  - "*.json" matches all OpenAPI JSON definition files in the CWD
  #  - "**/*.json" matches all OpenAPI JSON definition files in the CWD and all sub-directories
  #  - "../*.json" matches all OpenAPI JSON definition files in the CWD's parent directory
  #  - "*.yml" or "*.yaml" matches all OpenAPI YML or YAML definition files in the CWD
  #  - "**/*.yml" or "**/*.yaml" matches all OpenAPI YML or YAML definition files in the CWD and all sub-directories
  #  - "../*.yml" or "../*.yaml" matches all OpenAPI YML or YAML definition files in the CWD's parent directory
  #  - "steampipe*.json" or "steampipe*.yml" or "steampipe*.yaml" matches all OpenAPI definition files starting with "steampipe" in the CWD
  #  - "/path/to/dir/*.json" or "/path/to/dir/*.yml" or "/path/to/dir/*.yaml" matches all OpenAPI definition files in a specific directory
  #  - "/path/to/dir/main.json" or "/path/to/dir/main.yml" or "/path/to/dir/main.yaml" matches a specific file

  # If paths includes "*", all files (including non-OpenAPI definition files) in
  # the CWD will be matched, which may cause errors if incompatible file types exist

  # Defaults to CWD
  paths = [ "*.json", "*.yml", "*.yaml" ]
}

connection "openapi" {
  plugin = "openapi"

  paths = [
    "*.json",
    "~/*.json",
    "github.com/OAI/OpenAPI-Specification//examples/v2.0/json//*.json",
    "github.com/OAI/OpenAPI-Specification//examples/v2.0/yaml//*.yaml",
    "s3::https://bucket.s3.us-east-1.amazonaws.com/test_folder//*.json"
  ]
}

connection "openapi" {
  plugin = "openapi"

  paths = [ "*.json", "*.yml", "*.yaml", "~/*.json", "/path/to/dir/main.json" ]
}

connection "openapi" {
  plugin = "openapi"

  paths = [ 
    "github.com/OAI/OpenAPI-Specification//examples/v2.0/json//*.json",
    "github.com/OAI/OpenAPI-Specification//examples/v2.0/yaml//*.yaml"
  ]
}

connection "openapi" {
  plugin = "openapi"

  paths = [
    "github.com/OAI/OpenAPI-Specification//examples/v2.0/json//*.json",
    "github.com/OAI/OpenAPI-Specification//examples/v2.0/yaml//*.yaml"
  ]
}

connection "openapi" {
  plugin = "openapi"

  paths = [
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com//*.json?aws_profile=<AWS_PROFILE>",
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com/test_folder//*.yaml?aws_profile=<AWS_PROFILE>"
  ]
}

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "ReadBucketObject",
      "Effect": "Allow",
      "Principal": {
        "AWS": "arn:aws:iam::123456789012:user/YOUR_USER"
      },
      "Action": ["s3:ListBucket", "s3:GetObject", "s3:GetObjectVersion"],
      "Resource": ["arn:aws:s3:::test-bucket1", "arn:aws:s3:::test-bucket1/*"]
    }
  ]
}

connection "openapi" {
  plugin = "openapi"

  paths = [
    "s3::https://bucket-1.s3.us-east-1.amazonaws.com/test_folder//*.json",
    "s3::https://bucket-2.s3.us-east-1.amazonaws.com/test_folder//**/*.yaml"
  ]
}

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/postgres.sh)" -- openapi

CREATE EXTENSION IF NOT EXISTS steampipe_postgres_openapi;
CREATE SERVER steampipe_openapi FOREIGN DATA WRAPPER steampipe_postgres_openapi OPTIONS (config '<your_config>');
CREATE SCHEMA openapi;
IMPORT FOREIGN SCHEMA openapi FROM SERVER steampipe_openapi INTO openapi;

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/sqlite.sh)" -- openapi

$ sqlite3
sqlite> .load ./steampipe_sqlite_extension_openapi.so
sqlite> select steampipe_configure_openapi('<your_config>');

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- openapi

steampipe_export_openapi --config '<your_config>' <table_name>