I have an API key from mashabe with CURL syntax. https://www.mashape.com/nbio/domainr. I want to get the status of domains and put in google spreadsheets.
The Curl code is
https://domainr.p.mashape.com/v2/status?mashape-key=1QtxdZj0cumshK8rpzBpiZrSX3Krp1CxSEKjsnQzi4XxPFbnVN&domain=help.com’ (fyi – I changed the key b/c this is public). I am trying to use it in Google spreadsheets. I have 2 problems, I can’t execute the API and I want to make the help.com, a variable instead of text e.g. cell A1. Thanks.
I tried https://coderwall.com/p/vjoqua/quickly-lookup-potential-domains-startup-ideas-with-google-spreadsheets-and-domainr but I don’t know how to change the script with the mashape key. Thanks. https://docs.google.com/spreadsheets/d/182AVe7GzOY8e8tBDJpxNvU2VEAdRPy2fv-4LkeF2usI/edit?usp=sharing
Join in the discussion - add comment below:
Hi Daniel,
I’m pretty sure Mashape supports private support tickets, if you’re concerned about that.
Screenshot: http://cl.ly/image/3d103L3s292j
Your programmer will be able to update the Coderwall code to use the V2 API, it is straightforward. Mashape also probably has a way to revoke your current API token, and create a new one.
Here’s their documentation for it:
http://docs.mashape.com/api-keys#changing
Thanks, changing the code is above my skillset. I have hired someone on odesk. How do I change my API (close my current one and get a new one) since I shared my current one for testing?
Daniel
Hi there,
It looks like the Coderwall post is out of date — we’re now requiring that API calls be made through Mashape, and the V2 responses are structured a bit differently than the V1 responses (which the Coderwall example is using).
Our updated developer documentation is here: http://domainr.build/v2.0/docs/status
There’s an example response in the docs, which you can also see in Mashape by making a test query.
From glancing at the Coderwall code, what you’re probably looking for is the
summary
key in each object in thestatus
array.