NULL

The original answer doesn't contain actionable information for pulling ICP company data from an external CRM via API. It only raises a clarifying question about Attio integration and Clay webhooks without providing a solution or guidance on how to accomplish the stated goal.

To pull ICP company data from an external CRM via API and automatically refresh a table:

Prerequisites:

• HTTP API account already configured

API Configuration:

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

Refer to the Attio API documentation for complete query parameter specifications and authentication requirements.

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.