SAP Knowledge Base Article - Public

3596225 - Difference in field sequence in the Integration center JSON Preview and JSON Output File exported

Symptom

The data in the generated JSON output file does not follow the configured sequence of fields in the Integration Center JSON Outbound job.

  • For instance, the employee name, although configured as the first field, appears as the last field in the output file.



Disclaimer: Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Integrations
      • Integration Center

Cause

This is an expected behaviour. The order of fields in a JSON file is not guaranteed and cannot be controlled. 

Resolution

The order of fields in JSON is not guaranteed as per the JSON specification (ECMA-404 and RFC 8259). A JSON object is an unordered collection of key-value pairs. This is an expected behavior from JSON and not an issue from the Integration Center tool.

See Also

RFC 8259 - The JavaScript Object Notation (JSON) Data Interchange Format: https://datatracker.ietf.org/doc/html/rfc8259

Keywords

JSON, field order, sequence, Integration Center, unordered, key-value pairs, RFC 8259, ECMA-404., LOD-SF-INT-INC,  , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-JOB , Integration Center Job , Problem

Product

SAP SuccessFactors HCM Core 2411 ; SAP SuccessFactors HCM Suite 2505 ; SAP SuccessFactors Platform all versions