• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Need to retrieve a key value from a previous iterated step

GSG

Member
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
 

Attachments

  • Screenshot 2024-09-19 at 07.43.41.png
    Screenshot 2024-09-19 at 07.43.41.png
    42.5 KB · Views: 21
  • Screenshot 2024-09-19 at 08.38.28.png
    Screenshot 2024-09-19 at 08.38.28.png
    389.3 KB · Views: 21

Preeti Paryani

Well-known member
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).

image (31).png


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

GSG

Member
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?
 

Attachments

  • Screenshot 2024-09-20 at 08.28.02.png
    Screenshot 2024-09-20 at 08.28.02.png
    467.8 KB · Views: 13
Top