MicrosoftHello Pedro_M_Almeida
Thanks for the work
I'm about to achieve this, but i got an issue with the upload,
Everything passes and the file is uploaded as b64 as expected,
The problem is that the file is unreadable after being uploaded, because it stills in b64 (as exemple somedoc.pdf, if i open it with a notepad, it's b64 only inside). It is a bug ? It seems that devops does not decode the b64 during the upload or attach step
Compose task i use to convert attachment bytes to b64 in the loop
"Compose_b64_attachment_content": {
"type": "Compose",
"inputs": "@base64(body('Retrieve_attachments')?['contentBytes'])",
"runAfter": {
"Retrieve_attachments": [
"SUCCEEDED"
]
}
}The upload task,
"For_each": {
"type": "foreach",
"foreach": "@triggerBody()?['attachments']",
"actions": {
"Upload_attachment_to_AzDo": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"referenceName": "visualstudioteamservices"
}
},
"method": "post",
"body": {
"Method": "POST",
"Uri": "@{body('Parse_JSON')?['fields']?['System.TeamProject']}/_apis/wit/attachments?uploadType=Simple&fileName=@{body('Retrieve_attachments')?['name']}&api-version=7.1-preview.3",
"Headers": {
"content-type": "@{body('Retrieve_attachments')?['contentType']}"
},
"Body": "@outputs('Compose_b64_attachment_content')",
"IsBase64": true
},
"path": "/httprequest",
"queries": {
"account": "(redacted)"
}
},
"runAfter": {
"Compose_b64_attachment_content": [
"SUCCEEDED"
]
}
},and the attach part,
"Bind_the_attachment_to_the_AzDo_task": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"referenceName": "visualstudioteamservices"
}
},
"method": "post",
"body": {
"Method": "PATCH",
"Uri": "@{body('Parse_JSON')?['fields']?['System.TeamProject']}/_apis/wit/workItems/@{body('Parse_JSON')?['id']}?api-version=7.0-preview.3",
"Headers": {
"Content-Type": "application/json-patch+json"
},
"Body": "[\n\n{\n\n\"op\": \"add\",\n\n\"path\": \"/relations/-\",\n\n\"value\": {\n\n\"rel\": \"AttachedFile\",\n\n\"url\": \"@{body('Parse_JSON_response')?['url']}\",\n\n\"attributes\": {\n\n\"comment\": \"Added attachment\"\n\n}\n\n}\n\n}\n\n]",
"IsBase64": false
},
"path": "/httprequest",
"queries": {
"account": "(redacted)"
}
},Thanks for the help !!!
EDIT : Ok it seems that i had encoded in b64 twice. It seems that the http POST does it itself. I've removed my "compose" step with the b64 conversion and i can now see that a b64 string stills sent to the API:
But now it fails with this error and i don't understand why!
Microsofthi Attic0
from what I see, you're inputting the body incorrectly.
The output bytes from the attachment needs to be read as binary, so you need to use the expression to convert the body.
You will need to use
"Body": "@{binary(body('Get_Attachment_(V2)')?['contentBytes'])}",
also, you're using the {"$content-type":"", "$content":""} type of input to your Body, but you should only need to use the content.
try again, but only use the $content content, that's the file portion that you need.
"body": {
"Method": "POST",
"Uri": "@{body('Parse_JSON')?['fields']?['System.TeamProject']}/_apis/wit/attachments?uploadType=Simple&fileName=@{body('Retrieve_attachments')?['name']}&api-version=7.1-preview.3",
"Headers": {
"content-type": "@{body('Retrieve_attachments')?['contentType']}"
},
"Body": "@{binary(body('Retrieve_attachments')?['contentBytes'])}",
"IsBase64": true
}
let me know if it works for you
Hello Pedro_M_Almeida
Thanks for your response
I've tried to modify the upload step as below,
{
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"referenceName": "visualstudioteamservices"
}
},
"method": "post",
"body": {
"Method": "POST",
"Uri": "@{body('Parse_JSON')?['fields']?['System.TeamProject']}/_apis/wit/attachments?uploadType=Simple&fileName=@{body('Retrieve_attachments')?['name']}&api-version=7.1-preview.3",
"Headers": {
"content-type": "@{body('Retrieve_attachments')?['contentType']}"
},
"Body": "@binary(body('Retrieve_attachments')?['contentBytes'])",
"IsBase64": true
},
"path": "/httprequest",
"queries": {
"account": "(redacted)"
}
},
"runAfter": {
"Retrieve_attachments": [
"SUCCEEDED"
]
}
}Still have the error
{
"status": 400,
"message": "Body parameters are not specified.\r\nclientRequestId: 9cee4863-6766-492e-9f7b-72b79ac1fd1a",
"error": {
"message": "Body parameters are not specified."
},
"source": "vsts-fc.azconn-fc-001.p.azurewebsites.net"
}The body that is actually sent looks like,
{
"$content-type": "application/octet-stream",
"$content": "[redacted : b64 stream]"
}It seems that i need an extra step to parse json and send only the "$content" ?
Microsoftyes, you will need to extract the $content only.
Hello Pedro_M_Almeida
I definitely don't achieve this, the output of the "retrieve attachment" action is the below,
the body sent in question...
{
"$content-type": "application/octet-stream",
"$content": "SlZCRVJpMHhMalFL[redacted-b64...]"
}the output of the task "Parse JSON" response is the below,
and here is how i try to upload...
"method": "post",
"body": {
"Method": "POST",
"Uri": "@{body('Parse_JSON')?['fields']?['System.TeamProject']}/_apis/wit/attachments?uploadType=Simple&fileName=@{body('Retrieve_attachments')?['name']}&api-version=7.1-preview.3",
"Headers": {
"content-type": "@{body('Parse_JSON_response_from_Retrieve_attachments_step_')?['contentType']}"
},
"Body": "@binary(body('Parse_JSON_response_from_Retrieve_attachments_step_')?['contentBytes'])",
"IsBase64": true
},Could maybe share your whole workflow JSON ?
Thanks
Edit : it seems that i'm not the only concerned https://github.com/Azure/logicapps/issues/1236
Edit 2: i finally found that the binary() we put in the upload task causes the problem. I simply use the "body ContentBytes" values from the Retrieve Attachments response and now it works,