<?php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Request\PutPivotTableFieldRequest;

$cellsApi = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));

$remoteFolder = "TestData/In";

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

$pivotTableFieldRequestData = array (
    0
);
$pivotTableFieldRequest = new \Aspose\Cells\Cloud\Model\PivotTableFieldRequest();
$pivotTableFieldRequest->setData($pivotTableFieldRequestData ); 

 
$request = new PutPivotTableFieldRequest();
$request->setName( $remoteName);
$request->setSheetName( "Sheet4");
$request->setPivotTableIndex( 0);
$request->setPivotFieldType( "Row");
$request->setPivotTableFieldRequest( $pivotTableFieldRequest);
$request->setNeedReCalculate( 'true');
$request->setFolder( $remoteFolder);
$request->setStorageName( "");
$cellsApi->putPivotTableField($request);