Best answer

Selecting a value between two metadata lists

  • 22 October 2020
  • 8 replies
  • 444 views

Userlevel 1

I’m using a Zap that reads information from my Woocommerce site. The information is presented similar to below
 

I want to retrieve the _stripe_net value of 181.46, but the problem is that depending on the product sold, this value could be in any position from 6 to 9.
How can I create a step(s) that allows me to find out what is the column and retrieve the appropriate value.

I tried using string.find as per below

 

which resulted on the following output…

But I don’t know how to use this to select the 8th value inside the <Meta Data Value> field.

icon

Best answer by FalconOz 24 October 2020, 19:45

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Userlevel 7
Badge +14

[ADVANCED] You’ll need to use a custom Code step to get data from the array by finding the index of the match term: https://zapier.com/apps/code/help

Userlevel 1

[ADVANCED] You’ll need to use a custom Code step to get data from the array by finding the index of the match term: https://zapier.com/apps/code/help


Indeed. Thanks for the heads up. For anyone else who might be interested in getting Stripe NET values when selling with Woocommerce, the Python code I used is below: