Appsheet API for querying data

Hello, thanks in advance for your help.

I have an app and a third party needs to query data from a table in my app (mysql database).

I have tried to generate the endpoint url with the documentation(https://api.appsheet.com/api/v2/apps/{appId}/tables/{tableName}/Action)

But when I try to do the test in Postman I get the following error:

"Message": "REST API invoke request failed - The ApplicationAccessKey in the HTTP header did not match any of the valid ApplicationAccessKeys for the called application."

Although I have added the following headers the error continues

infoproconsult_0-1669739464547.png

Can someone please help me with a way to query data from a third party to a table in my application?

I have gone through all the documentation and tried to add the URL with the API key (https://api.appsheet.com/api/v2/apps/{appId}/tables/{tableName}/Action?applicationAccessKey=<applicationAccessKey>) and still I can't connect, it keeps giving me the same error from postman.

infoproconsult_0-1669739990377.png

 

Thank you very much to those who can help me

 

 

 

 

 

0 4 855
4 REPLIES 4

I don't think you've given enough information about what all you've tried here. I'm not sure if anybody can help besides just throwing out wild guesses.

Hello try to use this as header 

Authorization: "Token token=""9474e7df4ba7c96a06""" 

Accept: "application/json"

 

Please refer to this doc 

https://support.google.com/appsheet/answer/11511244#specify-http-basic-auth-header

 

 

You will have to provide data in the body also, using JSON format.

Might try regenerating the application access key in your application and then use the new key in your request.

Top Labels in this Space