When using the Jira Connector in Azure ADF, how can I save the table list in the dataset?

@Gue, David

It looks like you are trying to extract the list of tables available in the Jira connector within Azure Data Factory, so you can loop through them programmatically in a pipeline, rather than selecting each table manually in the dataset.

Unfortunately, ADF does not currently expose the list of available Jira tables (like issues, projects, etc.) as a queryable object. The dropdown in the dataset is only available through the UI and can't be extracted directly within the pipeline logic.

Workarounds you can consider:

Manual List + Lookup Activity:

• Manually copy the list of Jira tables shown in the dataset UI.
• Save them in a config file (like JSON or a SQL table).
• Use a Lookup activity to retrieve the list and pass it to a ForEach activity to loop through them.

Use Jira REST API - If you need to generate the table/entity list dynamically:

• Use ADF’s REST connector to call Jira’s REST API endpoints (e.g., /rest/api/3/project, /rest/api/3/field).
• Parse the response to get a list of entities you want to extract (like issues, users, etc.).
• Feed that result into a pipeline variable or dataset.

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.