Oracle Fusion Cloud Applications - CRM API Configuration

Request

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

{
  "group_id": "group_id",
  "service": "oracle_fusion_cloud_apps_crm",
  "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": {
    "public_key": "test_public_key",
    "authentication_method": "JWT | BASIC",
    "password": "test_password",
    "private_key": "test_private_key",
    "server_url": "https://:",
    "issuer": "test_issuer",
    "username": "test_username",
    "schema_prefix": "prefix"
  }
}

Config parameters

Name	Description
`public_key`	The Oracle Fusion Cloud public key.
`authentication_method`	The Oracle Fusion Cloud authentication method.
`password`	The Oracle Fusion Cloud user password.
`private_key`	The Oracle Fusion Cloud private key.
`server_url`	The Oracle Fusion Cloud Instance URL.
`issuer`	The Oracle Fusion Cloud issuer name.
`username`	The Oracle Fusion Cloud username.
`schema_prefix` (required)	Destination schema prefix. Prefix for each replicated schema. For example with prefix 'x', source schemas 'foo' and 'bar' get replicated as 'x_foo' and 'x_bar'. The prefix is permanent and cannot be changed after connection creation

Authorization

There are three ways to authorize this connector type:

Basic: By specifying the authentication_method as "BASIC" and the values for the username and password parameters in the request.

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

{
  "service": "oracle_fusion_cloud_apps_crm",
  "group_id": "group_id",
  "config": {
    "authentication_method": "BASIC",
    "username": "test_username",
    "password": "test_password"
  }
}

JWT Token: By specifying the authentication_method as "JWT" and the values for the username, issuer, private_key and public_key parameters in the request.

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

{
  "service": "oracle_fusion_cloud_apps_crm",
  "group_id": "group_id",
  "config": {
    "authentication_method": "JWT",
    "username": "test_username",
    "issuer": "test_issuer",
    "private_key": "test_private_key",
    "public_key": "test_public_key"
  }
}

By using the Connect Card or the Fivetran dashboard.