Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save groupdocs-cloud-gists/fb280757ece24c2045f7dfecf8d93dd3 to your computer and use it in GitHub Desktop.
Save groupdocs-cloud-gists/fb280757ece24c2045f7dfecf8d93dd3 to your computer and use it in GitHub Desktop.
Convert CSV to JSON or JSON to CSV Programmatically in C#

You can convert CSV to JSON online or JSON to CSV large file programmatically on the cloud. In this article, you will learn how to convert CSV to JSON or JSON to CSV Programmatically in C#.

The following topics are covered in this article:

  1. JSON to CSV and CSV to JSON Conversion API and C# SDK
  2. How to Convert CSV to JSON in C# using REST API
  3. Convert Large JSON to CSV in C# using REST API
// How to Convert CSV to JSON in C# using REST API
using System;
using GroupDocs.Conversion.Cloud.Sdk.Api;
using GroupDocs.Conversion.Cloud.Sdk.Client;
using GroupDocs.Conversion.Cloud.Sdk.Model;
using GroupDocs.Conversion.Cloud.Sdk.Model.Requests;
namespace GroupDocs.Conversion.CSharp
{
// Change CSV to JSON File Online
class Convert_CSV_to_JSON
{
static void Main(string[] args)
{
try
{
// Create necessary API instances
var apiInstance = new ConvertApi(configuration);
// Prepare convert settings
var settings = new ConvertSettings
{
FilePath = "csharp-testing/input-sample-file.csv",
Format = "json",
OutputPath = "csharp-testing/output-sample-file.json"
};
// Convert to specified format
var response = apiInstance.ConvertDocument(new ConvertDocumentRequest(settings));
Console.WriteLine("Successfully converted CSV to JSON format online in C#: " + response[0].Url);
}
catch (Exception e)
{
Console.WriteLine("Exception when calling GroupDocs ConvertApi: " + e.Message);
}
}
}
}
// How to Convert Large JSON to CSV in C# using REST API
using System;
using GroupDocs.Conversion.Cloud.Sdk.Api;
using GroupDocs.Conversion.Cloud.Sdk.Client;
using GroupDocs.Conversion.Cloud.Sdk.Model;
using GroupDocs.Conversion.Cloud.Sdk.Model.Requests;
namespace GroupDocs.Conversion.CSharp
{
// Convert From JSON to CSV Online
class Convert_JSON_to_CSV
{
static void Main(string[] args)
{
try
{
// Create necessary API instances
var apiInstance = new ConvertApi(configuration);
// Prepare convert settings
var settings = new ConvertSettings
{
FilePath = "csharp-testing/input-sample-file.json",
Format = "csv",
OutputPath = "csharp-testing/output-sample-file.csv"
};
// Convert to specified format
var response = apiInstance.ConvertDocument(new ConvertDocumentRequest(settings));
Console.WriteLine("Successfully converted JSON file to CSV file online in C#: " + response[0].Url);
}
catch (Exception e)
{
Console.WriteLine("Exception when calling GroupDocs ConvertApi: " + e.Message);
}
}
}
}
// How to Download converted JSON file in C#
using System;
using GroupDocs.Conversion.Cloud.Sdk.Api;
using GroupDocs.Conversion.Cloud.Sdk.Client;
using GroupDocs.Conversion.Cloud.Sdk.Model.Requests;
namespace GroupDocs.Conversion.CSharp
{
// Download Output File
class Download_File
{
static void Main(string[] args)
{
try
{
// initialize api
var fileApi = new FileApi(configuration);
// create download file request
var downloadRequest = new DownloadFileRequest("csharp-testing/output-sample-file.json", myStorage);
// download file
Stream downloadResponse = fileApi.DownloadFile(downloadRequest);
// save file in working directory
using (var fileStream = System.IO.File.Create("H:\\groupdocs-cloud-data\\output-sample-file.json"))
{
downloadResponse.Seek(0, SeekOrigin.Begin);
downloadResponse.CopyTo(fileStream);
}
}
catch (Exception e)
{
Console.WriteLine("Exception when calling GroupDocs FileApi: " + e.Message);
}
}
}
}
using System;
using GroupDocs.Conversion.Cloud.Sdk.Api;
using GroupDocs.Conversion.Cloud.Sdk.Client;
using GroupDocs.Conversion.Cloud.Sdk.Model.Requests;
using System.IO;
namespace GroupDocs.Conversion.CSharp
{
// Upload Sample File
class Upload_File
{
static void Main(string[] args)
{
try
{
// initialize api
var fileApi = new FileApi(configuration);
// open file
var fileStream = File.Open(@"H:\groupdocs-cloud-data\input-sample-file.csv", FileMode.Open);
// create file upload request
var request = new UploadFileRequest("csharp-testing/input-sample-file.csv", fileStream, myStorage);
// upload file
var response = fileApi.UploadFile(request);
Console.WriteLine("CSV File Upload Process Completed: " + response.Uploaded.Count.ToString());
fileStream.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception when calling GroupDocs FileApi: " + e.Message);
}
}
}
}
//Get clientId & clientSecret from https://dashboard.groupdocs.cloud (free registration is required).
string clientId = "xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
string clientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
string myStorage = "test-internal-storage";
var configuration = new Configuration(clientId, clientSecret);
configuration.ApiBaseUrl = "https://api.groupdocs.cloud";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment