question

jonathanprentice-2100 avatar image
0 Votes"
jonathanprentice-2100 asked ShaikMaheer-MSFT commented

How do I Query JIRA using Azure Data Factory connector?

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....

  • source dataset

  • query

What syntax can you put in the query box ? I cant find a single peice of help on this?

thanks




129230-image.png


azure-data-factory
image.png (53.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

jonathanprentice-2100 avatar image
0 Votes"
jonathanprentice-2100 answered ShaikMaheer-MSFT commented

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.
129867-image.png



image.png (21.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @jonathanprentice-2100 ,

Glad to know your issue resolved. Could you please mark it as Accepted Answer? Accepted answers helps community as well. Thank you.

0 Votes 0 ·
ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @jonathanprentice-2100 ,

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.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.