Alchemy API

[GoogleCodeExporter]

It seems that data cannot be fetched via the Alchemy API. When I try to Add 
Column by Fetching URL… and use the expression:

"http://access.alchemyapi.com/calls/text/TextGetRankedConcepts?apikey= MY API 
KEY&text=" + value

Google Refine appears to successfully query the service, progressing through 
100%, but only blank cells are returned. I've fetched data successfully using 
this method through similar APIs and I can utilize the Alchemy API successfully 
outside of Google Refine with the same data. Any help is much appreciated.

What is the expected output? text query results

What do you see instead? nothing, cells are blank

What version of Google Refine are you using? 2.1

What operating system and browser are you using? Mac 10.6.8, Safari and Firefox

Is this problem specific to the type of browser you're using or it happens
in all the browsers you tried? Same result in both browsers

Original issue reported on code.google.com by ocean.ch...@gmail.com on 11 Aug 2011 at 2:37

[GoogleCodeExporter]

This is the exact expression that worked for me,

"http://access.alchemyapi.com/calls/text/TextGetRankedConcepts?apikey=1062&text=
" + escape(value, 'url')

Obviously instead of 1062 is the API KEY.

In my experience, errors in making the expression are quite hard to spot!

One thing you can do to help with that is make a column that contains the URL 
so you can inspect/paste it into a browser. Then, "Add column by fetching URLs" 
from that URL column using just 'value' (no quotes)

Original comment by pa...@paulm.com on 11 Aug 2011 at 12:27

[GoogleCodeExporter]

You are a saint! Thank you! 

Original comment by ocean.ch...@gmail.com on 12 Aug 2011 at 3:56

[GoogleCodeExporter]

Oh, and this issue is resolved - the Alchemy API works perfect. 

Original comment by ocean.ch...@gmail.com on 12 Aug 2011 at 4:00

[GoogleCodeExporter]

Original comment by tfmorris on 12 Aug 2011 at 4:16

• Changed state: Invalid