The GTM Provider Directory
CRM & Data

How do I pull ICP company data from an external CRM via API to automatically refresh a table?

April 2026

Quick Answer

# Pulling ICP Company Data from Attio API ## Issue The API endpoint is returning "The response is not an array" error when querying company records. ## Configuration **Endpoint:** `[api.attio.com](https://api.attio.com/v2/objects/companies/records/query`) **Method:** GET **Headers:** ``` Content-Type: application/json Authorization: Bearer [your API key] ``` ## Solution The error suggests the API response structure doesn't match what **Clay** expects. Review the [Attio API documentation](https://attio.mintlify.app/rest-api/overview) to: - Verify the response format returned by the `/quer

○
Up to date
1 months ago

1 Answer

Pulling ICP Company Data from Attio API

Issue

The API endpoint is returning "The response is not an array" error when querying company records.

Configuration

Endpoint: [api.attio.com](https://api.attio.com/v2/objects/companies/records/query)

Method: GET

Headers:

Content-Type: application/json
Authorization: Bearer [your API key]

Solution

The error suggests the API response structure doesn't match what Clay expects. Review the Attio API documentation to:

  • Verify the response format returned by the /query endpoint
  • Check if the data is wrapped in an object rather than a direct array
  • Confirm the correct endpoint for retrieving company records
  • Review any required request parameters for the query endpoint

If the response is wrapped in an object (e.g., {"records": [...]} or {"data": [...]}), you may need to adjust your Clay table configuration to parse the nested array rather than treating the entire response as an array.

GTM StackCommunity Insight