Is it possible to retrieve a deep/nested structure (like a parent record together with all its related child records, for example a Purchase Order and all its Purchase Order Lines) in a single OData call and response, given standard $expand doesn't support this?

All FAQ questions / Integrations and APIs

Answer

Yes, it's possible, but not through $expand — it requires modeling the projection around a custom Action that constructs and returns the full nested structure directly, rather than relying on OData's own $expand mechanism. IFS's own premium API projections use this pattern — for example, an Assortment-retrieval action that returns assortment nodes together with nested child arrays of parts and attributes, implemented via a PL/SQL action that builds and returns the whole structure in one response. This is a more involved approach than a standard $expand (it requires actually authoring a custom action and its backing PL/SQL), but it's the supported way to get a genuinely nested, single-call/single-response structure out of IFS's OData API today.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Integrations and APIs questions