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.