Forum Discussion

zuber's avatar
zuber
Visitor
11 years ago

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
Roku Developer Program

6 Replies

  • krackers123's avatar
    krackers123
    Visitor
    11 years ago
    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's avatar
    zuber
    Visitor
    11 years ago
    It is XML but I do not maintain that XML, and that has some info which is not useful to Roku.
  • krackers123's avatar
    krackers123
    Visitor
    11 years ago
    Do you have a link to the XML? Roku can parse almost all XML files so it should still work.
  • zuber's avatar
    zuber
    Visitor
    11 years ago
    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