Bulk import of Issues from a spreadsheet

Savvas Kleanthous

• May 09, 2019 16:15

Request for directions/ post commands and API model to allow bulk creation of issues from a spreadsheet.

1

• Official comment

  

  Dylan Wright

  • September 27, 2019 16:02

  Hi Savvas,

  As you know, we just released this into our production environment. You can now bulk edit issues on the project level. Thank you for posting on here!

  
• 

  Richard Gold

  • May 14, 2019 21:22
  • Edited

  Hello Savvas,

  If you know how to create VBA macros in Excel you can loop through the rows of your sheet and call our issue API endpoint.

  The Issue model definition is found here: https://www.projectinsight.net/api-docs/help/model/issue

  The Issue endpoint definition is found here: https://www.projectinsight.net/api-docs/help/post-issue

  This Stack Overflow post might help you get started: https://stackoverflow.com/questions/38246789/how-do-we-use-restful-apis-from-excel-macros-vba

  Hope that helps!

  0

Please sign in to leave a comment.