Please enable JavaScript to view this site.

RSS Data Model RSS Forums

Navigation: » No topics above this level «

ChannelItems

Catalog: RSS

The data in this table is partitioned per value of the column.

Retrieve: true

Topic: rss

Base XPath: /rss/channel

XPath: /item

Table Columns

The columns of the table ChannelItems are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CATEGORY_DOMAIN_ATTR

string

 

 

 

CATEGORY

string

 

 

 

CHANNEL_CATEGORY_DOMAIN_ATTR

string

 

 

 

CHANNEL_CATEGORY

string

 

 

 

CHANNEL_CLOUD

string

 

 

Allows processes to register with a cloud to be notified of updates to the channel, implementing a lightweight publish-subscribe protocol for RSS feeds.

CHANNEL_COPYRIGHT

string

Channel Copyright

 

Copyright notice for content in the channel.

CHANNEL_DESCRIPTION

string

Channel Description

 

Phrase or sentence describing the channel.

CHANNEL_DOCS

string

 

 

A URL that points to the documentation for the format used in the RSS file. It's probably a pointer to this page. It's for people who might stumble across an RSS file on a Web server 25 years from now and wonder what it is.

CHANNEL_GENERATOR

string

Channel Generator

 

A string indicating the program used to generate the channel.

CHANNEL_IMAGE_DESCRIPTION

string

Image Description

 

Text that is included in the TITLE attribute of the link formed around the image in the HTML rendering.

CHANNEL_IMAGE_HEIGHT

int64

 

 

The height of the image in pixels.

CHANNEL_IMAGE_LINK

string

Image Hyperlink

 

The URL of the site, when the channel is rendered, the image is a link to the site. (Note, in practice the image <title> and <link> should have the same value as the channel's <title> and <link>.

CHANNEL_IMAGE_TITLE

string

Image Title

 

Describes the image, it's used in the ALT attribute of the HTML <img> tag when the channel is rendered in HTML.

CHANNEL_IMAGE_URL

string

 

 

The URL of the image file.

CHANNEL_IMAGE_WIDTH

int64

 

 

The width of the image in pixels.

CHANNEL_LANGUAGE

string(17)

Channel Language

 

The language the channel is written in. This allows aggregators to group all Italian language sites, for example, on a single page. A list of allowable values for this element, as provided by Netscape, is here. You may also use values defined by the W3C.

CHANNEL_LASTBUILDDATE

string

 

 

A date-time displayed in RFC-822 format.

CHANNEL_LINK

string

Channel Hyperlink

 

The URL to the HTML website corresponding to the channel.

CHANNEL_PUBDATE

string

 

 

A date-time displayed in RFC-822 format.

CHANNEL_SKIPDAYS

int64

 

 

A hint for aggregators telling them which days they can skip.

CHANNEL_SKIPHOURS

int64

 

 

A hint for aggregators telling them which hours they can skip.

CHANNEL_TEXTINPUT_DESCRIPTION

string

 

 

Explains the text input area.

CHANNEL_TEXTINPUT_LINK

string

 

 

The URL of the CGI script that processes text input requests.

CHANNEL_TEXTINPUT_NAME

string

 

 

The name of the text object in the text input area.

CHANNEL_TEXTINPUT_TITLE

string

 

 

The label of the Submit button in the text input area.

CHANNEL_TITLE

string

Channel Title

 

The name of the channel. It's how people refer to your service. If you have an HTML website that contains the same information as your RSS file, the title of your channel should be the same as the title of your website.

CHANNEL_TTL

int64

 

 

ttl stands for time to live. It's a number of minutes that indicates how long a channel can be cached before refreshing from the source.

COMMENTS

string

 

 

URL of a page for comments relating to the item.

DESCRIPTION

string

Description

 

The item synopsis.

ENCLOSURE_LENGTH_ATTR

int64

 

 

Size in bytes

ENCLOSURE_TYPE_ATTR

string

 

 

MIME media-type of the enclosure

ENCLOSURE_URL_ATTR

string

 

 

URL where the enclosure is located

ENCLOSURE

string

 

 

 

GUID_ISPERMALINK_ATTR

boolean

 

 

 

GUID

string

 

 

 

INTERFACE_URL

string(4000)

Interface URL

☑

 

LINK

string

Hyperlink

 

The URL of the item.

PUBDATE

string

 

 

A date-time displayed in RFC-822 format.

SOURCE_URL_ATTR

string

 

 

 

SOURCE

string

 

 

 

TITLE

string

Title

 

The title of the item.

 

15-06-2022 20:41 Version 22.0.232-PROD+3445

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.
  
Disclaimer