The JSON Feed
This option is for hardcore programmers that know how to parse a JSON stream. It allows any kinda of data layout that you want, but at the price of custom coding. You will need some kinda of scripting language php,asp or javascript...
- For shows point the browser to publish.billsgigulator.com/shows.json?site=your-site-id
- For posts point the browser to publish.billsgigulator.com/posts.json?site=your-site-id
Record Control Options
- See the URL options page for details on how to filter, limit show amounts etc via the URL.
JSON feed fields
- type
- the type of data being sent, "posts" "show"
- limit
- the limit set by "lim"
- offset
- the offset as set by "pg"
- page
- the page as set by "pg".
- page_recs
- number of records being sent on this page.
- total_recs
- total number of records ignoring page/limit/offset values
- data
- the requested data in array form.
Example
- Ex 1
publish.billsgigulator.com/shows.json?site=999&old=1&ldr=1&pg=3&lim=100Sends old shows for site '999' where the user is the project leader. The first gig is the 100th show.
Show Example Feed:
{
type: "shows",
limit: "1",
offset: 0,
page: 2,
page_recs: 1,
total_recs: 422,
data: [ {
gig_id: "6095",
gig_date: "20120518",
status: "CONFIRMED",
private: "0",
featured: "0",
hide_date: "0",
event_name: "Happy hour - free oysters",
event_url: null,
time_show: "7pm - 9:45pm",
time_doors: null,
ticket_price: null,
ticket_url: null,
proj_id: "1322",
proj_name: "Bill Malchow - solo piano",
proj_leader: "1",
proj_description: null,
proj_url: "http://www.billmalchow.com",
venue_id: "778",
venue_name: "Le Bon Temps Roule",
venue_url: "http://www.myspace.com/4801magazine",
venue_addr1: "4801 Magazine Street",
venue_addr2: null,
venue_addr3: null,
venue_city: "New Orleans",
venue_state: "LA",
venue_country: null,
venue_zip: null,
venue_phone: "(504) 897-3448",
pic: "http://www.billmalchow.com/pic/sched_pics/bill_back_sm.jpg",
event_pic: null,
proj_pic: "http://www.billmalchow.com/pic/sched_pics/bill_back_sm.jpg",
venue_pic: null,
misc: ""
{]
}
Post Example Feed:
{
type: "posts",
limit: "1",
offset: 0,
page: 1,
page_recs: 1,
total_recs: 56,
data: [ {
id: "323",
category: "News",
post_date: "2012-04-26 22:40:00",
hide_date: "0",
title: "New Years",
content: "Happy belated New Year Everyone!",
pic: null
}]
}