> This page is for Glide Classic. > For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://www.glideapps.com/docs/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://www.glideapps.com/docs/_mcp/server. # Add Rows to Table POST https://api.glideapps.com/tables/{tableID}/rows Content-Type: application/json Add one or more rows to an existing Big Table. Row IDs for the added rows are returned in the response in the same order as the input row data is passed in the request. Row data may be passed in JSON, CSV, or TSV format. If a column is not included in the passed row data, it will be empty in the added row. If a column is passed that does not exist in the table schema, or with a value that does not match the column's type, the default behavior is for no rows to be added and the API call to [return an error](/docs/classic-api/general/errors#invalid-row-data). However, you can control this behavior with the `onSchemaError` query parameter. ## Examples If you want to add a small number of rows to a table, you can do so by providing the data inline (being sure that row object structure matches the table schema): ```json [ { "fullName": "Alex Bard", "ageInYears": 30, "hiredOn": "2021-07-03" }, { "fullName": "Alicia Hines", "ageInYears": 34, "hiredOn": "2023-01-015" } ] ``` However, this is only appropriate for relatively small dataset (a few hundred rows or less, depending on schema complexity). If you need to work with a larger dataset you should utilize stashing. [Stashing](/docs/classic-api/stashing/introduction) is our process for handling the upload of large datasets. Break down your dataset into smaller, more manageable, pieces and [upload them to a single stash ID](/docs/classic-api/stashing/stash-data). Then, to add all the row data in a stash to the table in a single atomic operation, use the `$stashID` reference in the `rows` field instead of providing the data inline: ```json { "$stashID": "20240215-job32" } ``` Reference: https://www.glideapps.com/docs/classic-api/tables/add-rows-to-table ## Authentication - `Authorization` header (bearer token, required) — Bearer authentication header of the form Bearer ``, where `` is your [auth token](/docs/api-reference/v2/general/authentication). ## Request ### Path parameters - `tableID` (string, required) ### Query parameters - `onSchemaError` (enum, optional) — The action to take when the passed data does not match the table schema: - `abort`: Abort the entire operation and return an error. - `dropColumns`: Ignore the data that caused the error, and do not import those columns in the affected rows. - `updateSchema`: Update the schema as needed to add any missing columns or widen the data types of existing columns, and then import the data from them. - Allowed values: `abort`, `dropColumns`, `updateSchema` ### Body (application/json) This endpoint expects an addRowsToTable_Request. - `addRowsToTable_Request` - list of map from string to any - AddRowsToTableRequest1 ## Response ### 201 - `data` (TablesTableIdRowsPostResponsesContentApplicationJsonSchemaData, required) ## Errors ### 400 Bad Request Error - `error` (TablesTableIdRowsPostResponsesContentApplicationJsonSchemaError, required) ### 402 Payment Required Error - `error` (TablesTableIdRowsPostResponsesContentApplicationJsonSchemaError, required) ### 404 Not Found Error - `error` (TablesTableIdRowsPostResponsesContentApplicationJsonSchemaError, required) ### 422 Unprocessable Entity Error - `error` (TablesTableIdRowsPostResponsesContentApplicationJsonSchemaError, required) ## Types ### AddRowsToTableRequest1 A single reference to a [stash](/docs/api-reference/v2/stashing) whose data should be used. - `$stashID` (string, required) — ID of the stash, e.g., `20240215-job32` ### TablesTableIdRowsPostResponsesContentApplicationJsonSchemaData - `rowIDs` (list of string, required) — Row IDs of added rows, returned in the same order as the input rows, e.g., ```json [ "zcJWnyI8Tbam21V34K8MNA", "93a19-cf7c-44437-b8c1-e9acbbb" ] ``` ### TablesTableIdRowsPostResponsesContentApplicationJsonSchemaError - `type` (enum, required) - Allowed values: `column_has_invalid_value`, `column_id_reserved`, `column_id_not_found` - `message` (string, required) ## Examples **Request** ```json [ { "amountPaid": 0, "fullName": "Alex Bard", "invoiceDate": "2024-07-29T14:04:15.561Z", "totalAmount": 34.5 }, { "amountPaid": 20, "fullName": "Alicia Hines", "invoiceDate": "2023-06-15T10:30:00.000Z", "totalAmount": 50.75 } ] ``` **Response** ```json { "data": { "rowIDs": [ "zcJWnyI8Tbam21V34K8MNA", "93a19-cf7c-44437-b8c1-e9acbbb" ] } } ``` **SDK Code** ```python import requests url = "https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows" payload = [ { "amountPaid": 0, "fullName": "Alex Bard", "invoiceDate": "2024-07-29T14:04:15.561Z", "totalAmount": 34.5 }, { "amountPaid": 20, "fullName": "Alicia Hines", "invoiceDate": "2023-06-15T10:30:00.000Z", "totalAmount": 50.75 } ] headers = { "Authorization": "Bearer ", "Content-Type": "application/json" } response = requests.post(url, json=payload, headers=headers) print(response.json()) ``` ```javascript const url = 'https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows'; const options = { method: 'POST', headers: {Authorization: 'Bearer ', 'Content-Type': 'application/json'}, body: '[{"amountPaid":0,"fullName":"Alex Bard","invoiceDate":"2024-07-29T14:04:15.561Z","totalAmount":34.5},{"amountPaid":20,"fullName":"Alicia Hines","invoiceDate":"2023-06-15T10:30:00.000Z","totalAmount":50.75}]' }; try { const response = await fetch(url, options); const data = await response.json(); console.log(data); } catch (error) { console.error(error); } ``` ```go package main import ( "fmt" "strings" "net/http" "io" ) func main() { url := "https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows" payload := strings.NewReader("[\n {\n \"amountPaid\": 0,\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5\n },\n {\n \"amountPaid\": 20,\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75\n }\n]") req, _ := http.NewRequest("POST", url, payload) req.Header.Add("Authorization", "Bearer ") req.Header.Add("Content-Type", "application/json") res, _ := http.DefaultClient.Do(req) defer res.Body.Close() body, _ := io.ReadAll(res.Body) fmt.Println(res) fmt.Println(string(body)) } ``` ```ruby require 'uri' require 'net/http' url = URI("https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows") http = Net::HTTP.new(url.host, url.port) http.use_ssl = true request = Net::HTTP::Post.new(url) request["Authorization"] = 'Bearer ' request["Content-Type"] = 'application/json' request.body = "[\n {\n \"amountPaid\": 0,\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5\n },\n {\n \"amountPaid\": 20,\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75\n }\n]" response = http.request(request) puts response.read_body ``` ```java import com.mashape.unirest.http.HttpResponse; import com.mashape.unirest.http.Unirest; HttpResponse response = Unirest.post("https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows") .header("Authorization", "Bearer ") .header("Content-Type", "application/json") .body("[\n {\n \"amountPaid\": 0,\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5\n },\n {\n \"amountPaid\": 20,\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75\n }\n]") .asString(); ``` ```php request('POST', 'https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows', [ 'body' => '[ { "amountPaid": 0, "fullName": "Alex Bard", "invoiceDate": "2024-07-29T14:04:15.561Z", "totalAmount": 34.5 }, { "amountPaid": 20, "fullName": "Alicia Hines", "invoiceDate": "2023-06-15T10:30:00.000Z", "totalAmount": 50.75 } ]', 'headers' => [ 'Authorization' => 'Bearer ', 'Content-Type' => 'application/json', ], ]); echo $response->getBody(); ``` ```csharp using RestSharp; var client = new RestClient("https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows"); var request = new RestRequest(Method.POST); request.AddHeader("Authorization", "Bearer "); request.AddHeader("Content-Type", "application/json"); request.AddParameter("application/json", "[\n {\n \"amountPaid\": 0,\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5\n },\n {\n \"amountPaid\": 20,\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75\n }\n]", ParameterType.RequestBody); IRestResponse response = client.Execute(request); ``` ```swift import Foundation let headers = [ "Authorization": "Bearer ", "Content-Type": "application/json" ] let parameters = [ [ "amountPaid": 0, "fullName": "Alex Bard", "invoiceDate": "2024-07-29T14:04:15.561Z", "totalAmount": 34.5 ], [ "amountPaid": 20, "fullName": "Alicia Hines", "invoiceDate": "2023-06-15T10:30:00.000Z", "totalAmount": 50.75 ] ] as [String : Any] let postData = JSONSerialization.data(withJSONObject: parameters, options: []) let request = NSMutableURLRequest(url: NSURL(string: "https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "POST" request.allHTTPHeaderFields = headers request.httpBody = postData as Data let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error as Any) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ```