Merge PDF email attachments with Merge PDF API in logic apps

Question

I have a Logic App that monitors incoming emails.  Some have multiple PDF attachments that I want to merge and save to Dropbox.  I have it working with the Encodian API but I want to switch it over to the Adobe API.I then use the array as input for the Encodian API.  When I try this with the Adobe API, I get an error, "bad value for parameter 'files'; invalid type".  Doing some reasearch I read somewhere that I should change the fileName line to  "$content-type": "application/pdf" This still returns the same error.  Even though the files were already PDF's I thought maybe they still needed to be converted to Base64 so I tried that. The Append array action generates this result:  [
	{
		"$content-type":"application/pdf",
		"fileContent":"SlZCRVJ..."
	},
	{
		"$content-type":"application/pdf",
		"fileContent":"SlZCRVJ..."
	}
] The error again is: "bad value for parameter 'files'; invalid type".  the full code for the action is: {
    "inputs": {
        "host": {
            "connection": {
                "name": "@parameters('$connections')['adobepdftools']['connectionId']"
            }
        },
        "method": "post",
        "body": {
            "files": "@variables('FileToMerge')",
            "outputFileName": "Temp.pdf"
        },
        "headers": {
            "x-api-key": "PowerAutomate",
            "x-region-value": "-ue1"
        },
        "path": "/operation/v1/combinePDF"
    }
}  Why does this have to be so difficult?  Where am I going wrong?

DRYBSMT · Accepted Answer

For anyone looking for the same answer, I was finally able to get this sorted out.

If you are using the 'When a new email arrives' trigger, you need to append to the array variable (mine is named 'FilesToMerge' ) using a 'For each' loop based on the trigger body output:

triggerBody()?['attachments']

Then append the contentBytes alone to the array:

 items('For_each')?['contentBytes']

The json in the code view will look like this:

{
    "inputs": {
        "name": "FilesToMerge",
        "value": "@items('For_each')?['contentBytes']"
    }
}

If you veiw the output of the Array variable with a compose Action, You see a sincle line of code like this:

["---Code from first attachment---","---Second---","---etc---"]

The Adobe Merge PDFs action then will look like this:

Be sure to click this button to change the input mode first:

You can then use the output from the Merge PDFs as the content for whatever action you use to create the new file.

I really hope this is of benefit to someone else searching for the same answer.

Raymond Camden · Answer

You showed how you created the array, but not how you are calling the API. Are you using the official Acrobat Services connector?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded