Roku Developer Program

Join our online forum to talk to Roku developers and fellow channel creators. Ask questions, share tips with the community, and find helpful resources.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
zuber
Visitor

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 6
zuber
Visitor

Re: How to automate stream url from Google Sptreadsheets to

Anyone?
0 Kudos
krackers123
Visitor

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
Visitor

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
Visitor

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
Visitor

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
RokuChris
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
Need Assistance?
Welcome to the Roku Community! Feel free to search our Community for answers or post your question to get help.

Become a Roku Streaming Expert!

Share your expertise, help fellow streamers, and unlock exclusive rewards as part of the Roku Community. Learn more.