JIRA connector in Data factory

Rinshad Koissan 51 Reputation points
2022-03-10T11:05:44.113+00:00

Hi Team,

I would like to get the query to pull last 90 days data from JIRA. Currently we are using hard coded date.

Also would like to get syntax for a command which works similar to SQL like operator in JIRA connector .

181897-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,772 questions
0 comments No comments
{count} votes

Accepted answer
  1. Saurabh Sharma 23,761 Reputation points Microsoft Employee
    2022-03-11T03:25:13.13+00:00

    Hi @Rinshad Koissan ,

    Thanks for using Microsoft Q&A!!
    As per my understanding you have basically two asks - first one to pull data using by dynamically calculating 90 days from the current date and the second is to use a similar operator like SQL like in a JIRA query.
    For your first ask, you need to first create a variable to hold a date and you need to calculate prior date using addDays function like below using SET variable activity -
    @addDays(utcNow(), -90)
    182059-image.png

    Now instead of using a direct query in your Copy Data activity you need to use Dynamic Expression to create the query (including the date variable) which you want to run at JIRA end through JIRA data set. Your dynamic query would look something like below -
    182065-image.png

    @concat('Select Issues_key, Issues_Fields_Created ,Issues_Fields_Summary, Issues_Fields_Priority_Name from "Agile"."Agile_Board_Issue" where Issues_Fields_Created >= ''',formatDateTime(variables('Date'), 'yyyy-MM-dd'),'''')

    When you run this pipeline, actual query will be created like below which would fetch the required data from Jira. (See below)
    182030-image.png

    Now, regarding your second question, you can take a look at ~ operator in Jira Query Language if this helps. I do not have expertise on JIRA but I could feel this is what you are looking for.

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.


0 additional answers

Sort by: Most helpful