Browse the extensions reference

entities

returns [LedgerEntity!]!

List entities for a graph, optionally filtered by source.

Arguments

NameTypeDescription
sourceStringFilter by the system an entity came from, e.g. quickbooks.

Returns LedgerEntity

Entity details from the extensions OLTP database. Returned by entity reads and update-entity. Identifiers (CIK / ticker / SIC / LEI / tax_id) are present when sourced from SEC or registry data; many are null for private companies. The address fields are flattened (no nested object) to make them easy to project into reporting forms.

FieldTypeDescription
idString!Entity identifier (ULID).
nameString!Display name shown in UI.
legalNameStringFull registered legal name (when different from name).
uriStringCanonical URL / external identifier.
cikStringSEC CIK (Central Index Key).
tickerStringStock ticker symbol.
exchangeStringListing exchange (e.g. 'NASDAQ', 'NYSE').
sicStringSIC industry code.
sicDescriptionStringSIC code description.
categoryStringFiler category (e.g. 'Large Accelerated Filer').
stateOfIncorporationStringUS state or country of incorporation.
fiscalYearEndStringFiscal year-end as MM-DD (e.g. '12-31', '06-30').
taxIdStringTax ID (EIN / SSN).
leiStringLegal Entity Identifier (ISO 17442).
industryStringFree-form industry label.
entityTypeStringLegal form (e.g. 'corporation', 'llc', 'lp').
reportingStyleIdStringActive Reporting Style (Structure id) governing this entity's statement layout. Change it via the change-reporting-style operation.
phoneString—
websiteString—
statusString!Operational status: 'active' | 'inactive' | 'dissolved'.
isParentBoolean!True for top-level entities; False for subsidiaries.
parentEntityIdStringParent entity ID for subsidiaries; null for top-level.
ownershipPctFloatThe parent's share of this entity, as a percent (100 = wholly owned). Null on the group parent, and where it was never recorded.
consolidationMethodString!How the group's consolidated statements treat this entity: full (its books are summed and an outside owner's share is carried as noncontrolling interest), equity (one investment line and one income line), cost (an investment at cost) or none (the group parent, the consolidation entity, a linked counterparty). Derived from ownershipPct when not given — 50 and above full, 20 to 50 equity, below 20 cost, unrecorded full — and set by a person where control is not the percentage: a managing member with a minority stake consolidates in full, a majority without control takes the equity method.
entityRoleString!operating keeps a company's books. consolidation is the group's one entity for the consolidating entries — eliminations, noncontrolling interest, the equity-method pick-up — the adjustments column of a consolidation worksheet, which only the consolidated statements read and no operating company's statements ever include. Its method is none.
joinedOnDateThe month this entity became a member of the group, as any date in it; null is a member since the beginning. The consolidated statements include it from that month. Membership is by month: a period column wider than a month that overlaps the interval is summed whole, so a member's books in this graph should hold only the months it belonged.
leftOnDateThe month this entity left the group, as any date in it; null is a member still. The consolidated statements include it through that month and leave it out after. Membership is by month: a period column wider than a month that overlaps the interval is summed whole, so a member's books in this graph should hold only the months it belonged.
isFormerBoolean!True once the month this entity left the group is over: its months in the group are history, readable under it, and it is no longer current. False for a member still in, and through the month it leaves.
sourceString!Provenance: 'native' | 'sec' | 'quickbooks' | 'xero' | 'plaid'.
sourceIdStringSource-system primary key for sync reconciliation.
sourceGraphIdStringOrigin graph for received entities (cross-graph linking, e.g. RoboInvestor portfolio holdings).
connectionIdStringSource connection that ingested this row.
addressLine1String—
addressCityString—
addressStateString—
addressPostalCodeString—
addressCountryString—
createdAtString—
updatedAtString—

Example

query
{ entities { id name legalName uri } }
curl
curl -X POST "https://api.robosystems.ai/extensions/$GRAPH_ID/graphql" \
  -H "X-API-Key: $ROBOSYSTEMS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"query": "{ entities { id name legalName uri } }"}'