The HTTP header ACCEPT is missing or its value is invalid - SharePoint List

Hi,

Yes, we've encountered this issue with the SharePoint List connector.

Using Fiddler, I traced what the SharePoint List connector was doing.

SharePoint List Connector - Request Header

You can see the blackbox connector is requesting JSON to come back as JSON Minimal. Unfortunately SharePoint PRE SP1 does not support JSON Light. In the SharePoint SP1 update it included an enhancment to add JSON Light support.

You simply need to amend the headers being sent using the SharePoint REST API however and ask for verbose JSON which is supported pre SP1, you won't be able to use the SharePoint List Connector blackbox as this does not allow you to customise any request headers..

My solution was to use the web connector to send your own SharePoint REST API call. Authentication remains the same if you were using kerberos.

URL: https://SITENAME/_api/web/lists/GetByTitle('YOUR_LIST_TITLE')/items?$top=5000

Header: ACCEPT application/json;odata=verbose

Web Connector to SharePoint List

You should get data from the list but you'll get lots of metadat too, so you can just transform the data pick the columns you require.

SharePoint List Data Tranformed