Validate Configuration Spreadsheet

curl --request POST \
  --url https://app.aiinsurance.io/api/v1/external/companies/{companyId}/configuration/validate \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "googleOAuthToken": "ya29.a0AfH6SM..."
}
'

{
  "isValid": true,
  "errors": [],
  "spreadsheetName": "Allied Professionals Configuration"
}

Configuration Management

Validate Configuration Spreadsheet

Validates the structure and data of an FMV1 configuration spreadsheet without applying any changes. Use this to check for errors before running an import.

Returns a list of validation errors with details about the sheet, column, and row where each issue was found.

The caller must provide their own Google OAuth2 access token with read permission on the target spreadsheet.

Required permission: company.configuration:export

This endpoint requires an API key created with the FMV1_CONFIGURATION_MANAGER role. See Authentication for how to create API keys with specific roles.

POST

api

external

companies

{companyId}

configuration

validate

Validate Configuration Spreadsheet

curl --request POST \
  --url https://app.aiinsurance.io/api/v1/external/companies/{companyId}/configuration/validate \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "googleOAuthToken": "ya29.a0AfH6SM..."
}
'

{
  "isValid": true,
  "errors": [],
  "spreadsheetName": "Allied Professionals Configuration"
}

Authorizations

Authorization

string

header

required

API key authentication. Send your raw API key as the Authorization header value with NO scheme prefix — Authorization: YOUR-API-KEY. Do NOT prefix it with Bearer or ApiKey, and do not use an X-API-Key header; those are not accepted.

Path Parameters

companyId

string<uuid>

required

Company identifier

Body

application/json

Request body for FMV1 configuration spreadsheet operations

spreadsheetId

string

required

The ID of the target Google Spreadsheet

googleOAuthToken

string

required

A valid Google OAuth2 access token with Google Sheets access permission

Response

Validation completed

Result of validating an FMV1 configuration spreadsheet

isValid

boolean

required

Whether the spreadsheet passed all validation checks

errors

object[]

required

List of validation errors (empty when isValid is true)

Show child attributes

spreadsheetName

string

required

The name of the spreadsheet that was validated

Export Configuration Compare Configuration

⌘I