Description
To get the newly created/updated/deleted table rows in a specific table by specifying the activity and timestamp.
Note: To use this API a personal user profile token must be generated. For more information about how to get an API key see, Generating API key.
GET https://app.workspace.ai/api/public/tableApps/{{tableAppId}}/tables/{{tableId}}/rows?&since={{Since_Date}}&activity={{Activity}}&limit=20
Header
Invoke the API with JWT in the header with the following syntax:
--header 'auth: {{apiKey}}'
API Parameters
| Parameter | Description |
| tableAppId | The table app ID received in the API from the table app for which you have access. |
| tableId | Name of the table app. |
| Since_Date | The DateTime (ISO String/epochTime) from when you want to get the modified rows. For example, since=2022-06-28T13:40:22.000Z |
| Activity | Row Activity for which you are polling.
It is an optional parameter. By default it will return newly created/updated rows from DateTime provided. The possible values are ‘updated’, ‘updated’, and ‘created’.
|
Response Content Type
application/json
Sample Request
curl --location -g --request GET 'https://Workspace.ai.kore.ai/public/tableApps/{{tableAppId}}/tables/{{tableId}}/rows?&since={{Since_Date}}&activity={{Activity}}&limit=20' \
--header 'auth: {{apiKey}}'
Sample Response
{
"rows": [
{
"indexId": 10,
"wsId": "62baff5024c65d127485187a",
"appId": "i-0d7d6f7b-c961-5401-bdd2-16fc738d7b62",
"cOn": "2022-06-28T13:40:22.000Z",
"lMod": "2022-06-28T13:40:22.000Z",
"createdBy": "u-1063ff23-a182-595c-98e8-cfdd9964fefa",
"lModBy": "u-1063ff23-a182-595c-98e8-cfdd9964fefa",
"state": 0,
"position": "0|100008:",
"title": "Laptop/Desktop Buyers",
"status": "reviewsa184",
"texte6c18e": "Drive awareness to new homeowners, CPM >$1.45",
"dropdownc2c9a2": "awareness2d4b",
"date": "2022-01-25T18:30:00.000Z",
"date7dc09d": "2022-02-03T18:30:00.000Z",
"dropdown1fcd89": "continuee2ad",
"assignTo": "u-1063ff23-a182-595c-98e8-cfdd9964fefa",
"id": "61d5813bfe169b5966686bfd",
"tableId": "62bb04c6124d460eee1860b1"
}
],
"hasMore": false
}