Update: MasterCard has successfully resolved the issue with their commercial card systems. We're awaiting file deliveries now. For more information, please visit our status page.

Going to SuiteWorld in Las Vegas April 1-4? So are we! While you're there, you can stop by the Expensify booth in the Expo hall to chat about how the current features work, any questions you may have, or discuss what's next for this integration. We look forward to seeing you there!

Report Exporter always creates two export files with different filenames and same contents.

InnovAsianInnovAsian Posts: 25 Expensify Newcomer

When I request all my Approved reports after a certain date to be uploaded to my FTP site, it creates two files with different names and same contents. I can work around the issue, but it is strange.

The InputSettings "type" parameter is set to the only valid choice, 'combinedReportData', so I am not sure why it occurs.

------- PHP code snippet --------
$ch = curl_init();

$headers=array('Content-Type: multipart/form-data');

$post_fields=array();

$file_name_with_full_path="template_report_export.ftl";

$requestJobDescription["type"]="file";
$requestJobDescription["credentials"]=array(
"partnerUserID"=>$partnerUserID,
"partnerUserSecret"=>$partnerUserSecret
);
$requestJobDescription["onReceive"]=array("immediateResponse"=> array("returnRandomFileName"));

$requestJobDescription["inputSettings"]=array(
"type"=>"combinedReportData",
"reportState"=>"REIMBURSED",
"limit"=>"99",
"filters"=>array(
"approvedAfter"=>"2018-10-01" ,
"startDate"=>"2016-01-01",
"markedAsExported"=>"Expensify Export"
)
);
$requestJobDescription["outputSettings"]=array("fileExtension"=>"csv");

$requestJobDescription["onFinish"]=array(
array("actionName"=>'sftpUpload',
"sftpData"=>array(
"host"=>"anything.com",
"login"=>"username",
"password"=>"password",
"port"=>22
)
)
);

$post_fields['requestJobDescription']=json_encode($requestJobDescription);

$post_fields['template'] = file_get_contents($file_name_with_full_path);

curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_VERBOSE, TRUE);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post_fields);

curl_setopt($ch,CURLOPT_CUSTOMREQUEST, "POST");
$result = curl_exec($ch);
$response= curl_exec($ch);
$info= curl_getinfo($ch);
echo "Request not successful. Response code : ".$info['http_code']."
";
echo "Response : $response";

curl_close ($ch);
------- PHP code snippet --------

Answers

Sign In or Register to comment.