How to automate stream url from Google Sptreadsheets to Roku

Archived
1

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

2

Anyone?

3

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.

4

It is XML but I do not maintain that XML, and that has some info which is not useful to Roku.

5

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

6 
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

7

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

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