Need to retrieve a key value from a previous iterated step

[GSG]

The Pabbly Connect workflow ID is https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZkMDYzMDA0MzE1MjZhNTUzNCI_3D_pc

I am trying to extract the key value (as opposed to the return value) from a previous step in which meta data has been iterated and then transformed using data transformation step.

The iterator and data transformer steps (steps 3 and 5) returns the following: "5. Res2 NXT Polarized : Brown with Blue Mirror $ 645.00" in step 6 (text formatter). My understanding is that the first part before the colon is the key value and the return value is the part after the colon. We are already using the return value in a different step, but we need to also place the key value in a subsequent step.
In summary, we need to extract "NXT Polarized" from this string and place the resulting content into a subsequent step. I have tried to split text using regex and patterns to no avail.

Kindly note that the string which contains NXT Polarized before the colon will depend on the content of an e-commerce order and is therefore not fixed. There are 8 possible variations to this text including PC Fixed Tint, PC Polarized, PC Photochromic, NXT Polarized etc

Perhaps you can help make some suggestion to extract only the text between Res2 and the colon?

Many thanks

Graham

 

[Preeti Paryani]

Hello @GSG

The only way to extract the keys from a WordPress response is by using Pabbly’s JSON extractor, which returns the response as key-value pairs (as shown in the attached screenshot).

However, you may encounter an issue with the metadata fields being received in a shuffled order.

 

[GSG]

Thanks for your reply. The only issue with this is that if the woocommerce order details change or incorporate less options (or options in a different order), then the key - value number returned will be different and this makes it impossible to map the resulting values into specific columns in a google sheet.

To get around this for most of the values I have used an iterator plus data transformer steps which allow us to attach specific meta data values to specific columns in google sheet. See attached screenshot.

We are looking for a way to split the key-value pair into its components parts so that I can use one component of the key value pair to populate a specific column in google sheet, but it seems from what you are saying that this is impossible?

 

[Preeti Paryani]

Unfortunately, splitting key-value pairs from responses is not possible now.