pinterest.md

Pinterest

This page contains the setup guide and reference information for the Pinterest source connector.

Prerequisites

Please read How to get your credentials.

Setup guide

Step 1: Set up the Pinterest connector in Airbyte

For Airbyte Cloud:

1. Log into your Airbyte Cloud account.
2. In the left navigation bar, click Sources. In the top-right corner, click +new source.
3. On the Set up the source page, enter the name for the Pinterest connector and select Pinterest from the Source type dropdown.
4. Enter the start_date you want your sync to start from. start_date should be no older than 914 days from today, that's the restriction of the Pinterest API for some of the streams.
5. Choose OAuth2.0 in Authorization Method list
6. Click on Authenticate your Pinterest account button
7. Proceed with OAuth authentication of your account in the pop-up window that appears after previous step
8. Click Set up source

For Airbyte OSS:

1. Navigate to the Airbyte Open Source dashboard

2. Set the name for your source

3. Enter your client_id

4. Enter your client_secret

5. Enter your refresh_token

6. Enter the start_date you want your sync to start from.start_date should be no older than 914 days from today, that's the restriction of the Pinterest API for some of the streams.

7. Choose OAuth2.0 in Authorization Method list

8. Click Set up source

Supported sync modes

The Pinterest source connector supports the following sync modes:

Feature	Supported?
Full Refresh Sync	Yes
Incremental - Append Sync	Yes
SSL connection	Yes
Namespaces	No

Supported Streams

• Account analytics (Incremental)
• Boards (Full table)
  • Board sections (Full table)
    • Pins on board section (Full table)
  • Pins on board (Full table)
• Ad accounts (Full table)
  • Ad account analytics (Incremental)
  • Campaigns (Incremental)
    • Campaign analytics (Incremental)
  • Ad groups (Incremental)
    • Ad group analytics (Incremental)
  • Ads (Incremental)
    • Ad analytics (Incremental)

Performance considerations

The connector is restricted by normal Pinterest requests limitation.

Rate Limits

Analytics streams - 300 calls per day / per user
Ad accounts streams (Campaigns, Ad groups, Ads) - 1000 calls per min / per user / per app
Boards streams - 10 calls per sec / per user / per app

Changelog

Version	Date	Pull Request	Subject
0.1.7	2022-09-29	17387	Set start_date dynamically based on API restrictions.
0.1.6	2022-09-28	17304	Use CDK 0.1.89
0.1.5	2022-09-16	16799	Migrate to per-stream state
0.1.4	2022-09-06	16161	Added ability to handle 429 - Too Many Requests error with respect to Max Rate Limit Exceeded Error
0.1.3	2022-09-02	16271	Added support of OAuth2.0 authentication method
0.1.2	2021-12-22	10223	Fix naming of AD_ID and AD_ACCOUNT_ID fields
0.1.1	2021-12-22	9043	Update connector fields title/description
0.1.0	2021-10-29	7493	Release Pinterest CDK Connector