Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am trying to create approx. 600 child Jira tickets that link within their respective preexisting parent tickets with a google sheet row update trigger.

I’m trying to use a Find Issue by Key to match the row in my spreadsheet that contains Hubspot IDs (labeled record ID on the sheet) with the Hubspot ID field currently in the parent Jira ticket. I’ve triple-checked that the Hubspot ID in Jira matches the Record ID in the sheet, but I’m getting the below error message.

 

Because this test won’t run I can’t run the final Create Issue command, but when I do here is an excerpt of what shows on configure and test:

 

Am I going about this incorrectly? The Hubspot ID in Jira 100% matches the record ID I’m trying to link to it.

 

Thank you so much in advance for taking a look at this!

Hi and welcome to the Community, ​@Tattnall! 🎉

That Find Issue by Key action is expecting to receive the Key for the issue it needs to find, not the HubSpot/Record ID. The Fields field is used for selecting the specific fields to be output when it finds an issue, not for selecting the field to search by:
c7225663d38a76e7e2b9ba1b9f618fd8.png

If you need to search for the issue based on the value contained within a custom field then I’d suggest using the Find Issue (Via JQL) search action instead. It will allow you to use JQL (Jira Query Language) to search the issues for a matching Record ID value in each HubSpot ID field. If you’ve not used JQL before you can learn more about how to use it here: Perform advanced searching with JQL queries

Can you give that a try and let us know how it goes? 

Terms & ConditionsAccessibility statement