[CRITICAL] Get sandbox transactions working so we can get QA testing travel daily

[kevinksullivan]

Problem

We have a sandbox environment we can point accounts to in order to test travel booking (SO), but we've had issues getting all of the data from these transactions. That is a pretty broad statement though, and if we don't use the sandbox environment we pay a $15 fee every test booking we make in production.

Solution

• [x] Figure out what exactly is going wrong with sandbox and what data we are missing. Is this a Spotnana issue or is it on us?
• [ ] Depending on the above, let's fix the issue ourselves or come up with clear asks for spotnana
• [ ] Add a test script to testrail for applause, so we're QAing travel booking consistently and confirming it is working well end to end.

[stitesExpensify]

Added some logs today to see if my hunch is correct. Based on these logs it looks like we were sent the event, but when trying to get the user's info we got user_not_found. This to me indicates that we are trying to find the user on the production spotnana server instead of the sandbox

[stitesExpensify]

I ended up finding the problem before the logs were deployed! I CP'd it and we are not getting fares via the sandbox again. We are still not getting fees for some reason. My guess is because the amount is $0 on the sandbox?

[stitesExpensify]

Posted here to find out why we aren't getting fees https://expensify.slack.com/archives/C066REXJ9D3/p1726171051522029

[melvin-bot[bot]]

@kevinksullivan, @stitesExpensify Uh oh! This issue is overdue by 2 days. Don't forget to update your issues!

[stitesExpensify]

Waiting for Spotnana to respond here https://expensify.slack.com/archives/C066REXJ9D3/p1726171051522029

[stitesExpensify]

Waiting on a response, will bring it up in our meeting today

[stitesExpensify]

We're good! We can start testing the non-credit card case in staging now!