> For the complete documentation index, see [llms.txt](https://knowledgebase.fabricdata.com/insights/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.fabricdata.com/insights/api/overview.md).

# Overview

Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions

## Get content pulse KPIs

> Retrieve key performance indicators for content pulse overview

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"KpisResponse":{"type":"object","properties":{"message":{"type":"string"},"kpis":{"type":"object","properties":{"platforms":{"type":"integer"},"countries":{"type":"integer"},"total_contents":{"type":"integer"},"movies":{"type":"integer"},"series":{"type":"integer"},"seasons":{"type":"integer"},"episodes":{"type":"integer"},"releases_current_year":{"type":"integer"}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/kpis":{"get":{"summary":"Get content pulse KPIs","description":"Retrieve key performance indicators for content pulse overview","operationId":"getContentPulseKpis","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"name":"uid","in":"query","required":false,"description":"Filter by content UID(s), comma-separated","schema":{"type":"string"}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/KpisResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get platform assets overview

> Retrieve content counts by platform

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"PlatformAssetsResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"platform_id":{"type":"integer"},"platform_country":{"type":"string"},"name":{"type":"string"},"series_count":{"type":"integer"},"movie_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/platform_assets":{"get":{"summary":"Get platform assets overview","description":"Retrieve content counts by platform","operationId":"getPlatformAssets","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/PlatformAssetsResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic platform assets

> Retrieve historical content counts by platform from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PresentFrom":{"name":"present_from","in":"query","required":false,"description":"Filter to content that was present on or after this date (inclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose out_on is NULL or after this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PresentTo":{"name":"present_to","in":"query","required":false,"description":"Filter to content that entered before this date (exclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose enter_on is before this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"PlatformAssetsResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"platform_id":{"type":"integer"},"platform_country":{"type":"string"},"name":{"type":"string"},"series_count":{"type":"integer"},"movie_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/platform_assets":{"get":{"summary":"Get historic platform assets","description":"Retrieve historical content counts by platform from cp_availability_historic","operationId":"getHistoricPlatformAssets","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/PresentFrom"},{"$ref":"#/components/parameters/PresentTo"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/PlatformAssetsResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic genres overview

> Retrieve historical content distribution by genre from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PresentFrom":{"name":"present_from","in":"query","required":false,"description":"Filter to content that was present on or after this date (inclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose out_on is NULL or after this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PresentTo":{"name":"present_to","in":"query","required":false,"description":"Filter to content that entered before this date (exclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose enter_on is before this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"GenresResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"genre":{"type":"string"},"title_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/genres":{"get":{"summary":"Get historic genres overview","description":"Retrieve historical content distribution by genre from cp_availability_historic","operationId":"getHistoricGenres","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"name":"primary","in":"query","required":false,"description":"When true (default), counts by primary_genre. When false, splits the comma-separated genres column and counts each genre individually (a title may count toward multiple genres).","schema":{"type":"string","default":"true","enum":["true","false"]}},{"$ref":"#/components/parameters/PresentFrom"},{"$ref":"#/components/parameters/PresentTo"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/GenresResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get genres overview

> Retrieve content distribution by genre

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"GenresResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"genre":{"type":"string"},"title_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/genres":{"get":{"summary":"Get genres overview","description":"Retrieve content distribution by genre","operationId":"getGenresOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"name":"primary","in":"query","required":false,"description":"When true (default), counts by primary_genre. When false, splits the comma-separated genres column and counts each genre individually (a title may count toward multiple genres).","schema":{"type":"string","default":"true","enum":["true","false"]}},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/GenresResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic content age distribution

> Retrieve historical content distribution by release age from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PresentFrom":{"name":"present_from","in":"query","required":false,"description":"Filter to content that was present on or after this date (inclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose out_on is NULL or after this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PresentTo":{"name":"present_to","in":"query","required":false,"description":"Filter to content that entered before this date (exclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose enter_on is before this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"AgeResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"category":{"type":"string","enum":["Less than 1 year","1-3 years","4-7 years","7+ years"]},"title_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/age":{"get":{"summary":"Get historic content age distribution","description":"Retrieve historical content distribution by release age from cp_availability_historic","operationId":"getHistoricAge","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/PresentFrom"},{"$ref":"#/components/parameters/PresentTo"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/AgeResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic overview KPIs

> Retrieve historical overview KPIs (platform count, country count, content counts, seasons, episodes) from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PresentFrom":{"name":"present_from","in":"query","required":false,"description":"Filter to content that was present on or after this date (inclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose out_on is NULL or after this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PresentTo":{"name":"present_to","in":"query","required":false,"description":"Filter to content that entered before this date (exclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose enter_on is before this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"KpisResponse":{"type":"object","properties":{"message":{"type":"string"},"kpis":{"type":"object","properties":{"platforms":{"type":"integer"},"countries":{"type":"integer"},"total_contents":{"type":"integer"},"movies":{"type":"integer"},"series":{"type":"integer"},"seasons":{"type":"integer"},"episodes":{"type":"integer"},"releases_current_year":{"type":"integer"}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/kpis":{"get":{"summary":"Get historic overview KPIs","description":"Retrieve historical overview KPIs (platform count, country count, content counts, seasons, episodes) from cp_availability_historic","operationId":"getHistoricKpis","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"name":"uid","in":"query","required":false,"description":"Filter by content UID(s), comma-separated","schema":{"type":"string"}},{"$ref":"#/components/parameters/PresentFrom"},{"$ref":"#/components/parameters/PresentTo"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/KpisResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get content age distribution

> Retrieve content distribution by release age

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"AgeResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"category":{"type":"string","enum":["Less than 1 year","1-3 years","4-7 years","7+ years"]},"title_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/age":{"get":{"summary":"Get content age distribution","description":"Retrieve content distribution by release age","operationId":"getAgeOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/AgeResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic distribution overview

> Retrieve historical content distribution by platform availability from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"DistributionResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"title_year":{"type":"string"},"uid":{"type":"string"},"type":{"type":"string"},"primary_genre":{"type":"string","nullable":true},"total_platforms":{"type":"integer"},"unique_platforms":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/distribution":{"get":{"summary":"Get historic distribution overview","description":"Retrieve historical content distribution by platform availability from cp_availability_historic","operationId":"getHistoricDistribution","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"uid","in":"query","required":false,"description":"Filter by content UID(s), comma-separated","schema":{"type":"string"}},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DistributionResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get content distribution overview

> Retrieve content distribution by platform availability

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"DistributionResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"title_year":{"type":"string"},"uid":{"type":"string"},"type":{"type":"string"},"primary_genre":{"type":"string","nullable":true},"total_platforms":{"type":"integer"},"unique_platforms":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/distribution":{"get":{"summary":"Get content distribution overview","description":"Retrieve content distribution by platform availability","operationId":"getDistributionOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"name":"uid","in":"query","required":false,"description":"Filter by content UID(s), comma-separated","schema":{"type":"string"}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DistributionResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get popular content overview

> Retrieve popular content based on hits score, filterable by type, country, platform, and package type with pagination support

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"PopularResponse":{"type":"object","properties":{"message":{"type":"string"},"pagination":{"type":"object","properties":{"total_items":{"type":"integer"},"total_pages":{"type":"integer"},"page":{"type":"integer"},"page_size":{"type":"integer"}}},"data":{"type":"array","items":{"type":"object","properties":{"position":{"type":"integer"},"delta_position":{"type":"integer"},"score":{"type":"number"},"title":{"type":"string"},"year":{"type":"integer"},"type":{"type":"string"},"poster":{"type":"string","nullable":true}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"BadRequest":{"description":"Bad request - invalid parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/popular":{"get":{"summary":"Get popular content overview","description":"Retrieve popular content based on hits score, filterable by type, country, platform, and package type with pagination support","operationId":"getPopularOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"type","in":"query","description":"Content type filter (e.g. Movie, Show)","required":true,"schema":{"type":"string"}},{"name":"country","in":"query","description":"Country code filter (comma-separated for multiple)","required":false,"schema":{"type":"string"}},{"name":"platform","in":"query","description":"Platform ID filter (comma-separated integer IDs)","required":false,"schema":{"type":"string"}},{"name":"package_type","in":"query","description":"Package type filter (comma-separated, e.g. subscription-vod, transaction-vod, free-vod, tv-everywhere, validated-vod)","required":false,"schema":{"type":"string"}},{"name":"page","in":"query","description":"Page number (default 1)","required":false,"schema":{"type":"integer","minimum":1,"default":1}},{"name":"page_size","in":"query","description":"Number of items per page (default 50)","required":false,"schema":{"type":"integer","minimum":1,"default":50}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/PopularResponse"}}}},"400":{"$ref":"#/components/responses/BadRequest"},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get business models overview

> Retrieve historical quarterly count of titles by business model (package code), filterable by country and platform

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"BusinessModelsResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"package_code":{"type":"string"},"year":{"type":"integer"},"quarter":{"type":"integer","description":"Quarter of the year (1-4)"},"title_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/business_models":{"get":{"summary":"Get business models overview","description":"Retrieve historical quarterly count of titles by business model (package code), filterable by country and platform","operationId":"getBusinessModelsOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"uid","in":"query","required":false,"description":"Filter by content UID(s), comma-separated","schema":{"type":"string"}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/BusinessModelsResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic local productions overview

> Retrieve historical per-country counts of titles on local platforms from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PresentFrom":{"name":"present_from","in":"query","required":false,"description":"Filter to content that was present on or after this date (inclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose out_on is NULL or after this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PresentTo":{"name":"present_to","in":"query","required":false,"description":"Filter to content that entered before this date (exclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose enter_on is before this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"LocalProductionsResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"platform_country":{"type":"string"},"local_production_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/local_productions":{"get":{"summary":"Get historic local productions overview","description":"Retrieve historical per-country counts of titles on local platforms from cp_availability_historic","operationId":"getHistoricLocalProductions","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/PresentFrom"},{"$ref":"#/components/parameters/PresentTo"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/LocalProductionsResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get historic local contents by platform

> Retrieve historical per-platform counts of local production and co-production titles from cp\_availability\_historic

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"PresentFrom":{"name":"present_from","in":"query","required":false,"description":"Filter to content that was present on or after this date (inclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose out_on is NULL or after this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PresentTo":{"name":"present_to","in":"query","required":false,"description":"Filter to content that entered before this date (exclusive). Format YYYY-MM-DD. Uses interval overlap logic — content whose enter_on is before this date. Only applies to historic catalog queries (historic overview endpoints and catalog with historical=true); ignored otherwise.","schema":{"type":"string","format":"date"}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"LocalContentsByPlatformResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"platform_id":{"type":"integer"},"platform_name":{"type":"string"},"platform_country":{"type":"string"},"local_production_count":{"type":"integer"},"local_coproduction_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/historic/local_contents_by_platform":{"get":{"summary":"Get historic local contents by platform","description":"Retrieve historical per-platform counts of local production and co-production titles from cp_availability_historic","operationId":"getHistoricLocalContentsByPlatform","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/PresentFrom"},{"$ref":"#/components/parameters/PresentTo"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/LocalContentsByPlatformResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get local productions overview

> Retrieve per-country counts of titles on local platforms that were produced in that country

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"LocalProductionsResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"platform_country":{"type":"string"},"local_production_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/local_productions":{"get":{"summary":"Get local productions overview","description":"Retrieve per-country counts of titles on local platforms that were produced in that country","operationId":"getLocalProductionsOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/LocalProductionsResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```

## Get local contents by platform

> Retrieve per-platform counts of local production and co-production titles

```json
{"openapi":"3.0.3","info":{"title":"Fabric API","version":"1.0.0"},"tags":[{"name":"Overview","description":"Content Pulse overview KPIs, platform assets, genres, age distribution, and local productions"}],"servers":[{"url":"https://{apiId}.execute-api.{region}.amazonaws.com/{environment}","description":"AWS API Gateway","variables":{"apiId":{"default":"api-id","description":"API Gateway ID"},"region":{"default":"us-east-2","description":"AWS Region"},"environment":{"default":"dev","enum":["dev","prod"],"description":"Environment"}}}],"security":[{"ApiKeyAuth":[]}],"components":{"securitySchemes":{"ApiKeyAuth":{"type":"apiKey","in":"header","name":"x-api-key","description":"API key for authentication"}},"parameters":{"ApiKeyHeader":{"name":"x-api-key","in":"header","description":"API key for authentication","required":true,"schema":{"type":"string"}},"CacheBypass":{"name":"X-Cache-Bypass","in":"header","description":"Set to \"true\" to bypass cache and fetch fresh data","required":false,"schema":{"type":"string","enum":["true"]}},"MetaPrimaryCompany":{"name":"primary_company","in":"query","required":false,"description":"Filter by primary producer company name(s), comma-separated","schema":{"type":"string"}},"MetaProductionCompanies":{"name":"production_companies","in":"query","required":false,"description":"Filter by production company name(s), comma-separated. Matches titles where any listed company appears in the production_companies field","schema":{"type":"string"}},"MetaYearMin":{"name":"year_min","in":"query","required":false,"description":"Filter by minimum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaYearMax":{"name":"year_max","in":"query","required":false,"description":"Filter by maximum release year (inclusive, range 1800–2100)","schema":{"type":"integer","minimum":1800,"maximum":2100}},"MetaPrimaryCountryIso":{"name":"primary_country_iso","in":"query","required":false,"description":"Filter by primary production country ISO code(s), comma-separated","schema":{"type":"string"}},"MetaCountriesIso":{"name":"countries_iso","in":"query","required":false,"description":"Filter by production location ISO code(s), comma-separated. Matches titles where any listed country appears in the countries_iso field","schema":{"type":"string"}},"MetaCast":{"name":"cast","in":"query","required":false,"description":"Filter by cast member name (partial match, case-sensitive)","schema":{"type":"string"}},"MetaKeywords":{"name":"keywords","in":"query","required":false,"description":"Filter by keyword(s), comma-separated. Matches titles where any listed keyword appears in the keywords field","schema":{"type":"string"}},"MetaPrimaryGenre":{"name":"primary_genre","in":"query","required":false,"description":"Filter by primary genre(s), comma-separated","schema":{"type":"string"}},"MetaGenres":{"name":"genres","in":"query","required":false,"description":"Filter by genre(s), comma-separated. Matches titles where any listed genre appears in the genres field","schema":{"type":"string"}},"MetaType":{"name":"type","in":"query","required":false,"description":"Filter by content type, comma-separated","schema":{"type":"string","enum":["Movie","Series"]}},"IsOriginal":{"name":"is_original","in":"query","required":false,"description":"Filter to only original content (set to \"true\" to enable). Only applies to content_presence-based endpoints.","schema":{"type":"string","enum":["true"]}},"PlanChannel":{"name":"plan_channel","in":"query","required":false,"description":"Filter by plan/channel name(s), comma-separated. Exact match against package_plan column.","schema":{"type":"string"}},"IsExclusive":{"name":"is_exclusive","in":"query","required":false,"description":"Filter by content exclusivity. Requires both country and platform params to be set. When \"true\", only includes content that is exclusive on the specified platform/country. When \"false\", excludes exclusive content.","schema":{"type":"string","enum":["true","false"]}},"IsLocal":{"name":"is_local","in":"query","required":false,"description":"Filter by local content. Requires both country and platform params to be set. When \"true\", only includes content whose primary production country matches the platform country. When \"false\", excludes local content.","schema":{"type":"string","enum":["true","false"]}}},"schemas":{"LocalContentsByPlatformResponse":{"type":"object","properties":{"message":{"type":"string"},"data":{"type":"array","items":{"type":"object","properties":{"platform_id":{"type":"integer"},"platform_name":{"type":"string"},"platform_country":{"type":"string"},"local_production_count":{"type":"integer"},"local_coproduction_count":{"type":"integer"}}}},"userId":{"type":"string","nullable":true},"cached":{"type":"boolean"},"timestamp":{"type":"string","format":"date-time"}}},"ErrorResponse":{"type":"object","properties":{"message":{"type":"string"},"error":{"type":"string"}}}},"responses":{"Unauthorized":{"description":"Unauthorized - missing or invalid API key","content":{"application/json":{"schema":{"type":"object","properties":{"message":{"type":"string"}}}}}},"InternalError":{"description":"Internal server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}},"paths":{"/insights/content_pulse/overview/local_contents_by_platform":{"get":{"summary":"Get local contents by platform","description":"Retrieve per-platform counts of local production and co-production titles","operationId":"getLocalContentsByPlatformOverview","tags":["Overview"],"parameters":[{"$ref":"#/components/parameters/ApiKeyHeader"},{"$ref":"#/components/parameters/CacheBypass"},{"name":"country","in":"query","required":false,"description":"Filter by platform country code(s), comma-separated (e.g. AR,US)","schema":{"type":"string"}},{"name":"platform","in":"query","required":false,"description":"Filter by platform ID(s), comma-separated (e.g. 651,123)","schema":{"type":"string"}},{"name":"package_type","in":"query","required":false,"description":"Filter by package/business model type(s), comma-separated","schema":{"type":"string","enum":["Free/Free with Ads","Subscription","Transactional","Transaction","TV Everywhere","Subscription With Ads"]}},{"$ref":"#/components/parameters/MetaPrimaryCompany"},{"$ref":"#/components/parameters/MetaProductionCompanies"},{"$ref":"#/components/parameters/MetaYearMin"},{"$ref":"#/components/parameters/MetaYearMax"},{"$ref":"#/components/parameters/MetaPrimaryCountryIso"},{"$ref":"#/components/parameters/MetaCountriesIso"},{"$ref":"#/components/parameters/MetaCast"},{"$ref":"#/components/parameters/MetaKeywords"},{"$ref":"#/components/parameters/MetaPrimaryGenre"},{"$ref":"#/components/parameters/MetaGenres"},{"$ref":"#/components/parameters/MetaType"},{"$ref":"#/components/parameters/IsOriginal"},{"$ref":"#/components/parameters/PlanChannel"},{"$ref":"#/components/parameters/IsExclusive"},{"$ref":"#/components/parameters/IsLocal"}],"responses":{"200":{"description":"Successful response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/LocalContentsByPlatformResponse"}}}},"401":{"$ref":"#/components/responses/Unauthorized"},"500":{"$ref":"#/components/responses/InternalError"}}}}}}
```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://knowledgebase.fabricdata.com/insights/api/overview.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.