Domainr

FREEMIUM
Verified
By Domainr | Updated 4 दिन पहले | Business
Popularity

9.9 / 10

Latency

1,433ms

Service Level

100%

Health Check

N/A

Back to All Discussions

Need help using API in google spreadsheet

Rapid account: Laboheme
laboheme
9 वर्ष पहले

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

Rapid account: Domainr
domainr Commented 9 वर्ष पहले

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

Rapid account: Laboheme
laboheme Commented 9 वर्ष पहले

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

Rapid account: Domainr
domainr Commented 9 वर्ष पहले

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 the status array.

Join in the discussion - add comment below:

Login / Signup to post new comments