List columns
GET https://api.digicert.com/reports/v1/report/types/{{report_type}}/supported-columns
Use this endpoint to list details about the columns and filters you can add to a report of a given report_type.
Example requests and responses
curl --request GET 'https://api.digicert.com/reports/v1/report/types/orders/supported-columns' \
--header 'X-DC-DEVKEY: {{api_key}}' \
--header 'Content-Type: application/json' \{
"display_categories": [
{
"display_category_name": "Order details",
"display_sub_categories": [
{
"display_sub_category_name": "Order information",
"display_columns": [
{
"identifier": "account_id",
"display_name": "Account ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "account_name",
"display_name": "Account name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "additional_email",
"display_name": "Additional email",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "alternative_or_legacy_order_id",
"display_name": "Alternative/Legacy order ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "certificate_id",
"display_name": "Certificate ID",
"field_type": "INTEGER",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "multi_value",
"filter_only": false
},
{
"identifier": "certificate_requested_date",
"display_name": "Certificate requested date (UTC)",
"field_type": "DATE",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "last_30_days",
"display_name": "Last 30 days"
},
{
"operator_identifier": "last_month",
"display_name": "All certificates from last month"
},
{
"operator_identifier": "month_to_date",
"display_name": "Month to date"
},
{
"operator_identifier": "quarter_to_date",
"display_name": "Quarter to date"
},
{
"operator_identifier": "last_12_months",
"display_name": "Last 12 months"
},
{
"operator_identifier": "year_to_date",
"display_name": "Year to date"
},
{
"operator_identifier": "custom_date",
"display_name": "Custom date (maximum range of 90 days)"
},
{
"operator_identifier": "all_certs",
"display_name": "All certificates to current date"
}
],
"subaccount_column": false,
"is_required": true,
"recommended_default": false,
"filter_type": "date",
"filter_only": false
},
{
"identifier": "contains_wildcard",
"display_name": "Contains wildcard",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "division_or_container_id",
"display_name": "Division/Container ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "division_or_container_name",
"display_name": "Division/Container name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "division_or_container_status",
"display_name": "Division/Container status",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "number_of_sans",
"display_name": "Number of SANs",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "order_created_date",
"display_name": "Order created date (UTC)",
"field_type": "DATE",
"enabled": true,
"subaccount_column": false,
"is_required": true,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "order_email_client_certificate",
"display_name": "Order email (client certificate)",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "multi_value",
"filter_only": false
},
{
"identifier": "order_expiration_date",
"display_name": "Order expiration date (UTC)",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "expires_within_30_days",
"display_name": "Expires within 30 days"
},
{
"operator_identifier": "expires_within_60_days",
"display_name": "Expires within 60 days"
},
{
"operator_identifier": "expires_within_90_days",
"display_name": "Expires within 90 days"
},
{
"operator_identifier": "expired_in_the_last_7_days",
"display_name": "Expired in the last 7 days"
},
{
"operator_identifier": "expired",
"display_name": "Expired"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "static",
"filter_only": false
},
{
"identifier": "order_id",
"display_name": "Order ID",
"field_type": "INTEGER",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": true,
"recommended_default": false,
"filter_type": "multi_value",
"filter_only": false
},
{
"identifier": "order_month",
"display_name": "Order month",
"field_type": "INTEGER",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "order_placed_via",
"display_name": "Order placed via",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "multi_value",
"possible_values": [
"API",
"CertCentral",
"Guest Access",
"Guest URL"
],
"filter_only": false
},
{
"identifier": "order_revocation_date",
"display_name": "Order revocation date (UTC)",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "order_status",
"display_name": "Order status",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "multi_value",
"possible_values": [
"Issued",
"Pending",
"Reissue pending",
"Renewed",
"Revoked",
"Rejected",
"Expired",
"Waiting pickup",
"Canceled"
],
"filter_only": false
},
{
"identifier": "order_validity_years",
"display_name": "Order validity years",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "order_year",
"display_name": "Order year",
"field_type": "INTEGER",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "product_id",
"display_name": "Product ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "product_name",
"display_name": "Product name",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "product_api",
"filter_only": false
},
{
"identifier": "product_type",
"display_name": "Product type",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "multi_value",
"filter_only": false
},
{
"identifier": "purchased_non_wildcard_fqdn",
"display_name": "Purchased non wildcard FQDN",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "purchased_wildcard_sans",
"display_name": "Purchased wildcard SANs",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "request_state",
"display_name": "Request state",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "server_license",
"display_name": "Server license",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "server_type",
"display_name": "Server type",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
}
]
},
{
"display_sub_category_name": "Renewal, reissue, and duplicate information",
"display_columns": [
{
"identifier": "auto_renew",
"display_name": "Auto renew",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "certificate_reissue_or_duplicate_date",
"display_name": "Certificate reissue/duplicate date (UTC)",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "custom_renewal_message",
"display_name": "Custom renewal message",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "disabled_renewal_notifications",
"display_name": "Disabled renewal notifications",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "is_renewed",
"display_name": "Is renewed",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "reissued_order_new_cn",
"display_name": "Reissued order new CN",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "reissued_order_new_sans",
"display_name": "Reissued order new SANs",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "reissued_order_old_cn",
"display_name": "Reissued order old CN",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "reissued_order_old_sans",
"display_name": "Reissued order old SANs",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "renewed_order_id",
"display_name": "Renewed order ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
}
]
},
{
"display_sub_category_name": "Contact information",
"display_columns": [
{
"identifier": "organization_contact_email",
"display_name": "Organization contact email",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "organization_contact_job_title",
"display_name": "Organization contact job title",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "organization_contact_name",
"display_name": "Organization contact name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "organization_contact_telephone",
"display_name": "Organization contact telephone",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "technical_contact_email",
"display_name": "Technical contact email",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "technical_contact_job_title",
"display_name": "Technical contact job title",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "technical_contact_name",
"display_name": "Technical contact name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "technical_contact_telephone",
"display_name": "Technical contact telephone",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "user_or_approver_email",
"display_name": "User/Approver email",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "user_or_approver_id",
"display_name": "User/Approver ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "user_or_approver_name",
"display_name": "User/Approver name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "user_or_requester_email",
"display_name": "User/Requester email",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "multi_value",
"filter_only": false
},
{
"identifier": "user_or_requester_id",
"display_name": "User/Requester ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "user_or_requester_name",
"display_name": "User/Requester name",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "user_api",
"filter_only": false
}
]
},
{
"display_sub_category_name": "Billing and shipping information",
"display_columns": [
{
"identifier": "billing_address_city",
"display_name": "Billing address city",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_address_country",
"display_name": "Billing address country",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_address_line_1",
"display_name": "Billing address line 1",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_address_line_2",
"display_name": "Billing address line 2",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_address_state",
"display_name": "Billing address state",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_address_zip_code",
"display_name": "Billing address zip code",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_contact_email",
"display_name": "Billing contact email",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_contact_name",
"display_name": "Billing contact name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "billing_contact_organization_name",
"display_name": "Billing contact organization name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_address_line_1",
"display_name": "Shipping address line 1",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_address_line_2",
"display_name": "Shipping address line 2",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_city",
"display_name": "Shipping city",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_country",
"display_name": "Shipping country",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_name",
"display_name": "Shipping name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_state",
"display_name": "Shipping state",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "shipping_zip_code",
"display_name": "Shipping zip code",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
}
]
},
{
"display_sub_category_name": "Payment and transaction information",
"display_columns": [
{
"identifier": "account_currency",
"display_name": "Account currency",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "competitive_replacement_benefit_additional_days",
"display_name": "Competitive replacement benefit additional days",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "competitive_replacement_benefit_percentage",
"display_name": "Competitive replacement benefit percentage",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "competitive_replacement_order_actual_price",
"display_name": "Competitive replacement order actual price",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "deal_id",
"display_name": "Deal ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "estimated_tax",
"display_name": "Estimated tax",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "multi_year_plan",
"display_name": "Multi year plan",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "net_price",
"display_name": "Net price",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "payment_method",
"display_name": "Payment method",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "multi_value",
"possible_values": [
"Account balance",
"Credit Card",
"Voucher",
"Wire Transfer",
"Unit",
"PO"
],
"filter_only": false
},
{
"identifier": "provisioning_method",
"display_name": "Provisioning method",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "purchase_amount",
"display_name": "Purchase amount",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "receipt_id",
"display_name": "Receipt ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "total_units",
"display_name": "Total units",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "transaction_date",
"display_name": "Transaction date (UTC)",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "transaction_type",
"display_name": "Transaction type",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "unit_id",
"display_name": "Unit ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "wire_transfer_order_invoice_id",
"display_name": "Wire transfer order invoice ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
}
]
},
{
"display_sub_category_name": "Subaccount information",
"display_columns": [
{
"identifier": "parent_account_currency",
"display_name": "Parent account currency",
"field_type": "STRING",
"enabled": true,
"subaccount_column": true,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "parent_account_pricing",
"display_name": "Parent account pricing",
"field_type": "STRING",
"enabled": true,
"subaccount_column": true,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "subaccount_currency",
"display_name": "Subaccount currency",
"field_type": "STRING",
"enabled": true,
"subaccount_column": true,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "subaccount_division_or_container_id",
"display_name": "Subaccount division/container ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": true,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "subaccount_name",
"display_name": "Subaccount name",
"field_type": "STRING",
"enabled": true,
"subaccount_column": true,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "subaccount_pricing",
"display_name": "Subaccount pricing",
"field_type": "STRING",
"enabled": true,
"subaccount_column": true,
"is_required": false,
"recommended_default": false,
"filter_only": false
}
]
}
]
},
{
"display_category_name": "Certificate details",
"display_sub_categories": [
{
"display_sub_category_name": "Certificate information",
"display_columns": [
{
"identifier": "certificate_pem_format",
"display_name": "Certificate (PEM format)",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "certificate_status",
"display_name": "Certificate status",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "multi_value",
"possible_values": [
"Issued",
"Pending",
"Reissue pending",
"Renewed",
"Revoked",
"Rejected",
"Expired",
"Waiting pickup"
],
"filter_only": false
},
{
"identifier": "certificate_validity_in_days",
"display_name": "Certificate validity in days",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "common_name",
"display_name": "Common name",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
},
{
"operator_identifier": "contains",
"display_name": "Contains"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "multi_value",
"filter_only": false
},
{
"identifier": "country",
"display_name": "Country",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "csr",
"display_name": "CSR",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "days_remaining_until_expiration",
"display_name": "Days remaining until expiration",
"field_type": "INTEGER",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "expires_within_30_days",
"display_name": "Expires within 30 days"
},
{
"operator_identifier": "expires_within_60_days",
"display_name": "Expires within 60 days"
},
{
"operator_identifier": "expires_within_90_days",
"display_name": "Expires within 90 days"
},
{
"operator_identifier": "expired_in_the_last_7_days",
"display_name": "Expired in the last 7 days"
},
{
"operator_identifier": "expired",
"display_name": "Expired"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "static",
"filter_only": false
},
{
"identifier": "dcv_method",
"display_name": "DCV method",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "intermediate_ca",
"display_name": "Intermediate CA",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_type": "intermediate_ca_api",
"filter_only": false
},
{
"identifier": "intermediate_ca_id",
"display_name": "Intermediate CA ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "locality",
"display_name": "Locality",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "logged_to_public_ct",
"display_name": "Logged to public Certificate Transparency (CT) logs",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "organization_id",
"display_name": "Organization ID",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "organization_name",
"display_name": "Organization name",
"field_type": "STRING",
"enabled": true,
"supported_operators": [
{
"operator_identifier": "in",
"display_name": "Exact Match"
}
],
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_type": "organization_api",
"filter_only": false
},
{
"identifier": "organization_unit",
"display_name": "Organization unit",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "root",
"display_name": "Root",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "sans",
"display_name": "SANs",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "serial_number",
"display_name": "Serial number",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": true,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "signature_hash",
"display_name": "Signature hash",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "state",
"display_name": "State",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "thumbprint",
"display_name": "Thumbprint",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": false,
"filter_only": false
},
{
"identifier": "validity_end_date",
"display_name": "Validity end date (UTC)",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
},
{
"identifier": "validity_start_date",
"display_name": "Validity start date (UTC)",
"field_type": "STRING",
"enabled": true,
"subaccount_column": false,
"is_required": false,
"recommended_default": true,
"filter_only": false
}
]
}
]
}
]
}Path parameters
Name | Req/Opt | Description |
|---|---|---|
report_type | required | Report type. Possible values: |
URL query parameters
Name | Req/Opt | Type | Description |
|---|---|---|---|
language_id | optional | integer | ID of the language to use for the strings returned in these fields:
Allowed values: See Glossary – Locale codes. Default: English ( |
Response parameters
Name | Type | Description |
|---|---|---|
display_categories | array of objects | List of objects containing details about the column categories available for the |
.. display_category_name | string | Column category display name. To get this value in a language other than English, use the |
.. display_sub_categories | array of objects | List of objects containing details about each column subcategory. |
.. .. display_sub_category_name | string | Column subcategory display name. To get this value in a language other than English, use the |
.. .. display_columns | array | List of objects with details about each column. |
.. .. .. identifier | string | Column identifier. |
.. .. .. display_name | string | Column display name. To get this value in a language other than English, use the |
.. .. .. field_type | string | Data type of the value that the column contains in the report. Possible values: |
.. .. .. enabled | boolean | If true, the column is enabled, and you can include data from the column in a report. If false, you cannot include the column in a report. You can still add a filter for the column (see |
.. .. .. supported_operators | array of objects | List of objects with details about the operators you can use to add filters for this column while building a custom report. |
.. .. .. .. operator_identifier | string | Operator ID. Possible values: See Filters reference: Types and operators |
.. .. .. .. display_name | string | Operator display name. |
.. .. .. subaccount_column | boolean | If true, the column only contains data for subaccounts. Otherwise, false. |
.. .. .. is_required | boolean | If true, the column is required in all reports of the given |
.. .. .. recommended_default | boolean | If true, we recommend you always include the column when building reports of the specified |
.. .. .. filter_only | boolean | If true, you can add a filter for the column, but you cannot include data from the column in a report. If false, you can include the column in a report. Also, if the column has filter operators, you can use an |
.. .. .. filter_type | string | Filter type for the column. The filter type describes the values the column can be filtered against. Possible values: See Filters reference: Types and operators |
.. .. .. possible_values | array of strings | List of possible values to use as filter criteria when adding a filter for the column.
|