Retrieving the updated issue information from JIRA application - 7.0

JIRA

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Business applications > JIRA components
Data Quality and Preparation > Third-party systems > Business applications > JIRA components
Design and Development > Third-party systems > Business applications > JIRA components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tJIRAInput component to open its Basic settings view.
  2. Select Issue from the JIRA resource drop-down list.
  3. In the JQL field, enter the JQL query used to retrieve the issue in JIRA application.
    In this example, the query is project = DOC AND issuekey = DOC-2. The issue with the key DOC-2 under the project DOC will be retrieved.
  4. Double-click the tExtracJSONFields component to open its Basic settings view.
  5. Click the [...] button next to Edit schema, and in the schema dialog box displayed, define the schema by adding five columns of String type, id, key, project, description, and summary, which will hold the corresponding information of each issue retrieved.

    When done, click OK to save the changes and close the dialog box.

  6. Select the JSON field to be extracted from the JSON field drop-down list. In this example, it is json, which is passed from the tJIRAInput component.
  7. In the Loop Jsonpath query field, specify the path to the node on which the loop is based. In this example, it is $, which is the root node of the JSON field.
  8. In the Mapping table, the Column cells are automatically filled with the schema columns, and you need to specify the corresponding JSON node that holds the desired data for each schema column. In this example, $.id for the id column, $.key for the key column, $.fields.project.key for the project column, $.fields.description for the description column, and $.fields.summary for the summary column.
  9. Double-click the tFileOutputJSON component to open its Basic settings view.
  10. In the File Name field, specify the path to the file into which the extracted issue information will be written, D:/JiraComponents/issue_info_update.json in this example. And in the Name of data block field, enter the name of the data block, issue in this example.