Excel services rest APi URL size Limitations

Excel services rest APi URL size  limitation has been documented as approximately 2000 characters. However in our on premise environment we are able to set only 10 parameters( less than 1000 characters) . after that service is getting hanged.

Appreciate if some one can guide us on what settings needs to be changed  to leverage the approx. 2000 character option

Thanks & Regards

Roy

July 16th, 2015 12:41pm

uls log shows that "the rest call made is above the limit of allowed values to set to the workbook(limit= 10) ".

Is 10 parameter known design limit?

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 2:09pm

Never seen this issue before, can you provide a step by step demo about how you run the test? Maybe I can try it on my environment
July 20th, 2015 9:21am

Our colleague David Valentine suggested an alternate way to proceed for time being.

"Rather than passing all parameters separately, David suggested to pass the parameters as a single param separated with a special key delimiter. And in the excel sheel we have written formulas to split it and assign to the corresponding cells.

By this way we overcome the limitation of 10 parameter for time being. Special Thanks to David Valentine for the vluable suggestion.

 
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 3:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics