Amazon Ads Connector
Amazon Ads Connector
Documentation
Version: 1
ZappySys Logo
Documentation
Amazon Ads Connector
Amazon Ads Connector
Version: 1
  • Amazon Ads Connector
    • What's new
  • Authentication
    • OAuth Authentication
  • SSIS
    • Getting started
    • Reading data
    • Writing data
  • SQL Server
    • Getting started
    • Reading data
    • SQL examples
  • ODBC
    • Getting started
    • Reading data
    • SQL examples
  • Tables
    • __DynamicRequest__
    • Profiles
  • Endpoints
    • Get Beta Report
    • Get Profiles
    • Get Report
    • Test Connection
    • 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
  • Amazon Ads Connector
    • What's new
  • Authentication
    • OAuth Authentication
  • SSIS
    • Getting started
    • Reading data
    • Writing data
  • SQL Server
    • Getting started
    • Reading data
    • SQL examples
  • ODBC
    • Getting started
    • Reading data
    • SQL examples
  • Tables
    • __DynamicRequest__
    • Profiles
  • Endpoints
    • Get Beta Report
    • Get Profiles
    • Get Report
    • Test Connection
    • 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 » Amazon Ads 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 Amazon Ads.

  • Get profile by ID
  • List profiles
  • List profiles filtered by country and currency
  • Read Sponsored Products report (beta API)
  • Read Sponsored Products report (legacy API)
ZappySys LLC.