Unanswered

how to create a pdf file using SharePoint HTTP request

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All, This is regarding "creating a pdf file in SharePoint Library using "send http request of SharePoint". Below is the action I am using.

Content-Length: length(variables('varContent'))
Uri: _api/web/GetFolderByServerRelativeUrl('students')/Files/add(url='a.txt',overwrite=true)
Content: body('pmw')?['$content']

PMW - Populate a Microsoft Word template

For testing purpose - I was trying to create .txt file:

Error Message:

Spoiler (Highlight to read)

{

"error": {

"code": 500,

"source": "flow-apim-msmanaged-na-westus2-01.azure-apim.net",

"clientRequestId": "4776e0da-1c7d-40a0-98d8-c30044bc33cd",

"message": "BadGateway",

"innerError": {

"status": 500,

"message": "Bytes to be written to the stream exceed the Content-Length bytes size specified.\r\nclientRequestId: 4776e0da-1c7d-40a0-98d8-c30044bc33cd",

"source": "https://sharepointonline-eus2.azconn-eus2.p.azurewebsites.net/datasets/https%253A%252F%252FABCD.sharepoint.com%252Fsites%252FTEAMAPPS/httprequest",

"errors": []

}

{ "error": { "code": 500, "source": "flow-apim-msmanaged-na-westus2-01.azure-apim.net", "clientRequestId": "4776e0da-1c7d-40a0-98d8-c30044bc33cd", "message": "BadGateway", "innerError": { "status": 500, "message": "Bytes to be written to the stream exceed the Content-Length bytes size specified.\r\nclientRequestId: 4776e0da-1c7d-40a0-98d8-c30044bc33cd", "source": "https://sharepointonline-eus2.azconn-eus2.p.azurewebsites.net/datasets/https%253A%252F%252FABCD.sharepoint.com%252Fsites%252FTEAMAPPS/httprequest", "errors": [] } }}

Size of the word document: 25KB

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,502 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

If I understand correctly you just want to create a .txt file.

Try and use this approach. I believe all those headers are not required to create a .txt file.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus, thank you for the update. Yeah, I am unable to create the file only with Content-Type:application/json. But the issue is with pdf files. able to create PDF files but those are not correctly getting created, any thoughts on this?

Was this reply helpful? Yes No
Expiscornovus 33,502 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

You could use a Populate a word template with a text control and input that with text and use a convert file action to generate a pdf. Maybe this is also approach which is useful for you?

1. Use a populate word template to populate a docx file with your text. I added a HTMLTable text control via the Word Developer options. You could populate that control with text of your flow. In this case I am using some random text (Testing).

2. Create a temporary docx file in OneDrive
3. Convert the content of the docx to pdf in OneDrive

4. Create a pdf file in a SharePoint location

More details about this approach can be found in this nice blog from Jon Levesque:
https://flow.microsoft.com/nl-nl/blog/intermediate-flow-of-the-week-create-pdf-invoices-using-word-templates-with-microsoft-flow/

Was this reply helpful? Yes No