Importing Attachments to Jira

Integrator.io
1

I am trying to move attachments using a webhook from Azure DevOps into Jira. I have my flow setup and am getting the attachment URL from the webhook. I am then using a GET request from DevOps to get the blob key.

The image shows a configuration interface for setting up a GET request to Azure DevOps with options for connection, path, and URI input. (Captioned by AI)
The image shows a configuration interface for setting up a GET request to Azure DevOps with options for connection, path, and URI input. (Captioned by AI)756×488 24.2 KB

From there I have my Jira import step where I am specfying the blob returned from the prior step:

The image displays a configuration screen for setting up a file transfer in JIRA, including HTTP POST method details and header configurations. (Captioned by AI)
The image displays a configuration screen for setting up a file transfer in JIRA, including HTTP POST method details and header configurations. (Captioned by AI)883×891 56.7 KB

The step says it completes successfully in the run console, however, I can see in the response payload a status of "no_file_found" and there is no attachment in Jira.

A JSON response from an Azure URL indicates "no_file_found" for a missing file named "poll.png". (Captioned by AI)
A JSON response from an Azure URL indicates "no_file_found" for a missing file named "poll.png". (Captioned by AI)625×194 19.9 KB

Has anyone encountered this before or have any insight on how to fix?

2

Did you map back the blobKey and specify the blobKey on the import step?

This image shows a flowchart element labeled "Get media" with a "Success" status and a red arrow pointing to the next step. (Captioned by AI)
This image shows a flowchart element labeled "Get media" with a "Success" status and a red arrow pointing to the next step. (Captioned by AI)412×170 7.44 KB

The image shows a user interface for editing results mapping, with fields labeled "Lookup response field" and "Source record field." (Captioned by AI)
The image shows a user interface for editing results mapping, with fields labeled "Lookup response field" and "Source record field." (Captioned by AI)1773×373 13.6 KB

The image shows a software interface for configuring an HTTP request in Celigo, featuring various fields including request URL, headers, and body settings. (Captioned by AI)
The image shows a software interface for configuring an HTTP request in Celigo, featuring various fields including request URL, headers, and body settings. (Captioned by AI)2560×1277 187 KB

3

Yes, see below:

Two text fields are shown, labeled "Lookup response field" and "Source record field," with associated values "data[0].blobKey" and "blob" respectively. (Captioned by AI)

A web interface displaying a form for configuring an HTTP request body with advanced options like blob key path and mock response settings. (Captioned by AI)
A web interface displaying a form for configuring an HTTP request body with advanced options like blob key path and mock response settings. (Captioned by AI)880×612 30.1 KB

4

So I noticed that your Blob key path wasn't using handlebars so I removed those from mine as well. Now I am getting an error when it runs:

The image shows an error message indicating that the body lacks valid data required for a multipart/form-data request, with an invalid value for the "value" field. (Captioned by AI)
The image shows an error message indicating that the body lacks valid data required for a multipart/form-data request, with an invalid value for the "value" field. (Captioned by AI)1120×112 13.6 KB

5

The filename might be wrong. Try {{{record.filename}}}. This assumes you have a field on your record called filename though. In my case I do. You can also try just hardcoding some file name there to pinpoint other issues.

Also, what does your response mapping look like? Did you map blobKey to blob?

6

I think the filename was part of the problem. I am now seeing an attachment in Jira, however, the file appears to be corrupted.

image
image189×181 5.26 KB

Here is the Jira JSON response with my file information:

The image is a JSON snippet detailing an attachment with metadata, including URLs, filename, author, and avatar information. (Captioned by AI)
The image is a JSON snippet detailing an attachment with metadata, including URLs, filename, author, and avatar information. (Captioned by AI)1116×401 34.1 KB

However the file doesn't render in Jira:

The image shows an error message stating "Something went wrong. We couldn't generate a preview for this file," with a download button below. (Captioned by AI)
The image shows an error message stating "Something went wrong. We couldn't generate a preview for this file," with a download button below. (Captioned by AI)390×351 12.5 KB

Or in Windows if I download the file:

image
image345×242 1.7 KB

7

Got it! My lookup step to get the attachment from DevOps was incorrectly set to file encoding of UTF-8. Switched to binary and all is now working. Thanks again!

image
image195×169 26.6 KB

1 Like