How to create multiple projects in Jira at once?

[ana take]

Hi all,

I want to create multiple projects in Jira at once. I have read that Jira saves fields as table so Projects is a table. I want to create for example 1000 projects (The reason is that after all these projects have been created I want to extract some data through Power BI Desktop) in JIRA. I think that these projects can be created using sql queries. These can be done using INSERT INTO ...SELECT statements. In the documentation for 

CData Power BI Data Connector for JIRA 2018 

I read that these can be done  using the Odbc.Query function in the M formula language.

How can I access Odbc.Query?

[Nic Brough -Adaptavist- · Accepted solution]

NO!  Never update a Jira database with SQL direct access.  You will destroy the system and need to revert to a backup.

On the bright side, Cloud gives you no access to the database, so you can't do it anyway.

To work with automating stuff in Jira, either find an App that can help you, or use the REST api directly - https://developer.atlassian.com/server/jira/platform/rest-apis/

[ana take]

Thank you for your answer!

But I have another question: Can I use SQL statements to import data of Jira Cloud into Power BI Desktop?

[Nic Brough -Adaptavist-]

Cloud gives you no access to the database, so no.