Failed API Calls - JIRA

Question

Hello,

We are using automate.io for integrating google sheets and JIRA issue tickets. Whenever, the JIRA status updated, the same will be updated in the google sheet with all columns. We are able to update the columns in the sheet except "fixversion" column. Instead of version number, the URL as mentioned below appears in the column

https://qbizsol.atlassian.net/rest/api/2/version/10102,

This is happening due to the additional character (comma) suffixed at end of the URL by JIRA and found that the API calls work as expected if we removed the suffixed character (This was tested in REST client). Is that a bug or anything we missed?

Thanks,

Sabari.

Sabari_xpsm7s · Answer

Hi,

I checked with them, there are no issues in the configuration of automated tasks, Is there a way to remove suffixed character before invoking the API call? Any help would be appreciated.

Thanks,

Sabari.

Sabari_xpsm7s · Answer

Hi Nic,

Thanks for the response. The google sheet will get updated by automate.io bot whenever the status has changed in JIRA. Here, what I assume that the API call suffixed with comma separator even that specific ticket has one value. I am not sure that API call generated by JIRA or automate. I will check them too.

Regards,

Sabari.

Nic Brough -Adaptavist- · Answer

Your google sheet is not handling single versions properly, it needs to remove the ,

The comma is there as a separator between (possible) multiple options being in the field, and your sheet needs to strip it from the last value in the field.