Gmail Connector
Gmail Connector
Documentation
Version: 3
ZappySys Logo
Documentation
Gmail Connector
Gmail Connector
Version: 3
  • Gmail Connector
    • What's new
  • Authentication
    • User Account
  • SSIS
    • Getting started
    • Reading data
    • Writing data
  • SQL Server
    • Getting started
    • Reading data
    • SQL examples
  • ODBC
    • Getting started
    • Reading data
    • SQL examples
  • Tables
    • __DynamicRequest__
    • Labels
    • MessageAttachments
    • Messages
    • MyMessages
  • Endpoints
    • Download Message Attachments (With search condition)
    • Get a Specific Attachment included in a Specific Message for the Current User
    • Get a Specific Message for a Specific User
    • Get a Specific Message for the Current User
    • Get labels
    • Get List of Messages for a Specific User
    • Get List of Messages for the Current User
    • Get message attachment for user
    • Get Message Attachments (With search condition)
    • Send a New Message for the specified User
    • Make Generic REST API Request
    • Make Generic REST API Request (Bulk Write)
  • Advanced topics
    • SQL functions
    • Placeholder functions
    • Stored procedures
    • Views
    • Metadata
    • SQL syntax
  • Integration
    • Applications & ETL tools
    • Programming languages
  • Connector file
    • Download
    • Source code
  • Custom connectors
    • Connector customization
    • Building your own connector
  • Discover
    • All connectors
    • Community
  • Gmail Connector
    • What's new
  • Authentication
    • User Account
  • SSIS
    • Getting started
    • Reading data
    • Writing data
  • SQL Server
    • Getting started
    • Reading data
    • SQL examples
  • ODBC
    • Getting started
    • Reading data
    • SQL examples
  • Tables
    • __DynamicRequest__
    • Labels
    • MessageAttachments
    • Messages
    • MyMessages
  • Endpoints
    • Download Message Attachments (With search condition)
    • Get a Specific Attachment included in a Specific Message for the Current User
    • Get a Specific Message for a Specific User
    • Get a Specific Message for the Current User
    • Get labels
    • Get List of Messages for a Specific User
    • Get List of Messages for the Current User
    • Get message attachment for user
    • Get Message Attachments (With search condition)
    • Send a New Message for the specified User
    • Make Generic REST API Request
    • Make Generic REST API Request (Bulk Write)
  • Advanced topics
    • SQL functions
    • Placeholder functions
    • Stored procedures
    • Views
    • Metadata
    • SQL syntax
  • Integration
    • Applications & ETL tools
    • Programming languages
  • Connector file
    • Download
    • Source code
  • Custom connectors
    • Connector customization
    • Building your own connector
  • Discover
    • All connectors
    • Community
Home » API Integration Hub » Gmail Connector » Documentation » ODBC ยป SQL examples
ODBC guide

SQL examples for ODBC


The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Gmail.

  • Download message attachments to local disk
  • Download multiple attachments with search condition (sent after specific date)
  • Get a specific message by ID
  • Get all messages
  • Get all messages for a specified user
  • Get all messages with search condition(s)
  • Get message attachments
  • Send a message
ZappySys LLC.