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.