Get Records through a COQL Query

POST {{api-domain}}/crm/v4/coql

To get the records from the module through a COQL query.

Request Body

{"select_query"=>"select 'Account_Name' AS 'Account id','Account_Name.Account_Name' as 'Account Name','Account_Name.Parent_Account' as 'Parent Account id','Account_Name.Parent_Account.Account_Name' As 'Parent Account Name' from Contacts where Last_Name is not null"}

RESPONSES

status: OK

{"data":[{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Benton (Sample)","Account_Name":{"id":"4876876000000333089"},"id":"4876876000000333182"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Chanay (Sample)","Account_Name":{"id":"4876876000000333090"},"id":"4876876000000333183"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Chemel (Sample)","Account_Name":{"id":"4876876000000333091"},"id":"4876876000000333184"},{"Account_Name.Parent_Account.Account_Name":"King (Sample)","Account_Name.Parent_Account":{"id":"4876876000000333098"},"Account_Name.Account_Name":"Account_Name","Account_Name":{"id":"4876876000000333092"},"id":"4876876000000333185"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Printing Dimensions (Sample)","Account_Name":{"id":"4876876000000333093"},"id":"4876876000000333186"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Chapman (Sample)","Account_Name":{"id":"4876876000000333094"},"id":"4876876000000333187"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Morlong Associates (Sample)","Account_Name":{"id":"4876876000000333095"},"id":"4876876000000333188"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Commercial Press (Sample)","Account_Name":{"id":"4876876000000333096"},"id":"4876876000000333189"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Truhlar And Truhlar (Sample)","Account_Name":{"id":"4876876000000333097"},"id":"4876876000000333190"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"King (Sample)","Account_Name":{"id":"4876876000000333098"},"id":"4876876000000333191"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000000353011"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000000903051"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000000911051"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000000917050"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"XYZ systems","Account_Name":{"id":"4876876000001036036"},"id":"4876876000001036016"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"XYZ systems","Account_Name":{"id":"4876876000001036036"},"id":"4876876000001036039"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"XYZ systems","Account_Name":{"id":"4876876000001036036"},"id":"4876876000001073079"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000001081556"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Zoho Corporation","Account_Name":{"id":"4876876000001102002"},"id":"4876876000001102005"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Zoho Corporation","Account_Name":{"id":"4876876000001102002"},"id":"4876876000001117156"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000001125131"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":null,"Account_Name":null,"id":"4876876000001125192"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Villa Margarita","Account_Name":{"id":"4876876000001236001"},"id":"4876876000001236004"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Villa Margarita","Account_Name":{"id":"4876876000001236040"},"id":"4876876000001236043"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Grayson","Account_Name":{"id":"4876876000001236083"},"id":"4876876000001236086"},{"Account_Name.Parent_Account.Account_Name":null,"Account_Name.Parent_Account":null,"Account_Name.Account_Name":"Villa Margarita","Account_Name":{"id":"4876876000001236040"},"id":"4876876000001288001"}],"info":{"count":26,"more_records":false}}