Paid API key

[Priscila]

Good Morning

I was wondering if you could help me.

I was geocoding in open refine  using

 http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address="+escape(value,"url")

Tired of reaching my daily limit I got a paid key, However I cannot seem to use it correctly

 "http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address="+escape(value,"url")+"&key=APIKEY##"

However I keep getting this message

{

   "error_message" : "This API project was not found. This API project may have been \"\n             R\"(deleted.",

   "results" : [],

   "status" : "REQUEST_DENIED"

}

Could you help me?

Thanks

Priscila

[John Little]

As I read this I'm wondering if you tried the google maps api support options.    From your description it looks like you have a syntax problem for querrying the API rather than an issue with OpenRefine.  

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[xueyu...@gmail.com]

Hi there,

I have the same problem here. Did you fix that? thanks

[xueyu...@gmail.com]

I just figure out that instead of using http://, you probably need to use https://. It works for me

On Friday, June 10, 2016 at 10:38:14 AM UTC-4, Priscila wrote:

[rmal...@mail.uoguelph.ca]

Hi Priscila,

After much trial and error...This is what worked for me: 

"https://maps.googleapis.com/maps/api/geocode/json?address="+escape(value,"url")+"&key=APIKEY###"

Cheers,

Ryan

On Friday, June 10, 2016 at 10:38:14 AM UTC-4, Priscila wrote:

[raja kumar dash]

Just supplementing the answer that Ryan gave, inserting the API key into the URL as a parameter.... If anyone runs into a similar issue with a service other than Googleapis.com, trying ensuring that your API key value is the first parameter in the URL's querystring portion. I had this issue with the API for https://collegescorecard.ed.gov/.

For geocoding with Googleapis, I got around rate limit issues by always caching the results into an aggregated OpenRefine project and checked there first before querying Google. That's not always possible or useful, though.

[Shubham Agarwal]

I change http to https
place key at first query param
and enable Geocoding API.
And finally it worked

On Friday, June 10, 2016 at 7:38:14 AM UTC-7, Priscila wrote:

[Jitendra patil]

I was forget to enable API. After enabling API it's working fine.

Thanks You so much!