This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 62%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Trying to setup incremental extracts of JIRA data. So need to filter issues on date so I can get new records only.
There are 2 options on "Copy" control "Source" tab....
What syntax can you put in the query box ? I cant find a single peice of help on this?
thanks
I got this working, trick is tablename has to be one of the API names in the dropdown when you setup a dataset. But there is zero info about this online. Its nothing to do with JIRA database backend table names.
Hi @jonathan prentice ,
Glad to know your issue resolved. Could you please mark it as Accepted Answer? Accepted answers helps community as well. Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Hi!!
I have the same problem. I am trying to ingest Jira data into my dataLake but instead of ingesting the full info I would like to do deltas. I found out that the "updated" property, that in jira is available for every issue regardles of its type, is not available via the Azure Data Factory Connector. For the "Extra"."Api_Issue" we have the Fields_Updated field, but for other entities like "Platform"."Api_Project" I can't find any field that allows me to perform a delta. Do you know if there is any common field, available through the Jira ADF connector, that allows to filter by "updated" or something similar?
Hi @jonathan prentice ,
Welcome to Microsoft Q&A Platform. Thank you for posting your query here.
When you are using JIRA dataset as source, Use the custom SQL query to read data. For example: "SELECT * FROM MyTable".
Click here to know more about properties when you use Jira as source in copy activity.
Click here to know more about Jira connector in azure data factory.
Hope this will help. Please let us know if any further queries.
------------------------
accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.