Roku Developer Program

Developers and content creators—a complete solution for growing an audience directly.
cancel
Showing results for 
Search instead for 
Did you mean: 
zuber
Level 7

How to automate stream url from Google Sptreadsheets to Roku

I am using Google Spreadsheet formula =importxml to import stream url to the spreadsheet.

The url changes from time to time. How can I auto update this url into my roku channel?

			<streamBitrate>1500</streamBitrate>
<streamUrl>http://d1hya96e2cm7qi.cloudfront.net/Live/_definst_/sweetbcha1novD254_W_350.sdp/playlist.m3u8</streamUrl>
</media>
<synopsis></synopsis>


Below url is what is in Google Spreadsheet cell A1.
http://d1hya96e2cm7qi.cloudfront.net/Live/_definst_/sweetbcha1novD254_W_350.sdp/playlist.m3u8


Thanks
0 Kudos
6 Replies
zuber
Level 7

Re: How to automate stream url from Google Sptreadsheets to

Anyone?
0 Kudos
krackers123
Level 7

Re: How to automate stream url from Google Sptreadsheets to

Well if you have the XMl URL why not just use that directly? If it is not XML, what is the source of the info. If it is JSON then roku supports that too.
0 Kudos
zuber
Level 7

Re: How to automate stream url from Google Sptreadsheets to

It is XML but I do not maintain that XML, and that has some info which is not useful to Roku.
0 Kudos
krackers123
Level 7

Re: How to automate stream url from Google Sptreadsheets to

Do you have a link to the XML? Roku can parse almost all XML files so it should still work.
0 Kudos
zuber
Level 7

Re: How to automate stream url from Google Sptreadsheets to

http://52.74.60.168/controller/Controller?id=D254&platform=iPhone&network=hd&for=wowza&isadver=yes


This link is appearing to be offline right now, but this is format of the URL. Can you please guide me how to parse XML in roku environment.

Thanks
0 Kudos
Roku Employee
Roku Employee

Re: How to automate stream url from Google Sptreadsheets to

"zuber" wrote:
Can you please guide me how to parse XML in roku environment.


http://sdkdocs.roku.com/display/sdkdoc/roXMLElement
0 Kudos