using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Model;
using Aspose.Cells.Cloud.SDK.Request;
using System;
using System.IO;
using System.Collections.Generic;

CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
string remoteFolder = "TestData/In";

string localName = "TestCase.xlsx";
string remoteName = "TestCase.xlsx";



var pivotTableFieldRequestData = new List<int?>()
{
    0
};
var pivotTableFieldRequest = new PivotTableFieldRequest()
{
    Data = pivotTableFieldRequestData
};
var request = new DeletePivotTableFieldRequest(
    name: remoteName,
    sheetName: "Sheet4",
    pivotTableIndex: 0,
    pivotFieldType: "Row",
    pivotTableFieldRequest: pivotTableFieldRequest,
    folder: remoteFolder,
    storageName: ""
);
cellsApi.DeletePivotTableField(request);