Skip to main content

order_details

QUERY https://www.digicert.com/services/v2/reports/query

Use this query to get specific details for all certificate orders.

Notice

To get specific details for a single certificate order, use order_details_by_id query.

Arguments

Include query arguments to filter, search, or manipulate data. Separate multiple arguments using commas. With the exception of sort, all arguments use a key:value format (e.g., status:"issued").

Filters

Use filter arguments to narrow query data to specified parameter values. Multiple filters can be used to further narrow results.

Name

Req/Opt

Type

Description

id

optional

int

Order ID.

status

optional

string

Order status. See Glossary – Order status.

valid_from

optional

string

Date when certificate validity starts.

Format: yyyy-MM-dd

Operator: >=

valid_till

optional

string

Date when certificate validity ends.

Format: yyyy-MM-dd

Operator: <=

container_id

optional

string

Container ID.

organization_id

optional

string

Organization ID.

product_name_id

optional

string

Name ID of the product. See Glossary – Product identifiers.

serial_number

optional

string

Serial number of the certificate.

signature_hash

optional

string

Signature hash used to sign the certificate request.

user_id

optional

string

ID of the user that placed the order.

date_created

optional

string

Date the order was placed.

Format: yyyy-MM-dd HH:mm:ss

Operator: >=

ca_cert_id

optional

string

ID of the issuing certificate authority.

common_name

optional

string

Name secured by the certificate.

Use % for a like operator (e.g., common_name:"%example.com").

dns_names

optional

string

List of additional names secured by the certificate.

locale

optional

string

Locale of the order. See Glossary – Locale codes.

thumbprint

optional

string

Thumbprint of the certificate.

email

optional

string

Customer order email.

Search

Use search argument to find a specific string contained in searched fields.

Name

Req/Opt

Type

Description

search

optional

string

Search specific fields for included string.

Use % for a like operator (e.g., search:"%example.com").

Searched fields: id, status, container_id, organization_id, product_name_id, additional_emails, organization_name, product_name, serial_number, user_id, common_name, email

Sort and pagination

Use sort and pagination arguments to manipulate returned query results.

Name

Req/Opt

Type

Description

sort

optional

array

Specify sort field and direction.

Format: ["{{field}}","{{direction}}"]

Allowed values (field): valid_till, container_id, organization_id, product_name_id, serial_number, signature_hash, user_id, date_created, ca_cert_id, common_name, dns_names, locale, thumbprint, email

Allowed values (direction): ASC, DESC

Default: ["id","DESC"]

offset

optional

int

Start list at the specified number for pagination.

Default: 0

limit

optional

int

Truncate list to the specified number for pagination.

Max: 1000 (default)

Fields

Important

At least one field must be included in the request. If no fields are sent, a syntax error is returned.

Notice

If no data exists for the field, a value of null is returned.

Name

Type

Description

account_id

string

Account ID associated with the order.

additional_emails

string

Additional email addresses on the order.

agreement_id

string

ID of the CSA agreed to.

auto_renew

string

Specify if the certificate should automatically renew.

Possible values: 0 (disabled), 1 (enabled)

ca_cert_id

string

ID of the issuing certificate authority.

certificate_tracker_id

string

Certificate ID.

common_name

string

Name secured by the certificate.

contacts_email

string

Organization contact email address.

container_id

string

Container ID of the order.

container_name

string

Container name of the order.

cost

string

Order cost.

csr

string

Certificate signing request (CSR).

custom_renewal_message

string

Custom message included in renewal notifications.

customer_order_id

string

Customer order ID.

date_created

string

Date the order was placed.

Format: yyyy-MM-dd HH:mm:ss

dcv_method

string

Domain control validation method configured for the domain. See Glossary – DCV methods.

disable_issuance_email

string

Specifies if issuance emails are sent.

Possible values: 0 (false), 1 (true)

disable_renewal_notifications

string

Specifies if renew notifications are enabled.

Possible values: 0 (false), 1 (true)

dns_names

string

Comma separated list of additional names secured by the certificate.

email

string

If certificate has an embedded email address (e.g., client certificates), returns the email address on the certificate.

firstname

string

First name of organization contact.

has_duplicates

int

Specifies if the certificate has duplicates.

Possible values: 0 (false), 1 (true)

id

string

Order ID.

is_out_of_contract

string

Contract status of the order.

Possible values: 0 (false), 1 (true)

is_renewed

string

Specifies if the order has been renewed.

Possible values: 0 (false), 1 (true)

issuer_common_name

string

Friendly name of the issuing certificate authority.

job_title

string

Job title of the organization contact.

lastname

string

Last name of the organization contact.

locale

string

Locale of the order. See Glossary – Locale codes.

metadata

string

Custom field details.

Format: {{metadata_id}} {{metadata_label}} {{metadata_value}}

Data separator: 0x1f

org_addr1

string

Organization address.

org_addr2

string

organization_city

string

City where the organization is located.

organization_country

string

Country where the organization is located.

organization_id

string

Organization ID associated with the order.

organization_name

string

Organization name.

organization_state

string

State where the organization is located.

organization_unit

string

Organization units on the certificate.

pay_type

string

Payment method used for the order.

Possible values: A (account balance), C (credit card)

plus_feature

string

Specifies if plus feature is enabled for the order.

Possible values: 0 (disabled), 1 (enabled)

product_id

string

ID of the product.

product_name

string

Display name of the product. See Glossary – Product identifiers.

product_name_id

string

Name ID of the product. See Glossary – Product identifiers.

product_type

string

Product type. See Glossary – Product types.

purchased_dns_names

string

Number of additional SANs purchased.

receipt_id

string

Receipt ID.

Renewed

string

Specifies if the order has been renewed.

Possible values: FALSE, TRUE

renewed_order_id

string

Order ID of the previous order. Returned only if order is a renewal.

serial_number

string

Serial number of the certificate.

server_platform_id

string

Server platform ID. See Glossary – Server platforms.

signature_hash

string

Signature hash used to sign the certificate request.

status

string

Order status. See Glossary – Order status.

telephone

string

Phone number of organization contact.

thumbprint

string

Thumbprint of the certificate.

user_assignments

string

ID of the user assigned to the order.

user_email

string

Email address of user that requested the certificate.

user_first_name

string

First name of user that requested the certificate.

user_id

string

ID of the user that placed the order.

user_last_name

string

Last name of user that requested the certificate.

valid_from

string

Date when certificate validity starts.

Format: yyyy-MM-dd

valid_till

string

Date when certificate validity ends.

Format: yyyy-MM-dd

validity_years

string

Number of years the certificate is valid.

Response parameters

Name

Type

Description

data

object

Container for returned query data.

.. order_details

array

List of order objects containing queried fields.

.. .. {{field}}

-

Queried field and value. Returned fields dependent on sent query.