I'm new to Zapier and have only spent a couple hours poking around so far I've been unable to find a solution for what I want to do yet, and figured i'd ask here in case i'm missing something trivial.
The gist is, I want to take an event from Splitwise (New Transaction), Filter any transactions that I am not included in (easy enough, filter on my ID or first name), and then use the 'Net Balance' for myself in the last step. I am having trouble converting the data provided from Splitwise into a format that lets me pull net_balance for myself.
Here is an example of the format I receive from Splitwise (with some details I don't care about removed):
I want the net_balance for whichever user I am in the transaction (could identify by the id, or names). If my ID is 0000002, then I want a way to access the value '10.00' in my last Zapier step.
I thought i could do this with the lookup table utility, but it doesn't work how I expected (I can't find a way to create a lookup table from provided data in the correct format).
Any advice/help/shove in the right direction is appreciated! Thanks!