Update roster via YQL? [Sean Montgomery?]

Jeff Huang2 Jan 2012 7:31 PM
Is the only way to update a roster via the PUT webservice?

I tried messing around with the YQL Console and couldn't figure out how to UPDATE a specific player's position.

I tried this:
update fantasysports.teams.roster set position="BN" where team_key='265.l.xxx.t.x' and date='2012-01-02' and players.player.player_id=4612

And got this:
No matching endpoints for verb 'update' in table 'fantasysports.teams.roster'  

Which makes me think I need to use the webservice (though I don't know if I can install the OAuth php module on the server I'm using).

cc Sean Montgomery - looks like you've been answering a lot of these questions :)
Jeff Huang2 Jan 2012 8:33 PM
Also a separate question - I have a site working using the Yahoo.inc session ($session = YahooSession::requireSession(API_KEY, SHARED_SECRET, APP_ID);), and I like it because it does the redirect and everything for you, is there a way to get the oauth token(s) out of this rather than trying to do what&#39;s in the example?<br><br>http://developer.yahoo.com/fantasysports/guide/GettingStarted.html#GettingStarted-sample<br><br> QUOTE (Jeff Huang @ 2 Jan 2012 7:31 PM) Is the only way to update a roster via the PUT webservice?<br><br>I tried messing around with the YQL Console and couldn&#39;t figure out how to UPDATE a specific player&#39;s position.<br><br>I tried this:<br>update fantasysports.teams.roster set position=&quot;BN&quot; where team_key=&#39;265.l.xxx.t.x&#39; and date=&#39;2012-01-02&#39; and players.player.player_id=4612<br><br>And got this:<br> No matching endpoints for verb &#39;update&#39; in table &#39;fantasysports.teams.roster&#39; &nbsp;<br><br>Which makes me think I need to use the webservice (though I don&#39;t know if I can install the OAuth php module on the server I&#39;m using).<br><br>cc Sean Montgomery - looks like you&#39;ve been answering a lot of these questions :)<br>
Nathan Lutterman14 Feb 2012 3:19 PM
An answer to this would be much appreciated as I&#39;m in the same boat.
stuartf5 Mar 2012 8:44 PM
I don&#39;t think it is possible via YQL, but I have been wrong before.... You can always use the good ole put, though:&nbsp;http://developer.yahoo.com/fantasysports/guide/roster-resource.html#roster-resource-PUT