# Microsoft Ads

## Authentication methods

#### OAuth

{% hint style="warning" %}
Getting authentication credentials to work with this API can be difficult.

Please follow the instructions carefully, but feel free to contact us if you are unable to successfully create a connection.
{% endhint %}

1. In order to obtain the client id, client secret and tenant id, follow [these instructions](https://learn.microsoft.com/en-us/advertising/guides/authentication-oauth-register?view=bingads-13).
2. Once your app is registered add an authorised URL for your Snowflake account. The following Snowflake query will construct the correct value for your account:\
   \
   `select 'https://'||t.value:host::varchar||'/oauth/complete-secret' as URI from table(flatten(input => parse_json(system$allowlist()))) as t where t.value:host::varchar LIKE 'apps-api%';`\\
3. Follow [these instructions](https://learn.microsoft.com/en-us/advertising/guides/get-started?view=bingads-13#get-developer-token) to get a developer token.

## Inbound Syncs

The following streams are supported:

* accounts
* campaigns
* ad sets
* ads
* report\_campaign\_daily (basic campaign metrics at a daily granularity)

## Outbound Syncs

Currently there is no outbound sync functionality, but uploading offline conversions is coming soon!
