| Note |
|---|
Remember that only Jira admins have permanent permission to create data sources. If you're a User, ensure you've received the necessary permissions from your Jira administrator before attempting to create a data source. For detailed instructions on how to set up permissions, please visit the Administration page. |
...
To create a JSON Data Source in our app, follow these steps:
Open Data Processor for Jira: Navigate to the app within your Jira Cloud instance.
Image Removed
Image AddedGo to Data Sources ➡️ JSON‘Data Sources’ ➡️ ‘JSON’: Select the ‘Data SourcesSources’ section in the left-side menu, and then choose JSON ‘JSON’ from the list.
Image Removed
Image Addedor
On the Home page of the main interface, click the 'JSON' icon.
Image Removed
Image AddedCreate New Data Source: Click on 'Create your first Data Source' in the center of the screen if no Data Sources exist yet.
Image Removed
Image AddedIf you've previously created Data Sources, select '+New Data Source' at the top right corner of the screen.
Image RemovedEnter Main Information: Fill in the Name and optionally, a description for the Data Source. Click 'Next step'.
Image RemovedApply JQL Filter (Optional): Use JQL to filter your Jira data, if needed. Click 'Next step'.
Image RemovedTo 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.
Image AddedSelect Tables and Fields: Choose the specific tables and fields you want to include in your Data Source.
Available tables for export
In the left right section of the main interface, under each tab of Jira services, 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 that you export only the necessary data. Additionally, you can easily navigate using the Search bar.
Image Removed
Image AddedYou can expand the tables to view the available fields and their formats, allowing for a clear understanding of the data structure before exporting.
Image Removed
Image AddedThe 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
...
right section to the 'Selected tables for export' section on the
...
left.
...
Here, you
...
can select the 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 the total available is displayed next to each label name. You can also easily navigate using the Search bar.
...
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.
...
...
| Info |
|---|
While selecting data for export, you may encounter ‘As Array of objects in the Issues table' and
'As |
...
Nested object’ switches.  Image Added- 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:  Image Added- 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 |
...
Save Your Data Source: After selecting all the Tables and Fields you want to export, finalize your settings by clicking the ‘Save+’ button. This action will save the configurations you've made for your data export.
...
...
As Nested object for Update Author: |
...
 Image Added |
Once all data has been selected, click 'Next Step' to proceed.
...
| Note |
|---|
To activate the ‘Next Step’button and successfully create a data source, you must select at least one field in the 'Selected tables for export’ section. |
Apply JQL Filter (Optional): Use JQL to filter your Jira data, if needed. Click 'Next step'.
Image Added
| Info |
|---|
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. |
Enter Main Information: Fill in the Name and optionally, a description for the Data Source. Click 'Save+'.
Image AddedList of Created Data Sources: After clicking the 'Save+' button, you will see a list of the created data sources ready for export.
...
| Tip |
|---|
Identify the data source you need, and you're now ready to export your Jira data into JSON format. For a comprehensive guide on how to proceed with this process, please refer to the detailed instructions available here |
...
| Note |
|---|
To successfully activate the ‘Save+' button and create a Data Source, it's necessary to select at least one field in the 'Selected tables for export’ section. |
Keep in mind that you can navigate between steps using the 'Previous step' and 'Next step' buttons, allowing for easy adjustments at any stage of the process.
| Info |
|---|
To easily return to the Home page, simply click on the Data Processor Logo located at the top left corner. This provides a quick and straightforward way to navigate back to the main screen. |
| Panel |
|---|
| panelIconId | 2b50 |
|---|
| panelIcon | :star: |
|---|
| panelIconText | ⭐ |
|---|
| bgColor | #FFEBE6 |
|---|
|
If you've had the chance to use the Data Processor for Jira - Multi BI Connector and Advanced Exporter app, we'd love to hear your thoughts. Help us improve by sharing your honest review of the Free, PRO or Xray versions. Your feedback is crucial as we strive to improve and tailor our services to better meet your needs. 🤝 |
| Aura inline button |
|---|
| summary | back to top |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJiYWNrJTIwdG8lMjB0b3AlMjIlMkMlMjJzaXplJTIyJTNBJTIybWVkaXVtJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZmZmZmYlMjIlN0QlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyYXJyb3dzLXVwLXRvLWxpbmUlMjIlN0QlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGdGhlY29kZTQuYXRsYXNzaWFuLm5ldCUyRndpa2klMkZzcGFjZXMlMkZEUEZKJTJGcGFnZXMlMkYyMTk2MDE5JTJGQ3JlYXRlJTJCSlNPTiUyQmRhdGElMkJzb3VyY2UlMjNUby1jcmVhdGUtYS1KU09OLURhdGEtU291cmNlLWluLW91ci1hcHAlMjUyQy1mb2xsb3ctdGhlc2Utc3RlcHMlMjUzQSUyNTVCaGFyZEJyZWFrJTI1NUQlMjIlN0QlN0Q= |
|---|
|
| Aura inline button |
|---|
| summary | Free App |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlN0QlN0QJTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q= |
|---|
|
| Aura inline button |
|---|
| summary | Book a Demo |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q= |
|---|
|
| Aura inline button |
|---|
| summary | PRO App |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlN0QlN0Q=JTdCJTIybGFiZWwlMjIlM0ElMjJQUk8lMjBBcHAlMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyZGF0YWJhc2UlMjIlN0QlMkMlMjJtaW5XaWR0aCUyMiUzQTAlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGbWFya2V0cGxhY2UuYXRsYXNzaWFuLmNvbSUyRmFwcHMlMkYxMjMzNTA0JTJGZGF0YS1wcm9jZXNzb3ItZm9yLWppcmEtbGluay1wb3dlci1iaS1sb29rZXItdGFibGVhdS1wcm8lM0Zob3N0aW5nJTNEY2xvdWQlMjZ0YWIlM0RvdmVydmlldyUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA== |
|---|
|
...
| Panel |
|---|
| panelIconId | 1f917 |
|---|
| panelIcon | :hugging: |
|---|
| panelIconText | 🤗 |
|---|
| bgColor | #E6FCFF |
|---|
|
Still have questions? Feel free to reach out to us for any additional information or to request new features! |
