0

I would like to know if there are any JSON size limitation for response returned by HANA XSODATA service. I am working on a service which is returning huge volume of data (15-20K). When I call the service from browser I am receiving json parsing. I see that json is chopped off after certain character length.

Please let me know if any one has faced this issue and any resolution for this?

gvs
  • 39
  • 1
  • 11
  • Hi, First, have you considered pagination to retrieve such a large result? Then, can you clarify if are you using HANA 1 with XS Classic or HANA 2.0 with a JS module? – Abdel Dadouche Dec 17 '18 at 11:54
  • No, I haven't considered pagination. How do I enable pagination? I believe I am using XS classic. My calculation view is being exposed as XSODATA service. – gvs Dec 19 '18 at 02:26

1 Answers1

0

Unfortunately, pagination (or paging) is not something you enable with just a config attribute or something as simple as that as far as I know.

It assumes first that your can handle it in your calculation view using the $skip & $count request parameters.

This will most likely require you to use XSJS instead of a straight forward XSOData service.

For example, you would need to extend your calculation view and:

  • add a column with the Rank of the row
  • add placeholder attributes to be used for the first row to be selected
  • add placeholder attributes to be used for the row count

Once this is done, create a XSJS service where you can handle a $skip & $count request parameters.

Also, have you looked into the max_message_size_mb parameter in the SAP HANA XS Configuration Parameters

Abdel Dadouche
  • 217
  • 1
  • 7