Amazon Selling Partner API Configuration

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "amazon_selling_partner",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "destination_schema_names": "SOURCE_NAMING",
  "config": {
    "is_vendor": true,
    "merchant_id": "test_merchant_id",
    "historical_sync_time_frame": "ALL_TIME | DATE_LIMIT",
    "region": "NORTH_AMERICA | EUROPE | FAR_EAST",
    "backward_sync_limit": "2020-01-01",
    "schema": "schema_name"
  },
  "auth": {
    "refresh_token": "my_refresh_token",
    "role_arn": "my_iam_role_arn",
    "aws_access_key": "my_aws_access_key",
    "client_secret": "my_client_secret",
    "aws_secret_key": "my_aws_secret_key",
    "client_id": "my_client_id"
  }
}

Config parameters

Name	Description
`is_vendor`	Whether or not you have a Vendor Account. Default value: `false`.
`merchant_id`	The Merchant ID or Vendor Code.
`historical_sync_time_frame`	The time frame for historical data synchronization. Default value: `ALL_TIME`.
`region`	The region used by the Amazon Selling Partner profile.
`backward_sync_limit`	The earliest date to sync data from, in YYYY-MM-DD format. Cannot be before 1994-01-01 or in the future.
`schema` (required)	Destination schema name. Schema name is permanent and cannot be changed after connection creation

Authorization

There are two ways to authorize this connector type:

By specifying the values for the aws_access_key, aws_secret_key, role_arn, client_id, client_secret and refresh_token parameters in the auth section.

POST https://api.fivetran.com/v1/connections

{
  "service": "amazon_selling_partner",
  "group_id": "group_id",
  "auth": {
    "aws_access_key": "my_aws_access_key",
    "aws_secret_key": "my_aws_secret_key",
    "role_arn": "my_iam_role_arn",
    "client_id": "my_client_id",
    "client_secret": "my_client_secret",
    "refresh_token": "my_refresh_token"
  }
}

Auth Parameters

Name	Description
`refresh_token`	The long-lived `Refresh token` along with the `client_id` and `client_secret` parameters carry the information necessary to get a new access token for API resources.
`role_arn`	`IAM Role ARN` of your AWS Account.
`aws_access_key`	`AWS Access Key` of your AWS Account User.
`client_secret`	`Client Secret` of your Amazon Seller/Vendor Central client application.
`aws_secret_key`	`AWS Secret Key` of your AWS Account User.
`client_id`	`Client ID` of your Amazon Seller/Vendor Central client application.

By using the Connect Card or the Fivetran dashboard.