Our Media Query API allows you to query a date range for active Contracts, it returns the Contract information along with any copy rotations for the spots that are instructed to rotate for that Contract within the specified date range. An example use of this endpoint, would be to request a list of Contracts on air tomorrow that have no instruction lines capable of fullfilling the scheduled times. You could then send a push notification to the rep informing them that they have missing copy.
{
"status": 200,
"data": [
{
"mediaFound": true,
"coreId": 20489,
"projectId": 58292,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "18-19 fall\/winter\/spring",
"startDate": "2018-10-01",
"endDate": "2019-06-16",
"accountId": 189156,
"accountName": "Lucky Bones Back Water Grill",
"number": "CON-CAP-JC-446",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": true,
"coreId": 20695,
"projectId": 62572,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "Holiday 2018 ",
"startDate": "2018-11-19",
"endDate": "2019-01-05",
"accountId": 189197,
"accountName": "Wildwood SID",
"number": "CON-CAP-JC-540",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": true,
"coreId": 3795,
"projectId": 49459,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018 year round",
"startDate": "2018-03-26",
"endDate": "2019-03-24",
"accountId": 189242,
"accountName": "Shamrock Beef And Ale",
"number": "CON-CAP-JC-172",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": true,
"coreId": 3816,
"projectId": 49462,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018 year round",
"startDate": "2018-03-26",
"endDate": "2019-03-24",
"accountId": 189242,
"accountName": "Shamrock Beef And Ale",
"number": "CON-CAP-JC-183",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": true,
"coreId": 4363,
"projectId": 55976,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018-2019 year round",
"startDate": "2018-09-03",
"endDate": "2019-09-01",
"accountId": 189281,
"accountName": "North Wildwood Shirt Shop",
"number": "CON-CAP-JC-399",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": true,
"coreId": 4249,
"projectId": 54795,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "weather",
"startDate": "2018-09-12",
"endDate": "2019-01-01",
"accountId": 189344,
"accountName": "Avalon Honda",
"number": "CON-CAP-KM-368",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 21041,
"projectId": 0,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "TRADE ",
"startDate": "2018-12-26",
"endDate": "2019-04-28",
"accountId": 189353,
"accountName": "Icona Resorts",
"number": "CON-CAP-KM-677",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 21040,
"projectId": 0,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "one day sale",
"startDate": "2018-12-26",
"endDate": "2019-04-30",
"accountId": 189353,
"accountName": "Icona Resorts",
"number": "CON-CAP-KM-676",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3878,
"projectId": 49285,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "national news",
"startDate": "2018-05-07",
"endDate": "2019-05-05",
"accountId": 189382,
"accountName": "Evolution Salon & Spa",
"number": "CON-CAP-KM-220",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 20589,
"projectId": 61447,
"salesRepId": 885,
"salesRepName": "Robert Maschio",
"descriptor": "6 Month Contract 2018-2019",
"startDate": "2018-10-29",
"endDate": "2019-04-21",
"accountId": 189546,
"accountName": "Cape May County MUA",
"number": "CON-CAP-RM-498",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 21011,
"projectId": 66571,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "New Years 2018",
"startDate": "2018-12-27",
"endDate": "2019-01-01",
"accountId": 189590,
"accountName": "Find's Furniture",
"number": "CON-CAP-JC-670",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 20536,
"projectId": 59122,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018-2019 year round",
"startDate": "2018-10-22",
"endDate": "2019-10-20",
"accountId": 189595,
"accountName": "Grand Hotel of Cape May",
"number": "CON-CAP-JC-469",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3822,
"projectId": 49458,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018 year round",
"startDate": "2018-04-23",
"endDate": "2019-04-21",
"accountId": 189602,
"accountName": "Olivieri Chiropractic",
"number": "CON-CAP-JC-189",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 20558,
"projectId": 0,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "annual",
"startDate": "2018-10-15",
"endDate": "2019-10-13",
"accountId": 189655,
"accountName": "Seaside Cheese CO",
"number": "CON-CAP-KM-481",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 4302,
"projectId": 0,
"salesRepId": 15192,
"salesRepName": "Nicole James",
"descriptor": "Summer 2018",
"startDate": "2018-04-16",
"endDate": "2019-04-15",
"accountId": 193102,
"accountName": "Collier's Liquor Store",
"number": "CON-CAP-NJ-381",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 4118,
"projectId": 51892,
"salesRepId": 15192,
"salesRepName": "Nicole James",
"descriptor": "Willow Year Round",
"startDate": "2018-07-02",
"endDate": "2019-07-01",
"accountId": 193113,
"accountName": "Willow Creek Winery and Farm",
"number": "PROP-NJ-1",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 4217,
"projectId": 52835,
"salesRepId": 15192,
"salesRepName": "Nicole James",
"descriptor": "Year Round Projections",
"startDate": "2018-07-02",
"endDate": "2019-07-01",
"accountId": 193113,
"accountName": "Willow Creek Winery and Farm",
"number": "CON-CAP-NJ-349",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3625,
"projectId": 49287,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "news",
"startDate": "2018-02-05",
"endDate": "2019-02-03",
"accountId": 194242,
"accountName": "WIldwood Catholic Crusader Club",
"number": "CON-CAP-KM-130",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3865,
"projectId": 49168,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "year round national news",
"startDate": "2018-05-07",
"endDate": "2019-05-05",
"accountId": 194380,
"accountName": "Beefy's ",
"number": "CON-CAP-KM-210",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3831,
"projectId": 49286,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "news",
"startDate": "2018-04-09",
"endDate": "2019-04-07",
"accountId": 199023,
"accountName": "Hereford Inlet Lighthouse",
"number": "CON-CAP-KM-197",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3908,
"projectId": 46357,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018 year round",
"startDate": "2018-05-09",
"endDate": "2019-05-05",
"accountId": 207629,
"accountName": "Sapore Italiano",
"number": "CON-CAP-JC-231",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3844,
"projectId": 51890,
"salesRepId": 15192,
"salesRepName": "Nicole James",
"descriptor": "Year Round Package",
"startDate": "2018-04-11",
"endDate": "2019-04-10",
"accountId": 226327,
"accountName": "5 West Pub",
"number": "CON-CAP-NJ-200",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 20392,
"projectId": 0,
"salesRepId": 11084,
"salesRepName": "Kimberly Maschio",
"descriptor": "europe",
"startDate": "2018-09-13",
"endDate": "2019-01-04",
"accountId": 226657,
"accountName": "Kim",
"number": "CON-CAP-KM-423",
"revenueTypeId": 23,
"revenueTypeDescription": "Promo"
},
{
"mediaFound": false,
"coreId": 20943,
"projectId": 66066,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2019 Polar Plunge",
"startDate": "2018-12-26",
"endDate": "2019-01-12",
"accountId": 243762,
"accountName": "Special Olympics New Jersey",
"number": "CON-CAP-JC-642",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
},
{
"mediaFound": false,
"coreId": 3902,
"projectId": 49169,
"salesRepId": 11081,
"salesRepName": "JennaLee Cooker",
"descriptor": "2018-2019 year round",
"startDate": "2018-05-07",
"endDate": "2019-05-05",
"accountId": 248324,
"accountName": "Primo Hoagies- Rio Grande",
"number": "PROP-JC-1",
"revenueTypeId": 17,
"revenueTypeDescription": "Cash"
}
]
}