zuber
Visitor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-10-2015
03:29 PM
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?
Below url is what is in Google Spreadsheet cell A1.
Thanks
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
6 REPLIES 6
zuber
Visitor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2015
06:18 AM
Re: How to automate stream url from Google Sptreadsheets to
Anyone?
krackers123
Visitor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2015
10:47 AM
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.
zuber
Visitor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2015
12:09 PM
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.
krackers123
Visitor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2015
12:48 PM
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.
zuber
Visitor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2015
01:54 PM
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


Roku Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2015
05:59 PM
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