Insert Row | Athena | API Reference Docs

Insert a row in an Athena spreadsheet.

Authentication

X-API-KEYstring

API Key authentication via header

Request

This endpoint expects an object.

asset_idstringRequired

The ID of the spreadsheet asset

reference_row_indexintegerRequired

1-based reference row index where to insert

num_rowsintegerOptionalDefaults to 1

Number of rows to insert

sheet_idintegerOptionalDefaults to 1

Sheet ID (defaults to 1)

Response

Successful Response

asset_idstring

The ID of the spreadsheet asset

messagestring

Success message or error description

successboolean

Whether the operation was successful

new_sheet_idinteger or nullOptional

ID of the newly created sheet when the operation creates one (e.g. duplicate). For rnc-engine sheets this is the engine-assigned id, which may differ from a requested new_sheet_id.

Errors

422

Unprocessable Entity Error

$	curl -X POST https://api.athenaintel.com/api/v0/tools/sheets/row/insert \
>	-H "X-API-KEY: <apiKey>" \
>	-H "Content-Type: application/json" \
>	-d '{
>	"asset_id": "spreadsheet_987654321",
>	"reference_row_index": 5
>	}'

1	{
2	"asset_id": "spreadsheet_987654321",
3	"message": "Row inserted successfully at position 5.",
4	"success": true,
5	"new_sheet_id": 1
6	}