2 Replies Latest reply on Aug 14, 2017 7:26 PM by Nicholas Sewitz

    Get Activities Form Field API Response

    Nicholas Sewitz

          Has anyone come up with a regex/parse expression for the activities api response on the form submissions table. An example value is

       

      ```

      => "a:33:{s:6:\"module\";s:11:\"leadCapture\";s:6:\"action\";s:5:\"save2\";s:9:\"FirstName\";s:7:\"Valerii\";s:8:\"LastName\";s:9:\"Smith\";s:5:\"Email\";s:37:\"test@test.com\";s:5:\"Phone\";s:13:\"+442032860354\";s:7:\"Type__c\";s:14:\"Design Gallery\";s:7:\"Company\";s:9:\"Timax-Art\";s:7:\"Website\";s:37:\"https://www.test.com\";s:10:\"botCapture\";s:0:\"\";s:15:\"galleryInsights\";s:4:\"TRUE\";s:21:\"galleryInsightsSource\";s:23:\"partnership application\";s:19:\"galleryInsightsType\";s:8:\"prospect\";s:6:\"formid\";s:4:\"2001\";s:10:\"munchkinId\";s:11:\"609-FDY-207\";s:25:\"utm_medium_First_Touch__c\";s:5:\"email\";s:25:\"utm_source_First_Touch__c\";s:8:\"sailthru\";s:27:\"utm_campaign_First_Touch__c\";s:31:\"personalized_email_sun-08-13-17\";s:26:\"utm_content_First_Touch__c\";s:33:\"personalized_artists_and_artworks\";s:19:\"RC_First_Channel__c\";s:0:\"\";s:23:\"utm_term_First_Touch__c\";s:0:\"\";s:19:\"RC_First_Adgroup__c\";s:0:\"\";s:25:\"RC_Acquisition_Channel__c\";s:12:\"UnpaidEarned\";s:27:\"utm_medium_Lead_Creation__c\";s:6:\"Social\";s:27:\"utm_source_Lead_Creation__c\";s:8:\"Facebook\";s:29:\"Web_Referrer_Lead_Creation__c\";s:25:\"https://www.facebook.com/\";s:25:\"utm_source_Most_Recent__c\";s:8:\"Facebook\";s:20:\"RC_Recent_Channel__c\";s:12:\"UnpaidEarned\";s:25:\"utm_medium_Most_Recent__c\";s:8:\"Referral\";s:27:\"Web_Referrer_Most_Recent__c\";s:25:\"https://www.facebook.com/\";s:8:\"_mkt_trk\";s:55:\"id:609-FDY-207&token:_mch-artsy.net-1502622181874-60448\";s:7:\"formVid\";s:4:\"2001\";s:13:\"_mktoReferrer\";s:42:\"https://www.test.net/partnerships\";}"

      ```