SAP Knowledge Base Article - Public

2813051 - How to extract all the results of a Integration Center's outbound interface

Symptom

 Integration Center's preview of an Outbound interface is only extracting 1000 results. How to extract all possible results?

Environment

  • SuccessFactors
  • Integration Center 

Reproducing the Issue

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

  1. Create an Outbound interface on Integration Center
  2. Click on the Preview icon, on the top-right side of the screen

    integration_center_1000_max_1.jpg 
  3. You'll see that you can only view a maximum of 1000 results on Integration Center's UI

    integration_center_1000_max_2.jpg

  4. Click on the Save button, on the bottom-left side of the screen, and download the preview file

    integration_center_1000_max_3.jpg

  5. The generated preview file only contains 1000 results as well

    integration_center_1000_max_4.jpg

Cause

Integration Center runs on OData.

The results of a query made on OData will be divided in pages when it exceedes 1000 results (each page containing 1000 records).

Resolution

This occurs only in Integration Center's preview.

When the integration is finally executed, the output file that is generated will return all the possible results of the query.

Also, if you access the preview screen on Integration Center's UI, you'll be able to navigate through the pages that were generated by the OData query made by the integration itself:

integration_center_1000_max_5.jpg

If you download the preview file after changing the page on the preview UI, it will contain the data referred to that specific page.

See Also

Keywords

success, factors, csv, xml, file, limit, save, check, full, file, complete, all, possible, data, integration, center, download, preview, option, extract, 1000, entries, need, full, data, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , How To

Product

SAP SuccessFactors HCM Suite all versions