Envelopes
The Envelope provides methods that allow you to manage envelopes
View Specific Information
The driver will use the DocuSign API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- EnvelopeId supports the '='.
- Status supports the '='.
- DateToSearch supports the '=,>,>=,<,<='.
For example, the following queries are processed server side:
SELECT * FROM Envelopes WHERE EnvelopeId = '764c564c-b540-42d1-a667-ccee6813ef7b' SELECT * from Envelopes where DateToSearch <= '2024-05-15 10:55:11' SELECT * from Envelopes where DateToSearch >= '2024-05-15 10:55:11'
Columns
| Name | Type | References | Description |
| EnvelopeId [KEY] | String | The envelope ID. | |
| EnvelopeUri | String | Contains a URI for an endpoint that you can use to retrieve the envelope or envelopes. | |
| Status | String | Indicates the envelope status. Valid values are: completed - The envelope has been completed and all tags have been signed. created - The envelope is created as a draft. It can be modified and sent later. declined - The envelope has been declined by the recipients. delivered - The envelope has been delivered to the recipients. sent - The envelope is sent to the recipients. signed - The envelope has been signed by the recipients. voided - The envelope is no longer valid and recipients cannot access or sign the envelope. | |
| EnvelopeIdStamping | String | When set to true, Envelope ID Stamping is enabled. | |
| EmailSubject | String | Specifies the subject of the email that is sent to all recipients. | |
| EmailBlurb | String | This is the same as the email body. | |
| SenderUserName | String | The sender username associated with the envelope. | |
| SenderUserId | String | The sender user ID associated with the envelope. | |
| SenderAccountId | String | The sender account ID associated with the envelope. | |
| SenderEmail | String | The sender email associated with the envelope. | |
| DocumentsUri | String | Contains a URI for an endpoint that you can use to retrieve the documents. | |
| DocumentsCombinedUri | String | Contains a URI for an endpoint that you can use to retrieve the combined documents. | |
| AttachmentsUri | String | Contains a URI for an endpoint that you can use to retrieve the attachments. | |
| RecipientsUri | String | Contains a URI for an endpoint that you can use to retrieve the recipients. | |
| CustomFieldsUri | String | Contains a URI for an endpoint to retrieve the custom fields. | |
| CertificateUri | String | Retrieves a URI for an endpoint allowing you to easily retrieve certificate information. | |
| NotificationUri | String | Contains a URI for an endpoint that you can use to retrieve the notifications. | |
| SigningLocation | String | Specifies the physical location where the signing takes place. It can have two enumeration values; InPerson and Online. The default value is Online. | |
| BrandId | String | The unique identifier of a brand. | |
| BrandLock | String | Lock of the brand. | |
| SentDateTime | Datetime | The date and time the envelope was sent. | |
| CompletedDateTime | Datetime | Specifies the date and time this item was completed. | |
| CreatedDateTime | Datetime | Indicates the date and time the item was created. | |
| DeclinedDateTime | Datetime | The date and time the recipient declined the document. | |
| LastModifiedDateTime | Datetime | The date and time the item was last modified. | |
| DeletedDateTime | Datetime | Specifies the data and time the item was deleted. | |
| StatusChangedDateTime | Datetime | The data and time the status changed. | |
| VoidedDateTime | Datetime | The date and time the envelope was voided. | |
| VoidedReason | String | The reason the envelope was voided. | |
| MessageLock | String | When set to true, prevents senders from changing the contents of emailBlurb and emailSubject properties for the envelope. | |
| RecipientsLock | String | When set to true, prevents senders from changing, correcting, or deleting the recipient information for the envelope. | |
| PurgeState | String | Shows the current purge state for the envelope. The possible values are: unpurged: There has been no successful request to purge documents. documents_queued: The envelope documents have been added to the purge queue, but have not been purged. documents_dequeued: The envelope documents have been taken out of the purge queue. documents_and_metadata_queued: The envelope documents and metadata have been added to the purge queue, but have not yet been purged. documents_purged: The envelope documents have been successfully purged. documents_and_metadata_purged: The envelope documents and metadata have been successfully purged. | |
| EnableWetSign | String | When set to true, the signer is allowed to print the document and sign it on paper. | |
| EnforceSignerVisibility | String | When set to true, documents with tabs can only be viewed by signers that have a tab on that document. Recipients that have an administrative role (Agent, Editor, or Intermediaries) or informational role (Certified Deliveries or Carbon Copies) can always see all the documents in an envelope, unless they are specifically excluded using this setting when an envelope is sent. | |
| AllowReassign | String | When set to true, the recipient can redirect an envelope to a more appropriate recipient. | |
| AllowMarkup | String | When set to true, Document Markup is enabled for envelope. | |
| Asynchronous | String | When set to true, the envelope is queued for processing and the value of the status property is set to 'Processing'. Additionally, get status calls return 'Processing' until completed. | |
| AuthoritativeCopy | String | Specifies whether all documents in this envelope are authoritative copies. | |
| AuthoritativeCopyDefault | String | The default authoritativeCopy setting for documents in this envelope that do not have authoritativeCopy set. | |
| AutoNavigation | String | Specifies whether auto navigation is set for the recipient. | |
| ItemURL | String | Contains a ItemUrl to retrieve the envelopes. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| DateToSearch | Datetime | Date to search. |