How can I match multiple PDF files back to their respective expense report IDs?

oschlipf
oschlipf Approved! Accountant Posts: 11 Expensify Newcomer
edited March 2020 in Integrations and API

I'm downloading PDFs with images for employee expense reports. To load into our imaging system, I need to match these PDFs back to their respective expense reports for automated loading.

The trouble is that I am needing one PDF per expense report/invoice, but there's no way to match the pdf files back to an expense report because the names are random. If I could force the pdf filenames to be the expense report IDs that would solve the problem. But how is anyone supposed to use a set of PDF files that come back with names like this:

imagesdc2ed26f-04ad-4586-aed3-36f4c10207ca-37305054.pdf,
imagesdc2ed26f-04ad-4586-aed3-36f4c10207ca-39092683.pdf,
imagesdc2ed26f-04ad-4586-aed3-36f4c10207ca-38195588.pdf

How am I supposed to do anything programmatically to know which PDF goes to which expense report??

Best Answer

  • Ted Harris
    Ted Harris Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 359 Expensify Team
    Answer ✓

    Hi there @oschlipf - I've taken a quick look at your account and it does look like the final 8 digits of those filenames are report ID's that you have access to.

    Would you mind checking whether report ID's: 37305054, 39092683 and 38195588 match up with the three PDF's you've mentioned above?

    As a quick refresher, you can always use Shift + G to quickly navigate to any report ID within Expensify.

Answers