Pinterest is an image and video sharing and social media service for finding ideas.
Data integration: Skyvia supports importing data to and from Pinterest, exporting Pinterest data to CSV files, replicating Pinterest data to relational databases.
Backup: Skyvia Backup does not support Pinterest.
Query: Skyvia Query supports Pinterest.
Pinterest-Specific Features and Limitations
Skyvia has the following limitations for Pinterest:
In the Data Integration product, Pinterest connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Pinterest in your package.
- Skyvia supports DML operations for such Pinterest objects:
- INSERT, UPDATE, DELETE: Boards, BoardSections.
- INSERT, DELETE: Pins Other objects are read-only.
Skyvia supports Replication with Incremental Updates normally for the following objects: Campaigns, AdGroups, Ads, Pins. The following objects also support replication with the incremental updates, but only on a daily basis: PinDailyAnalytics, UserAccountDailyAnalytics, AdAccountDailyAnalytics. Skyvia tracks changes in these objects by the Date field, which stores only dates without time, so the replication with incremental updates should not be scheduled more often than once per day. To avoid duplicates, replication with incremental updates replicates only records up to the previous day, and does not replicate records for the current day. The latter are replicated only next day.
Synchronization for Pinterest is not supported.
The Pins object represents your Pinterest pins. Its ImageBody field contains the binary data of the image in the original size. For video pins, the VideoCoverBody also contains binary data of the video cover image. For non-video pins, the VideoCoverBody field is always NULL.
These fields are read via an additional API call for each pin record, so querying them significantly increases Pins reading time and API use. If you don’t need them, it’s better not to query them.
Currently Skyvia supports creating only image pins. It does not support creating video pins.
The PinImages object returns all the pin images in all the available sizes. Its ImageBody field contains the binary data of an image. Its Body field is also read via an additional API call for each pin record, so querying the field significantly increases reading time and API use.
The Ads object can have records, referencing already deleted pins (with PinId field not corresponding Id of any existing Pin record). Such records can cause errors in replication packages if the Create Foreign Key checkbox is selected because of foreign key violation. If you need to replicate ads and pins, we recommend either not selecting the Create Foreign Key checkbox or filtering Ads records by the IsPinDeleted field.
The following objects are not supported in Skyvia: Feeds, CatalogsItems, ProductGroups, UserAccountTopPinAnalytics, UserAccountTopVideoPinAnalytics, Register media upload, Get media upload details.
Some of the Pinterest objects can be accessed only via their parent objects. For example, to query BordSections or Pins, Pinterest API requires the ID of the corresponding Boards record. To get PinImages or PinDailyAnalytics records, Pinterest API requires the ID of the corresponding Pin. Campaigns, AdGroups, Ads, AdAccountDailyAnalytics require ID of the AdAccounts records.
Skyvia does not require the ID of the parent object from user. If you don’t specify the IDs of the parent objects (for example, in a filter), Skyvia queries all the parent object records first, takes their IDs and then queries child object records for each parent object record. This allows querying child objects without knowing their parents, but this method takes much time and consumes many API calls. It uses at least one API call for every parent object record. Thus, working with child records can be slow.
Because of this, it is recommended to use filters on the parent object fields when querying data from such child objects. This reduces the number of parent object records, for which child object data must be queried.
To connect to Pinterest, you need to perform the following steps:
- Click +NEW in the top menu.
- Open the Select Connector page by clicking Connection in the menu on the left.
- In the opened page, click Pinterest.
Click Sign In with Pinterest.
Enter your Pinterest credentials and click Log in
Click Give access.
- Optionally, select the Suppress Extended Requests checkbox to reduce the number of API calls.
- Use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Supported Actions and Actions Specifics
Clever Reach connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
- Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.