Using DevTeach live data with json

This document provide details on how you can use DevTeach web site to retrieve data. The data is provided with a list of URI containing json data set. When the database change, a minute later, the corresponding json(s) are recreated. Here the list of URI returning json data. If you need the data in French, You can add in the URI "Francais" ex: /Data/Francais/News.json

You can get images, Logo and banners at this link:http://www.devteach.com/Banners/index.aspx

Main Page information: /Data/MainPage.json

{
	"adddate":"2016-03-13T15:40:10"
	,"description":"July 5-7..."
	,"icon":1
	,"id":211
	,"img":"http://www.devteach.com/images/Schedule2016.jpg "
	,"moddate":"2016-04-19T19:07:34"
	,"target":""
	,"title":"DevTeach schedule for the Main Conference is online."
	,"url":"/Schedule.aspx"
}


                

News: /Data/News.json

{
	"adddate":"2016-03-13T15:40:10"
	,"description":"July 5-7..."
	,"icon":1
	,"id":211
	,"img":"http://www.devteach.com/images/Schedule2016.jpg "
	,"moddate":"2016-04-19T19:07:34"
	,"target":""
	,"title":"DevTeach schedule for the Main Conference is online."
	,"url":"/Schedule.aspx"
}

                

Schedule Overview: /Data/ScheduleOverview.json

{
	"date":"2016-07-05T07:00:00"
	,"duration":45
	,"name":"Continental breakfast "
	,"ordertype":2
}

                

Rooms: /Data/Rooms.json

{
	"conferenceid":26
	,"roomid":134
	,"roomname":"Room 1"
	,"sponsorid":0
	,"trackday1":"Cloud "
	,"trackday2":"Cloud "
	,"trackday3":"Cloud "
	,"trackid":215
	,"trackname":"Cloud Computing "
}

                

Sessions: /Data/Sessions.json

To get the picture of the speaker you can use the field img like this: ex: http://www.devteach.com/member/002485.jpg
{
	"addtomyschedulurl":"http://www.devteach.com/wconnect/wc.dll?FournierTransformation~1,15,8,2501"
	,"code":"WFE317"
	,"conferenceid":26
	,"description":"So now that Angular 2..."
	,"img":"002485.jpg"
	,"level":3
	,"memberid":2485
	,"sessiondetailsurl":"http://www.devteach.com/wconnect/wc.dll?FournierTransformation~1,5,2,2466"
	,"sessionevalurl":"http://www.devteach.com/wconnect/wc.dll?FournierTransformation~1,15,1,2466"
	,"sessionid":2466
	,"speakername":"Laurent Duveau "
	,"techno1":"Angular"
	,"techno1id":4
	,"techno2":"---"
	,"techno2id":40
	,"title":"Angular 2: so can I use it now?? "
	,"track":"Web Frontend"
	,"trackid":216
	,"uppertitle":"ANGULAR 2: SO CAN I USE IT NOW?? "
}

                

Speakers: /Data/Speakers.json

To get the picture of the speaker you can use memberid like this: ex: http://www.devteach.com/member/013218.jpg
{
	"blog":"http://thedynamicscrmblog.wordpress.com/"
	,"company":""
	,"description":"Salim Adamon is ..."
	,"email":"s.xxx@xxx.com"
	,"facebook":""
	,"linkedin":"http://www.linkedin.com/in/sadamon"
	,"memberid":13218
	,"mvp":"http://mvp.microsoft.com/en-us/mvp/Salim Adamon-5000786 "
	,"rd":""
	,"show":"NET"
	,"speakerid":652
	,"speakername":"Salim Adamon "
	,"talkshow":""
	,"twitter":"https://twitter.com/salimadamon "
	,"upperlname":"ADAMON"
	,"urlsite":""
}

                

Sponsors: /Data/Sponsors.json

To get the log of the sponsor you can use the img field like this: http://www.devteach.com/sponsor/000046.jpg
{
	"company":"Microsoft MSDN Canada "
	,"id":46
	,"img":"000046.jpg"
	,"level":3
	,"leveldesc":"Platin"
	,"notes":"The Microsoft Developer ..."
	,"urlsite":"http://msdn.microsoft.com "
}


                

SubmittedAbstracts: /Data/SubmittedAbstracts.json

{
	"adddate":"2015-11-16T23:54:02"
	,"description":"The HTTP protocol ..."
	,"speaker":"Robert Boedigheimer"
	,"title":"HTTP/2:What You Need to Know"
	,"track":"Web Frontend"
}

                

Tracks: /Data/Tracks.json

{
	"conferenceid":26
	,"technical":1
	,"topicid":216
	,"track":"Web Frontend"
}

                

TrackTechno: /Data/TrackTechno.json

{
	"conferenceid":26
	,"techno":"ASP.NET"
	,"technoid":2
	,"topicid":216
	,"track":"Web Frontend"}
	,{"conferenceid":26
	,"techno":"Angular"
	,"technoid":4
	,"topicid":216
	,"track":"Web Frontend"}
	,{"conferenceid":26
	,"techno":"Javascript "
	,"technoid":1
	,"topicid":216
	,"track":"Web Frontend"
}
                

WinForEval: /Data/WinForEval.json

{
	"company":"Devart"
	,"details":"\r\nNevron Chart ..."
	,"id":1424
	,"item":"Nevron Chart for .NET"
	,"memberid":0
	,"noconferen":26
	,"nosponsor":162
	,"startdate":"2013-12-03T09:09:00"
	,"urlsite":"http://www.devart.com/"
	,"value":589
	,"winner":""
}

                

WinForEvalWinners: /Data/WinForEvalWinners.json

{
	"company":"Devart"
	,"details":"\r\nNevron Chart ..."
	,"id":1424
	,"item":"Nevron Chart for .NET"
	,"memberid":0
	,"noconferen":26
	,"nosponsor":162
	,"startdate":"2013-12-03T09:09:00"
	,"urlsite":"http://www.devart.com/"
	,"value":589
	,"winner":"JR Roy"
}

                

Schedule: /Data/Schedule.json

{
	"activityid":0
	,"activityname":"Session "
	,"activitytype":1
	,"conferenceid":26
	,"description":"Systems are connected now..."
	,"duration":60
	,"language":0
	,"level":2
	,"room":"Pierre de  Coubertin"
	,"roomid":136
	,"scheduledate":"2016-07-05T10:15:00"
	,"scheduleid":2516
	,"sessioncode":"WBE259"
	,"sessionid":2437
	,"sessiondetailsurl":"http://www.devteach.com/wconnect/wc.dll?FournierTransformation~1,5,2,2437"
	,"speaker":"James Chambers "
	,"speakerid":684
	,"tag":""
	,"techno1":"Web Hooks"
	,"techno2":"---"
	,"technoid1":11
	,"technoid2":40
	,"title":"Lighting up Your Integration Story with ASP.NET We "
	,"track":"Web Backend "
	,"trackid":217
}

                

Top10Speakers: /Data/Top10Speakers.json

{
	"memberid":2
	,"nbeval":6
	,"nospeaker":54
	,"speakername":"Jean-René Roy"
	,"total":414
}

                

Using DevTeach HTTP transaction with json

Login: /wconnect/wc.dll?FournierTransformation~1,25,1,UserName,Password

Use this HTTP transaction to login and get a GUID for future transaction.
{
	"company":"DevTeach"
	,"errmess":""
	,"fname":"Mike"
	,"lname":"Smith"
	,"memberid":2342
	,"username":"GOMIKE"
	,"wsid":"6DCDC5B7-F16C-4729-B0CE-B35FB20A728A"
}

                

Get My Schedule: /wconnect/wc.dll?FournierTransformation~1,25,12,6DCDC5B7-F16C-4729-B0CE-B35FB20A728A

Use this HTTP transaction to get your schedule. You need to pass the GUID you received from the login transaction.
{
	"attendeescheduleid":18339
	,"code":"DAT355"
	,"date":"2016-07-05T13:30:00"
	,"errmess":""
	,"memberid":2345
	,"room":"Room 5"
	,"roomid":138
	,"scheduleid":2453
	,"sessionid":2404
	,"speakerid":54
	,"title":"The SQL Server modern DBA"
	,"track":"Big Data"
	,"trackid":219
	,"track_fr":"Big Data"
}

                

Add to My Schedule: /wconnect/wc.dll?FournierTransformation~1,25,13,6DCDC5B7-F16C-4729-B0CE-B35FB20A728A,2404

Use this HTTP transaction to add to your schedule. You need to pass the GUID you received from the login transaction and a ScheduleID.
{
	"attendeescheduleid":18339
	,"code":"DAT355"
	,"date":"2016-07-05T13:30:00"
	,"errmess":""
	,"memberid":2345
	,"room":"Room 5"
	,"roomid":138
	,"scheduleid":2453
	,"sessionid":2404
	,"speakerid":54
	,"title":"The SQL Server modern DBA"
	,"track":"Big Data"
	,"trackid":219
	,"track_fr":"Big Data"
}

                

Delete from My Schedule: /wconnect/wc.dll?FournierTransformation~1,25,14,6DCDC5B7-F16C-4729-B0CE-B35FB20A728A,18487

Use this HTTP transaction to delete from your schedule. You need to pass the GUID you received from the login transaction and a AttendeeScheduleID.
{
	"attendeescheduleid":18339
	,"code":"DAT355"
	,"date":"2016-07-05T13:30:00"
	,"errmess":""
	,"memberid":2345
	,"room":"Room 5"
	,"roomid":138
	,"scheduleid":2453
	,"sessionid":2404
	,"speakerid":54
	,"title":"The SQL Server modern DBA"
	,"track":"Big Data"
	,"trackid":219
	,"track_fr":"Big Data"
}