Transform data in a workflow

[binamov]

Hi folks,

Curious to hear some suggestions for this usecase:

I have a step that generates a list of products ordered line_items, something like this:

[
  {
    "sku": "foo",
    "price": 1500
  },
  {
    "sku": "bar",
    "price": 2000
  }
]

You can see that the price is in cents. I’d like to convert those values to dollars, so divide by 100, before handing the line_items to my smtp service for populating an email template with a summary of products ordered.

Is there a lightweight way to go about this, eg some of the utility steps, or should I just use a code step?

[kishanprmr]

Hi @binamov , Welcome to the community ,

You can use a Code step with the following code to format the line_items. You need to pass the line_items array in the data field, as shown in the image.

export const code = async (inputs) => {
  return inputs.data.map(item => ({
    ...item,
    price: item.price / 100,
  }));
};

[binamov]

Yeah, that’s what I ended up doing, thanks for the confirmation