Saptarshi_Konar
Level 2
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
01-28-2020
02:05 AM
|
11
Posts
0
Likes
0
Solutions
12-20-2019
07:41 AM
I don't think it is related to the admin timezone. If timezone is associated with it then we will have a time and timezone value associated with the "Created Date" data.
... View more
12-20-2019
07:40 AM
Usually I get date like " 2018-12-18T16:01:11Z "- which means it is in UTC but in this case I am getting data like " 2018-12-16 " - it seems like Marketo in not considering the time. My application is in EST timezone, so should I save the data as it is or change the date time according to the timezone.
... View more
12-19-2019
02:06 AM
I have fetched the data for new Lead activity where the "Created Date"(in attributes) field has a date value. Is the value specific to any timezone like "Activity Date"which is in UTC. Example - marketoGUID leadId activityDate activityTypeId campaignId primaryAttributeValueId primaryAttributeValue attributes 151258 969095 2018-12-18T16:01:11Z 12 null 899015 Mark Josh {"Created Date":"2018-12-16","Form Name":"5204 - ABC Training XDC.Post ONLY Form - Access Onlis","Source Type":"Webinar form fillout"}
... View more
Labels:
11-25-2019
01:57 AM
I did not get you, My Question is if I have data for "email send" and "email delivered"(from bulk extract API), how would I map this data between this two activities. Is it the "primaryAttribute" by which we can connect the activity? And one more thing, is there any document to get details/ meaning of each activity and there respective attributes.
... View more
11-22-2019
06:44 AM
I have data for the following activities- Send Email Email Delivered Email Bounced Unsubscribe Email Open Email Click Email I want to know what is the common attribute between these activities through which I can identify that the email which had been send to lead, was opened or clicked later.
... View more
11-07-2019
12:09 AM
Sanford Whiteman Actually it is not a subset. I want the data as per EST( considering the Daylight Saving ). So I tried the following request- API- /bulk/v1/activities/export/create.json JSON - { "format": "CSV", "filter": { "createdAt": { "startAt": " 2018-10-16T00:00:00Z America/New_York ", "endAt": " 2018-10-16T23:59:59Z America/New_York " } } } But in the output CSV from the api " /bulk/v1/activities/export/{requestId}/file.json", I am not getting any entries for the timeline. But for the "startAt": " 2018-10-16T00:00:00Z ", "endAt": " 2018-10-17T23:59:59Z " or "startAt": " 2018-10-16T00:00:00Z America/New_York ", "endAt": " 2018-10-17T23:59:59Z America/New_York " which is a 2 days interval I am getting below entries which all are dated between " 2018-10-16T00:00:00 " to 2018-10-16T22:00:00 marketoGUID leadId activityDate 2913 169 2018-10-16T16:26:06Z 2916 169 2018-10-16T16:26:13Z 2921 169 2018-10-16T16:31:22Z 2923 169 2018-10-16T16:31:52Z 2929 169 2018-10-16T16:32:03Z 2947 13 2018-10-16T17:36:00Z 2950 13 2018-10-16T17:36:10Z 2969 13 2018-10-16T18:34:35Z 2972 13 2018-10-16T18:34:41Z 3003 87 2018-10-16T21:07:29Z 3006 87 2018-10-16T21:07:41Z 3012 171 2018-10-16T21:12:10Z 3014 171 2018-10-16T21:12:22Z Is the activityDate in CSV always show the date time in UTC? what should be the Ideal input for the request if I want to fetch data in EST timezone for the above example? Is marketo instance timezone is related to the API timezone?
... View more
11-06-2019
06:29 AM
Sanford Whiteman Have timezone related queries for bulk extract API of activity. You can refer this - https://nation.marketo.com/thread/52253-timezone-for-bulk-export-api-of-activity
... View more
11-06-2019
05:10 AM
I am also confused about the timezone. Need clarification what is the timezone marketo is considering for rest APIs.
... View more
11-06-2019
03:08 AM
I am confused regarding the timezone, when a bulk export API for activity is called. Example- API- /bulk/v1/activities/export/create.json JSON - { "format": "CSV", "filter": { "createdAt": { "startAt": "2018-10-16T00:00:00Z", "endAt": "2018-10-16T23:59:59Z" } } } I have tested with Date Range "startAt": "2018-10-15T00:00:00Z", "endAt": "2018-10-16T23:59:59Z" "startAt": "2018-10-17T00:00:00Z", "endAt": "2018-10-17T23:59:59Z" API - /bulk/v1/activities/export/{exportId}/file.json Result- No data found for all this time range But when the input is - "startAt": "2018-10-16T00:00:00Z", "endAt": "2018-10-17T23:59:59Z" Result- 13 records found marketoGUID leadId activityDate 1913 1234 2018-10-16T16:26:06Z 1916 1234 2018-10-16T16:26:13Z 1921 1234 2018-10-16T16:31:22Z 1923 1234 2018-10-16T16:31:52Z 1929 134 2018-10-16T16:32:03Z 1947 118 2018-10-16T17:36:00Z 1950 113 2018-10-16T17:36:10Z 1969 113 2018-10-16T18:34:35Z 1972 213 2018-10-16T18:34:41Z 2003 987 2018-10-16T21:07:29Z 2006 987 2018-10-16T21:07:41Z 2012 1171 2018-10-16T21:12:10Z 2014 1171 2018-10-16T21:12:22Z So which time zone is considered at the time of request and what is the timezone of the activityDate in the CSV output ?
... View more
Labels:
11-05-2019
11:25 PM
Thanks for the quick response. your answer will solve my query.
... View more
11-05-2019
09:01 AM
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?
... View more
Public Statistics
| Name | Saptarshi Konar |
| Date Registered | 08-19-2019 10:47 AM |
| Date Last Visited | 01-28-2020 02:05 AM |
| Total Messages Posted | 11 |
.png?67D10DF4A500B5C9CAD6D9D40B974747)