SAP Knowledge Base Article - Public

3580756 - Error "Key column(s) not selected in input" when consuming a Data Export Odata Service in SAP Analytics Cloud (SAC)

Symptom

When attempting to consume a Data Export Odata Service that is coming from a SAC tenant, you get the error:

"Response from external server has status code of 400

Key column(s) not selected in input [1402]"

Environment

  • SAP Analytics Cloud 2025.1

Reproducing the Issue

  1. Create a model
  2. Obtain an export service URL
    e.g.
    https://<tenant URL>/api/v1/dataexport/providers/sac/aBCdeFGh12345HG 
  3. Attempt to consume that Export URL and get the error

Cause

This error occurs because of a limitation that all Key columns must be included in a $select statement.  It does not need to be all columns, just the key columns.

Resolution

In order to verify which columns are key columns you may check the /$metadata endpoint

Link

The reason all key columns must be selected is due to an OData stadnard which enforces referential integrity for the data when its read via the API

Additional Query Options for Data Export
Link

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Import, export, manage, management, dataexport , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0