I pull data from phantombuster via webhook. My desired Outcome is: Post URL | Firstname | Lastname | LinkedIn URL. However, the webhook drops all the data into one output field. But I need a row per person. Is there a way to fix this? Maybe by pulling this data chunk and import it to another table and cleaning it in the process? Would really appreaciate the help! Btw I couldn't find a way to change the output within PhantomBuster
You can solve this by using the "Send row for each item in a list" feature in Clay. Here's how: 1. First, set up a webhook table to receive your PhantomBuster data by clicking "+ Create New" and selecting "Import data from Webhook" from the "Other" section. 2. Once your webhook table has the PhantomBuster data, go to that table and click "Actions" → "Send table data". 3. Select a destination table (create a new one if needed). 4. Choose "Send row for each item in a list" as your method. This will flatten the list and create individual rows for each person in your data. 5. Map the fields to ensure each person's Post URL, Firstname, Lastname, and LinkedIn URL are properly assigned to columns in the destination table. 6. Click "Save" to complete the setup. This approach will transform your consolidated webhook data into individual rows with each person's details separated as you need.
Hi Hermann, thank you for reaching out! I’ve set up a flow for you that handles this process. It first converts the text object into an array, making it easier to work with. Then, the data is sent to a new table using 'Send Table Data' action, where the list is broken down into individual rows. I hope this helps :)