Files are not clear when uploaded through Sharepoint REST API

Question

Files are not clear when uploaded through Sharepoint REST API

Madhu Sudan Singh 61

Hi,

When I am uploading files to Sharepoint using REST API, files are getting stored in Sharepoint, but those files are incomplete. For Image files, either color are not clear or only half of the image is uploaded. For pdf files, some portion of the page itself is not displaying.

I am not sending any header other than 'Authorization' and in body, I am sending Blob content.

I am doing Salesforce integration with Sharepoint through Salesforce's APEX coding and not JQuery/Javascript

Regards
Madhusudan Singh

RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-15T02:36:35.6+00:00

Hi @Madhu Sudan Singh ,
Could you please provide more details about your code and Blob content for test?
Madhu Sudan Singh 61 Reputation points

2021-07-15T02:43:48.237+00:00

@RaytheonXie_MSFT ,

Below code, I am using, which is creating a file in Sharepoint but those files are incomplete.

HttpRequest req = new HttpRequest();
req.setEndpoint('callout:Sharepoint/_api/web/GetFolderByServerRelativeUrl(\'/sites/SalesforceFiles/Shared%20Documents/Test\')/Files/add(url=\''+fileName+'\',overwrite=true)');
req.setBodyAsBlob(fileContent); // this is blob file content
req.setHeader('Content-Type','application/octet-stream');
req.setHeader('Content-Length', String.valueOf(req.getBodyAsBlob().size()));
req.setMethod('POST');
Http http = new Http();
HTTPResponse res = http.send(req);
System.debug(res.getBody());

I also posted a question on stack overflow but no response there as well. This is turning a blocker for the entire project.

Stackoverflow question
https://salesforce.stackexchange.com/questions/349530/post-file-to-sharepoint-from-apex
Sven Sieverding 1 Reputation point MVP

2021-07-15T11:41:14.783+00:00

If you were to do an incomplete upload of a file (i.e. not transfering the whole blob) then this could result in broken images and PDFs like yours...

Is there something wrong with the "Content-Length" in your header?
Could you try to set it directly as "fileContent.size()" instead of "req.getBodyAsBlob().size()"?
Madhu Sudan Singh 61 Reputation points

2021-07-15T13:22:33.6+00:00

I tried that also, but have same issue
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-22T06:41:09.263+00:00

Hi @Madhu Sudan Singh ,
I am checking to see if the problem has been resolved.
Madhu Sudan Singh 61 Reputation points

2021-07-22T06:43:47.573+00:00

@RaytheonXie_MSFT , Yes it is resolved(found a workaround). It seems the problem is from the salesforce end. I raised a ticket to salesforce.
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-22T06:50:43.557+00:00

Hi @Madhu Sudan Singh ,
It is very glad that the issue is resolved.
Thank you for your sharing and it will help others have the same issue.
Richa Singh 1 Reputation point

2022-03-01T15:06:42.067+00:00

Hi @Madhu Sudan Singh - I am trying to implement the same and facing similar issues, can you let me know how did you solve it?

1 answer

Your answer

RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-15T02:36:35.6+00:00

Hi @Madhu Sudan Singh ,
Could you please provide more details about your code and Blob content for test?
Madhu Sudan Singh 61 Reputation points

2021-07-15T02:43:48.237+00:00

@RaytheonXie_MSFT ,

Below code, I am using, which is creating a file in Sharepoint but those files are incomplete.

HttpRequest req = new HttpRequest();
req.setEndpoint('callout:Sharepoint/_api/web/GetFolderByServerRelativeUrl(\'/sites/SalesforceFiles/Shared%20Documents/Test\')/Files/add(url=\''+fileName+'\',overwrite=true)');
req.setBodyAsBlob(fileContent); // this is blob file content
req.setHeader('Content-Type','application/octet-stream');
req.setHeader('Content-Length', String.valueOf(req.getBodyAsBlob().size()));
req.setMethod('POST');
Http http = new Http();
HTTPResponse res = http.send(req);
System.debug(res.getBody());

I also posted a question on stack overflow but no response there as well. This is turning a blocker for the entire project.

Stackoverflow question
https://salesforce.stackexchange.com/questions/349530/post-file-to-sharepoint-from-apex
Sven Sieverding 1 Reputation point MVP

2021-07-15T11:41:14.783+00:00

If you were to do an incomplete upload of a file (i.e. not transfering the whole blob) then this could result in broken images and PDFs like yours...

Is there something wrong with the "Content-Length" in your header?
Could you try to set it directly as "fileContent.size()" instead of "req.getBodyAsBlob().size()"?
Madhu Sudan Singh 61 Reputation points

2021-07-15T13:22:33.6+00:00

I tried that also, but have same issue
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-22T06:41:09.263+00:00

Hi @Madhu Sudan Singh ,
I am checking to see if the problem has been resolved.
Madhu Sudan Singh 61 Reputation points

2021-07-22T06:43:47.573+00:00

@RaytheonXie_MSFT , Yes it is resolved(found a workaround). It seems the problem is from the salesforce end. I raised a ticket to salesforce.
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-22T06:50:43.557+00:00

Hi @Madhu Sudan Singh ,
It is very glad that the issue is resolved.
Thank you for your sharing and it will help others have the same issue.
Richa Singh 1 Reputation point

2022-03-01T15:06:42.067+00:00

Hi @Madhu Sudan Singh - I am trying to implement the same and facing similar issues, can you let me know how did you solve it?

Answer 1

RaytheonXie_MSFT 40,471 Microsoft External Staff

Hi @Madhu Sudan Singh ,
Please try upload files by postman like following picture:

I have tested to upload pdf and image files, and it works.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Madhu Sudan Singh 61 Reputation points

2021-07-15T06:54:14.85+00:00

through postman it is working, but not with the code
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2021-07-15T08:10:55.857+00:00

Hi @Madhu Sudan Singh ,
Since the url can work in postman, we consider that something might be wrong in code.
But Salesforce's APEX code is out of our support scope. You can get answers from Salesforce's APEX code support.
sadomovalex 3,636 Reputation points

2021-07-15T16:46:38.883+00:00

you may check in Fiddler details of your http request (which doesn't work) and request from Postman (which works) and compare them. If there will be difference - try to use the same request properties as Postman uses in your request.

Share via

Files are not clear when uploaded through Sharepoint REST API

1 answer

Your answer