Can you share a sample response if you call the API with curl or postman, etc.. it can be a snip of just the first two elements, and feel free to obfuscate any private into in the actual data. I mainly want to see the structure of the JSon payload. Also, please share the resource paths you are configuring (you mentioned you have 3 paths configured).
You can send it to me at shaaland@google.com .
My guess, without seeing the details is that the JSON is not putting the table name as the root element. See these snips from the doc page. Note how the tableName has to match both the API Resource Path and the JSON root element. ie: /orders in the path has to have a root element of { "orders" : [ ...
|
API Resource Paths
|
Comma-separated list of API proxy endpoints. The paths correspond to table names in AppSheet.
|
...
To get all entries in a table, the Apigee API proxy must support the following API operation:
GET /{tableName}
Where:
{tableName} - Name of the table.
The response body consists of a JSON payload with {tableName} as the key that includes the details for all rows in the table. For example:
{
"tableName": [
{
"ID": 1,
"TextValue": "Test1",
"DecimalValue": 1.10,
"DateTime": "1/1/2016 1:01:01 AM",
"PhoneValue": "111 111 1111",
"EmailValue": "email1@appsheet.com"
},
{
"ID": 2,
"TextValue": "Test2",
"DecimalValue": 1.11,
"DateTime": "2/1/2016 1:01:01 AM",
"PhoneValue": "111 112 1111",
"EmailValue": "email2@appsheet.com"
}
]
}
LinkedIn
Twitter
