This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
I have the option to pull a raw webhook from my affiliates list. It comes in as one string and I want to extract the First Name and Email.
Yes, raw webhook is the only option I have right now. I know there’s an extract email feature in Zapier but I really need the name too and can’t figure out how to get that.
This is my Row Body:
{"type":"Sale.created","id":156097961,"livemode":true,"created":"2024-04-10T04:28:28+00:00","hook_event_id":712322122,"object":{"id":156097961,"price":0,"currency":"USD","is_active":true,"is_recurring":false,"user_id":105043073,"school_id":1705736,"final_price":0,"shipping_address":null,"course":{"id":2478144,"name":"Core Course","url":"https://academyofdjs.teachable.com/courses/2478144","friendly_url":"core","meta_description":"","description":null,"image_url":"https://cdn.filestackcontent.com/fC3BdjzFR3GbzfdKQ6rM","author_bio":{"created_at":"2023-08-03T23:00:39Z","profile_image_url":"https://www.filepicker.io/api/file/XkAz41mQcykBzbhvb7QG","bio":"\u003cp\u003eAcademy of DJs, founded in 2015, is a DJ school set with a purpose greater than just showing students how to blend songs and beat match. We are here to mentor, we are here to instill passion \u0026amp; ambition, we are here to show you what it really takes to be a DJ in this modern day industry.\n\u003c/p\u003e\n\u003cp\u003eWe provide the full spectrum of education ranging from beat matching, scratching, branding, reading a crowd, setting up audio equipment, mixtapes, and more!\n\u003c/p\u003e","position":null,"user_id":96263538,"name":"Academy of DJs","id":1874541,"meta":{"class":"authorbio","url":"/author_bios/1874541","name":"Academy of DJs","description":"","image_url":null,"status":null},"user_name":"xxxxx xx","user_is_owner":true,"user_has_custom_role":false}},"product":{"id":5459239,"is_recurring":false,"price":0,"name":"Admin enrolled","currency":"USD"},"user":{"id":105043073,"role":"student","email":"xxxxxx-xxxxx@gmail.com","name":"xxxxxxx Pham","school_id":1705736,"src":null,"first_touch":null,"last_touch":null,"last_sign_in_at":null,"sign_in_count":0,"unsubscribe_from_marketing_emails":false},"coupon":{"created_at":"2024-04-10T04:28:27Z","scope_name":"","pricing_plan_specific":true,"is_for_student_referral":false,"student_referral_type":null,"new_purchase_price":0,"formatted_discount":"$0","formatted_price":"FREE","calculated_discount":0,"currency":"USD","discount_percent":1.0,"discount_amount":null,"number_available":0,"code":"67B5EBEECD909482E6091C00B8D0FEAAED7741CB","name":"generated to enroll student at 2024-04-10 04:28:27 +0000","expiration_date":"2026-04-10T04:28:27+00:00","cap_visible":false,"display_priority":null,"product_id":5459239,"is_published":true,"duration_kind":"once","number_of_uses":1,"class_period_id":null,"id":308433197,"meta":{"class":"coupon","url":null,"name":"generated to enroll student at 2024-04-10 04:28:27 +0000","description":"","image_url":null,"status":null},"product":{"created_at":"2024-04-10T04:15:32Z","formatted_price":"FREE","formatted_period_full_words":"monthly","formatted_price_no_period":"FREE","course_id":2478144,"name":"Admin enrolled","description":null,"billing_interval":"month","enrollment_cap":null,"enrollment_cap_fulfillment_count":0,"enrollment_cap_visible":false,"enrollment_cap_expires_at":null,"enrollment_cap_display_priority":null,"display_enrollment_cap?":false,"detailed_description":null,"currency":"USD","position":4,"price":0,"is_recurring":false,"is_published":false,"billing_interval_count":1,"author_revenue_share":null,"num_payments_required":null,"free_trial_length":null,"id":5459239,"access_limit_duration":null,"access_limit_interval":null,"access_limit_date":null,"meta":{"class":"product","url":null,"name":"Admin enrolled","description":null,"image_url":null,"status":null},"course":{"created_at":"2024-03-05T20:24:12Z","destroyed_at":null,"is_published":true,"is_listed":true,"primary_product_id":5384680,"video_settings":{"translations":["ES","VI","FIL_PH","ZH_CN"],"main_language":"EN"},"path":"/courses/2478144","safe_image_url":"https://process.fs.teachablecdn.com/ADNupMnWyR7kCWRvm76Laz/resize=width:705/https://cdn.filestackcontent.com/fC3BdjzFR3GbzfdKQ6rM","has_published_lecture":true,"has_published_product":true,"promo_video":null,"is_cohort":false,"name":"Core Course","template":"colossal","heading":"The ONLY course you'll need to go from 0 to HERO. This course includes 8 modules teaching fundamentals including history and music theory.","page_title":"Core Course","meta_description":"","friendly_url":"core","description":null,"author_bio_id":1874541,"position":14,"conversion_pixels":null,"closing_letter":null,"image_url":"https://cdn.filestackcontent.com/fC3BdjzFR3GbzfdKQ6rM","hero_image_url":null,"bundled_courses_count":0,"child_course_ids":[],"preenrollment_call_to_action":"Sign up to get this course when it launches","is_open":true,"is_accepting_preenrollments":false,"use_old_course_page":null,"skip_thank_you_page":null,"onboarded_at":null,"id":2478144,"default_page_id":15594422,"checkout_sidebar_page_id":15594423,"certificate_page_id":15594483,"purchase_redirect_url":null,"mobile_thumbnail_url":"https://cdn.filestackcontent.com/4zxOWO1sRIE2fTVd305v","mobile_hero_image_url":"https://cdn.filestackcontent.com/3NgyeuC9RHqAXeGB9C0u","post_purchase_page_id":15594424,"issue_certificates_manually":null,"is_video_completion_enforced":true,"is_lecture_order_enforced":true,"is_minimum_quiz_score_enforced":true,"minimum_quiz_score":80.0,"maximum_quiz_retakes":99,"is_maximum_content_width_enforced":true,"is_progress_bar_disabled":null,"meta":{"class":"course","url":"/courses/2478144/","name":"Core Course","description":null,"image_url":"https://cdn.filestackcontent.com/fC3BdjzFR3GbzfdKQ6rM","status":null},"categories":[{"created_at":"2023-08-11T00:59:31Z","name":"Core Course","description":null,"is_published":true,"id":785283,"meta":{"class":"category","url":"/categories/785283","name":"Core Course","description":null,"image_url":null,"status":null}}],"author_bio":{"created_at":"2023-08-03T23:00:39Z","profile_image_url":"https://www.filepicker.io/api/file/XkAz41mQcykBzbhvb7QG","bio":"\u003cp\u003eAcademy of DJs, founded in 2015, is a DJ school set with a purpose greater than just showing students how to blend songs and beat match. We are here to mentor, we are here to instill passion \u0026amp; ambition, we are here to show you what it really takes to be a DJ in this modern day industry.\n\u003c/p\u003e\n\u003cp\u003eWe provide the full spectrum of education ranging from beat matching, scratching, branding, reading a crowd, setting up audio equipment, mixtapes, and more!\n\u003c/p\u003e","position":null,"user_id":96263538,"name":"Academy of DJs","id":1874541,"meta":{"class":"authorbio","url":"/author_bios/1874541","name":"Academy of DJs","description":"","image_url":null,"status":null},"user_name":"xxxxx xx","user_is_owner":true,"user_has_custom_role":false}},"creator_product":null,"product_collection":null,"digital_product":null}},"affiliate":null,"transactions":[]}}
