SELECT INTO ステートメントを使って、書式付きデータをファイルにエクスポートできます。

SQL クエリを使ったデータのエクスポート

次のクエリは、comma-separated values（CSV）ファイルフォーマットにデータをエクスポートします。

C#

String connectionString = "ApiKey=jQJ45617PnmrZAtrPnYWqGtBhojsX9;Url=https://yourURL.backlog.com";

using (BacklogConnection connection = new BacklogConnection(connectionString)) {
  BacklogCommand cmd = new BacklogCommand("SELECT Id, ProjectID INTO [csv://Issues.txt] FROM [Issues] WHERE StatusID = '1' ", connection);
  int rowsAffected = cmd.ExecuteNonQuery();
} 

VB.NET

Dim connectionString As [String] = "ApiKey=jQJ45617PnmrZAtrPnYWqGtBhojsX9;Url=https://yourURL.backlog.com" 

Using connection As New BacklogConnection(connectionString)
  Dim cmd As New BacklogCommand("SELECT Id, ProjectID INTO [csv://Issues.txt] FROM [Issues] WHERE StatusID = '1'", connection)
  Dim rowsAffected As Integer = cmd.ExecuteNonQuery()
End Using

C#

String connectionString = "ApiKey=jQJ45617PnmrZAtrPnYWqGtBhojsX9;Url=https://yourURL.backlog.com";

using (BacklogConnection connection = new BacklogConnection(connectionString)) {
  BacklogCommand cmd = new BacklogCommand("SELECT * INTO [Issues] IN [csv://filename=c:/Issues.csv;delimiter=tab] FROM [Issues] WHERE StatusID = '1'", connection);
  int rowsAffected = cmd.ExecuteNonQuery();
} 

VB.NET

Dim connectionString As [String] = "ApiKey=jQJ45617PnmrZAtrPnYWqGtBhojsX9;Url=https://yourURL.backlog.com" 

Using connection As New BacklogConnection(connectionString)
  Dim cmd As New BacklogCommand("SELECT * INTO [Issues] IN [csv://filename=c:/Issues.csv;delimiter=tab] FROM [Issues] WHERE StatusID = '1'", connection)
  Dim rowsAffected As Integer = cmd.ExecuteNonQuery()
End Using