Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open Data Processor for Jira: Navigate to the app within your Jira Cloud instance.

    navigation to app.jpg
  2. Go to Data Sources ➡️ JSON: Select the Data Sources section in the left-side menu, and then choose JSON from the list.

    data sources left bar_json.jpg

    or

    On the Home page of the main interface, click the 'JSON' icon.

    home_json.jpg

  3. Create New Data Source: Click on 'Create your first Data Source' in the center of the screen if no Data Sources exist yet.

    create first data source_orange.jpg

    If you've previously created Data Sources, select '+New Data Source' at the top right corner of the screen.

    plus_new_data_source.png
  4. Enter Main Information: Fill in the Name and optionally, a description for the Data Source. Click 'Next step'.

    main information_orange.jpg
  5. Apply JQL Filter (Optional): Use JQL to filter your Jira data, if needed. Click 'Next step'.

    JQL_orange.jpg

    To learn more about JQL and get assistance with its syntax, please refer to this informative article. It offers valuable insights and guidelines to help you understand and effectively use JQL for your data queries.

  6. Select Tables and Fields: Choose the specific tables and fields you want to include in your Data Source.

    Available tables for export
    In the left section of the main interface, you'll find a list of all available tables for export. You can conveniently select the specific tables you need by clicking the 'Plus' button next to each table. This feature allows for a tailored and efficient export process, ensuring you export only the necessary data.

    available tables for export_orange.jpg

    You can expand the tables to view the available fields and their formats, allowing for a clear understanding of the data structure before exporting.

    expand tables.jpg

    The complete list of tables and fields that are available for export can be seen here.

    Selected tables for export
    Clicking the 'Plus' button moves tables from the left section to the 'Selected tables for export' on the right. There, you'll select fields for export. Check the box next to a label to select all fields within it or expand the label to choose individual fields. The count of selected fields versus total available is displayed next to each label name.

    selected to export_orange.jpg

    To remove a table from those selected for export, simply click the ‘Trash bin’ button on the right. This will automatically move the table back to the 'Available tables for export' section, allowing you to adjust your selections as needed.

    trash_orange.jpg

    While selecting data for export, you may encounter ‘As Array of objects in the Issues table' and
    'As Nested object’ switches.

    switches.jpg


    - As Array of objects in the Issues table:
    Nested JSON arrays of objects offer advanced data management by embedding objects within arrays for a structured, hierarchical format. This is particularly effective for representing complex relationships, enhancing both the efficiency and clarity in handling interconnected data. It's a preferred method in programming and data handling due to its organized approach to complex data structures.

    Here is an example of disabled and enabled As Array of objects in the Issues table for Worklogs:

    example_worklogs_as_array.png


- As Nested object:
Nested JSON objects are highly effective for complex data organization. They offer better structuring by allowing objects within objects, creating a hierarchical layout. This method enhances data organization and reduces redundancy, as repeated values can be stored in a single, overarching object, thus eliminating data duplication.

Here is an example of disabled and enabled As Nested object for Update Author:

...