Can you get a link to the Report (not the expense) using Custom Export format

jbaxter

I need a link to the report in my custom export format but it looks like I can only get the link to the individual expense? Does anyone know how to get the report link or do I have to use the API?

Ted Harris

Hey again @jbaxter - this one should actually be pretty simple because:
1. The link used for a Report is exactly the same across Expensify, for everything but the Report ID AND
2. The Report ID is something you can generate in a Custom Export!

For example, here's one of my reports in Expensify:

Here you can see that the URL leading up to the the Report ID is simply:

https://www.expensify.com/report?reportID=

...finishing with the Report ID itself:

37523940

All you'll need to do when creating your CSV Export formula is to put these two strings together!

https://www.expensify.com/report?reportID={report:id}

jbaxter

Thankyou! @Ted Peeters This was exactly what I was looking for When I was logged in and looking at the report the link looked a bit more complicated but I tested using your instructions and it works perfectly.