BLADE

Owned by Jonathan Schmale
Last updated: Aug 26, 2016Version comment
10 min read

BLADE offers simplified data retrieval contained within a single URL. The BLADE module provides you access to information such as Program Schedules and As Run reports in XML, JSON or CSV formats, as available, so that you can use the same dynamic broadcast content on any platform.

You assemble direct query URL access to your data for formatted results using the Reports > BLADE option.

Date Filtering

You can specify start and end dates to filter the results you get from BLADE.

Note: You may choose to select only times and leave the dates blank to create a request that pulls data from the same timeframe each day you run it.

Note: The default start date is 5:00 AM today and the default interval is one day respectively if no start date or end date is selected.

General Options

There are a set of extra options that apply to all of the BLADE modules. The options allow you to customize the output of BLADE.

Program Schedules URL Generator

Use the Program Schedules section to help you generate the direct query URL for program schedules.

  1. Specify URL parameters, as defined in the following table.
  2. Click Generate to produce the query string in the specified format based on the parameters you set.
  3. Click Test to generate data in the specified format in a new browser tab based on the parameters you set. Use the Test function to ensure that it returns appropriate results and to view the format of the output.
  4. Copy and paste the Query String generated in your platforms as needed.

URL ParameterDescription
FormatSelect the data format. Select from: XML or JSON or JSONP or CSV.
ChannelSelect a channel from the list.
Start At

Choose from

  • Now
  • Next (program that start after current program)
  • Report Start Date
    • selected in the Report Dates section below
Include

Choose from:

  • a set number of scheduled programs (defaults to 1)
  • until the Report End Date
    • selected in the Report Dates section below


Program Schedule Samples

JSONP Sample 
callback({
  "programSchedule": [
    {
      "type": "channel",
      "name": "CityTV Toronto",
      "programs": []
    },
    {
      "type": "channel",
      "name": "OMNI 1",
      "programs": [
        {
          "startTime": "2016-08-23T08:30:00",
          "endTime": "2016-08-23T09:00:00",
          "title": "All About Aardvarks",
          "isLive": false,
          "rating": "C8",
          "duration": 30.0,
          "shortName": "Aardvarks",
          "line1": "All About",
          "line2": "Aardvarks",
          "hashtag": "#aardvarksOnTv"
        },
        {
          "startTime": "2016-08-23T11:00:00Z",
          "endTime": "2016-08-23T11:30:00Z",
          "title": "11 O'Clock News",
          "isLive": false,
          "rating": "PG",
          "duration": 30.0,
          "shortName": "11:00 News",
          "line1": "11 O'Clock News",
          "line2": "",
          "hashtag": "#newshour",
          "test123": "A retired black ops commando targets an innocent group of popr people to make his point in brutal fashion. Can we stop him?"
        },
        {
          "startTime": "2016-08-23T12:00:00Z",
          "endTime": "2016-08-23T13:00:00Z",
          "title": "12 Noon",
          "isLive": false,
          "rating": "TV-Y",
          "duration": 60.0,
          "shortName": "Noon",
          "line1": "12 Noon",
          "line2": "",
          "hashtag": "#NoonNews"
        }
      ]
    },
    {
      "type": "channel",
      "name": "OMNI 2",
      "programs": [
        {
          "startTime": "2016-08-23T09:00:00Z",
          "endTime": "2016-08-23T12:30:00Z",
          "title": "2014 Grey Cup",
          "isLive": false,
          "rating": null,
          "duration": 210.0,
          "shortName": "2014 Grey Cup",
          "line1": "2014 Grey Cup",
          "line2": "",
          "hashtag": ""
        }
      ]
    }
  ]
});
XML Sample 
<?xml version="1.0" encoding="utf-8"?>
<ProgramSchedule>
  <Channel>
    <Name>CityTV Toronto</Name>
    <Programs />
  </Channel>
  <Channel>
    <Name>OMNI 1</Name>
    <Programs>
      <Event>
        <StartTime>2016-08-23T08:30:00</StartTime>
        <EndTime>2016-08-23T09:00:00</EndTime>
        <Title>All About Aardvarks</Title>
        <IsLive>false</IsLive>
        <Rating>C8</Rating>
        <Duration>30</Duration>
        <ShortName>Aardvarks</ShortName>
        <Line1>All About</Line1>
        <Line2>Aardvarks</Line2>
        <Hashtag>#aardvarksOnTv</Hashtag>
        <isGame dynamicField="true" type="boolean">false</isGame>
      </Event>
      <Event>
        <StartTime>2016-08-23T11:00:00Z</StartTime>
        <EndTime>2016-08-23T11:30:00Z</EndTime>
        <Title>11 O'Clock News</Title>
        <IsLive>false</IsLive>
        <Rating>PG</Rating>
        <Duration>30</Duration>
        <ShortName>11:00 News</ShortName>
        <Line1>11 O'Clock News</Line1>
        <Line2 />
        <Hashtag>#newshour</Hashtag>
        <isGame dynamicField="true" type="boolean">true</isGame>
        <test123 dynamicField="true" type="text">A retired black ops commando targets an innocent group of popr people to make his point in brutal fashion. Can we stop him?</test123>
        <vTeam dynamicField="true" type="logo">set_visibility.png</vTeam>
        <hTeam dynamicField="true" type="logo">add_ridings.png</hTeam>
      </Event>
      <Event>
        <StartTime>2016-08-23T12:00:00Z</StartTime>
        <EndTime>2016-08-23T13:00:00Z</EndTime>
        <Title>12 Noon</Title>
        <IsLive>false</IsLive>
        <Rating>TV-Y</Rating>
        <Duration>60</Duration>
        <ShortName>Noon</ShortName>
        <Line1>12 Noon</Line1>
        <Line2 />
        <Hashtag>#NoonNews</Hashtag>
        <hTeam dynamicField="true" type="logo" />
        <vTeam dynamicField="true" type="logo">announcements.png</vTeam>
      </Event>
    </Programs>
  </Channel>
  <Channel>
    <Name>OMNI 2</Name>
    <Programs>
      <Event>
        <StartTime>2016-08-23T09:00:00Z</StartTime>
        <EndTime>2016-08-23T12:30:00Z</EndTime>
        <Title>2014 Grey Cup</Title>
        <IsLive>false</IsLive>
        <Rating />
        <Duration>210</Duration>
        <ShortName>2014 Grey Cup</ShortName>
        <Line1>2014 Grey Cup</Line1>
        <Line2 />
        <Hashtag />
      </Event>
    </Programs>
  </Channel>
</ProgramSchedule>
CSV Sample 
Channel,Start,End,Title,IsLive,Rating,Duration,ShortName,Line1,Line2,Hashtag
Channel 1,2016-08-22 11:00:00 AM,2016-08-22 11:30:00 AM,11 O'Clock News,False,PG,30,11:00 News,11 O'Clock News,,#newshour
Channel 1,2016-08-22 12:00:00 PM,2016-08-22 1:00:00 PM,12 Noon,False,TV-Y,60,Noon,12 Noon,,#NoonNews

 

As Run Report URL Generator

Use the As Run section to help you generate the direct query URL for As Run reports.

  1. Specify URL parameters, as defined in the following table.
  2. Click Generate to produce the query string in the specified format based on the parameters you set.
  3. Click Test to generate data in the specified format in a new browser tab based on the parameters you set. Use the Test function to ensure that it returns appropriate results and to view the format of the output.
  4. Copy and paste the Query String generated in your platforms as needed.

 

 

URL ParameterDescription
FormatSelect the data format. Select from: XML or JSON or JSONP or CSV.
ChannelSelect a channel from the list.
ClientOptional - select a client to filter the results on
ProgramOptional - select a program to filter the results on
TitleOptional - select a title to filter the results on


 

As Run Samples

JSONP Sample 
callback({"asRunRecords": [
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T16:34:16",
    "endDate": "2012-07-23T16:34:24",
    "title": "FactorsPGX",
    "clientName": "Testing",
    "clientId": "3",
    "programName": "Storage Wars: Texas"
  },
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T16:33:16",
    "endDate": "2012-07-23T16:33:24",
    "title": "FactorsPGX",
    "clientName": "Testing",
    "clientId": "3",
    "programName": "Storage Wars: Texas"
  },
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T15:33:16",
    "endDate": "2012-07-23T15:33:24",
    "title": "FactorsPGX",
    "clientName": "Testing",
    "clientId": "3",
    "programName": "Minutes To Win It"
  },
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T15:32:06",
    "endDate": "2012-07-23T15:32:14",
    "title": "FactorsPGX",
    "clientName": "Testing",
    "clientId": "3",
    "programName": "Minutes To Win It"
  },
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T14:14:16",
    "endDate": "2012-07-23T14:14:24",
    "title": "laugh shop",
    "clientName": "Sky Machine Creative",
    "clientId": "2",
    "programName": "Operation Repo"
  },
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T14:03:16",
    "endDate": "2012-07-23T14:03:24",
    "title": "laugh shop",
    "clientName": "Sky Machine Creative",
    "clientId": "2",
    "programName": "Operation Repo"
  },
  {
    "channelName": "OLN",
    "startDate": "2012-07-23T13:03:07",
    "endDate": "2012-07-23T13:03:15",
    "title": "laugh shop",
    "clientName": "Sky Machine Creative",
    "clientId": "2",
    "programName": "Monsterquest"
  }
]});
XML Sample 
<?xml version="1.0" encoding="utf-8"?>
<AsRunRecords>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T16:34:16</StartDate>
    <EndDate>2012-07-23T16:34:24</EndDate>
    <Title>FactorsPGX</Title>
    <ClientName>Testing</ClientName>
    <ClientId>3</ClientId>
    <ProgramName>Storage Wars: Texas</ProgramName>
  </AsRunItem>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T16:33:16</StartDate>
    <EndDate>2012-07-23T16:33:24</EndDate>
    <Title>FactorsPGX</Title>
    <ClientName>Testing</ClientName>
    <ClientId>3</ClientId>
    <ProgramName>Storage Wars: Texas</ProgramName>
  </AsRunItem>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T15:32:06</StartDate>
    <EndDate>2012-07-23T15:32:14</EndDate>
    <Title>FactorsPGX</Title>
    <ClientName>Testing</ClientName>
    <ClientId>3</ClientId>
    <ProgramName>Minutes To Win It</ProgramName>
  </AsRunItem>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T15:31:16</StartDate>
    <EndDate>2012-07-23T15:31:24</EndDate>
    <Title>FactorsPGX</Title>
    <ClientName>Testing</ClientName>
    <ClientId>3</ClientId>
    <ProgramName>Minutes To Win It</ProgramName>
  </AsRunItem>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T14:14:16</StartDate>
    <EndDate>2012-07-23T14:14:24</EndDate>
    <Title>laugh shop</Title>
    <ClientName>Sky Machine Creative</ClientName>
    <ClientId>2</ClientId>
    <ProgramName>Operation Repo</ProgramName>
  </AsRunItem>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T14:03:16</StartDate>
    <EndDate>2012-07-23T14:03:24</EndDate>
    <Title>laugh shop</Title>
    <ClientName>Sky Machine Creative</ClientName>
    <ClientId>2</ClientId>
    <ProgramName>Operation Repo</ProgramName>
  </AsRunItem>
  <AsRunItem>
    <ChannelName>OLN</ChannelName>
    <StartDate>2012-07-23T13:03:07</StartDate>
    <EndDate>2012-07-23T13:03:15</EndDate>
    <Title>laugh shop</Title>
    <ClientName>Sky Machine Creative</ClientName>
    <ClientId>2</ClientId>
    <ProgramName>Monsterquest</ProgramName>
  </AsRunItem>
</AsRunRecords>
CSV Sample 
ChannelName,StartDate,EndDate,Title,ClientName,ClientId,ProgramName
OLN,23/07/2012 4:34:16 PM,23/07/2012 4:34:24 PM,FactorsPGX,Testing,3,Storage Wars: Texas
OLN,23/07/2012 4:33:16 PM,23/07/2012 4:33:24 PM,FactorsPGX,Testing,3,Storage Wars: Texas
OLN,23/07/2012 4:32:16 PM,23/07/2012 4:32:24 PM,FactorsPGX,Testing,3,Storage Wars: Texas
OLN,23/07/2012 4:31:16 PM,23/07/2012 4:31:24 PM,FactorsPGX,Testing,3,Storage Wars: Texas
OLN,23/07/2012 4:30:16 PM,23/07/2012 4:30:24 PM,FactorsPGX,Testing,3,Storage Wars: Texas
OLN,23/07/2012 4:02:16 PM,23/07/2012 4:02:24 PM,laugh shop,Sky Machine Creative,2,Get Stuffed
OLN,23/07/2012 3:34:16 PM,23/07/2012 3:34:24 PM,FactorsPGX,Testing,3,Minutes To Win It
OLN,23/07/2012 3:33:16 PM,23/07/2012 3:33:24 PM,FactorsPGX,Testing,3,Minutes To Win It
OLN,23/07/2012 3:32:06 PM,23/07/2012 3:32:14 PM,FactorsPGX,Testing,3,Minutes To Win It
OLN,23/07/2012 3:31:16 PM,23/07/2012 3:31:24 PM,FactorsPGX,Testing,3,Minutes To Win It
OLN,23/07/2012 3:30:16 PM,23/07/2012 3:30:24 PM,FactorsPGX,Testing,3,Minutes To Win It
OLN,23/07/2012 3:02:16 PM,23/07/2012 3:02:24 PM,laugh shop,Sky Machine Creative,2,Minutes To Win It
OLN,23/07/2012 2:14:16 PM,23/07/2012 2:14:24 PM,laugh shop,Sky Machine Creative,2,Operation Repo
OLN,23/07/2012 2:03:16 PM,23/07/2012 2:03:24 PM,laugh shop,Sky Machine Creative,2,Operation Repo
OLN,23/07/2012 1:03:07 PM,23/07/2012 1:03:15 PM,laugh shop,Sky Machine Creative,2,Monsterquest


In this section:

BannisterLake.com 

 

Note: You may choose to select only times and leave the dates blank to create a request that pulls data from the same timeframe each day you run it.