beautypg.com

Data tables for social media snapshots and tickers – Grass Valley Xstudio Vertigo Suite v.4.10 User Manual

Page 257

background image

9-34

Xstudio User Manual

Linking objects to a data source

Data tables for social media snapshots and tickers

The data tables used by snapshots and tickers have a fixed set of columns determined by
the choice of social media provider and type. The number of rows in the table varies
according to the data that is present. The columns present for the different types of tables
are outlined in the following sections:

“Spredfast and Telescope messages data table columns” on page 9-34

“Spredfast and Telescope polls data tables columns” on page 9-36

Spredfast and Telescope messages data table columns

The following table identifies the columns that are populated in the data tables for Spredfast
messages and Telescope messages. There is one row in the table for each message.

MessageId

A unique message identifier that is guaranteed to be different for every message.

Example: 4783947938943

UserName

The unique identifier of the message poster. In the case of Facebook messages, this is the user id
number.

Example: dmcormick5

ScreenName

The readable identifier of the message poster.

Example: Doug McCormick

Avatar

The url of the message poster's avatar image.

Example:
http://pbs.twimg.com/profile_images/473465519791360/c9iPjGKx_normal.jpeg

Source

The source from where the message was posted.

twitter

facebook

instagram

Example: twitter

This manual is related to the following products: