CANNOT post image via meme api ?

Hi Oscar,

we will rename the field "comment" to "caption" - that should be online in a few days. For now, you can use "comment" instead of "caption" (we'll support both for some time, before removing "comment").

Ex.: INSERT INTO meme.user.posts (type, content, comment) VALUES ("photo", "http://www.yahoo.com/myphoto.jpg", "this is the photo caption posted from YQL")


Regards,
Bruno

hello

I have tried this YQL command with caption and comment without success; I get response NULL
$response = $app->query($yql);
I have no problem with other yql commands like SELECT * FROM meme.following, but I can't post text , photo, audio . What I am doing wrong? Thanks for your help

Hi,

INSERT/UPDATE/DELETE are handled differently in YQL. I'm almost sure this method (query) uses GET to perform the request, and YQL solely rejects it when it is not a SELECT statement. For that case you should use either POST,PUT,DELETE or JSONP-X. Probably you will need to make the request yourself using curl, but I'll double check this.

Regards,
~dsouza

In the doc we have $response = $session->query($query); but the response is NULL! I get the session but I can't post text. Who knows how to do this?

still same problem even after 2 months

$query='INSERT INTO meme.user.posts (type, content) VALUES ("text", "Posting via my app")';

$user->execute($query);

this Does not work.....!

Even
$queryResponse = $session->query($query);
Does not work

i changed method to POST, PUT but no result.

please help us

is yql dont support insert command?

is yql dont support insert command? if not then what is correct solution..

Hi,

the current SDK available for yql does not support INSERT/UPDATE/DELETE commands. The support for this is already being implemented and should be released soon. The problem is that the current SDK uses HTTP GET method for all statements and yql demands either POST,PUT,DELETE (you may actually use GET if you perform JSON-P request, which is really appending a `callback' parameter to the request.).

In the meantime, while the API is not available, the only solution is to implement this by yourself, which is a bit trick as you would need to compute oauth signature correctly. Other than that it should be relatively simple to get this working.

Let me know your findings about this.

Regards,
~dsouza

Hi dsouza,

Any work around for this?

Here's a workaround to get insert capabilities working via the PHP SDK provided for YAP. As mentioned above a GET request with JSON-P (JSON with callback) will work on the system. To modify the SDK to allow this functionality, you can do the following:

In the Yahoo.inc file on like 789 is the following line:
$params = array('q' => $yql, 'format' => 'json', 'env' => 'http://datatables.org/alltables.env');

Switch this to JSON-P functionality by adding a callback like so:
$params = array('q' => $yql, 'format' => 'json', 'callback' => 'runCallback', 'env' => 'http://datatables.org/alltables.env');

Then define in JavaScript the following function (should be in the same file that you're calling the query method):
<script type="text/javascript">
function runCallback(obj){
console.log('callback called' + obj);
}

That should give you the GET request with callback, making the query method be a JSON-P request. This also means that all YQL queries will now go through that callback.

Hope that helps,

Jonathan LeBlanc
Technology Evangelist
Yahoo! Developer Network
Twitter: @jcleblanc