I have more than 150 key value pair, Need to import those in Lookup table for automation, can i do?

[Sidra Shakoor]

I have more than 150 key value pair, Need to import those in Lookup table for automation, Is this possible to import key value pairs in lookup table?

[Sebastian Krzewiński · Accepted solution]

Hi @Sidra Shakoor 

Automatic import is not available. I see 2 options:

1. Add it manually in rule

2. Export rule, open json file, add pairs where they should be added, import rule again

Regards,

Seba

[Sidra Shakoor]

Thanks!

[Bill Sheboy]

Hi @Sidra Shakoor 

What is the stability of your lookup data, as you could try the Dynamic Lookup Table for larger number of rows in different cases:

• Data is stable -- Use Created Variables and a Dynamic Lookup Table
  • Use a created variable to copy-and-paste your data in using delimiters
  • Split the variable into a list on the delimiters, and use the list to load a Dynamic Lookup Table
• Data changes often -- Use your data source and a Dynamic Lookup Table
  • Get your data from a REST API endpoint, attachment, entity property, etc.
  • Split into a list  / load your data using the Dynamic Lookup Table

Kind regards,
Bill

[Rik de Valk _Brainboss_]

Hi @Sidra Shakoor , 

There is no option to import lookup tables in an automation rule. I've had to create quite large lookup tables myself, and it's no fun. 

I would not like to create one of 150 rows....

It would be really useful if you had Assets available. You could import, store and maintain your lookup table in Assets. And then use Assets in your automation rule to fetch the values. 

If you don't have Assets, but this lookup table is very important, you could create a Jira project and create 1 issue for each row in your lookup table. And use the Summary as the Key and the Description as its Value. Then use the lookup work items to fetch the value. 

But that is a very creative solution that is quite far-fetched 😄

Have a nice day. 

Rik 

[Sidra Shakoor]

Thanks for the idea!