Jared_Oxborrow
Community Member

Has anyone used Apipheny.io?

Jump to solution

I'm new to API's and not a skilled developer. I'm working on a team of instructional technologists (not programmers) trying to make use of API's. I don't want to invest the time to learn and develop anything that would become obsolete if I'm not here to maintain it. 

In trying to figure out a solution that could be used by the whole team I came across an Add-on for Google sheets called Apipheny. 

It seems promising, but I wondered if anyone has used it before and if so what was your experience with it. If you haven't, I wonder if anyone who has more experience with making API calls would  be willing to take a look and share their thoughts.

Here is a link to their Google Marketplace App.

Thanks in advance!

Labels (1)
0 Kudos
1 Solution
dtod
Community Contributor

One question would be how it does authorization. You could probably do a manual key, but OAuth is preferred.

I've used MS flow (https://community.canvaslms.com/t5/Canvas-Developers-Group/Microsoft-Power-Apps-or-other-low-code-pl...), Postman, and even built a Google API proxy service, but other platforms support this kind of API work, e.g. Zapier.

View solution in original post

0 Kudos
2 Replies
dtod
Community Contributor

One question would be how it does authorization. You could probably do a manual key, but OAuth is preferred.

I've used MS flow (https://community.canvaslms.com/t5/Canvas-Developers-Group/Microsoft-Power-Apps-or-other-low-code-pl...), Postman, and even built a Google API proxy service, but other platforms support this kind of API work, e.g. Zapier.

0 Kudos

Since I posted I was able to make a few API calls. They have an area where you can add headers, which have "New key" and "Value" fields, and I entered "Authorization" as the key and Bearer <my access token> as the value, and that worked. 

Knowing the right search term can really open a whole world of possibilities! So thanks for introducing me to the term "low-code." That will allow me to explore other solutions alongside Apipheny. It seems pretty handy, and having the response entered directly into a google sheet is nice, but I will check out that other forum you linked to see what other similar solutions there are. 

0 Kudos