SAP Knowledge Base Article - Public

3161440 - Retrieving dictionary items via API does not deliver complete data - only first 10,000 entries are in the response

Symptom

 

I want to download all elements of a dictionary category. I use the following API call:

https://editor.signavio.com/p/glossary?category=<category_id>

Unfortunately, when I look on the response, I see only 10,000 entries. This category contains over 80,000 items.

Resolution

There is a limitation of 10,000 items in the SolrSearch. To avoid responses with incomplete data and timeouts by large data sets, please use a further parameter in your request:

  • offset
  • limit
  • sort=title
  • excludeMetaData=true

Especially look at first and second parameter. "offset" should take the value of the entry, you want to start with. By "limit" you set the amount of entries which should be retrieved.

Here are two examples:

  • http://editor.signavio.com/p/glossary?category=<Category_ID>&sort=title&limit=1000&offset=1&excludeMetaData=true'

  • http://editor.signavio.com/p/glossary?category=<Category_ID>&sort=title&limit=1000&offset=1001&excludeMetaData=true'

&limit=1000&offset=1 - starts with the 1st entry and delivers 1000 entries

&limit=1000&offset=1001 - starts with entry 1001 and delivers next 1000 entries

Keywords

KBA , BPI-SIG-CA-API , REST-API for SAP Signavio , How To

Product

SAP Signavio Process Manager all versions ; Signavio Process Manager all versions