Synapse Web Activity Failure - API call to Sharepoint - "error_description":"ID3035: The request was not valid or is malformed."

Question

Good morning,

this web activity is failing at retrieving data from Sharepoint. Error:

Operation on target Web1 failed: {"error_description":"ID3035: The request was not valid or is malformed."}

Web activity:

Note:

(1) The activity has been registered and granted permissions in AAD:

(2) The application has been granted SharePoint Online site permissions, as explained here: https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory

Any help will be much appreciated.

Answer 1

Helo @Maggiore, Marco (IST-BRUNELENERGYPL) !

Welcome to Microsoft QnA!

Please go to Sharepoint settings and verify that Guest Access is allowed for the Site or Library

Similar issues :

https://answers.microsoft.com/en-us/msteams/forum/all/id3035-the-request-was-not-valid-or-it-is/b8d93f2d-6524-4623-a719-431b272b4416

https://learn.microsoft.com/en-us/answers/questions/1102988/sharepoint-api-error-id3035-the-request-was-not-va?orderBy=Helpful

---

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Answer 2

Hello @Maggiore, Marco (IST-BRUNELENERGYPL) !

Thanks for the message and the clarification

The error ID points to Authentication as i have seen around

https://learn.microsoft.com/en-us/answers/questions/1102988/sharepoint-api-error-id3035-the-request-was-not-va

It does not matter where your Pipeline is located . Authentication and Authorization are different things and no matter where requests come from , they should authenticate and be authorized if needed

Even if you are using a SP does not change the fact that you still need to Authenticate

The SP has the ability to do so and you correctly did the steps with the App Registration , but based on the error something is wrong, and clearly to register an app does not mean Authentication is open and ready to execute code! You need to acquire a Token for example and you can do that since you have Registered the APP . The process provides you the ability to do so , but how do you do it ?

Are you using OAuth for example ? Have you verified the request is formatted as Sharepoint API expects it ?

Is there Logging to check deeper ?

cannot clearly see the code on the PIC so kindly post it in text so i can have a better look

---

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards