CONSUME EXTERNAL APIs 'Pull data to appsheet app'

AppSheet AppSheet Q&A
, ,
1

Hi Team.

I would want to achieve an integration with external services pulling data in an appsheet table. After several checks in knowledge repo > no clear steps to achieve this. Is it actually possible ?

Case scenario is:

  1. I build an API to push data to a partner services

  2. The partner service needs to do same for a diiferent data set target which will allow me to pull in data into table

Can anyone here help ?

Thanks

Brgds

2

Appsheet can only send “fire & forget” webhooks to external APIs, it cannot handle any response.

To handle a response, one option is to utilize a Google App Script.

Bots can directly trigger a GAS. One of the newer Appsheet features is the ability for a Bot to receive data returned from a triggered GAS, and do stuff with it in subsequent Bot Steps. However this is really only helpful if you’re querying single records at a time.

If you have to handle multi-record responses from your API, you should probably go directly from the GAS to your data source.

2 Likes
3

Do you use an integration platform like Make or Zappier?

I can do it with Make through webhooks

4

Hi @Ju ,

Thanks on your message. i don’t use Make or Zappier. I am currently exploring Google App scripts.

2 Likes
5

Thanks @Marc_Dillon ,

This is very helpful. Exploring GAS Option now.

1 Like