def transform_many(self, inputs, options=None, **kwargs):
"""
Override the standard behavior of the transform_many by only
accepting list inputs which we use to perform the choose operation.
"""
if not inputs:
if options is not None and options.get('default') is not None:
return options.get('default')
return u''
if not isinstance(inputs, list):
self.raise_exception('Choose requires a list of inputs')
if options is None:
options = {}
default = options.get('default')
op = options.get('operation', None)
if op is None or op == '':
self.raise_exception('Missing Operation')
if op in self._operations:
op_func = self._operations[op]
return op_func(inputs, default=default)
i = try_parse_number(op, cls=int, default=None)
if i is None:
return default
return self.choose_nth(i, inputs, default=default)
def transform(self, str_input, separator=u'', index=0, **kwargs):
if not str_input:
return u''
separator = expand_special_chargroups(separator)
if separator:
segments = str_input.split(separator)
else:
segments = str_input.split()
if index == 'all':
return segments
if index == 'fields':
return {
u'Item {}'.format(i + 1): s
for i, s in enumerate(segments)
}
index = try_parse_number(index, cls=int)
try:
return segments[index]
except:
pass
return u''
def transform_many(self, inputs, options=None, **kwargs):
"""
Override the standard behavior of the transform_many by only
accepting list inputs which we use to perform the choose operation.
"""
if not inputs:
if options is not None and options.get('default') is not None:
return options.get('default')
return u''
if not isinstance(inputs, list):
self.raise_exception('Choose requires a list of inputs')
if options is None:
options = {}
default = options.get('default')
op = options.get('operation', None)
if op is None or op == '':
self.raise_exception('Missing Operation')
if op in self._operations:
op_func = self._operations[op]
return op_func(inputs, default=default)
i = try_parse_number(op, cls=int, default=None)
if i is None:
return default
return self.choose_nth(i, inputs, default=default)
def transform(self, str_input, find=u'', offset=0, **kwargs):
str_input = str_input or u''
find = find or u''
pos = -1
if isinstance(offset, basestring):
offset = try_parse_number(offset, cls=int, default=None)
if not isinstance(offset, (int, long)):
self.raise_exception('offset must be a number')
if str_input and find:
pos = str_input.find(find, offset)
return pos
def transform(self, str_input, separator=u'', index=0, **kwargs):
if not str_input:
return u''
separator = expand_special_chargroups(separator)
if separator:
segments = str_input.split(separator)
else:
segments = str_input.split()
if index == 'all':
return segments
index = try_parse_number(index, cls=int)
try:
return segments[index]
except:
pass
return u''
def transform(
self, input_key, my_dict=None, decimals=2, subtotal_toggle=False, **kwargs
):
"""Take a dict input and output an array of one or more Zapier standard line-items.
Subtotal value takes the values from two other fields like Price and Quantity and multiplies them
Example:
User inputs some strings and a dict like this:
input_key = "Order Lines"
my_dict = {
"Price": "5,3.5,4",
"Description": "Hat,Shoes,Shirt",
"Quantity": "1,2,1"
}
decimals = "2"
subtotal_toggle=True,
Expected output (Zapier Standard Line Items with optional, calculated Subtotal property):
{
Order Lines": [
{
"Price": "5",
"Description": "Hat",
"Quantity": "1",
"Subtotal": "5.00"
},
{
"Price": "3.5",
"Description": "Shoes",
"Quantity": "2",
"Subtotal": "7.00
},
{
"Price": "4",
"Description": "Shirt",
"Quantity": "1",
"Subtotal": "4.00"
}
]
}
"""
# make sure that a name is set for the line-item group
if not input_key:
input_key = "Line-item(s)"
# initialize variables
if my_dict is None:
my_dict = {}
output = {input_key: []}
longest_array = 0
subtotal = "subtotal"
price = "Price"
qty = "Quantity"
# check for alternative cases for property names for price and quantity
if price not in my_dict:
for k in my_dict:
if k.lower() == "price":
price = k
if qty not in my_dict:
for k in my_dict:
if k.lower() == "quantity":
qty = k
elif k.lower() == "qty":
qty = k
decimals = try_parse_number(decimals)
try:
my_places = Decimal(10) ** (-1 * int(decimals))
except ValueError as e:
self.raise_exception(
"Please enter an integer for the 'Decimal Places for Subtotal Values' field."
)
# filter out entries with no key
my_dict.pop("", None)
# split each string value in the dict by ',' and determine the
# length of longest array
for k, v in my_dict.items(): # might not need iteritems
my_dict[k] = v.split(",")
if len(my_dict[k]) > longest_array:
longest_array = len(my_dict[k])
# make individual objects for each line (example: could include 1 value each of qty, description, price) to add to the output object
for num in range(0, longest_array):
# initialize a new individual line-item
this_line_item = {}
for k, v in my_dict.items():
# Try to add each property from my_dict to the individual line-item.
# Skips if the list isn't long enough for an available property.
try:
this_line_item[k] = v[num]
except IndexError as e:
pass
if price in this_line_item and qty in this_line_item and subtotal_toggle:
# Try to create a subtotal value for this line item if:
# Create Subtotal Property is "Yes"
# There is no conflict between a Line-item property with the same name as the Subtotal field
# The Price and Quantity fields both exist in this line item.
try:
decimal_price = Decimal(this_line_item[price])
decimal_qty = Decimal(this_line_item[qty])
# must convert to string or float here, or else output will include the text "Decimal()"
this_line_item[subtotal] = str(
(decimal_price * decimal_qty).quantize(my_places)
)
except (KeyError, ValueError, InvalidOperation) as e:
# These are the three error types we'd expect to happen in this block, although KeyError is minimized
# by the if statement
pass
# try adding the individual line item object to the main output array. Skips if no object is available (unlikely).
try:
output[input_key].append(this_line_item)
except IndexError as e:
pass
return output
