API doesn't return row data

Hi, I’m trying to do a simple “Find” on a table in my app. The POST is successful, but the response body contains no rows.

URL:

https://api.appsheet.com/api/v1/apps/{{appId}}/tables/{{tableName}}

Headers:

ApplicationAccessKey: {{appKey}}
Content-Type: application/json
User-Agent: PostmanRuntime/7.28.4
Accept: */*
Postman-Token: {{token}}
Host: api.appsheet.com
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Length: 72

Body:

{
"Action": "Find",
"Properties": {
   "Locale": "en-GB"
},
"Rows": []
}

Reponse Body:

{
    "HasWarning": true,
    "ReturnedFromCache": false,
    "RowValues": null,
    "Success": true,
    "ErrorDescription": "",
    "Retryable": true,
    "Timestamp": "2021-09-21T21:22:49.4015053Z",
    "BackendVersion": 1.0,
    "RequiredIOSAppVersion": 4.3,
    "RequiredAndroidAppVersion": 3.0,
    "AppSheetJSVersion": "'20210921'.1",
    "ExternalAccounts": null
}

As you can see, I get a "Success": true, but I don’t get any rows back. I tested by running an “Add” and it adds to the table correctly, but also doesn’t return the row (and the auto-generated ID that I need access to).

Any help would be much appreciated!

Solved Solved
0 1 576
1 ACCEPTED SOLUTION

Most upsetting. I had copied the url from another help article, and it was wrong xD

Should have been:

https://api.appsheet.com/api/**v2**/apps/{{appId}}/tables/{{tableName}}/**Action**

View solution in original post

1 REPLY 1

Most upsetting. I had copied the url from another help article, and it was wrong xD

Should have been:

https://api.appsheet.com/api/**v2**/apps/{{appId}}/tables/{{tableName}}/**Action**
Top Labels in this Space