API: Report exporter billable and reimbursable values always blank?

John_ Expensify Customer Posts: 3 Expensify Newcomer
edited May 2018 in Integrations and API


I'm trying to get the billable and reimbursable expense values through the csv report exporter but they always output blank in the exported csv. All of the other report and expense values in my template are coming through correctly (e.g. amount, tag, comment), so I'm not sure what the issue is.

Any guidance on how to properly get these values is appreciated.


Best Answer

  • Greg Schroeder
    Greg Schroeder Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 64 Expensify Team
    edited August 2018 Answer ✓

    Hi @John_!

    For reference, the reimbursable and billable variables are booleans. As such, these won't output any values without a string added to them.

    Using the billable variable as an example, instead of using ${expense.billable}, try using ${expense.billable?string("Yes", "No"}. This will output Yes if the expense is billable and No if it is not.

    Let me know if that does the trick for you!