Rows APIs
The rows APIs are used to create, update, and delete records. The rows APIs are available in the rows
namespace and are generally easier to use then the cells apis.
The rows APIs are great when using a ETL tool like boomi, workato, pipedream, or zappier. The rows APIs works with APIName properties instead of IDs, these APIs are slower then the Cells APIs.
All rows APIs support bulk operations.
Schema
When working with the rows APIs you will can use a standard JSON schema to define the data you are working with.
Get Schema
{
"totalRecords": 1,
"rows": [Entries]
}
Entries
FieldAPiName
is the APIName of the field(s) you have on a given object
{
"EntryId": "string",
"FieldAPiName": "string",
}
Endpoints
Get
Get Data from the system. If you are planning to use queries you should use the Query endpoint instead.
Query
Query Data from the system. Everything you can do with the Get endpoint you can do with the query endpoint. The query endpoint allows for larger queries.
Create
Endpoint for creating new entries in the system.
Patch
Endpoint for updating existing entries in the system.
Put
Endpoint for updating existing entries in the system, same as Patch.
Views
Endpoint for working with views in the system.
View Details
Endpoint for getting data from a view in the system.