Skip to main content
Robert_Kelen3
Robert_Kelen3
Level 4
February 6, 2018
Question

Script/program/tool for iterative Activities extraction via API

  • February 6, 2018
  • 2 replies
  • 1577 views

I'm wondering if folks have preferred tools for doing something similar to @David Everly​'s excellent shell script for retrieving activity data via API? That script actually does everything I'd like to accomplish (with support for both any activity type, and narrowing by listId), yet jq regularly fails on certain undesirables in Marketo JSON data ('parse error: Invalid string: control characters from U+0000 through U+001F...').

This python tool GitHub - kioy/MarketoExportActivities: Exporting lead activities via Marketo REST API is also quite useful, but is currently coded to only handle certain activity types.

Thanks.

Robert

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
SanfordWhiteman
Level 10
February 6, 2018

yet jq regularly fails on certain undesirables in Marketo JSON data ('parse error: Invalid string: control characters from U+0000 through U+001F...').

It's not valid JSON if it has unescaped control characters. Are you sure this is actually coming from Marketo? Can you post a raw HTTP trace that has these characters in the response?

Robert_Kelen3
Robert_Kelen3Author
Level 4
February 7, 2018

Oops, forgot the link to David's script: http://developers.marketo.com/blog/retrieve-activities-for-a-single-lead-using-rest-api/

Terms & ConditionsAccessibility statement

Loading footer...