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\";}"
```
Solved! Go to Solution.
That's PHP serialized output. But if you don't care about field lengths you don't need the (s)tring sizes.
That's PHP serialized output. But if you don't care about field lengths you don't need the (s)tring sizes.
Thanks!