Endpoint URL: https://api.alfinsight.com/odata/Companies

Returns data ALF holds about Companies. This includes both Advertisers and Agencies.

OData relations

Expandable entities

These can be fetched along with the Company data using OData's $expand option.

• Websites - Company website(s).
• Locations - Locations where the Company has offices.
• Spend - Company's historical spend data (Advertisers only). Spend data is sourced from Nielsen.
• Digital Spend - Further breakdown of Digital Spend data (Advertisers only).

Related entities

These require a separate API request based on a single company. If you know the CompanyId of a Company you are interested in, you can fetch related data using URL in the format:

https://api.alfinsight.com/odata/Companies({CompanyId})/{Relation}

• Websites - Company website(s).
• Locations - Locations where the Company has offices.
• Spend - Company's historical spend data (Advertisers only). Spend data is sourced from Nielsen.
• Digital Spend - Company's digital spend breakdown data (Advertisers only) from spend data.
• Brands - Related Brands.
• Contacts - Contacts that work for the Company.
• Trade Press - News articles related to the Company.

Field Specifications

Key field(s): CompanyId

To fetch details for one Company using the key field(s), call the endpoint with URL in format: /odata/Companies({CompanyId})

Websites are expandable, so you can fetch them with Company data in one request like this:

You can also fetch them for one Company in this format:

This will only return the Websites data.

Field Specifications

Key field(s): UrlId

To fetch details for one Website using the key field(s), call the endpoint with URL in format: /odata/Websites({UrlId})

Locations are expandable, so you can fetch them with Company data in one request like this:

You can also fetch them for one Company in this format:

This will only return the Locations data.

Field Specifications

Key field(s): CompanyId, CountyCode

To fetch details for one Company Location using the key field(s), call the endpoint with URL in format: /odata/CompanyLocations({CompanyId}, {CountyCode})

Spend is expandable, so you can fetch it with Company data in one request like this:

You can also fetch Spend for one Company in this format:

Field Specifications

Key field(s): CompanyId, SpendType, Year, Quarter

To fetch details for one Company Spend using the key field(s), call the endpoint with URL in format: /odata/CompanySpend({CompanyId}, {SpendType}, {Year}, {Quarter})

Digital Spend is expandable, so you can fetch it with Company data in one request like this:

You can also fetch Spend for one Company in this format:

Field Specifications

Key field(s): CompanyId, SpendType, Year, Quarter

To fetch details for one Company Digital Spend using the key field(s), call the endpoint with URL in format: /odata/CompanyDigitalSpend({CompanyId}, {SpendType}, {Year}, {Quarter})

You can fetch the Company's Brands in this format:

Field Specifications

Key field(s): BrandId

To fetch details for one Brand using the key field(s), call the endpoint with URL in format: /odata/Brands({BrandId})

You can fetch the Contacts working for a Company with a URL in this format:

Field Specifications

Key field(s): JobId

To fetch details for one Contact using the key field(s), call the endpoint with URL in format: /odata/Contacts({JobId})

You can fetch the Trade Press related to a Company with a URL in this format:

Field Specifications

Key field(s): TradePressNewsId

To fetch details for one Trade Press article using the key field(s), call the endpoint with URL in format: /odata/TradePress({TradePressNewsId})