Loop through webrequest with pagination

[Yogesh Ranjitkar]

Hi Team,

I am trying to create a Jira Automation where I am making a web request to one of the customfields in Jira to pull it value and based on the choice of another Customfield, one of the JIra fields is populated from the value it fetch from the web request.

For example:

I have a field called Field A, Field B and Field C.

I am making rest call in Feild A which is a Select List (SIngle choice) field and it contains nearly 800 options to be selected from. Now what I am trying to automate is, when a user select a value in Field B, based on that value, Field C should be populated from the value it pulled from Field A via web request. 

I have got it working. However, the problem is with pagination. In Jira cloud, the max item it retuns in a call is 100. Is there any efficient way to go through the paginated list i.e. a best way to get all 800 items from field A.

Thanks.

[Bill Sheboy]

Hi @Yogesh Ranjitkar 

The short answer is: no, there is no easy / efficient way to do this in an automation rule.

What problem are you trying to solve?  That is, "why do this?"  Knowing that may help the community to offer other solution approaches.

Until we know that information, and back to your question...

You do not indicate which version of Jira you are using: Cloud, Server, or Data Center.

All three versions could use conditional logic, but with 800 values that would require repeating your Send Web Request action block nine times with hardcoded pagination, and is likely to be difficult to maintain.

Similarly all three versions could inline this using smart value, conditional logic.  I do not know the upper limit on the length of a smart value expression (although I believe it to be several million characters), and I would not want to maintain something with 800+ conditions!

If you are using Jira Cloud, Lookup Tables could handle up to 200 rows each, reducing the rule length some, although those tables would also be difficult to maintain.

Kind regards,
Bill