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 100 results. How to extract all possible results?

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

Environment

  • SuccessFactors
  • Integration Center 

Reproducing the Issue

  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 100 results on Integration Center's UI

  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 100 results as well

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:

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

  • 2675265 - OData API: Using the $top and $skip tokens - More info on why you're not receiving all the data you expected on a OData call
  • Integration Center's guide

Keywords

SuccessFactors, csv, xml, file, limit, save, check, full, file, complete, all, possible, data, integration, center, download, preview, option, extract, 100 entries, need, full, data, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions