Fetching MCC column value for Merchant Credit Card transaction

Sandipan_Pal09

Hi Team,

We are using the Expensify API to fetch expense report data. We are also fetching MCC column[expense.mcc] as suggested in report template guide. But the details are not coming in extract.

Refer attached template file for reference.

Kindly let me know if this is some setup issue or something else.

Template.txt

Zany Renney

Hi there!

Thanks for sending over the template file. I'm not super sure what you are attempting to show me though, could you clarify which details are missing from the extract for me, please?

As our API is self-serve so the best way to know if you are using it corrected is by referring to our Help Guide which contains all the information.

Sandipan_Pal09

Hi,

When we ran with attached template file, we got output without MCC column value[last column as per template].

Remaining columns data is fine, but expense.mcc didn't generate any value[as per guide, if the transaction is of merchant credit card, expense.mcc should fetch last 4 digits of the credit card]. Is there some other way to fetch the same?

Zany Renney

Hi!

This sounds like a bit of a complicated scenario, particular to your use case, would you mind writing in to [email protected] or hitting the blue chat bubble on your mobile / web, so that we can troubleshoot this with you live?

Thanks.