Re: StepID Column in Email Activities

Anonymous
Not applicable

StepID Column in Email Activities

Hi Experts,

I have written a bulk API C# code to extract activity data on a monthly basis. The documentation says there is a default set of Columns I can extract. If I look at the table columns via the DSN connection i see a Column named StepId. Can I extract this column using bulk api. Is there a different REST API name for it?

Thanks.

5 REPLIES 5
SanfordWhiteman
Level 10 - Community Moderator

Re: StepID Column in Email Activities

You don't choose individual columns when you do an Activity extract, just the Activity Types.

When you include Send Email as one of the Activity Types, the Step ID can be found in the attributes column, which contains a seralized JSON object; ​Step ID ​is one of the top-level properties of the object. This is quite clear when you do an export.

Also your DSN isn't a real OLEDB/ODBC connection (I don't know what plugin you're using to get this DSN, as you haven't said). It's talking to the Describe Activities endpoint, when you can easily query over REST as well.

Anonymous
Not applicable

Re: StepID Column in Email Activities

I bought the CData Marketo ODBC driver and the DSN is using the REST Connection so I am assuming its a REST ODBC.

pastedImage_0.png

SanfordWhiteman
Level 10 - Community Moderator

Re: StepID Column in Email Activities

There's no such thing as "REST ODBC".

ODBC is an abstraction layer for database queries (not just SQL but metadata queries, like lists of columns).

All this driver is doing is calling the REST Describe Activities endpoint and trying to present the response as a list of columns that's compatible with the ODBC standard.

It has no direct access whatsoever to the database.

CData tries hard, but they don't really understand (nor regularly use) Marketo and none of their products understand the API semantics correctly.

Anonymous
Not applicable

Re: StepID Column in Email Activities

Ok.. Thanks for the quick reply. I will try with attributes column extraction.

SanfordWhiteman
Level 10 - Community Moderator

Re: StepID Column in Email Activities

Please mark my first answer Correct when you get a chance, thanks.