Unperseable JSON value for the Bulk Export of activity - Unsubscribe Email/Fill Out Form | Community
Skip to main content
Saptarshi_Konar
New Participant
November 5, 2019
Solved

Unperseable JSON value for the Bulk Export of activity - Unsubscribe Email/Fill Out Form

  • November 5, 2019
  • 1 reply
  • 3153 views

Getting unparseable json for the attribute "Form Fields"  while calling API for the activity - Unsubscribe Email/Fill Out Form.

Example-

ActivityTypeId - 2,9

API - /bulk/v1/activities/export/{exportId}/file.json

method - GET

Response - CSV

 This contains one column called - "attributes" which contains below json-

{
   "Client IP Address": "Masked IP",
   "Query Parameters": "",
   "Referrer URL": "Masked URL",
   "User Agent": "Masked User Agent",
   "Webpage ID": 1,
     "Form Fields": "a:5:{s:6:\"module\";s:11:\"something\";s:6:\"action\";s:5:\"some action\";s:9:\"FirstName\";s:6:\"Some       First Name\";s:8:\"LastName\";s:5:\"Some Last       Name\";s:13:\"_mktoReferrer\";s:59:\"https://some.something.com/abc.html\";}"
}

  • Please let us know how to parse this value of Form Fields to a json.
  • Is there any parser or sample code available in marketo for this?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

That's a valid JSON string (so I wouldn't refer to this as "unparseable JSON", it never claims to be JSON-in-JSON).

Internally it's in PHP object serialization format. There is likely a decoder for your language, if you search Github.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
November 5, 2019

That's a valid JSON string (so I wouldn't refer to this as "unparseable JSON", it never claims to be JSON-in-JSON).

Internally it's in PHP object serialization format. There is likely a decoder for your language, if you search Github.

Saptarshi_Konar
New Participant
November 6, 2019

Thanks for the quick response.

your answer will solve my query.

SanfordWhiteman
New Participant
November 6, 2019

Cool, could you mark my answer above as Correct?