Extracting Report using API.

Pradeep_R Expensify Customer Posts: 1

Hello all,

I am trying to extract the report using Expensify APIs by following the steps below.

API References:

//File Export:

{    "type":"file",    

 "credentials":{      "partnerUserID":"//Valid UserID",

"partnerUserSecret":"//ValidUserSecret"    },     


 "immediateResponse":["returnRandomFileName"]    },     

 "inputSettings":{      "type":"combinedReportData",       






"markedAsExported":"Expensify Export"      }    },    



"fileBasename":"myExport"    }



<#if addHeader == true>Submitted,AccountID,Merchant,Amount,Category,currency,reportID,mcc,convertedAmount,reimbursable,tag,ManagerUserID,PolicyID,ApproverUserID</#if>

<#list reports as report>

<#-- Report level -->

<#list report.transactionList as expense>












${report.managerUserID},<#t> // Required Help


${report.approvers}<#lt> // Required Help





  "type": "download",

  "credentials": {




  "fileName": "Output from above export API",

  "fileSystem": "integrationServer"


This API call gives me the below output CSV file but I am not getting the required value for the field approvers / ManagerUserID.

I created a template by referring to this https://integrations.expensify.com/Integration-Server/doc/export_report_template.html.

* Approvers is in array! I just wanted to confirm whether the template formula that I have used to extract this approver is valid or not.

Even though I tried to define the approver in the report's policy, the formula I was using was not a valid one.

Not sure if this is mandatory to extract the approver information from the report.

* ManagerUserID- I used this field instead of approvers to get the approver but still, it has not given me any value.


My report is in approved status and I believe they should return a value of the approver.

Can anyone tell me where I am making a mistake in pulling the approver value? If the template formula that I am using is wrong, can anyone suggest how to write a formula to extract the approver value?

Any suggestion is appreciated.