Are you receiving SNAP/EBT benefits? The Expensify.org/SNAP-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP receipt and $50 for getting your COVID-19 vaccine here and join today!

API: Report exporter billable and reimbursable values always blank?

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

Hi,

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.

Thanks

Best Answer

  • Greg Schroeder
    Greg Schroeder Expensify Success Coach - Admin, Expensify Team Posts: 55 Expensify Team
    edited August 2018 Accepted 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!

Answers