How to Get Defect list from Jira using SQL query in Uipath
To connect to Jira using this activity package, you must first create the credentials required by the Jira Scope to authenticate all subsequent calls. The scope currently supports two types of authentication:
API Token: An authentication token is generated by Jira for your user. This method supports fully unattended automations.
OAuth 2.0: A client ID and secret are generated by Jira and may be used for all users within an organization. This method displays, at runtime, a login screen in which a user may enter their login credentials for Jira or any of its SSO providers. A token is produced and saved locally. This token is short-lived and may have to be refreshed at a later time. For this reason, this method supports attended and some unattended automations.
For Connecting we need to perform below step:
1. Add a Jira Scope to your workflow and change the Authentication Type parameter to Api Token.
2. Fill in the Server URL property with the URL of your organization's Jira instance. For Cloud instances, this is usually in the form of https://your org.atlassian.net.
3. Lastly, fill in the Api Token property with the token generated in step 1 and the Username property with the email you use to log into the designated Jira instance. The Jira Scope is now ready for use.
For generating Token use below link:
URL: https://id.atlassian.com/manage/api-t...
Once the connection is done and tested we have to use Jira get application scope activity and get Issue SQL activity for extracting defect list through SQL command.
#Uipath #RPA #Uipathrpa #JIRAautomation #jiraintegrationinuipath #uipathstudiopro #UiPathAutomation #UiPathtutorial #RPAtutorial #uipathtutorialsforbeginners #defectlist #extractingdefectlistthoughsqlcommand #SQLcommand
*********************************************************************
Did you enjoy the video? If so, give it a like above!
Subscribe to our channel for more techie video
👉 https://www.youtube.com/c/DeepakRai?s...
Keep Learning!! Keep Growing!!
P.S. Make sure to keep up with us by clicking the bell!
