Zapier API appsheet integration BETA

[a_fatima]

Anyone know why I am getting errors when I am trying to use zapiers beta integration with appsheet. The error is attached below?

[Koichi_Tsuji]

Im not perfectly sure, but my understanding is Appsheet/Zap integration is no longer supported. It could be died out bata stage.

It is making sense to me (at least) as Google acquire appsheet (after this beta programme was in place), and Appsheet team should have been focusing on Appsheet Automation, which is their own integration tool to communicate the third party services.

Appsheet Automation (new feature, yet released) is competing with Zap, so my understanding is it is no longer supported, if i m not wrong.

Also Appsheet API requires Business Plans as well, which seems to be making story complicated as well.

[a_fatima]

can I use appsheet REST API in zapier to be able to add a new row to appsheet? if so how?

[Koichi_Tsuji]

I m not Appsheet employee, only they could advise you precisely. Suggest you send your own query to support@appsheet.com

[Koichi_Tsuji]

Again this is basis TBOOK (to the best of my knowledge).

I never used Zapier before on my production app of Appsheet, as I dont like to get the third party services involved, and make it my own rule to stay with appsheet features and function as much as possible for the Apps which I push and manage for my clients.

But I remember Zapier should have Webhook service in general.

Provided that the Appsheet account and creator is on the right plan to deal with AppSheet API, it should work.

Once you detect the changes in the data base (spreadsheet) then you take that even as trigger to initiate the subsquent job, which is to call to Appsheet API to trigger action.

help.appsheet.com

Invoking an Action

How to invoke an action using the API.

See the document in terms of firing Appsheet Action through Appsheet APIs.

You set Appsheet action to change some value in some table. Then create workflow to do NOTIFICATION as you want.

I quickly tested with AppSheet/Postman, and the result was positive, so it should work, as far as we could make the settings on Zap correctly.

[Henry_Scott]

@Phil is it true that Zapier Beta was discontinued? Was there an announcement? Maybe I missed it

[a_fatima]

Hi @tsuji_koichi
I tried your method but I keep getting an error in zapier. Am I setting this up incorrectly? It says content type header missing but I have a content type header.

[Koichi_Tsuji]

Content type should be set to JSON

[a_fatima]

As shown in the picture I have it set to JSON and I tried it again as shown in the image below. Still shows the same error.

[Koichi_Tsuji]

As suggested , you go to support@appsheet.com as it is beyond my capability. Sorry.

[Koichi_Tsuji]

In the meantime are you on the appsheet business plan?

[Steve]

Unbalanced quote:

[a_fatima]

@tsuji_koichi yes I am

[Koichi_Tsuji]

Sure, good luck with appsheet support then.

[a_fatima]

Hi, I removed the quote and tried it again but still got the same error

[Leonard_van_Gen]

Hi everyone!

Any news from anyone on the Appsheet staff regarding this? The problem is affecting our application too.

Regards

[Steve · Accepted solution]

Please contact support@appsheet.com for help with this.

[Phil]

I think this link should still work:
https://zapier.com/developer/public-invite/4368/597ae61fde8ebae08b865d92d46817be/

[teambelair]

Doesn’t seem to work.

[Leonard_van_Gen]

Hi Phil

Thank you for the response. The Zapier Appsheet integration doesn’t appear to work, I get the following error:

Is this perhaps the wrong version of the beta? This is version 2.0.3.

Regards

[Steve]

From a developer:

[…] the problem was that the user needed to go to the Manage > Integrations > In tab and create an Application Access Key.

[Support] diagnosed the problem by checking the REST API call in Audit History and seeing the REST API call fail with a no Application Access Key error. […] check the REST API records in Audit History as the first step […] to take when having trouble with a Zapier call.

Expired access key:

[Henry_Scott]

Appsheet Support responded that we had to activate access keys on the APP LEVEL now. In the past ACCOUNT LEVEL access was enough. So as @Steve explained that the fix is to go into Manage > Integrations > In tab on the app itself.

[Phil]

Try 2.0.0