Does Jira have the ability to pull data from a table?

[Trevor Overstreet]

Can JIRA perform a lookup function to pull information out of a table?

For example, if we provided JIRA a table with data values in multiple columns for making a burger - bun type, condiments, packaging, employee - and we asked it to give us the employee value associated with sesame seed bun, ketchup, and cardboard box...could it give us the associated employee name listed in the table and insert the value into a user field?

Real world ex: we have client name, client#, teams, and products...based on a number of combinations, if a task is entered via a form and the values = clientABC, #1234, team falcons, product research THEN assign task to Michael J. 

The assignee field (or maybe another field) would pull from the table to extract that user

[Kai Becker · Accepted solution]

Hi @Trevor Overstreet 

I've read your text twice but I actually have no idea what you are trying to achieve.

Out of the box, there is no option for Jira Cloud to pull data from a database.
Therefore you would need to use an app like Elements Connect

[Trevor Overstreet]

First point:

Have a reference data table (attached) with multiple data point and columns. Ideally pulled via API from another system so its always updated or stored in Jira and manually updated (least desired)

Second:

Be able to create automation rules using this data table to reference assignees and automatically assign issues based on the grid in the data table. So when a task is submitted via an intake form and it answers which Client, Department, Product then it auto assigns to that person. See attachment and hope this helps.

We can not set up these rules manually bc there would be 100+ rules

This app you referenced may work if we can use it for automation

[Laura Campbell _Seibert Group_]

Thanks for the mention @Kai Becker !

@Trevor Overstreet You should be able to set up your use case by adding Elements Connect connected items to your JSM request, and then using Automation to take the assignee from your datasource and set it in the issue.

To get an idea of how this could work, check out this tutorial of querying Okta to get the reporter's manager and set them as the approver: https://doc.elements-apps.com/elements-connect-cloud/how-to/set-the-reporter-s-manager-as-approver-from-okta

You mention that your data is available via API; you'll want to check the authentication required. For information, authorization grant code flow will be available very shortly (in addition to the currently supported API authentication methods).

If you have questions about setting up your use case, our Product Manager would be happy to talk with you. You can book a call here.

[Kai Becker]

@Trevor Overstreet by default there is no option to store such data in Jira. So this data should be made accessible via app or you could use Assets to store this information. But therefore an upgrade to your Jira plan would be necessary.

[Trevor Overstreet]

Thank you both @Kai Becker @Laura Campbell _Seibert Group_  for the suggestions and documentation! I will certainly review Elements Connect in more detail. We haven't created the API yet but ideally this data would feed from Gainsight into Jira.