Bálint S.

how do I see the actual JSON?

I get a similar answer to both "data" or "records": The specified result path "records" was not found in the response or was not an array.

I've created this table: https://app.clay.com/workspaces/546708/workbooks/wb_0t5m0u5u8eKco9mjCfd/tables/t_0t6litfJeac6GfpX4Yv/views/gv_0t6litfSVYd8XMQebvV With this setup Endpoint: https://api.attio.com/v2/objects/companies/records/query Method: GET Headers: {Content-Type:application/json,Authorization:Bearer [our API key]} But I get a "The response is not an array." error. The Attio API documentation is here: https://attio.mintlify.app/rest-api/overview

sort of. What I don't understand how will it pull each ICP company into a separate row.

I have an HTTP API account set up already. How should the query be set up? I assume the Method is "GET", the endpoint is probably https://api.attio.com/v2/objects/companies/records/query.

yes, thank you. Next and connected question. Now that I thought about it me sending weekly or monthly data of all ICP companies will require too much Attio resource (each refresh would consume 3-4 Attio automation credit). Is there a way to rather PULL the data from Attio via an HTTP API call? My problem is, how to set up a table that would query Attio, pull ICP companies into it's rows and have a way to get automatically refreshed weekly or monthly.

Attio don't have integration so the data would come into the table to a Clay webhook. Would that change anything?

ok. I'll create separate tables. Hopefully source identification will be a thing at some point.

Sayli G. any additional thoughts here?