Failing to fetch issues using JIRA Cloud for Sheets

maganti.sreekar

I have connected my JIRA to Google Sheets, and am trying to fetch issues using Basic querying, but I'm seeing a persistent error:

Error message: "Error in JQL Query: Expecting either a value, list or function but got 'IN'. You must surround 'IN' in quotation marks to use it as a value. (line 1, character 35)"

The same query was successful in populating the Google Sheet with JIRA issues in the past

I tried pasting the JQL query in the Filter search in JIRA to verify if the syntax is right, and this is showing that everything is fine with the query syntax:

 

Please clarify what the issue is here.

Thanks,

Sreekar

Andy Heinzer

Hi Sreekar,

I tried to recreate this problem based on your screenshots, but so far I have not been able to.

One way to try to work around this would be to go to this search in Jira first (such as in your 2nd screenshot).  Then run this search at least once.  Once you do this, you can then save this search as a filter.  Save that filter.  When you do, the URL in the address bar will change to show you the id of that filter.  It will look something like this

.atlassian.net/issues/?filter=10073

One thing you can try to get around this problem is to then go back to google sheets and enter in this for the JQL search

filter=10073

You will need to change that number to whatever number you found when saving your filter.  This should at least let you continue to pull those Jira issues into this sheet without this error.

However, I would also be interested to see if we can gather the complete JQL query here.  It looks like it is getting truncated by your screenshots here, so perhaps the great length of the query is a factor in the problem here.  Interested to try to learn more here.

Andy