CONSUME EXTERNAL APIs 'Pull data to appsheet app'

[Beda]

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

[Marc_Dillon]

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.

[Beda]

Thanks @Marc_Dillon ,

This is very helpful. Exploring GAS Option now. 

[juandres]

Do you use an integration platform like Make or Zappier?

I can do it with Make through webhooks

[Beda]

Hi @Ju ,

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