Agent Proposals

entity_type proposed confidence: 97%

Connector: people (https://swapi.info/api/) ← connector

StarWarsCharacter

Represents a character from the Star Wars universe, including physical attributes, biographical details, and associations with films, species, vehicles, and starships, as sourced from the SWAPI dataset.

name string required
height string
mass string
hair_color string
skin_color string
eye_color string
birth_year string
gender string
homeworld string required
films json required
species json required
vehicles json required
starships json required
created datetime required
edited datetime required
url string required

Display label: name

Potential relationships detected:

homeworld → Planet Field contains a URL pointing to a SWAPI planet resource (e.g., https://swapi.info/api/planets/1), indicating a foreign-key-style reference to a Planet entity.
films → Film Field contains a JSON array of URLs pointing to SWAPI film resources (e.g., https://swapi.info/api/films/1), indicating a many-to-many relationship with a Film entity.
species → Species Field contains a JSON array of URLs pointing to SWAPI species resources (e.g., https://swapi.info/api/species/2), indicating a many-to-many relationship with a Species entity.
vehicles → Vehicle Field contains a JSON array of URLs pointing to SWAPI vehicle resources (e.g., https://swapi.info/api/vehicles/14), indicating a many-to-many relationship with a Vehicle entity.
starships → Starship Field contains a JSON array of URLs pointing to SWAPI starship resources (e.g., https://swapi.info/api/starships/12), indicating a many-to-many relationship with a Starship entity.

The source data clearly represents Star Wars characters from the SWAPI (Star Wars API), containing biographical and physical attributes (name, height, mass, hair/skin/eye color, birth year, gender), relational URL references to homeworld, films, species, vehicles, and starships, and metadata timestamps. This is distinct from the existing Employee entity type which is organization-focused. The entity is named StarWarsCharacter to be descriptive and domain-specific. Fields like height and mass are kept as strings since they contain non-numeric placeholders ('n/a'). The homeworld, films, species, vehicles, and starships fields are URL-based foreign-key-style references to other SWAPI resource types, making them strong candidates for relationships.

1a3be673-f332-4297-a825-6f4cea5a5a5b 2026-06-22 13:55
entity_type proposed confidence: 97%

Connector: films (https://swapi.info/api/) ← connector

StarWarsFilm

Represents a Star Wars film entry from the SWAPI dataset, including metadata such as title, episode number, director, producer, release date, opening crawl text, and references to associated characters, planets, starships, vehicles, and species.

title string required
episode_id integer required
opening_crawl string required
director string required
producer string required
release_date date required
characters json required
planets json required
starships json required
vehicles json required
species json required
created datetime required
edited datetime required
url string required

Display label: title

Potential relationships detected:

characters → StarWarsPerson Array of URLs pointing to https://swapi.info/api/people/, indicating references to person/character entities.
planets → StarWarsPlanet Array of URLs pointing to https://swapi.info/api/planets/, indicating references to planet entities.
starships → StarWarsStarship Array of URLs pointing to https://swapi.info/api/starships/, indicating references to starship entities.
vehicles → StarWarsVehicle Array of URLs pointing to https://swapi.info/api/vehicles/, indicating references to vehicle entities.
species → StarWarsSpecies Array of URLs pointing to https://swapi.info/api/species/, indicating references to species entities.
url → StarWarsFilm Self-referencing canonical resource URL at https://swapi.info/api/films/, uniquely identifying this film entity.

The source data clearly represents Star Wars film entries from the SWAPI (Star Wars API). Each record has a unique title, episode ID, opening crawl, director, producer, release date, and multiple relationship arrays (characters, planets, starships, vehicles, species) stored as lists of resource URLs. The existing Employee entity type is entirely unrelated. A dedicated StarWarsFilm entity type captures all fields faithfully, with json arrays for the multi-valued relationship fields and appropriate scalar types for the remaining fields. The relationship arrays contain URLs pointing to other SWAPI resource types, signaling foreign-key-style references to separate entity types.

31f74e79-daab-47f7-b82a-6c53ff643860 2026-04-23 18:39

Ingestion Flow

  1. 1. Discover API or create connector
  2. 2. Confirm discovery → auto-proposes schemas
  3. 3. Confirm schema → creates entity type
  4. 4. Propose relationships (if detected) → confirm
  5. 5. Propose mapping → confirm
  6. 6. Trigger sync on the connector