Agent for SharePoint Guide › Troubleshooting › REST API in Excel Services Does Not Work

REST API in Excel Services Does Not Work

Symptom:

REST API in Excel Services does not work when a SharePoint web application using Claims-based Authentication is protected with CA SiteMinder®.

Solution:

The REST API in Excel Services does not work because the CSSChecking ACO parameter is enabled by default. CSSChecking verifies URLs for escaped and unescaped characters defined in the BadCSSChars parameter and returns with an Access Denied message.

Disable the CSSChecking ACO parameter. This change allows the REST API in Excel Services to work when a SharePoint web application using Claims-based Authentication is protected with CA SiteMinder®.

Follow these steps:

1. Log on to the SiteMinder Administrative UI.

   The relevant tabs for your administrator privileges appear.

2. Click Infrastructure, Agents, Agent Configuration, Modify Agent Configuration.

   The Modify Agent Configuration: Search screen opens.

3. Select the Agent Configuration object from the list and click Select.

   The Modify Agent Configuration: ACO_Name dialog appears.

4. Click the Edit button on the CssChecking Parameter.

   The Edit Parameter dialog appears.

5. Enter No in the Value field and click OK.

   The Modify Agent Configuration: ACO_Name dialog appears with the General and Parameters group boxes.

6. Click Submit.

   The Modify Agent Configuration Object task is submitted for processing and the confirmation message appears.