Skip to content
AWS for Query.Farm

aws.apigateway.get_rest_apis

Example SQL Queries

SELECT * FROM
aws.apigateway.get_rest_apis;

Description

Lists the RestApis resources for your collection.

Table Definition

Column NameColumn Data Type
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
api_key_source

The source of the API key for metering requests according to a usage plan. Valid values are: >HEADER to read the API key from the X-API-Key header of a request. AUTHORIZER to read the API key from the UsageIdentifierKey from a custom authorizer.

VARCHAR
binary_media_types

The list of binary media types supported by the RestApi. By default, the RestApi supports only UTF-8-encoded text payloads.

VARCHAR[]
Show child fields
binary_media_types[]
created_date

The timestamp when the API was created.

TIMESTAMP_S
description

The API's description.

VARCHAR
disable_execute_api_endpoint

Specifies whether clients can invoke your API by using the default execute-api endpoint. By default, clients can invoke your API with the default https://{api_id}.execute-api.{region}.amazonaws.com endpoint. To require that clients use a custom domain name to invoke your API, disable the default endpoint.

BOOLEAN
endpoint_configuration

The endpoint configuration of this RestApi showing the endpoint types of the API. 

STRUCT(
    "types" VARCHAR[],
    "vpc_endpoint_ids" VARCHAR[]
)
Show child fields
endpoint_configuration.types[]
endpoint_configuration.vpc_endpoint_ids[]
id

The API's identifier. This identifier is unique across all of your APIs in API Gateway.

VARCHAR
minimum_compression_size

A nullable integer that is used to enable compression (with non-negative between 0 and 10485760 (10M) bytes, inclusive) or disable compression (with a null value) on an API. When compression is enabled, compression or decompression is not applied on the payload if the payload size is smaller than this value. Setting it to zero allows compression for any payload size.

BIGINT
name

The API's name.

VARCHAR
policy

A stringified JSON policy document that applies to this RestApi regardless of the caller and Method configuration.

VARCHAR
root_resource_id

The API's root resource ID.

VARCHAR
tags

The collection of tags. Each tag element is associated with a given resource.

MAP(VARCHAR, VARCHAR)
version

A version identifier for the API.

VARCHAR
warnings

The warning messages reported when failonwarnings is turned on during API import.

VARCHAR[]
Show child fields
warnings[]