Using an API from another software in my app

Tiger1 · 02-20-2020 07:36 AM

I am confused on how to add an API i have from another software in one of my apps. I have a token and
an API key - from the other software. Where do i go to add this to my app?

Steve

https://help.appsheet.com/en/?q=api

Tiger1

Thanks Steve. As i am reading through this, it seems this is using the API key from Appsheets, correct? If i have the key from another software to use- how to i place that in Appsheets to pull information from that software? I have read about webhooks, but it seems to be more for tables already built in appsheets - to other tables built in appsheets…

I guess i am asking, in order to get data from the software (not Appsheets) without using Google or Onedrive, etc… I want to use an API. I want it always flowing data into my app. So i need to create a webhook in Appsheets for doing that?

Koichi_Tsuji

This is one of the missing features we currently dont have in Appsheet.

We call external API, but Appsheet is currently not possible to parse the response body and dump the data into the data source you are connecting.

I really love to have such a feature in place.

My old post to extract data from external API and consume within Appsheet. This may help you a bit.

Daniel_Sayo

Hi,
On this thread:
Do we have an update when Appsheet will be able to handle response from a GET request / parse the response and put the data in a form? Also to call an external API that does a POST HTTP method?

Thanks

Marc_Dillon

There has not been any mention of this feature coming anytime soon.

Not sure what you mean by this? Appsheet can POST to external APIs.

Phil

Hi Tiger,

You can push data from some external systems into Appsheet by using a webhook in the external system to invoke the Appsheet API Steve referred you to.

This approach works if the external system allows you to invoke a webhook when data you care about is added, updated, or deleted in the external system.

As Koichi said, we don’t currently support a way to pull data from an external system directly into Appsheet.

Tiger1

Ok. Unfortunately - my software says they only have a “pull” not a “push”. However, can i use Zapier to do this?

Harriswe

@Phil I too have this requirement to pull data from an external API in to the AppSheet app. Again the external API does not PUSH data. Using Zapier as an intermediary will NOT go down well with the client-user and it adds another fail-point in the API set-up.

If AppSheet does not plan to offer this functionality we may have to reconsider using AppSheet as our development platform, which will come at a massive cost. Is there really no alternative other than using Zapier? 🤔

Phil

Hi Tiger,

You can perform a Zap on a schedule. That should allow you to pull data from from your software system on a schedule you specify. Once you get the pull response, you could push the data to AppSheet using the AppSheet API.

Tiger1

ok. I got the data to go into my Zap. But i cant figure out where to push this into appsheets pp using Appsheet api…

Phil

See https://help.appsheet.com/en/articles/1980012-adding-records-to-a-table
and https://help.appsheet.com/en/articles/1980044-connect-a-zapier-zap-to-your-app

Tiger1

Thank you…