Saptarshi_Konar

Saptarshi_Konar · ‎12-20-2019

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.

Saptarshi_Konar · ‎12-20-2019

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.

Saptarshi_Konar · ‎12-19-2019

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"}

Saptarshi_Konar · ‎11-25-2019

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.

Saptarshi_Konar · ‎11-22-2019

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.

Saptarshi_Konar · ‎11-07-2019

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?

Saptarshi_Konar · ‎11-06-2019

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

Saptarshi_Konar · ‎11-06-2019

I am also confused about the timezone. Need clarification what is the timezone marketo is considering for rest APIs.

Saptarshi_Konar · ‎11-06-2019

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 ?

Saptarshi_Konar · ‎11-05-2019

Thanks for the quick response. your answer will solve my query.

Saptarshi_Konar · ‎11-05-2019

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?

Online Status	Offline
Date Last Visited	‎01-28-2020 02:05 AM

Date Registered	‎08-19-2019 10:47 AM
Date Last Visited	‎01-28-2020 02:05 AM
Total Messages Posted	11

Top Badges Earned

Re: What is the timezone for the field - "Created ...

Re: What is the timezone for the field - "Created ...

What is the timezone for the field - "Created Date...

Re: Link between different activities

Link between different activities

Re: Timezone for Bulk export API of activity

Re: datetime timezone wrong

Re: datetime timezone wrong

Timezone for Bulk export API of activity

Re: Unperseable JSON value for the Bulk Export of ...

Unperseable JSON value for the Bulk Export of acti...