CData Python Connector for Pinterest

Build 20.0.7745

Pins

Get user pins.

Table Specific Information

Select

The Pinterest allows only a small subset of columns to be used in the WHERE clause of a SELECT query to processed on the server side. These columns can typically be used with only the equals(=) comparison. The available columns for Pins are Id, BoardId, BoardURL. For example:

SELECT * FROM Pins WHERE Id = '661536632745205886'

SELECT * FROM Pins WHERE BoardId = '661536701453532539'

SELECT * FROM Pins WHERE BoardURL = 'https://www.pinterest.com/jafferss/nature/'

Columns

Name Type References Description
Id [KEY] String The unique string of numbers and letters that identifies the Pin on Pinterest.
CreatorURL String Creator profile url.
CreatorFirstName String Creator First Name.
CreatorLastName String Creater Last Name.
CreatorId String

Users.Id

Creater Unique Id.
URL String The URL of the Pin on Pinterest.
MediaType String The media type of the Pin.
CreatedAt Datetime The date the Pin was created.
OriginalLink String The Original Link of the Pin.
Note String The user-entered description of the Pin.
Color String The dominant color of the Pin image in hex code format.
Link String The URL of the webpage where the Pin was created.
BoardURL String

Boards.URL

The board URL that the Pin is on.
BoardId String

Boards.Id

The board Id that the Pin is on.
BoardName String

Boards.Name

The board Name that the Pin is on.
Attribution String The source data for videos, including the title, URL, provider, author name, author URL and provider name.
ImageOriginalURL String The URL of the Image.
ImageOriginalWidth Integer The Width of the Image.
ImageOriginalHeight Integer The Height of the Image.
SavesCount Integer Number of Saves.
CommentsCount Integer Number of comments.
Locale String Information on Pins locale
Title String Information on pins title
SiteName String Information on pins site name
Description String Information on pins description
Favicon String Pin favicon

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7745